利用战略管理框架开发企业管理系统

最编程 2024-10-19 19:54:39

...

一、功能介绍

商品查询：基于SSM整合基础上完成商品查询
商品添加：完成商品添加功能，实现事务操作
订单分页查询：使用mybatis分页插件PageHelper完成简单的多表查询操作
订单详情查询：订单详情是用于查询某一个订单的完整信息
用户管理：实现基于spring Security的用户登录、退出操作；以及用户查询、添加、详情操作
角色管理：角色管理主要完成角色查询、角色添加、角色删除
资源权限管理：资源权限管理主要完成查询、添加、删除操作，用于赋予角色操作权限
权限关联与控制：主要会讲解用户角色关联、角色权限关联
AOP日志处理：使用spring AOP切面来完成系统级别的日志收集

二、实现步骤

1、数据库设计

1.创建数据库

产品表

CREATE TABLE product(
   id INT NOT NULL AUTO_INCREMENT,       --无意义，主键
   productNum VARCHAR(60),           --产品编号
   productName VARCHAR(60),       --产品名称（路线名称）
   cityName VARCHAR(60),           --出发城市
   DepartureTime TIMESTAMP,       --出发时间
   productPrice DOUBLE,           --产品价格
   productDesc VARCHAR(600),       --产品描述
   productStatus INT,               --状态(0 关闭 1 开启)
   PRIMARY KEY (id)
);

会员表

CREATE TABLE member(
id INT PRIMARY KEY AUTO_INCREMENT, --无意义、主键
NAME VARCHAR(20),   --姓名
nickname VARCHAR(20),   --昵称
phoneNum VARCHAR(20),   --电话号码
email VARCHAR(20)    --邮箱
);

订单表

