一、SSM整合的步骤

0)建库,建表

  1. /*
  2. Navicat Premium Data Transfer
  4. Source Server         : zar
  5. Source Server Type    : MySQL
  6. Source Server Version : 80022
  7. Source Host           : localhost:3306
  8. Source Schema         : ssmusers
  10. Target Server Type    : MySQL
  11. Target Server Version : 80022
  12. File Encoding         : 65001
  14. Date: 26/06/2021 16:26:14
  15. */
  17. SET NAMES utf8mb4;
  18. SET FOREIGN_KEY_CHECKS = 0;
  20. CREATE DATABASE IF NOT EXISTS `ssmuser` DEFAULT CHARACTER SET utf8;
  21. USE `ssmuser`;
  23. -- ----------------------------
  24. -- Table structure for user
  25. -- ----------------------------
  26. DROP TABLE IF EXISTS `user`;
  27. CREATE TABLE `user`  (
  28.   `user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  29.   `card_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  30.   `card_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  31.   `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  32.   `user_sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  33.   `user_age` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  34.   `user_role` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  35.   PRIMARY KEY (`user_id`) USING BTREE
  36. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;
  38. -- ----------------------------
  39. -- Records of user
  40. -- ----------------------------
  41. INSERT INTO `user` VALUES ('15968162087363060', '身份证', '114264195202156467', '张三', '男', '30', '办事人员和有关人员');
  42. INSERT INTO `user` VALUES ('15968162346981977', '护照', 'A32532654', '李四', '男', '29', '不便分类的其他从业人员');
  43. INSERT INTO `user` VALUES ('15968162893439470', '身份证', '112344198709094532', '王五', '男', '31', '农、林、牧、渔、水利业生产人员');
  44. INSERT INTO `user` VALUES ('15968163245457143', '身份证', '453234199909094532', '赵六', '男', '34', '未知');
  45. INSERT INTO `user` VALUES ('15968163514764733', '军官证', '军7657868', '钱七', '女', '23', '不便分类的其他从业人员');
  46. INSERT INTO `user` VALUES ('15968165113694372', '台湾往来大陆通行证', '43256786', '周八', '女', '48', '生产、运输设备操作人员及有关人员');
  47. INSERT INTO `user` VALUES ('15968165371931786', '港澳居民通行证', 'C98767665', '吴九', '女', '35', '不便分类的其他从业人员');
  48. INSERT INTO `user` VALUES ('15968941217553030', '身份证', '343546199801018768', '郑十', '男', '22', '军人');
  49. INSERT INTO `user` VALUES ('15968943937844616', '身份证', '445453199603025756', '冯十一', '女', '31', '不便分类的其他从业人员');
  50. INSERT INTO `user` VALUES ('15968944123869023', '护照', 'B54322654', '陈十二', '女', '39', '农、林、牧、渔、水利业生产人员');
  51. INSERT INTO `user` VALUES ('15968953962316864', '身份证', '110232199505056789', '朱十三', '女', '33', '商业、服务业人员');
  52. INSERT INTO `user` VALUES ('15968954638794962', '身份证', '110654196604079098', '孔十四', '女', '29', '生产、运输设备操作人员及有关人员');
  54. SET FOREIGN_KEY_CHECKS = 1;

1)新建Maven项目,选择webapp模板

2)修改目录

image.png

3)修改pom.xml文件(使用老师提供)

  1. <?xml version="1.0" encoding="UTF-8"?>
  3. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  5.   <modelVersion>4.0.0</modelVersion>
  7.   <groupId>com.bjpowernode</groupId>
  8.   <artifactId>springmvc_006_ssm</artifactId>
  9.   <version>1.0</version>
  10.   <packaging>war</packaging>
  15.   <!-- 集中定义依赖版本号 -->
  16.   <properties>
  17.     <!--单元测试的依赖-->
  18.     <junit.version>4.12</junit.version>
  20.     <!--spring的相关依赖-->
  21.     <spring.version>5.2.5.RELEASE</spring.version>
  22.     <!--注意这个依赖要与mysql版本一致>
  23.     <mysql.version>8.0.27</mysql.version>
  25.     <!--mybatis的相关依赖-->
  26.     <mybatis.version>3.5.1</mybatis.version>
  27.     <!--mybaits与spring整合的依赖-->
  28.     <mybatis.spring.version>1.3.1</mybatis.spring.version>
  29.     <!--mybatis支持的分页插件的依赖-->
  30.     <mybatis.paginator.version>1.2.15</mybatis.paginator.version>
  31.     <!--mysql的依赖-->
  32.     <mysql.version>5.1.32</mysql.version>
  33.     <!--slf4j日志依赖-->
  34.     <slf4j.version>1.6.4</slf4j.version>
  35.     <!--阿里的数据库连接池-->
  36.     <druid.version>1.1.12</druid.version>
  37.     <!--分页插件的依赖-->
  38.     <pagehelper.version>5.1.2</pagehelper.version>
  39.     <!--JSTL的依赖(jsp的标准标签库)-->
  40.     <jstl.version>1.2</jstl.version>
  41.     <!--servlet的依赖-->
  42.     <servlet-api.version>3.0.1</servlet-api.version>
  43.     <!--jsp的依赖-->
  44.     <jsp-api.version>2.0</jsp-api.version>
  45.     <!--jackson的依赖,springmvc框架默认进行JSON转换的依赖工具-->
  46.     <jackson.version>2.9.6</jackson.version>
  47.   </properties>
  50.   <dependencies>
  51.     <!-- spring -->
  52.     <dependency>
  53.       <groupId>org.springframework</groupId>
  54.       <artifactId>spring-context</artifactId>
  55.       <version>${spring.version}</version>
  56.     </dependency>
  57.     <dependency>
  58.       <groupId>org.springframework</groupId>
  59.       <artifactId>spring-beans</artifactId>
  60.       <version>${spring.version}</version>
  61.     </dependency>
  62.     <dependency>
  63.       <groupId>org.springframework</groupId>
  64.       <artifactId>spring-webmvc</artifactId>
  65.       <version>${spring.version}</version>
  66.     </dependency>
  67.     <dependency>
  68.       <groupId>org.springframework</groupId>
  69.       <artifactId>spring-jdbc</artifactId>
  70.       <version>${spring.version}</version>
  71.     </dependency>
  72.     <dependency>
  73.       <groupId>org.springframework</groupId>
  74.       <artifactId>spring-aspects</artifactId>
  75.       <version>${spring.version}</version>
  76.     </dependency>
  77.     <dependency>
  78.       <groupId>org.springframework</groupId>
  79.       <artifactId>spring-jms</artifactId>
  80.       <version>${spring.version}</version>
  81.     </dependency>
  82.     <dependency>
  83.       <groupId>org.springframework</groupId>
  84.       <artifactId>spring-context-support</artifactId>
  85.       <version>${spring.version}</version>
  86.     </dependency>
  87.     <dependency>
  88.       <groupId>org.springframework</groupId>
  89.       <artifactId>spring-test</artifactId>
  90.       <version>5.2.5.RELEASE</version>
  91.     </dependency>
  92.     <!-- Mybatis -->
  93.     <dependency>
  94.       <groupId>org.mybatis</groupId>
  95.       <artifactId>mybatis</artifactId>
  96.       <version>${mybatis.version}</version>
  97.     </dependency>
  98.     <dependency>
  99.       <groupId>org.mybatis</groupId>
  100.       <artifactId>mybatis-spring</artifactId>
  101.       <version>${mybatis.spring.version}</version>
  102.     </dependency>
  103.     <dependency>
  104.       <groupId>com.github.miemiedev</groupId>
  105.       <artifactId>mybatis-paginator</artifactId>
  106.       <version>${mybatis.paginator.version}</version>
  107.     </dependency>
  108.     <dependency>
  109.       <groupId>com.github.pagehelper</groupId>
  110.       <artifactId>pagehelper</artifactId>
  111.       <version>${pagehelper.version}</version>
  112.     </dependency>
  113.     <!-- MySql -->
  114.     <dependency>
  115.       <groupId>mysql</groupId>
  116.       <artifactId>mysql-connector-java</artifactId>
  117.       <version>${mysql.version}</version>
  118.     </dependency>
  119.     <!-- 连接池 -->
  120.     <dependency>
  121.       <groupId>com.alibaba</groupId>
  122.       <artifactId>druid</artifactId>
  123.       <version>${druid.version}</version>
  124.     </dependency>
  126.     <!-- junit -->
  127.     <dependency>
  128.       <groupId>junit</groupId>
  129.       <artifactId>junit</artifactId>
  130.       <version>${junit.version}</version>
  131.       <scope>test</scope>
  132.     </dependency>
  135.     <!-- JSP相关 -->
  136.     <dependency>
  137.       <groupId>jstl</groupId>
  138.       <artifactId>jstl</artifactId>
  139.       <version>${jstl.version}</version>
  140.     </dependency>
  141.     <dependency>
  142.       <groupId>javax.servlet</groupId>
  143.       <artifactId>javax.servlet-api</artifactId>
  144.       <version>3.0.1</version>
  145.       <scope>provided</scope>
  146.     </dependency>
  147.     <dependency>
  148.       <groupId>javax.servlet</groupId>
  149.       <artifactId>jsp-api</artifactId>
  150.       <scope>provided</scope>
  151.       <version>${jsp-api.version}</version>
  152.     </dependency>
  153.     <!-- Jackson Json处理工具包 -->
  154.     <dependency>
  155.       <groupId>com.fasterxml.jackson.core</groupId>
  156.       <artifactId>jackson-databind</artifactId>
  157.       <version>${jackson.version}</version>
  158.     </dependency>
  160.   </dependencies>
  162.   <!-- 插件配置 -->
  163.   <build>
  164.     <plugins>
  165.       <plugin>
  166.         <groupId>org.apache.maven.plugins</groupId>
  167.         <artifactId>maven-compiler-plugin</artifactId>
  168.         <configuration>
  169.           <source>1.8</source>
  170.           <target>1.8</target>
  171.           <encoding>UTF-8</encoding>
  172.         </configuration>
  173.       </plugin>
  174.     </plugins>
  175.     <!--识别所有的配置文件-->
  176.     <resources>
  177.       <resource>
  178.         <directory>src/main/java</directory>
  179.         <includes>
  180.           <include>**/*.properties</include>
  181.           <include>**/*.xml</include>
  182.         </includes>
  183.         <filtering>false</filtering>
  184.       </resource>
  185.       <resource>
  186.         <directory>src/main/resources</directory>
  187.         <includes>
  188.           <include>**/*.properties</include>
  189.           <include>**/*.xml</include>
  190.         </includes>
  191.         <filtering>false</filtering>
  192.       </resource>
  193.     </resources>
  194.   </build>
  198. </project>

4)添加jdbc.properties属性文件

  1. jdbc.driver=com.mysql.jdbc.Driver
  2. jdbc.url=jdbc:mysql://localhost:3306/ssmuser?useUnicode=true&characterEncoding=utf8
  3. jdbc.username=root
  4. jdbc.password=123456
  1. jdbc.driverClassName=com.mysql.cj.jdbc.Driver
  2. jdbc.url=jdbc:mysql://localhost:3306/ssmuser?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
  3. jdbc.username=root
  4. jdbc.password=123456

5)添加SqlMapConfig.xml文件(使用模板)

  1. <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  2.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
  3. <configuration>
  6.   <!--设置日志输出语句,显示相应操作的sql语名-->
  7.   <settings>
  8.     <setting name="logImpl" value="STDOUT_LOGGING"/>
  9.   </settings>
  11. </configuration>

6)添加applicationContext_mapper.xml文件(数据访问层的核心配置文件)

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.        xmlns:context="http://www.springframework.org/schema/context"
  5.        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">
  7.     <!--读取属性文件-->
  8.     <context:property-placeholder location="classpath:jdbc.properties"></context:property-placeholder>
  10.     <!--配置数据源-->
  11.     <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
  12.         <property name="driverClassName" value="${jdbc.driverClassName}"></property>
  13.         <property name="url" value="${jdbc.url}"></property>
  14.         <property name="username" value="${jdbc.username}"></property>
  15.         <property name="password" value="${jdbc.password}"></property>
  16.     </bean>
  18.     <!--配置SqlSessionFactoryBean-->
  19.     <bean class="org.mybatis.spring.SqlSessionFactoryBean">
  20.         <!--配置数据源-->
  21.         <property name="dataSource" ref="dataSource"></property>
  22.         <!--配置SqlMapConfig.xml核心配置-->
  23.         <property name="configLocation" value="classpath:SqlMapConfig.xml"></property>
  24.         <!--注册实体类-->
  25.         <property name="typeAliasesPackage" value="com.bjpowernode.pojo"></property>
  26.     </bean>
  27.     <!--注册mapper.xml文件-->
  28.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  29.         <property name="basePackage" value="com.bjpowernode.mapper"></property>
  30.     </bean>
  31. </beans>

7)添加applicationContext_service.xml文件(业务逻辑层的核心配置文件)

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.        xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
  5.        xmlns:aop="http://www.springframework.org/schema/aop"
  6.        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">
  8.     <!--添加包扫描-->
  9.     <context:component-scan base-package="com.bjpowernode.service.impl"></context:component-scan>
  10.     <!--添加事务管理器-->
  11.     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  12.         <!--切记切记:配置数据源-->
  13.         <property name="dataSource" ref="dataSource"></property>
  14.     </bean>
  15.     <!--配置事务切面-->
  16.     <tx:advice id="myadvice" transaction-manager="transactionManager">
  17.         <tx:attributes>
  18.             <tx:method name="*select*" read-only="true"/>
  19.             <tx:method name="*find*" read-only="true"/>
  20.             <tx:method name="*serach*" read-only="true"/>
  21.             <tx:method name="*get*" read-only="true"/>
  22.             <tx:method name="*insert*" propagation="REQUIRED"/>
  23.             <tx:method name="*add*" propagation="REQUIRED"/>
  24.             <tx:method name="*save*" propagation="REQUIRED"/>
  25.             <tx:method name="*set*" propagation="REQUIRED"/>
  26.             <tx:method name="*update*" propagation="REQUIRED"/>
  27.             <tx:method name="*change*" propagation="REQUIRED"/>
  28.             <tx:method name="*modify*" propagation="REQUIRED"/>
  29.             <tx:method name="*delete*" propagation="REQUIRED"/>
  30.             <tx:method name="*drop*" propagation="REQUIRED"/>
  31.             <tx:method name="*remove*" propagation="REQUIRED"/>
  32.             <tx:method name="*clear*" propagation="REQUIRED"/>
  33.             <tx:method name="*" propagation="SUPPORTS"/>
  34.         </tx:attributes>
  35.     </tx:advice>
  36.     <!--配置切入点+绑定-->
  37.     <aop:config>
  38.         <aop:pointcut id="mycut" expression="execution(* com.bjpowernode.service.impl.*.*(..))"></aop:pointcut>
  39.         <aop:advisor advice-ref="myadvice" pointcut-ref="mycut"></aop:advisor>
  40.     </aop:config>
  41. </beans>

8)添加spirngmvc.xml文件

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.        xmlns:context="http://www.springframework.org/schema/context"
  5.        xmlns:mvc="http://www.springframework.org/schema/mvc"
  6.        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">
  8.     <!--添加包扫描-->
  9.     <context:component-scan base-package="com.bjpowernode.controller"></context:component-scan>
  10.     <!--添加注解驱动-->
  11.     <mvc:annotation-driven></mvc:annotation-driven>
  12.     <!--因为本项目全部是ajax请求,不需要配置视图解析器-->
  13. </beans>

image.png

9)删除web.xml文件,新建,改名,设置中文编码,并注册spirngmvc框架,并注册Spring框架

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
  3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.          xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
  5.          version="4.0">
  6.     <!--添加中文编码过滤器
  7.         private String encoding;
  8.         private boolean forceRequestEncoding;
  9.         private boolean forceResponseEncoding;
  10.     -->
  11.     <filter>
  12.         <filter-name>encode</filter-name>
  13.         <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
  14.         <init-param>
  15.             <param-name>encoding</param-name>
  16.             <param-value>UTF-8</param-value>
  17.         </init-param>
  18.         <init-param>
  19.             <param-name>forceRequestEncoding</param-name>
  20.             <param-value>true</param-value>
  21.         </init-param>
  22.         <init-param>
  23.             <param-name>forceResponseEncoding</param-name>
  24.             <param-value>true</param-value>
  25.         </init-param>
  26.     </filter>
  27.     <filter-mapping>
  28.         <filter-name>encode</filter-name>
  29.         <url-pattern>/*</url-pattern>
  30.     </filter-mapping>
  31.     <!--注册SpringMVC框架-->
  32.     <servlet>
  33.         <servlet-name>springmvc</servlet-name>
  34.         <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  35.         <init-param>
  36.             <param-name>contextConfigLocation</param-name>
  37.             <param-value>classpath:springmvc.xml</param-value>
  38.         </init-param>
  39.     </servlet>
  40.     <servlet-mapping>
  41.         <servlet-name>springmvc</servlet-name>
  42.         <url-pattern>/</url-pattern>
  43.     </servlet-mapping>
  44.     <!--注册Spring框架,目的就是启动spring容器-->
  45.     <listener>
  46.         <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  47.     </listener>
  48.     <context-param>
  49.         <param-name>contextConfigLocation</param-name>
  50.         <param-value>classpath:applicationContext_*.xml</param-value>
  51.     </context-param>
  52. </web-app>

10)新建实体类user

  1. package com.bjpowernode.pojo;
  3. /**
  4. *
  5. */
  6. public class User {
  7.     private String userId;
  8.     private String cardType;
  9.     private String cardNo;
  10.     private String userName;
  11.     private String userSex;
  12.     private String userAge;
  13.     private String userRole;
  15.     @Override
  16.     public String toString() {
  17.         return "User{" +
  18.             "userId='" + userId + '\'' +
  19.             ", cardType='" + cardType + '\'' +
  20.             ", cardNo='" + cardNo + '\'' +
  21.             ", userName='" + userName + '\'' +
  22.             ", userSex='" + userSex + '\'' +
  23.             ", userAge='" + userAge + '\'' +
  24.             ", userRole='" + userRole + '\'' +
  25.             '}';
  26.     }
  28.     public String getUserId() {
  29.         return userId;
  30.     }
  32.     public void setUserId(String userId) {
  33.         this.userId = userId;
  34.     }
  36.     public String getCardType() {
  37.         return cardType;
  38.     }
  40.     public void setCardType(String cardType) {
  41.         this.cardType = cardType;
  42.     }
  44.     public String getCardNo() {
  45.         return cardNo;
  46.     }
  48.     public void setCardNo(String cardNo) {
  49.         this.cardNo = cardNo;
  50.     }
  52.     public String getUserName() {
  53.         return userName;
  54.     }
  56.     public void setUserName(String userName) {
  57.         this.userName = userName;
  58.     }
  60.     public String getUserSex() {
  61.         return userSex;
  62.     }
  64.     public void setUserSex(String userSex) {
  65.         this.userSex = userSex;
  66.     }
  68.     public String getUserAge() {
  69.         return userAge;
  70.     }
  72.     public void setUserAge(String userAge) {
  73.         this.userAge = userAge;
  74.     }
  76.     public String getUserRole() {
  77.         return userRole;
  78.     }
  80.     public void setUserRole(String userRole) {
  81.         this.userRole = userRole;
  82.     }
  84.     public User(String userId, String cardType, String cardNo, String userName, String userSex, String userAge, String userRole) {
  85.         this.userId = userId;
  86.         this.cardType = cardType;
  87.         this.cardNo = cardNo;
  88.         this.userName = userName;
  89.         this.userSex = userSex;
  90.         this.userAge = userAge;
  91.         this.userRole = userRole;
  92.     }
  94.     public User() {
  95.     }
  96. }

11)新建UserMapper.java接口

  1. package com.bjpowernode.mapper;
  3. import com.bjpowernode.pojo.User;
  4. import org.apache.ibatis.annotations.Param;
  6. import java.util.List;
  8. /**
  9.  *
  10.  */
  11. public interface UserMapper {
  12.     /**
  13.      * url    /user/selectUserPage?userName=z&userSex=男&page=null
  14.      * 参数
  15.          * userName:表单中用户名称
  16.          * userSex:表单中用户性别
  17.          * page:提交的页码(第一次访问为null)
  18.      * 结果    有数据时：
  19.      * [{
  20.      * "userId":"15968954638794962",
  21.      * "cardType":"身份证","
  22.      * cardNo":"343343554654",
  23.      * "userName":"撒撒旦",
  24.      * "userSex":"女",
  25.      * "userAge":"29",
  26.      * "userRole":"生产、运输设备操作人员及有关人员"},
  27.      * {….}
  28.      * ]
  29.      * 无数据时：
  30.      * []
  31.      *
  32.      * select * from user
  33.      * #limit (当前页码-1)*每页条数,每页条数
  34.      * limit 10,5;
  35.      */
  36.     List<User> selectUserPage(
  37.             @Param("userName")
  38.             String userName,
  39.             @Param("userSex")
  40.             String userSex,
  41.             @Param("startRow")  //算好的起始行的值
  42.             int startRow);
  44.     /**
  45.      * url    /user/createUser(参数见下面)
  46.      * 参数
  47.          * cardType: this.ruleForm.cardType,//证件类型
  48.          * cardNo: this.ruleForm.cardNo,//证件号码
  49.          * userName: this.ruleForm.userName,//用户姓名
  50.          * userSex: this.ruleForm.userSex,//用户性别
  51.          * userAge: this.ruleForm.userAge,//用户年龄
  52.          * userRole: this.ruleForm.userRole,//用户角色
  53.      * 结果    增加成功时：
  54.      * 1
  55.      * 增加失败时:
  56.      * 0
  57.      */
  58.     int createUser(User user);
  60.     /**
  61.      * url    /user/ deleteUserById?userId= 15968162087363060
  62.      * 参数
  63.      *      userId:删除用户的id
  64.      * 结果
  65.      * 删除成功时：
  66.      * 1
  67.      * 删除失败时:
  68.      * 0
  69.      */
  70.     int deleteUserById(String userId);
  72.     /**
  73.      * url    /user/getRowCount?userName=z&userSex=男
  74.      * 参数
  75.      *      userName:表单中用户名称
  76.      *      userSex:表单中用户性别
  77.      * 结果    有数据时:
  78.      * 12
  79.      * 无数据时:
  80.      * 0
  81.      */
  82.     int getRowCount(
  83.             @Param("userName")
  84.             String userName,
  85.             @Param("userSex")
  86.             String userSex);
  87. }

12)新建UserMapper.xml实现增删查所有功能,没有更新

  1. <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  2.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  3. <mapper namespace="com.bjpowernode.mapper.UserMapper">
  4.   <!--完成实体类与表中列名的映射
  5.         private String userId;
  6.         private String cardType;
  7.         private String cardNo;
  8.         private String userName;
  9.         private String userSex;
  10.         private String userAge;
  11.         private String userRole;
  12.     -->
  13.   <resultMap id="usermap" type="user">
  14.     <id property="userId" column="user_id"></id>
  15.     <result property="cardType" column="card_type"></result>
  16.     <result property="cardNo" column="card_no"></result>
  17.     <result property="userName" column="user_name"></result>
  18.     <result property="userSex" column="user_sex"></result>
  19.     <result property="userAge" column="user_age"></result>
  20.     <result property="userRole" column="user_role"></result>
  21.   </resultMap>
  23.   <!--定义全部列名-->
  24.   <sql id="allColumns">
  25.     user_id,card_type,card_no,user_name,user_sex,user_age,user_role
  26.   </sql>
  28.   <!--
  29.       List<User> selectUserPage(
  30.             @Param("userName")
  31.             String userName,
  32.             @Param("userSex")
  33.             String userSex,
  34.             @Param("startRow")  //算好的起始行的值
  35.             int startRow);
  36.     -->
  37.   <select id="selectUserPage" resultMap="usermap">
  38.     select <include refid="allColumns"></include>
  39.     from user
  40.     <where>
  41.       <if test="userName != null and userName != ''">
  42.         and user_name like concat('%',#{userName},'%')
  43.       </if>
  44.       <if test="userSex != null and userSex != ''">
  45.         and user_sex = #{userSex}
  46.       </if>
  47.     </where>
  48.     limit #{startRow},5
  49.   </select>
  51.   <!--
  52.       int createUser(User user);
  53.     -->
  54.   <insert id="createUser" parameterType="user">
  55.     insert into user values(#{userId},#{cardType},#{cardNo},#{userName},#{userSex},#{userAge},#{userRole})
  56.   </insert>
  58.   <!--
  59.       int deleteUserById(String userId);
  60.     -->
  61.   <delete id="deleteUserById" parameterType="string">
  62.     delete from user where user_id = #{userId}
  63.   </delete>
  65.   <!--
  66.       int getRowCount(
  67.             @Param("userName")
  68.             String userName,
  69.             @Param("userSex")
  70.             String userSex);
  71.     -->
  72.   <select id="getRowCount" resultType="int">
  73.     select count(*)
  74.     from user
  75.     <where>
  76.       <if test="userName != null and userName != ''">
  77.         and user_name like concat('%',#{userName},'%')
  78.       </if>
  79.       <if test="userSex != null and userSex != ''">
  80.         and user_sex = #{userSex}
  81.       </if>
  82.     </where>
  83.   </select>
  85. </mapper>

13)新建service接口和实现类

  1. package com.bjpowernode.service;
  3. import com.bjpowernode.pojo.User;
  5. import java.util.List;
  7. /**
  8. *
  9. */
  10. public interface UserService {
  11.     /**
  12.     * url    /user/selectUserPage?userName=z&userSex=男&page=null
  13.     */
  14.     List<User> selectUserPage(String userName,String userSex,int startRow);
  16.     /**
  17.     * /user/createUser(参数见下面)
  18.     */
  19.     int createUser(User user);
  21.     /**
  22.     * user/ deleteUserById?userId= 15968162087363060
  23.     */
  24.     int deleteUserById(String userId);
  25.     /**
  26.     * /user/getRowCount?userName=z&userSex=男
  27.     */
  28.     int getRowCount(String userName,String userSex);
  29. }
  1. package com.bjpowernode.service.impl;
  3. import com.bjpowernode.mapper.UserMapper;
  4. import com.bjpowernode.pojo.User;
  5. import com.bjpowernode.service.UserService;
  6. import org.springframework.beans.factory.annotation.Autowired;
  7. import org.springframework.stereotype.Service;
  9. import java.util.List;
  11. /**
  12.  *
  13.  */
  14. @Service
  15. public class UserServiceImpl implements UserService {
  17.     //切记切记:一定会有数据访问层的对象
  18.     @Autowired
  19.     UserMapper userMapper;
  21.     @Override
  22.     public List<User> selectUserPage(String userName, String userSex, int startRow) {
  23.         return userMapper.selectUserPage(userName,userSex,startRow);
  24.     }
  26.     @Override
  27.     public int createUser(User user) {
  28.         return userMapper.createUser(user);
  29.     }
  31.     @Override
  32.     public int deleteUserById(String userId) {
  33.         return userMapper.deleteUserById(userId);
  34.     }
  36.     @Override
  37.     public int getRowCount(String userName, String userSex) {
  38.         return userMapper.getRowCount(userName,userSex);
  39.     }
  40. }

14)新建测试类,完成所有功能的测试

  1. package test;
  3. import com.bjpowernode.pojo.User;
  4. import com.bjpowernode.service.UserService;
  5. import org.junit.Test;
  6. import org.junit.runner.RunWith;
  7. import org.springframework.beans.factory.annotation.Autowired;
  8. import org.springframework.test.context.ContextConfiguration;
  9. import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
  11. import java.util.List;
  13. /**
  14.  *
  15.  */
  16. @RunWith(SpringJUnit4ClassRunner.class) //启动spring容器
  17. @ContextConfiguration(locations = {"classpath:applicationContext_mapper.xml","classpath:applicationContext_service.xml"})
  18. public class MyTest {
  20.     @Autowired
  21.     UserService userService;
  23.     @Test
  24.     public void testSelectUserPage(){
  25.         List<User> list = userService.selectUserPage("三","男",0);
  26.         list.forEach(user -> System.out.println(user));
  27.     }
  29.     @Test
  30.     public void testDeleteUserById(){
  31.        int num = userService.deleteUserById("15968162087363060");
  32.         System.out.println(num);
  33.     }
  34.     @Test
  35.     public void testGetRowCount(){
  36.         int num = userService.getRowCount(null,"男");
  37.         System.out.println(num);
  38.     }
  40.     @Test
  41.     public void testCreateUser(){
  42.         User u = new User("125412145214547846","身份证","121451245784","哈哈","男","23","工人");
  43.         int num = userService.createUser(u);
  44.         System.out.println("-----"+num);
  45.     }
  47. }

15)新建控制器,完成所有功能

  1. package com.bjpowernode.controller;
  3. import com.bjpowernode.pojo.User;
  4. import com.bjpowernode.service.UserService;
  5. import org.springframework.beans.factory.annotation.Autowired;
  6. import org.springframework.stereotype.Controller;
  7. import org.springframework.web.bind.annotation.CrossOrigin;
  8. import org.springframework.web.bind.annotation.RequestMapping;
  9. import org.springframework.web.bind.annotation.ResponseBody;
  10. import org.springframework.web.bind.annotation.RestController;
  12. import java.util.List;
  14. /**
  15.  *
  16.  */
  17. @CrossOrigin  //在服务器端支持跨域访问
  18. @RestController  //如果本类中全部都是ajax请求,则使用此注解,方法上的@ResponseBody可不写
  19. @RequestMapping("/user")
  20. public class UserController {
  22.     //切记切记:一定会有业务逻辑层的对象
  23.     @Autowired
  24.     UserService userService;
  26.     public static final int PAGE_SIZE = 5;
  28.     //user/selectUserPage?userName=z&userSex=男&page=null
  29.     @RequestMapping("/selectUserPage")
  31.     public List<User> selectUserPage(String userName,String userSex,Integer page){
  32.         //根据页码计算起始行
  33.         int startRow = 0;
  34.         if(page != null){
  35.             startRow = (page-1) * PAGE_SIZE;
  36.         }
  38.         return userService.selectUserPage(userName,userSex,startRow);
  39.     }
  40.     ///user/getRowCount?userName=z&userSex=男
  41.     @RequestMapping("/getRowCount")
  43.     public int getRowCount(String userName,String userSex){
  44.         return userService.getRowCount(userName,userSex);
  45.     }
  46.     ///user/deleteUserById?userId= 15968162087363060
  47.     @RequestMapping("/deleteUserById")
  49.     public int deleteUserById(String userId){
  50.         return userService.deleteUserById(userId);
  51.     }
  53.     ///user/createUser(参数见下面)
  54.     @RequestMapping("/createUser")
  56.     public int createUser(User user){
  57.         String userId = System.currentTimeMillis()+"";
  58.         user.setUserId(userId);
  59.         return userService.createUser(user);
  60.     }
  61. }

16)浏览器测试功能