SpringMVC 08: SSM框架整合(Spring + SpringMVC + MyBatis)
SSM项目整合
- 本篇博客是对前面所学的MyBatis框架，Spring框架，SpringMVC框架的整合应用，较为详细了梳理了SSM框架的整合步骤
- 为了方便以后复习，步骤比较详细，配置文件比较多，代码量也比较大，包涵包涵
- 对于有些步骤如果感觉描述不清晰，可以参考MyBatis博客集，Spring博客集，SpringMVC博客集中的相应博客
整合步骤
- 建库，建表
- 新建maven项目，选择webapp模板
- 修改目录
- 修改pom.xml文件
- 添加jdbc.properties属性文件
- 添加SqlMapConfig.xml文件
- 添加applicationContext_mapper.xml文件(数据访问层的核心配置文件)
- 添加applicationContext_service.xml文件(业务逻辑层的核心配置文件)
- 添加springmvc.xml文件
- 删除web.xml文件，新建，改名，设置中文编码，注册springmvc框架，注册spring框架
- 新建实体类User
- 新建UserMapper.java接口
- 新建UserMapper.xml实现增删查的功能，暂时没有实现更新操作
- 新建service接口和实现类
- 新建测试类，完成所有功能的测试
- 新建控制器，完成所有功能
- 用浏览器测试功能
项目配置
建库，建表
- ssmuser.sql脚本
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
CREATE DATABASE IF NOT EXISTS `ssmuser` DEFAULT CHARACTER SET utf8;
USE `ssmuser`;
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`card_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`card_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`user_sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`user_age` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`user_role` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('15968162087363060', '身份证', '114264195202156467', '张三', '男', '30', '办事人员和有关人员');
INSERT INTO `user` VALUES ('15968162346981977', '护照', 'A32532654', '李四', '男', '29', '不便分类的其他从业人员');
INSERT INTO `user` VALUES ('15968162893439470', '身份证', '112344198709094532', '王五', '男', '31', '农、林、牧、渔、水利业生产人员');
INSERT INTO `user` VALUES ('15968163245457143', '身份证', '453234199909094532', '赵六', '男', '34', '未知');
INSERT INTO `user` VALUES ('15968163514764733', '军官证', '军7657868', '钱七', '女', '23', '不便分类的其他从业人员');
INSERT INTO `user` VALUES ('15968165113694372', '台湾往来大陆通行证', '43256786', '周八', '女', '48', '生产、运输设备操作人员及有关人员');
INSERT INTO `user` VALUES ('15968165371931786', '港澳居民通行证', 'C98767665', '吴九', '女', '35', '不便分类的其他从业人员');
INSERT INTO `user` VALUES ('15968941217553030', '身份证', '343546199801018768', '郑十', '男', '22', '军人');
INSERT INTO `user` VALUES ('15968943937844616', '身份证', '445453199603025756', '冯十一', '女', '31', '不便分类的其他从业人员');
INSERT INTO `user` VALUES ('15968944123869023', '护照', 'B54322654', '陈十二', '女', '39', '农、林、牧、渔、水利业生产人员');
INSERT INTO `user` VALUES ('15968953962316864', '身份证', '110232199505056789', '朱十三', '女', '33', '商业、服务业人员');
INSERT INTO `user` VALUES ('15968954638794962', '身份证', '110654196604079098', '孔十四', '女', '29', '生产、运输设备操作人员及有关人员');
SET FOREIGN_KEY_CHECKS = 1;
项目结构
- ssm整合项目的项目结构
pom.xml
<?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.example</groupId>
<artifactId>ch06-springmvc-ssm</artifactId>
<version>1.0.0</version>
<packaging>war</packaging>
<!-- 集中定义依赖版本号 -->
<properties>
<!-- 单元测试相关依赖-->
<junit.version>4.13.2</junit.version>
<!-- spring相关依赖-->
<spring.version>5.3.22</spring.version>
<!-- mybatis相关依赖-->
<mybatis.version>3.5.10</mybatis.version>
<!-- mybatis和spring相关依赖-->
<mybatis.spring.version>2.0.7</mybatis.spring.version>
<!-- mysql依赖-->
<mysql.version>8.0.30</mysql.version>
<!-- slf4j日志依赖-->
<slf4j.version>1.6.4</slf4j.version>
<!-- 数据库连接池依赖-->
<druid.version>1.2.11</druid.version>
<!-- jsp标准标签库-->
<jstl.version>1.2</jstl.version>
<!-- servlet相关依赖-->
<servlet-api.version>3.0.1</servlet-api.version>
<!-- jsp相关依赖-->
<jsp-api.version>2.0</jsp-api.version>
<!-- jackson相关依赖-->
<jackson.version>2.13.3</jackson.version>
</properties>
<!-- 具体相关依赖的配置-->
<dependencies>
<!-- spring -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</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-webmvc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aspects</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jms</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-test</artifactId>
<version>5.3.22</version>
</dependency>
<!-- Mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${mybatis.version}</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>${mybatis.spring.version}</version>
</dependency>
<!-- MySql -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>${mysql.version}</version>
</dependency>
<!-- 连接池 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>${druid.version}</version>
</dependency>
<!-- junit -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>${junit.version}</version>
<scope>test</scope>
</dependency>
<!-- JSP相关 -->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>${jstl.version}</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.0.1</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jsp-api</artifactId>
<scope>provided</scope>
<version>${jsp-api.version}</version>
</dependency>
<!-- Jackson Json处理工具包 -->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>${jackson.version}</version>
</dependency>
</dependencies>
<!-- 插件配置 -->
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<configuration>
<source>1.8</source>
<target>1.8</target>
<encoding>UTF-8</encoding>
</configuration>
</plugin>
</plugins>
<!--识别所有的配置文件-->
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>false</filtering>
</resource>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>false</filtering>
</resource>
</resources>
</build>
</project>
jdbc.properties
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://服务器或本机ip:3306/数据库名称?useUnicode=true&characterEncoding=utf8
jdbc.username=数据库用户名
jdbc.password=数据库密码
SqlMapConfig.xml
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<settings>
<!-- 输出底层sql语句-->
<setting name="logImpl" value="STDOUT_LOGGING"/>
</settings>
</configuration>
applicationContext_mapper.xml
<?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"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
<!-- 读取jdbc.properties属性配置文件-->
<context:property-placeholder location="classpath:jdbc.properties"/>
<!-- 配置数据源-->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
<property name="driverClassName" value="${jdbc.driver}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</bean>
<!-- 配置SqlSessionFactoryBean-->
<bean class="org.mybatis.spring.SqlSessionFactoryBean">
<!--配置数据源 -->
<property name="dataSource" ref="dataSource"/>
<!--添加SqlMapConfig.xml核心配置文件 -->
<property name="configLocation" value="classpath:SqlMapConfig.xml"/>
<!--注册实体类 -->
<property name="typeAliasesPackage" value="com.example.pojo"/>
</bean>
<!-- 注册Mapper文件-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.example.mapper"/>
</bean>
</beans>
applicationContext_service.xml
<?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:tx="http://www.springframework.org/schema/tx"
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/context https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/aop https://www.springframework.org/schema/aop/spring-aop.xsd">
<!-- 包扫描-->
<context:component-scan base-package="com.example.service.impl"/>
<!-- 添加事务管理器-->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<!--
添加数据源:这里报红先不管
因为最后注册时，会以通配符的形式导入spring的所有配置文件，那时候会包含applicationContext_mapper.xml
而applicationContext_mapper.xml里面已经注册了数据源，所以不用担心这里引用的数据源不存在
-->
<property name="dataSource" ref="dataSource"/>
</bean>
<!-- 配置事务切面：采用声明式事务-->
<tx:advice id="myadvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="*select*" read-only="true"/>
<tx:method name="*get*" read-only="true"/>
<tx:method name="*find*" read-only="true"/>
<tx:method name="*search*" read-only="true"/>
<tx:method name="*delete*" propagation="REQUIRED"/>
<tx:method name="*clear*" propagation="REQUIRED"/>
<tx:method name="*remove*" propagation="REQUIRED"/>
<tx:method name="*insert*" propagation="REQUIRED"/>
<tx:method name="*create*" propagation="REQUIRED"/>
<tx:method name="*save*" propagation="REQUIRED"/>
<tx:method name="*set*" propagation="REQUIRED"/>
<tx:method name="*add*" propagation="REQUIRED"/>
<tx:method name="*change*" propagation="REQUIRED"/>
<tx:method name="*modify*" propagation="REQUIRED"/>
<tx:method name="*update*" propagation="REQUIRED"/>
<tx:method name="*" propagation="SUPPORTS"/>
</tx:attributes>
</tx:advice>
<!-- 声明切入点 + 绑定事务切面-->
<aop:config>
<!-- 自定义切入点表达式-->
<aop:pointcut id="mycut" expression="execution(* com.example.service.impl.*.*(..))"/>
<!-- 将切入点和事务切面绑定-->
<aop:advisor advice-ref="myadvice" pointcut-ref="mycut"/>
</aop:config>
</beans>
springmvc.xml
<?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:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd">
<!-- 添加包扫描-->
<context:component-scan base-package="com.example.controller"/>
<!-- 添加注解驱动-->
<mvc:annotation-driven/>
<!-- 由于本项目请求全部为ajax请求，直接将数据返回给前端，所以不用添加视图解析器-->
</beans>
web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
version="4.0">
<!-- 注册中文编码过滤器-->
<filter>
<filter-name>encode</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<!--
private String encoding;
private boolean forceRequestEncoding;
private boolean forceResponseEncoding;
-->
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
<init-param>
<param-name>forceRequestEncoding</param-name>
<param-value>true</param-value>
</init-param>
<init-param>
<param-name>forceResponseEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encode</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- 注册SpringMVC框架-->
<servlet>
<servlet-name>springmvc</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:springmvc.xml</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>springmvc</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<!-- 注册Spring：目的是当项目发布到服务器上时，可以启动并管理spring容器-->
<!-- 1.注册监听器-->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- 2.注册spring的配置文件：这里采用通配符的方式进行批量注册配置-->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext_*.xml</param-value>
</context-param>
</web-app>
实体类
- 按照user表的字段创建User实体类
package com.example.pojo;
public class User {
private String userId;
private String cardType;
private String cardNo;
private String userName;
private String userSex;
private String userAge;
private String userRole;
@Override
public String toString() {
return "User{" +
"userId='" + userId + '\'' +
", cardType='" + cardType + '\'' +
", cardNo='" + cardNo + '\'' +
", userName='" + userName + '\'' +
", userSex='" + userSex + '\'' +
", userAge='" + userAge + '\'' +
", userRole='" + userRole + '\'' +
'}';
}
public String getUserId() {
return userId;
}
public void setUserId(String userId) {
this.userId = userId;
}
public String getCardType() {
return cardType;
}
public void setCardType(String cardType) {
this.cardType = cardType;
}
public String getCardNo() {
return cardNo;
}
public void setCardNo(String cardNo) {
this.cardNo = cardNo;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getUserSex() {
return userSex;
}
public void setUserSex(String userSex) {
this.userSex = userSex;
}
public String getUserAge() {
return userAge;
}
public void setUserAge(String userAge) {
this.userAge = userAge;
}
public String getUserRole() {
return userRole;
}
public void setUserRole(String userRole) {
this.userRole = userRole;
}
public User(String userId, String cardType, String cardNo, String userName, String userSex, String userAge, String userRole){
this.userId = userId;
this.cardType = cardType;
this.cardNo = cardNo;
this.userName = userName;
this.userSex = userSex;
this.userAge = userAge;
this.userRole = userRole;
}
public User() {
}
}
项目接口文档
- 在实际项目的开发中，按照开发规范，需要有项目接口文档，用来规定接口信息，以及约定前后端的数据交互信息等等
- 下面是一个简单的项目接口文档
SSMUSER服务器接口说明文档
1.服务器地址：
http:// http://localhost:8082
http://127.0.0.1:8082
2.数据接口说明：
----------------------------------
根据条件分页获取分页数据
url
/user/selectUserPage?userName=z&userSex=男&page=null
参数
userName:表单中用户名称
userSex:表单中用户性别
page:提交的页码(第一次访问为null)
结果
有数据时：
[{
"userId":"15968954638794962",
"cardType":"身份证","
cardNo":"343343554654",
"userName":"撒撒旦",
"userSex":"女",
"userAge":"29",
"userRole":"生产、运输设备操作人员及有关人员"},
{….}
]
无数据时：
[]
-------------------------------------
获取总行数
url
/user/getRowCount?userName=z&userSex=男
参数
userName:表单中用户名称
userSex:表单中用户性别
结果
有数据时:
12
无数据时:
0
-------------------------------------
根据用户ID删除用户
url
/user/ deleteUserById?userId= 15968162087363060
参数
userId:删除用户的id
结果
删除成功时：
1
删除失败时:
0
---------------------------------------
增加用户
url
/user/createUser(参数见下面)
参数
cardType: this.ruleForm.cardType,//证件类型
cardNo: this.ruleForm.cardNo,//证件号码
userName: this.ruleForm.userName,//用户姓名
userSex: this.ruleForm.userSex,//用户性别
userAge: this.ruleForm.userAge,//用户年龄
userRole: this.ruleForm.userRole,//用户角色
结果
增加成功时：
1
增加失败时:
0
---------------------------------------
UserMapper.java接口
package com.example.mapper;
import com.example.pojo.User;
import org.apache.ibatis.annotations.Param;
import java.util.List;
/**
* 数据访问层的数据操作接口：要按照项目的接口文档来开发
*/
public interface UserMapper {
/**
* 根据条件分页获取分页数据
*
* url
*
* /user/selectUserPage?userName=z&userSex=男&page=null
*
* 参数
* userName:表单中用户名称
* userSex:表单中用户性别
* page:提交的页码(第一次访问为null)
*
* 结果
*
* 有数据时：
* [{
* "userId":"15968954638794962",
* "cardType":"身份证","
* cardNo":"343343554654",
* "userName":"撒撒旦",
* "userSex":"女",
* "userAge":"29",
* "userRole":"生产、运输设备操作人员及有关人员"},
* {….}
* ]
*
* 无数据时：
* []
*
* 关于参数startRow：(当前页数 - 1) * 每页条数 ,这样的表达式不能在sql语句中出现，所以必须传入表达式的结果，也即startRow
* select * from user
* #limit (当前页数 - 1) * 每页条数,每页条数
* limit 0,5;
*/
List<User> selectUserPage (
@Param("userName")
String userName,
@Param("userSex")
String userSex,
@Param("startRow")
int startRow);//算好起始的行数
/**
* 增加用户
*
* url
* /user/createUser(参数见下面)
*
* 参数
* cardType: this.ruleForm.cardType,//证件类型
* cardNo: this.ruleForm.cardNo,//证件号码
* userName: this.ruleForm.userName,//用户姓名
* userSex: this.ruleForm.userSex,//用户性别
* userAge: this.ruleForm.userAge,//用户年龄
* userRole: this.ruleForm.userRole,//用户角色
*
* 结果
* 增加成功时：
* 1
* 增加失败时:
* 0
*/
int insert(User user);
/**
* 根据用户ID删除用户
*
* url
* /user/ deleteUserById?userId= 15968162087363060
*
* 参数
* userId:删除用户的id
* 结果
* 删除成功时：
* 1
* 删除失败时:
* 0
*/
int delete(String userId);
/**
* 获取总行数：在分页显示的时候用来确定可以分多少页
*
* url
* /user/getRowCount?userName=z&userSex=男
*
* 参数
* userName:表单中用户名称
* userSex:表单中用户性别
*
* 结果
* 有数据时:
* 12
* 无数据时:
* 0
*/
int getRowCount(
@Param("userName")
String userName,
@Param("userSex")
String userSex);
}
UserMapper.xml
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.mapper.UserMapper">
<!--
完成实体类属性和表中列名的映射
private String userId;
private String cardType;
private String cardNo;
private String userName;
private String userSex;
private String userAge;
private String userRole;
-->
<resultMap id="userMap" type="user">
<id property="userId" column="user_id"/>
<result property="cardType" column="card_type"/>
<result property="cardNo" column="card_no"/>
<result property="userName" column="user_name"/>
<result property="userSex" column="user_sex"/>
<result property="userAge" column="user_age"/>
<result property="userRole" column="user_role"/>
</resultMap>
<!-- 定义全部列名-->
<sql id="allColumns">
user_id,card_type,card_no,user_name,user_sex,user_age,user_role
</sql>
<!-- 根据条件分页获取分页数据
List<User> selectUserPage (
@Param("userName")
String userName,
@Param("userSex")
String userSex,
@Param("startRow")
int startRow);//算好起始的行数
-->
<select id="selectUserPage" resultMap="userMap">
select <include refid="allColumns"/>
from user
<where>
<if test="userName != null and userName != ''">
and user_name like concat('%', #{userName}, '%')
</if>
<if test="userSex != null and userSex != ''">
and user_sex = #{userSex}
</if>
</where>
limit #{startRow},5
</select>
<!--
int insert(User user);
-->
<insert id="insert" parameterType="user">
insert into user values (#{userId},#{cardType},#{cardNo},#{userName},#{userSex},#{userAge},#{userRole})
</insert>
<!--
int delete(String userId);
-->
<delete id="delete" parameterType="string">
delete from user where user_id = #{userId}
</delete>
<!--
int getRowCount(
@Param("userName")
String userName,
@Param("userSex")
String userSex);
-->
<select id="getRowCount" resultType="int">
select count(*)
from user
<where>
<if test="userName != null and userName != ''">
and user_name like concat('%', #{userName}, '%')
</if>
<if test="userSex != null and userSex != ''">
and user_sex = #{userSex}
</if>
</where>
</select>
</mapper>
UserService.java业务逻辑层接口
package com.example.service;
import com.example.pojo.User;
import java.util.List;
/**
* 定义业务逻辑层接口:参照接口文档编写业务逻辑层接口
*/
public interface UserService {
/**
* /user/selectUserPage
* userName=z&userSex=男&page=null
*/
List<User> selectUserPage(String userName, String userSex, int startRow);
/**
* /user/createUser
*/
int createUser(User user);
/**
* /user/deleteUserById
*/
int deleteUserById(String userId);
/**
* /user/getRowCount?userName=z&userSex=男
*/
int getRowCount(String userName, String userSex);
}
业务逻辑层的实现类
package com.example.service.impl;
import com.example.mapper.UserMapper;
import com.example.pojo.User;
import com.example.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import java.util.List;
/**
* 业务逻辑层的实现类
*/
@Service
public class UserServiceImpl implements UserService {
//业务逻辑层的实现类要持有数据访问层的接口类型的变量
@Autowired
UserMapper userMapper;
@Override
public List<User> selectUserPage(String userName, String userSex, int startRow) {
return userMapper.selectUserPage(userName, userSex, startRow);
}
@Override
public int createUser(User user) {
return userMapper.createUser(user);
}
@Override
public int deleteUserById(String userId) {
return userMapper.deleteUserById(userId);
}
@Override
public int getRowCount(String userName, String userSex) {
return userMapper.getRowCount(userName, userSex);
}
}
测试数据访问层和业务逻辑层的功能是否正常
package com.example.test;
import com.example.pojo.User;
import com.example.service.UserService;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import java.util.List;
//启动spring容器
@RunWith(SpringJUnit4ClassRunner.class)
//导入spring容器的两个核心配置文件
@ContextConfiguration(locations = {"classpath:applicationContext_mapper.xml", "classpath:applicationContext_service.xml"})
public class TestUserServiceImpl {
@Autowired
UserService userService;
@Test
public void testSelectUserPage(){
List<User> userList = userService.selectUserPage("三", "男", 0);
userList.forEach(System.out::println);
}
@Test
public void testDeleteUserById(){
int num = userService.deleteUserById("15968162087363060");
System.out.println(num);
}
@Test
public void testGetRowCount(){
int num = userService.getRowCount(null, "男");
System.out.println(num);
}
@Test
public void testCreateUser(){
User user = new User("20020823", "身份证", "20220823", "荷包蛋", "女", "20", "女程序员");
int num = userService.createUser(user);
System.out.println(num);
}
}
控制器
package com.example.controller;
import com.example.pojo.User;
import com.example.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;
/**
* SpringMVC控制器
*
*/
@RestController//如果类中的请求全部都是ajax请求，那么可以使用该注解，类上的@ResponseBody注解可以不写
@RequestMapping("/user")
public class UserController {
//页面记录条数
public static final int PAGE_SIZE = 5;
//视图层持有业务逻辑层的接口类型的变量
@Autowired
UserService userService;
/**
* /user/selectUserPage?userName=z&userSex=男&page=null
*/
@RequestMapping("/selectUserPage")
public List<User> selectUserPage(String userName, String userSex, Integer page){
int startRow = 0;//起始行
if(page != null){
startRow = (page - 1) * PAGE_SIZE;//根据前端传来的页面数，计算起始行
}
return userService.selectUserPage(userName, userSex, startRow);
}
/**
* /user/getRowCount?userName=z&userSex=男
*/
@RequestMapping("/getRowCount")
public int getRowCount(String userName, String userSex){
return userService.getRowCount(userName, userSex);
}
/**
* /user/createUser(
*
* 参数
* cardType: this.ruleForm.cardType,//证件类型
* cardNo: this.ruleForm.cardNo,//证件号码
* userName: this.ruleForm.userName,//用户姓名
* userSex: this.ruleForm.userSex,//用户性别
* userAge: this.ruleForm.userAge,//用户年龄
* userRole: this.ruleForm.userRole,//用户角色
*/
@RequestMapping("/createUser")
public int createUser(User user){
//手动构建用户主键
String userId = System.currentTimeMillis() + "";
user.setUserId(userId);
return userService.createUser(user);
}
/**
* /user/deleteUserById?userId= 15968162087363060
*/
@RequestMapping("/deleteUserById")
public int deleteUserById(String userId){
return userService.deleteUserById(userId);
}
}
前端浏览器测试整个项目功能是否正常
- 直接在浏览器地址栏访问：localhost:8080/user/selectUserPage，后端返回的json格式的数据如下，其他测试不再赘述
控制器支持跨域访问 + ssm项目端口修改
- 在前后端分离开发中，由于我们使用vue作为前端开发框架，这里还要再做2件事
- a. vue框架使用8080端口，默认访问后端框架的8082端口，为了防止端口冲突，这里将ssm后端项目的端口修改为8082
- b. 由于前后端框架使用的端口不同，涉及到ajax跨域访问问题，前端vue支持跨域访问，所以要配置使得后端控制器也支持跨域访问，在上述控制器上添加@CrossOrigin注解，使后端支持跨域访问
结语
- 到这里ssm框架的后端整合已经完成，由于vue还没有学习到，前端框架的内容不再赘述
分类:
SpringMVC
· 阿里巴巴 QwQ-32B真的超越了 DeepSeek R-1吗？
· 10年+ .NET Coder 心语 ── 封装的思维：从隐藏、稳定开始理解其本质意义
· 【译】Visual Studio 中新的强大生产力特性
· 【设计模式】告别冗长if-else语句：使用策略模式优化代码结构
· 字符编码：从基础到乱码解决