CREATE TABLE orders(
id INT PRIMARY KEY AUTO_INCREMENT,   --无意义、主键
orderNum VARCHAR(20) NOT NULL UNIQUE,   --订单编号不为空唯一
orderTime TIMESTAMP,       --下单时间
peopleCount INT,       --出行人数
orderDesc VARCHAR(500),   --订单描述(其它信息)
payType INT,       --支付方式(0 支付宝 1 微信 2其它)
orderStatus INT,   --订单状态(0 未支付 1 已支付)
productId INT,   --产品id 外键
memberId INT,       --会员(联系人）id 外键
FOREIGN KEY (productId) REFERENCES product(id),
FOREIGN KEY (memberId) REFERENCES member(id)
);

游客表

CREATE TABLE traveller(
id INT PRIMARY KEY AUTO_INCREMENT,   --无意义、主键
NAME VARCHAR(20),       --姓名
sex VARCHAR(20),       --性别
phoneNum VARCHAR(20),       --电话号码
credentialsType INT,       --证件类型 0身份证 1护照 2军官证
credentialsNum VARCHAR(50),   --证件号码
travellerType INT       --旅客类型(人群) 0 成人 1 儿童
);

订单与游客中间表

CREATE TABLE order_traveller(
orderId INT, --订单主键
travellerId INT(32), --旅客主键
PRIMARY KEY (orderId,travellerId),
FOREIGN KEY (orderId) REFERENCES orders(id),
FOREIGN KEY (travellerId) REFERENCES traveller(id)
);

用户表

CREATE TABLE users(
   id INT PRIMARY KEY AUTO_INCREMENT,   --无意义，主键
   email VARCHAR(60) UNIQUE NOT NULL,   --非空，唯一
   username VARCHAR(60),               --用户名
   usersPASSWORD VARCHAR(60),           --密码（加密）
   phoneNum VARCHAR(60),               --电话
   usersSTATUS INT                       -- 状态0 未开启 1 开启
);

角色表

CREATE TABLE role(
   id INT PRIMARY KEY AUTO_INCREMENT,   --无意义，主键
   roleName VARCHAR(60) ,               --角色名
   roleDesc VARCHAR(60)               --角色描述
);

用户角色关联表

CREATE TABLE users_role(
   userId INT,
   roleId INT,
   PRIMARY KEY(userId,roleId),
   FOREIGN KEY (userId) REFERENCES users(id),
   FOREIGN KEY (roleId) REFERENCES role(id)
);

资源权限表

CREATE TABLE permission(
   id INT PRIMARY KEY AUTO_INCREMENT,   --无意义，主键
   permissionName VARCHAR(60) ,       --权限名
   url VARCHAR(60)                       --资源路径
);

角色权限关联表

CREATE TABLE role_permission(
   permissionId INT,
   roleId INT,
   PRIMARY KEY(permissionId,roleId),
   FOREIGN KEY (permissionId) REFERENCES permission(id),
   FOREIGN KEY (roleId) REFERENCES role(id)
);

用户、角色、权限之间的表结构

日志表

CREATE TABLE sysLog(
   id INT PRIMARY KEY AUTO_INCREMENT,   --主键无意义
   visitTime TIMESTAMP,           --访问时间
   username VARCHAR(60),           --操作者用户名
   ip VARCHAR(30),                   --访问ip
   url VARCHAR(60),               --访问资源url
   executionTime INT,               --执行时长
   method VARCHAR(300)               --访问方法
);

2、编写代码

1、搭建ssm框架相应配置文件

1.jar坐标依赖

1.引入父工程jar坐标依赖
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>

<groupId>com.hzxy</groupId>
<artifactId>ssm_day01</artifactId>
<packaging>pom</packaging>
<version>1.0-SNAPSHOT</version>
<modules>
<module>maven_web</module>
<module>maven_dao</module>
<module>maven_domain</module>
<module>maven_utils</module>
<module>maven_service</module>
</modules>
<properties>
<spring.version>5.0.2.RELEASE</spring.version>
<slf4j.version>1.6.6</slf4j.version>
<log4j.version>1.2.12</log4j.version>
<mysql.version>8.0.13</mysql.version>
<mybatis.version>3.4.5</mybatis.version>
<spring.security.version>5.0.1.RELEASE</spring.security.version>
</properties>

<dependencies> 
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.6.8</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context-support</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${spring.version}</version>

</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>

<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.0</version>
<scope>provided</scope>
</dependency>

<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency> 
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>${log4j.version}</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>${slf4j.version}</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>${slf4j.version}</version>
</dependency>

<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${mybatis.version}</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.0</version>
</dependency>
<dependency>
<groupId>c3p0</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.1.2</version>
<type>jar</type>
<scope>compile</scope>
</dependency>
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.2</version>
</dependency>

<dependency>
<groupId>org.springframework.security</groupId>
<artifactId>spring-security-web</artifactId>
<version>${spring.security.version}</version>
</dependency>
<dependency>
<groupId>org.springframework.security</groupId>
<artifactId>spring-security-config</artifactId>
<version>${spring.security.version}</version>
</dependency>
<dependency>
<groupId>org.springframework.security</groupId>
<artifactId>spring-security-core</artifactId>
<version>${spring.security.version}</version>
</dependency>
<dependency>
<groupId>org.springframework.security</groupId>
<artifactId>spring-security-taglibs</artifactId>
<version>${spring.security.version}</version>
</dependency>

<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>${mysql.version}</version>
</dependency>

<dependency>
<groupId>javax.annotation</groupId>
<artifactId>jsr250-api</artifactId>
<version>1.0</version>
</dependency>
</dependencies>

</project>

2.引入子工程jar坐标依赖

maven_utils
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<parent>
<artifactId>ssm_day01</artifactId>
<groupId>com.hzxy</groupId>
<version>1.0-SNAPSHOT</version>
</parent>
<modelVersion>4.0.0</modelVersion>

<artifactId>maven_utils</artifactId>
</project>

maven_domain
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<parent>
<artifactId>ssm_day01</artifactId>
<groupId>com.hzxy</groupId>
<version>1.0-SNAPSHOT</version>
</parent>
<modelVersion>4.0.0</modelVersion>

<artifactId>maven_domain</artifactId>

<dependencies>
<dependency>
<groupId>com.hzxy</groupId>
<artifactId>maven_utils</artifactId>
<version>1.0-SNAPSHOT</version>
</dependency>

</dependencies>

</project>

maven_dao
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<parent>
<artifactId>ssm_day01</artifactId>
<groupId>com.hzxy</groupId>
<version>1.0-SNAPSHOT</version>
</parent>
<modelVersion>4.0.0</modelVersion>

<artifactId>maven_dao</artifactId>

<dependencies>
<dependency>
<groupId>com.hzxy</groupId>
<artifactId>maven_domain</artifactId>
<version>1.0-SNAPSHOT</version>
</dependency>

</dependencies>

</project>

maven_service
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<parent>
<artifactId>ssm_day01</artifactId>
<groupId>com.hzxy</groupId>
<version>1.0-SNAPSHOT</version>
</parent>
<modelVersion>4.0.0</modelVersion>

<artifactId>maven_service</artifactId>

<dependencies>
<dependency>
<groupId>com.hzxy</groupId>
<artifactId>maven_domain</artifactId>
<version>1.0-SNAPSHOT</version>
</dependency>
<dependency>
<groupId>com.hzxy</groupId>
<artifactId>maven_dao</artifactId>
<version>1.0-SNAPSHOT</version>
</dependency>
</dependencies>

</project>

maven_web
<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<parent>
<artifactId>ssm_day01</artifactId>
<groupId>com.hzxy</groupId>
<version>1.0-SNAPSHOT</version>
</parent>
<modelVersion>4.0.0</modelVersion>

<artifactId>maven_web</artifactId>
<packaging>war</packaging>

<name>maven_web Maven Webapp</name>

<url>http://www.example.com</url>

<dependencies>
<dependency>
<groupId>com.hzxy</groupId>
<artifactId>maven_service</artifactId>
<version>1.0-SNAPSHOT</version>
</dependency>
</dependencies>

</project>

3.编写配置文件

1.applicationContext.xm

l
编写Spring配置文件applicationContext.xml（Spring整合MyBatis）

1. 导入约束
2.开启注解扫描，管理service和dao

Spring整合MyBatis框架
1. 配置连接池
2. 配置SqlSessionFactory工厂
3. 配置接口所在包

配置Spring框架声明式事务管理
1. 配置事务管理器
2. 配置事务通知
3. 配置AOP增强

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
   http://www.springframework.org/schema/beans/spring-beans.xsd
   http://www.springframework.org/schema/context
   http://www.springframework.org/schema/context/spring-context.xsd
   http://www.springframework.org/schema/aop
   http://www.springframework.org/schema/aop/spring-aop.xsd
   http://www.springframework.org/schema/tx
   http://www.springframework.org/schema/tx/spring-tx.xsd">

<context:component-scan base-package="com.hzxy.service">
</context:component-scan>
<context:component-scan base-package="com.hzxy.dao">
</context:component-scan>

<context:property-placeholder location="classpath:jdbcConfig.properties"/>

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${jdbc.driver}"/>
<property name="jdbcUrl" value="${jdbc.url}"/>
<property name="user" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</bean>

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />

<property name="plugins">
<array>

<bean class="com.github.pagehelper.PageInterceptor">
<property name="properties">
<props>
<prop key="helperDialect">mysql</prop>
<prop key="reasonable">true</prop>
</props>
</property>
</bean>
</array>
</property>
</bean>

<bean id="mapperScanner" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.hzxy.dao"/>
</bean>

<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>

<tx:annotation-driven transaction-manager="transactionManager"/>
</beans>

2.web.xml

web.xml配置Spring MVC核心控制器（Spring整合Spring MVC和实现spring-security功能)

1.配置加载类路径的配置文件：applicationContext.xml、spring-security.xml
2.配置前端核心控制器（DispatcherServlet）
3.解决乱码问题
4.配置监听器
5.实现spring-security功能

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
version="3.1">

<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath*:applicationContext.xml,classpath*:spring-security.xml</param-value>
</context-param>

<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>

<servlet>
<servlet-name>dispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring-mvc.xml</param-value>
</init-param>

<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>dispatcherServlet</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>

<filter>
<filter-name>characterEncodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>characterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>

<filter>
<filter-name>springSecurityFilterChain</filter-name>
<filter-class>org.springframework.web.filter.DelegatingFilterProxy</filter-class>
</filter>

<filter-mapping>
<filter-name>springSecurityFilterChain</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>

<error-page>
<error-code>403</error-code>
<location>/403.jsp</location>
</error-page>

<welcome-file-list>
<welcome-file>index.html</welcome-file>
<welcome-file>index.htm</welcome-file>
<welcome-file>index.jsp</welcome-file>
<welcome-file>default.html</welcome-file>
<welcome-file>default.htm</welcome-file>
<welcome-file>default.jsp</welcome-file>
</welcome-file-list>
</web-app>

3.springmvc.xml

Spring MVC配置文件springmvc.xml

1. 开启注解扫描，只扫描Controller注解
2. 配置的视图解析器对象
3. 过滤静态资源
4. 开启SpringMVC注解的支持
5.AOP的注解支持

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
">

<context:component-scan base-package="com.hzxy.controller">
</context:component-scan>

<bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">

<property name="prefix" value="/pages/" />

<property name="suffix" value=".jsp" />
</bean>

<mvc:resources location="/css/" mapping="/css/**" />
<mvc:resources location="/img/" mapping="/img/**" />
<mvc:resources location="/js/" mapping="/js/**" />
<mvc:resources location="/plugins/" mapping="/plugins/**" />

<mvc:annotation-driven />

<aop:aspectj-autoproxy proxy-target-class="true"/>

</beans>

4.spring-security.xml

（spring security配置文件）

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:security="http://www.springframework.org/schema/security"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/security
http://www.springframework.org/schema/security/spring-security.xsd">

<security:http pattern="/login.jsp" security="none"/>
<security:http pattern="/failer.jsp" security="none"/>
<security:http pattern="/css/**" security="none"/>
<security:http pattern="/img/**" security="none"/>
<security:http pattern="/plugins/**" security="none"/>

<security:http auto-config="true" use-expressions="false">

<security:intercept-url pattern="/**" access="ROLE_USER,ROLE_ADMIN"/>

<security:form-login
login-page="/login.jsp"
login-processing-url="/login.do"
default-target-url="/index.jsp"
authentication-failure-url="/failer.jsp"
authentication-success-forward-url="/pages/main.jsp"
/>

<security:csrf disabled="true"/>

<security:logout invalidate-session="true" logout-url="/logout.do" logout-success-url="/login.jsp" />

</security:http>

<security:authentication-manager>
<security:authentication-provider user-service-ref="userService">

</security:authentication-provider>
</security:authentication-manager>

<bean id="passwordEncoder" class="org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder"/>

</beans>

4.各实现类和接口

1.utils模块时间

package com.hzxy.utils;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

public class DateUtils {

//日期转换成字符串
public static String date2String(Date date, String patt) {
SimpleDateFormat sdf = new SimpleDateFormat(patt);
String format = sdf.format(date);
return format;
}

//字符串转换成日期
public static Date string2Date(String str, String patt) throws ParseException {
SimpleDateFormat sdf = new SimpleDateFormat(patt);
Date parse = sdf.parse(str);
return parse;
}
}

2.domain模块实体类模块

产品Product

package com.hzxy.domain;

import com.hzxy.utils.DateUtils;

import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;

public class Product {
private String id; // 主键
private String productNum; // 编号唯一
private String productName; // 名称
private String cityName; // 出发城市
@DateTimeFormat(pattern="yyyy-MM-dd HH:mm")
private Date departureTime; // 出发时间
private String departureTimeStr; //页面只能展示String类型，方便页面的展示
private double productPrice; // 产品价格
private String productDesc; // 产品描述
private Integer productStatus; // 状态 0 关闭 1 开启
private String productStatusStr; //页面只能展示String类型，方便页面的展示

public String getId() {
return id;
}

public void setId(String id) {
this.id = id;
}

public String getProductNum() {
return productNum;
}

public void setProductNum(String productNum) {
this.productNum = productNum;
}

public String getProductName() {
return productName;
}

public void setProductName(String productName) {
this.productName = productName;
}

public String getCityName() {
return cityName;
}

public void setCityName(String cityName) {
this.cityName = cityName;
}

public Date getDepartureTime() {
return departureTime;
}

public void setDepartureTime(Date departureTime) {
this.departureTime = departureTime;
}

public String getDepartureTimeStr() {
if(departureTime!=null){
departureTimeStr= DateUtils.date2String(departureTime,"yyyy-MM-dd HH:mm:ss");
}
return departureTimeStr;
}

public void setDepartureTimeStr(String departureTimeStr) {
this.departureTimeStr = departureTimeStr;
}

public double getProductPrice() {
return productPrice;
}

public void setProductPrice(double productPrice) {
this.productPrice = productPrice;
}

public String getProductDesc() {
return productDesc;
}

public void setProductDesc(String productDesc) {
this.productDesc = productDesc;
}

public Integer getProductStatus() {
return productStatus;
}

public void setProductStatus(Integer productStatus) {
this.productStatus = productStatus;
}

public String getProductStatusStr() {
if (productStatus != null) {
// 状态 0 关闭 1 开启
if(productStatus==0)
productStatusStr="关闭";
if(productStatus==1)
productStatusStr="开启";
}
return productStatusStr;
}

public void setProductStatusStr(String productStatusStr) {
this.productStatusStr = productStatusStr;
}
}

orders订单实体模块

package com.hzxy.domain;

import com.hzxy.utils.DateUtils;

import java.util.Date;
import java.util.List;

//订单
public class Orders {
private String id;
private String orderNum;
private Date orderTime;
private String orderTimeStr;
private int orderStatus;
private String orderStatusStr;
private int peopleCount;
private Product product;
private List<Traveller> travellers;
private Member member;
private Integer payType;
private String payTypeStr;
private String orderDesc;

public String getOrderStatusStr() {
//订单状态(0 未支付 1 已支付)
if(orderStatus==0){
orderStatusStr="未支付";
}else if(orderStatus==1){
orderStatusStr="已支付";
}
return orderStatusStr;
}

public void setOrderStatusStr(String orderStatusStr) {
this.orderStatusStr = orderStatusStr;
}

public String getId() {
return id;
}

public void setId(String id) {
this.id = id;
}

public String getOrderNum() {
return orderNum;
}

public void setOrderNum(String orderNum) {
this.orderNum = orderNum;
}

public Date getOrderTime() {
return orderTime;
}

public void setOrderTime(Date orderTime) {
this.orderTime = orderTime;
}

public String getOrderTimeStr() {
if(orderTime!=null){
orderTimeStr= DateUtils.date2String(orderTime,"yyyy-MM-dd HH:mm");
}
return orderTimeStr;
}

public void setOrderTimeStr(String orderTimeStr) {
this.orderTimeStr = orderTimeStr;
}

public int getOrderStatus() {
return orderStatus;
}

public void setOrderStatus(int orderStatus) {
this.orderStatus = orderStatus;
}

public int getPeopleCount() {
return peopleCount;
}

public void setPeopleCount(int peopleCount) {
this.peopleCount = peopleCount;
}

public Product getProduct() {
return product;
}

public void setProduct(Product product) {
this.product = product;
}

public List<Traveller> getTravellers() {
return travellers;
}

public void setTravellers(List<Traveller> travellers) {
this.travellers = travellers;
}

public Member getMember() {
return member;
}

public void setMember(Member member) {
this.member = member;
}

public Integer getPayType() {
return payType;
}

public void setPayType(Integer payType) {
this.payType = payType;
}

public String getPayTypeStr() {
//支付方式(0 支付宝 1 微信 2其它)
if(payType==0){
payTypeStr="支付宝";
}else if(payType==1){
payTypeStr="微信";
}else if(payType==2){
payTypeStr="其它";
}
return payTypeStr;
}

public void setPayTypeStr(String payTypeStr) {
this.payTypeStr = payTypeStr;
}

public String getOrderDesc() {
return orderDesc;
}

public void setOrderDesc(String orderDesc) {
this.orderDesc = orderDesc;
}
}

成员模块Member

package com.hzxy.domain;

//会员
public class Member {
private String id;
private String name;
private String nickname;
private String phoneNum;
private String email;

public String getId() {
return id;
}

public void setId(String id) {
this.id = id;
}

public String getName() {
return name;
}

public void setName(String name) {
this.name = name;
}

public String getNickname() {
return nickname;
}

public void setNickname(String nickname) {
this.nickname = nickname;
}

public String getPhoneNum() {
return phoneNum;
}

public void setPhoneNum(String phoneNum) {
this.phoneNum = phoneNum;
}

public String getEmail() {
return email;
}

public void setEmail(String email) {
this.email = email;
}
}

旅客模块Traveller

package com.hzxy.domain;

//旅客
public class Traveller {
private String id;
private String name;
private String sex;
private String phoneNum;
private Integer credentialsType; //证件类型 0身份证 1护照 2军官证
private String credentialsTypeStr;
private String credentialsNum;
private Integer travellerType; //旅客类型(人群) 0 成人 1 儿童
private String travellerTypeStr;

public String getId() {
return id;
}

public void setId(String id) {
this.id = id;
}

public String getName() {
return name;
}

public void setName(String name) {
this.name = name;
}

public String getSex() {
return sex;
}

public void setSex(String sex) {
this.sex = sex;
}

public String getPhoneNum() {
return phoneNum;
}

public void setPhoneNum(String phoneNum) {
this.phoneNum = phoneNum;
}

public Integer getCredentialsType() {
return credentialsType;
}

public void setCredentialsType(Integer credentialsType) {
this.credentialsType = credentialsType;
}

public String getCredentialsTypeStr() {
//证件类型 0身份证 1护照 2军官证
if (credentialsType != null) {
if (credentialsType == 0) {
credentialsTypeStr = "身份证";
} else if (credentialsType == 1) {
credentialsTypeStr = "护照";
} else if (credentialsType == 2) {
credentialsTypeStr = "军官证";
}
}
return credentialsTypeStr;
}

public void setCredentialsTypeStr(String credentialsTypeStr) {
this.credentialsTypeStr = credentialsTypeStr;
}

public String getCredentialsNum() {
return credentialsNum;
}

public void setCredentialsNum(String credentialsNum) {
this.credentialsNum = credentialsNum;
}

public Integer getTravellerType() {
return travellerType;
}

public void setTravellerType(Integer travellerType) {
this.travellerType = travellerType;
}

public String getTravellerTypeStr() {
旅客类型(人群) 0 成人 1 儿童
if (travellerType != null) {
if (travellerType == 0) {
travellerTypeStr = "成人";
} else if (travellerType == 1) {
travellerTypeStr = "儿童";
}
}
return travellerTypeStr;
}

public void setTravellerTypeStr(String travellerTypeStr) {
this.travellerTypeStr = travellerTypeStr;
}
}

用户实体模块UserInfo

package com.hzxy.domain;

import java.util.List;

//与数据库中users对应
public class UserInfo {
private String id;
private String username;
private String email;
private String password;
private String phoneNum;
private int status;
private String statusStr;
private List<Role> roles;

public int getStatus() {
return status;
}

public void setStatus(int status) {
this.status = status;
}

public String getId() {
return id;
}

public void setId(String id) {
this.id = id;
}

public String getUsername() {
return username;
}

public void setUsername(String username) {
this.username = username;
}

public String getEmail() {
return email;
}

public void setEmail(String email) {
this.email = email;
}

public String getPassword() {
return password;
}

public void setPassword(String password) {
this.password = password;
}

public String getPhoneNum() {
return phoneNum;
}

public void setPhoneNum(String phoneNum) {
this.phoneNum = phoneNum;
}

public String getStatusStr() {
//状态0 未开启 1 开启
if (status == 0) {
statusStr = "未开启";
} else if (status == 1) {
statusStr = "开启";
}
return statusStr;
}

public void setStatusStr(String statusStr) {
this.statusStr = statusStr;
}

public List<Role> getRoles() {
return roles;
}

public void setRoles(List<Role> roles) {
this.roles = roles;
}
}

角色实体模块Role

package com.hzxy.domain;

import java.util.List;

public class Role {
private String id;
private String roleName;
private String roleDesc;
private List<Permission> permissions;
private List<UserInfo> users;

public String getId() {
return id;
}

public void setId(String id) {
this.id = id;
}

public String getRoleName() {
return roleName;
}

public void setRoleName(String roleName) {
this.roleName = roleName;
}

public String getRoleDesc() {
return roleDesc;
}

public void setRoleDesc(String roleDesc) {
this.roleDesc = roleDesc;
}

public List<Permission> getPermissions() {
return permissions;
}

public void setPermissions(List<Permission> permissions) {
this.permissions = permissions;
}

public List<UserInfo> getUsers() {
return users;
}

public void setUsers(List<UserInfo> users) {
this.users = users;
}
}

权限实体模块Permission

package com.hzxy.domain;

import java.util.List;

public class Permission {
private String id;
private String permissionName;
private String url;
private List<Role> roles;

public String getId() {
return id;
}

public void setId(String id) {
this.id = id;
}

public String getPermissionName() {
return permissionName;
}

public void setPermissionName(String permissionName) {
this.permissionName = permissionName;
}

public String getUrl() {
return url;
}

public void setUrl(String url) {
this.url = url;
}

public List<Role> getRoles() {
return roles;
}

public void setRoles(List<Role> roles) {
this.roles = roles;
}
}

日志实体模块SysLog

package com.hzxy.domain;

import com.hzxy.utils.DateUtils;
import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;

public class SysLog {
private String id;
@DateTimeFormat(pattern="yyyy-MM-dd HH:mm")
private Date visitTime;
private String visitTimeStr;
private String username;
private String ip;
private String url;
private Long executionTime;
private String method;

public String getId() {
return id;
}

public void setId(String id) {
this.id = id;
}

public Date getVisitTime() {
return visitTime;
}

public void setVisitTime(Date visitTime) {
this.visitTime = visitTime;
}

public String getVisitTimeStr() {
if(visitTime!=null){
visitTimeStr= DateUtils.date2String(visitTime,"yyyy-MM-dd HH:mm:ss");
}
return visitTimeStr;
}

public void setVisitTimeStr(String departureTimeStr) {
this.visitTimeStr = visitTimeStr;
}

public String getUsername() {
return username;
}

public void setUsername(String username) {
this.username = username;
}

public String getIp() {
return ip;
}

public void setIp(String ip) {
this.ip = ip;
}

public String getUrl() {
return url;
}

public void setUrl(String url) {
this.url = url;
}

public Long getExecutionTime() {
return executionTime;
}

public void setExecutionTime(Long executionTime) {
this.executionTime = executionTime;
}

public String getMethod() {
return method;
}

public void setMethod(String method) {
this.method = method;
}
}

3.dao模块

产品IProductDao

package com.hzxy.dao;

import com.hzxy.domain.Product;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface IProductDao {

//根据id查询产品
@Select("select * from product where id=#{id}")
public Product findById(String id) throws Exception;

//查询所有的产品信息
@Select("select * from product")
public List<Product> findAll() throws Exception;

@Insert("insert into product(productNum,productName,cityName,departureTime,productPrice,productDesc,productStatus) values(#{productNum},#{productName},#{cityName},#{departureTime},#{productPrice},#{productDesc},#{productStatus})")
void save(Product product);
}

订单 IOrdersDao

package com.hzxy.dao;

import com.hzxy.domain.Member;
import com.hzxy.domain.Orders;
import com.hzxy.domain.Product;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface IOrdersDao {

@Select("select * from orders")
@Results({
@Result(id = true, property = "id", column = "id"),
@Result(property = "orderNum", column = "orderNum"),
@Result(property = "orderTime", column = "orderTime"),
@Result(property = "orderStatus", column = "orderStatus"),
@Result(property = "peopleCount", column = "peopleCount"),
@Result(property = "peopleCount", column = "peopleCount"),
@Result(property = "payType", column = "payType"),
@Result(property = "orderDesc", column = "orderDesc"),
@Result(property = "product", column = "productId", javaType = Product.class, one = @One(select = "com.hzxy.dao.IProductDao.findById")),
})
public List<Orders> findAll() throws Exception;

//多表操作
@Select("select * from orders where id=#{ordersId}")
@Results({
@Result(id = true, property = "id", column = "id"),
@Result(property = "orderNum", column = "orderNum"),
@Result(property = "orderTime", column = "orderTime"),
@Result(property = "orderStatus", column = "orderStatus"),
@Result(property = "peopleCount", column = "peopleCount"),
@Result(property = "peopleCount", column = "peopleCount"),
@Result(property = "payType", column = "payType"),
@Result(property = "orderDesc", column = "orderDesc"),
@Result(property = "product", column = "productId", javaType = Product.class, one = @One(select = "com.hzxy.dao.IProductDao.findById")),
@Result(property = "member",column = "memberId",javaType = Member.class,one = @One(select = "com.hzxy.dao.IMemberDao.findById")),
@Result(property = "travellers",column = "id",javaType =List.class,many = @Many(select = "com.hzxy.dao.ITravellerDao.findByOrdersId"))
})
public Orders findById(String ordersId) throws Exception;
}

成员IMemberDao

package com.hzxy.dao;

import com.hzxy.domain.Member;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

@Repository
public interface IMemberDao {

@Select("select * from member where id=#{id}")
public Member findById(String id) throws Exception;
}

旅行 ITravellerDao

package com.hzxy.dao;

import com.hzxy.domain.Traveller;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface ITravellerDao {

@Select("select * from traveller where id in (select travellerId from order_traveller where orderId=#{ordersId})")
public List<Traveller> findByOrdersId(String ordersId) throws Exception;
}

用户IUserDao

package com.hzxy.dao;

import com.hzxy.domain.Role;
import com.hzxy.domain.UserInfo;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface IUserDao {

@Select("select * from users where username=#{username}")
@Results({
@Result(id = true, property = "id", column = "id"),
@Result(property = "username", column = "username"),
@Result(property = "email", column = "email"),
@Result(property = "password", column = "usersPASSWORD"),
@Result(property = "phoneNum", column = "phoneNum"),
@Result(property = "status", column = "usersSTATUS"),
@Result(property = "roles",column = "id",javaType = java.util.List.class,
many = @Many(select = "com.hzxy.dao.IRoleDao.findRoleByUserId"))
})
public UserInfo findByUsername(String username) throws Exception;

@Select("select * from users")
@Results({
@Result(id = true, property = "id", column = "id"),
@Result(property = "username", column = "username"),
@Result(property = "email", column = "email"),
@Result(property = "password", column = "usersPASSWORD"),
@Result(property = "phoneNum", column = "phoneNum"),
@Result(property = "status", column = "usersSTATUS")
})
List<UserInfo> findAll() throws Exception;

@Insert("insert into users(email,username,usersPASSWORD,phoneNum,usersSTATUS) " +
"values(#{email},#{username},#{password},#{phoneNum},#{status})")
@Results({
@Result(id = true, property = "id", column = "id"),
@Result(property = "username", column = "username"),
@Result(property = "email", column = "email"),
@Result(property = "password", column = "usersPASSWORD"),
@Result(property = "phoneNum", column = "phoneNum"),
@Result(property = "status", column = "usersSTATUS")
})
void save(UserInfo userInfo) throws Exception;

@Select("select * from users where id=#{id}")
@Results({
@Result(id = true, property = "id", column = "id"),
@Result(property = "username", column = "username"),
@Result(property = "email", column = "email"),
@Result(property = "password", column = "usersPASSWORD"),
@Result(property = "phoneNum", column = "phoneNum"),
@Result(property = "status", column = "usersSTATUS"),
@Result(property = "roles",column = "id",javaType = java.util.List.class,
many = @Many(select = "com.hzxy.dao.IRoleDao.findRoleByUserId"))
})
UserInfo findById(String id) throws Exception;

@Select("select * from role where id not in (select roleId from users_role where userId=#{userId})")
List<Role> findOtherRoles(String userId);

@Insert("insert into users_role(userId,roleId) values(#{userId},#{roleId})")
void addRoleToUser(@Param("userId") String userId, @Param("roleId") String roleId);

@Delete("delete from users_role where userId=#{id}")
void deleteFromUser_RoleByRoleId(String id);

@Delete("delete from users where id=#{id}")
void deleteUserById(String id);

}

角色IRoleDao

package c

上一篇： Linux 系统性能调整技巧

下一篇： python 机器人编程 - 使用 python API 调用控制 wifi 小车的示例程序

利用战略管理框架开发企业管理系统

一、功能介绍

二、实现步骤

1、数据库设计

1.创建数据库

产品表

会员表

订单表

游客表

订单与游客中间表

用户表

角色表

用户角色关联表

资源权限表

角色权限关联表

用户、角色、权限之间的表结构

日志表

2、编写代码

1、搭建ssm框架相应配置文件

1.jar坐标依赖

2.引入子工程jar坐标依赖

3.编写配置文件

1.applicationContext.xm

2.web.xml

3.springmvc.xml

4.spring-security.xml

4.各实现类和接口

1.utils模块 时间

2.domain模块 实体类模块

产品Product

orders订单实体模块

成员模块Member

旅客模块Traveller

用户实体模块UserInfo

角色实体模块Role

权限实体模块Permission

日志实体模块SysLog

3.dao模块

产品IProductDao

订单 IOrdersDao

成员IMemberDao

旅行 ITravellerDao

用户IUserDao

角色IRoleDao