包依赖
数据库相关包：mysql-connector 、c3p0连接池或druid
持久层包：mybatis、spirng整合mybatis
spring包：springwebmvc、spring jdbc
视图包：默认视图、jsp视图、thymeleaf视图、servlet-api
单元测试包：junit

  1. <dependencies>
  3.   <!--数据库相关包mysql-connector 、连接池 -->
  4.   <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
  5.   <dependency>
  6.     <groupId>mysql</groupId>
  7.     <artifactId>mysql-connector-java</artifactId>
  8.     <version>8.0.26</version>
  9.   </dependency>
  11.   <!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
  12.   <dependency>
  13.     <groupId>com.alibaba</groupId>
  14.     <artifactId>druid</artifactId>
  15.     <version>1.2.8</version>
  16.   </dependency>
  19.   <!--持久层包mybatis、spring整合mybatis -->
  20.   <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
  21.   <dependency>
  22.     <groupId>org.mybatis</groupId>
  23.     <artifactId>mybatis</artifactId>
  24.     <version>3.5.7</version>
  25.   </dependency>
  27.   <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
  28.   <dependency>
  29.     <groupId>org.mybatis</groupId>
  30.     <artifactId>mybatis-spring</artifactId>
  31.     <version>2.0.6</version>
  32.   </dependency>
  35.   <!--spring包 springwebmvc 、 spring jdbc -->
  36.   <!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
  37.   <dependency>
  38.     <groupId>org.springframework</groupId>
  39.     <artifactId>spring-webmvc</artifactId>
  40.     <version>5.2.9.RELEASE</version>
  41.   </dependency>
  43.   <!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
  44.   <dependency>
  45.     <groupId>org.springframework</groupId>
  46.     <artifactId>spring-jdbc</artifactId>
  47.     <version>5.2.9.RELEASE</version>
  48.   </dependency>
  51.   <!--视图包 thymeleaf 、 servlet-api-->
  52.   <!-- https://mvnrepository.com/artifact/org.thymeleaf/thymeleaf -->
  53.   <dependency>
  54.     <groupId>org.thymeleaf</groupId>
  55.     <artifactId>thymeleaf</artifactId>
  56.     <version>3.0.11.RELEASE</version>
  57.   </dependency>
  59.   <!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api -->
  60.   <dependency>
  61.     <groupId>javax.servlet</groupId>
  62.     <artifactId>javax.servlet-api</artifactId>
  63.     <version>3.1.0</version>
  64.     <scope>provided</scope>
  65.   </dependency>
  67.   <!--单元测试包 junint-->
  68.   <!-- https://mvnrepository.com/artifact/junit/junit -->
  69.   <dependency>
  70.     <groupId>junit</groupId>
  71.     <artifactId>junit</artifactId>
  72.     <version>4.12</version>
  73.     <scope>test</scope>
  74.   </dependency>
  77.   <!--日志包 log4j -->
  78.   <!-- https://mvnrepository.com/artifact/log4j/log4j -->
  79.   <dependency>
  80.     <groupId>log4j</groupId>
  81.     <artifactId>log4j</artifactId>
  82.     <version>1.2.17</version>
  83.   </dependency>
  86.   <!--其他包-->
  88. </dependencies>

一、项目介绍

1、技术点

基础框架：SSM(Spring + SpringMVC + Mybatis)
数据库：MySQL 8.0.26
前端框架：BootStrap 3.4.1
项目构建：Maven 3.6.3
分页插件：pageHelper
逆向工程：Mybatis-Generator 1.3.5

2、功能点

分页
数据校验
前端校验jQuery + 后端校验 JSR303
ajax
Rest风格的URI

二、环境搭建

1、创建maven工程 链接

image.png

2、引入jar包

  1.     <dependencies>
  3.         <!-- 1.Spring-MVC 依赖 -->
  4.         <!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
  5.         <dependency>
  6.             <groupId>org.springframework</groupId>
  7.             <artifactId>spring-webmvc</artifactId>
  8.             <version>4.3.7.RELEASE</version>
  9.         </dependency>
  11.         <!-- 2.Spring jdbc -->
  12.         <!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
  13.         <dependency>
  14.             <groupId>org.springframework</groupId>
  15.             <artifactId>spring-jdbc</artifactId>
  16.             <version>4.3.7.RELEASE</version>
  17.         </dependency>
  19.         <!-- 3.spring 面向切面编程 Aspects -->
  20.         <!-- https://mvnrepository.com/artifact/org.springframework/spring-aspects -->
  21.         <dependency>
  22.             <groupId>org.springframework</groupId>
  23.             <artifactId>spring-aspects</artifactId>
  24.             <version>4.3.7.RELEASE</version>
  25.         </dependency>
  28.         <!-- 4.mybatis 依赖 -->
  29.         <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
  30.         <dependency>
  31.             <groupId>org.mybatis</groupId>
  32.             <artifactId>mybatis</artifactId>
  33.             <version>3.4.2</version>
  34.         </dependency>
  37.         <!-- 5.mybatis-spring 整合 -->
  38.         <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
  39.         <dependency>
  40.             <groupId>org.mybatis</groupId>
  41.             <artifactId>mybatis-spring</artifactId>
  42.             <version>1.3.1</version>
  43.         </dependency>
  45.         <!-- 6.数据库连接池、连接驱动 -->
  46.         <!-- https://mvnrepository.com/artifact/com.mchange/c3p0 -->
  47.         <dependency>
  48.             <groupId>com.mchange</groupId>
  49.             <artifactId>c3p0</artifactId>
  50.             <version>0.9.2</version>
  51.         </dependency>
  53.         <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
  54.         <dependency>
  55.             <groupId>mysql</groupId>
  56.             <artifactId>mysql-connector-java</artifactId>
  57.             <version>8.0.26</version>
  58.         </dependency>
  60.         <!-- 7.jstl junit sevlet-api -->
  61.         <!-- https://mvnrepository.com/artifact/jstl/jstl -->
  62.         <dependency>
  63.             <groupId>jstl</groupId>
  64.             <artifactId>jstl</artifactId>
  65.             <version>1.2</version>
  66.         </dependency>
  68.         <!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api -->
  69.         <dependency>
  70.             <groupId>javax.servlet</groupId>
  71.             <artifactId>javax.servlet-api</artifactId>
  72.             <version>3.1.0</version>
  73.             <scope>provided</scope>
  74.         </dependency>
  76.         <!-- https://mvnrepository.com/artifact/junit/junit -->
  77.         <dependency>
  78.             <groupId>junit</groupId>
  79.             <artifactId>junit</artifactId>
  80.             <version>4.12</version>
  81.             <scope>test</scope>
  82.         </dependency>
  85.     </dependencies>

3、引入bootstrap前端框架 链接

image.png

4、编写ssm整合的关键配置文件 链接

1>配置web.xml 链接

  1. <!-- 1.启动spring容器 -->
  2.     <!-- needed for ContextLoaderListener -->
  3.     <context-param>
  4.         <param-name>contextConfigLocation</param-name>
  5.         <param-value>classpath:applicationContext.xml</param-value>
  6.     </context-param>
  8.     <!-- Bootstraps the root web application context before servlet initialization -->
  9.     <listener>
  10.         <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  11.     </listener>
  13.     <!-- 2.配置springMVC 前端控制器==》拦截所有请求 -->
  14.     <!-- The front controller of this Spring Web application, responsible for handling all application requests -->
  15.     <servlet>
  16.         <servlet-name>dispatcherServlet</servlet-name>
  17.         <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  18.         <init-param>
  19.             <param-name>contextConfigLocation</param-name>
  20.             <param-value>classpath:SpringMVC.xml</param-value>
  21.         </init-param>
  22.         <load-on-startup>1</load-on-startup>
  23.     </servlet>
  25.     <!-- Map all requests to the DispatcherServlet for handling -->
  26.     <servlet-mapping>
  27.         <servlet-name>dispatcherServlet</servlet-name>
  28.         <url-pattern>/</url-pattern>
  29.     </servlet-mapping>
  31.     <!-- 3.字符编码过滤器 如果同时存在多个过滤器，字符过滤器需要设置在所有过滤器的前面  -->
  32.     <filter>
  33.         <!-- 查询类名快捷键 ctrl + shift + t -->
  34.         <filter-name>charanterEncoding</filter-name>
  35.         <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
  37.         <init-param>
  38.             <param-name>encoding</param-name>
  39.             <param-value>utf-8</param-value>
  40.         </init-param>
  42.         <init-param>
  43.             <param-name>forceRequestEncoding</param-name>
  44.             <param-value>true</param-value>
  45.         </init-param>
  47.         <init-param>
  48.             <param-name>forceResponseEncoding</param-name>
  49.             <param-value>true</param-value>
  50.         </init-param>
  51.     </filter>
  52.     <filter-mapping>
  53.         <filter-name>characterEncoding</filter-name>
  54.         <url-pattern>/*</url-pattern>
  55.     </filter-mapping>
  58.     <!-- 4.使用Rest风格URI -->
  59.     <filter>
  60.         <filter-name>HiddenHttpMethodFilter</filter-name>
  61.         <filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class>
  62.     </filter>
  63.     <filter-mapping>
  64.         <filter-name>HiddenHttpMethodFilter</filter-name>
  65.         <url-pattern>/*</url-pattern>
  66.     </filter-mapping>

2>配置SpringMVC.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:mvc="http://www.springframework.org/schema/mvc"
  5.     xmlns:context="http://www.springframework.org/schema/context"
  6.     xsi:schemaLocation="http://www.springframework.org/schema/beans 
  7.                         http://www.springframework.org/schema/beans/spring-beans.xsd
  8.                         http://www.springframework.org/schema/context 
  9.                         http://www.springframework.org/schema/context/spring-context-4.3.xsd
  10.                         http://www.springframework.org/schema/mvc 
  11.                         http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
  12. ">
  14.     <!-- 1.配置扫描器 将默认的过滤器取消掉，只扫描指定的层 -->
  15.     <context:component-scan base-package="xyz.zhouge.ssm.controller" use-default-filters="false" >
  17.         <!-- 只扫描controller层 -->
  18.         <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
  20.     </context:component-scan>
  22.     <!-- 2.配置视图解析器 -->
  23.     <bean id="internalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  25.         <!-- 配置前缀 -->
  26.         <property name="preffix" value="/WEB-INF/views/" />
  28.         <!-- 配置后缀 -->
  29.         <property name="suffix" value=".jsp" />
  30.     </bean>
  32.     <!-- 3.default-handler -->
  33.     <mvc:default-servlet-handler/>
  35.     <!-- 4.注解驱动 -->
  36.     <mvc:annotation-driven />
  38. </beans>

3>配置Spring.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:tx="http://www.springframework.org/schema/tx"
  5.         xmlns:mvc="http://www.springframework.org/schema/mvc"
  6.         xmlns:aop="http://www.springframework.org/schema/aop"
  7.         xmlns:context="http://www.springframework.org/schema/context"
  8.         xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
  9.         xsi:schemaLocation="http://mybatis.org/schema/mybatis-spring
  10.         http://mybatis.org/schema/mybatis-spring-1.2.xsd
  11.         http://www.springframework.org/schema/beans
  12.         http://www.springframework.org/schema/beans/spring-beans.xsd
  13.         http://www.springframework.org/schema/context
  14.         http://www.springframework.org/schema/context/spring-context-4.0.xsd
  15.         http://www.springframework.org/schema/tx
  16.         http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
  17.         http://www.springframework.org/schema/mvc 
  18.         http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
  19.         http://www.springframework.org/schema/aop 
  20.         https://www.springframework.org/schema/aop/spring-aop.xsd
  21. ">    
  23.     <!--1.包扫描  扫描指定包下面的所有资源-->
  24.     <context:component-scan base-package="xyz.zhouge.ssm">
  26.         <!-- 包下面的Controller注解包不扫描 -->
  27.         <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
  29.     </context:component-scan>
  32.     <!--2.配置数据源-->
  33.     <context:property-placeholder location="classpath:database.properties"/>
  34.     <bean id="c3P0PooledDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
  35.         <property name="driverClass"    value="${mysql.driver}"/>
  36.         <property name="jdbcUrl"    value="${mysql.url}"/>
  37.         <property name="user"   value="${mysql.username}"/>
  38.         <property name="password"   value="${mysql.password}"/>
  39.     </bean>
  42.     <!-- 3.配置mybatis -->
  43.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  45.         <!-- 指定mybatis全局配置文件的位置 -->
  46.         <property name="configLocation" value="classpath:mybatis-config.xml" />
  48.         <!-- 注入数据源 -->
  49.         <property name="dataSource" ref="c3P0PooledDataSource" />
  51.         <!-- 指定mapper映射文件位置 -->
  52.         <property name="mapperLocations" value="classpath:mapper/*.xml" />
  53.     </bean>
  55.     <!-- 4.配置扫描器 将mybatis的接口交给ioc容器进行管理 -->
  56.     <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  58.         <!-- 扫描所有mapper接口的所有实现，将其加入到ioc容器中 -->
  59.         <property name="basePackage" value="xyz.zhouge.ssm.mapper" />
  60.     </bean>
  62.     <!-- 5.数据源事务控制 -->
  63.     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  65.         <!-- 将数据源添加事务控制 -->
  66.         <property name="dataSource" ref="c3P0PooledDataSource"/>
  67.     </bean>
  69.     <!-- 6.开启基于注解的事务控制 -->
  70.     <aop:config>
  72.         <!-- 切入点表达式 -->
  73.         <aop:pointcut expression="execution(xyz.zhouge.ssm.service..*(..))"  id="servicePointCut" />
  75.         <!-- 配置事务增强 设置事务如何切入，以及切入哪些方法-->
  76.         <aop:advisor advice-ref="txAdvice" pointcut-ref="servicePointCut" />
  77.     </aop:config>
  79.     <!-- 7.配置事务通知。事务如何切入 -->
  80.     <tx:advice id="txAdvice" transaction-manager="transactionManager">
  82.         <tx:attributes>
  84.             <!-- 以get开头的方法名，开启事务，设置只读 -->
  85.             <tx:method name="get*" read-only="true" />
  87.             <!-- 所有方法都开启事务 -->
  88.             <tx:method name="*"/>
  90.         </tx:attributes>
  91.     </tx:advice>
  93. </beans>

4>配置mybatis，搭建逆向工程

a>mybatis-config配置文件

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE configuration
  3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
  5. <configuration>
  7.     <settings>
  9.         <!--驼峰命名规则  -->
  10.         <setting name="maoUnderscoreToCamelCase" value="true"/>
  11.     </settings>
  13.     <!-- 配置类型别名 -->
  14.     <typeAliases>
  15.         <package name="xyz.zhouge.ssm.pojo"/>
  16.     </typeAliases>
  18. </configuration>

b>创建数据库表

  1. create database if not EXISTS db_ssm_crud;
  3. use db_ssm_crud;
  5. create table tb_department(
  6.     `dep_id` int PRIMARY key auto_increment,
  7.     `dep_name` varchar(25)
  8. );
  11. create table tb_employee(
  12.     `emp_id` int PRIMARY key auto_increment,
  13.     `emp_name` varchar(25) not null,
  14.     `emp_gender` varchar(4),
  15.     `emp_email` varchar(25),
  16.     `emp_depId` int,
  17.     foreign key(`emp_depId`) REFERENCES tb_department(`dep_id`)
  18. );

c>逆向工程 链接

  1. <!DOCTYPE generatorConfiguration PUBLIC
  2.  "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
  3.  "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
  4. <generatorConfiguration>
  6.   <context id="simple" targetRuntime="MyBatis3">
  8.     <!-- 数据库的连接信息 -->
  9.    <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
  10.                    connectionURL="jdbc:mysql://zhouge.xyz:3306/db_ssm_crud"
  11.                    userId="admin"
  12.                    password="991227zg@.">
  13.    </jdbcConnection>
  15.         <!-- javaBean的生成策略-->
  16.         <javaModelGenerator targetPackage="xyz.zhouge.ssm.pojo" targetProject=".\src\main\java">
  17.             <property name="enableSubPackages" value="true" />
  18.             <property name="trimStrings" value="true" />
  19.         </javaModelGenerator>
  21.         <!-- SQL映射文件的生成策略 -->
  22.         <sqlMapGenerator targetPackage="mapper" targetProject=".\src\main\resources">
  23.             <property name="enableSubPackages" value="true" />
  24.         </sqlMapGenerator>
  26.         <!-- Mapper接口的生成策略 -->
  27.         <javaClientGenerator type="XMLMAPPER" targetPackage="xyz.zhouge.ssm.mapper" targetProject=".\src\main\java">
  28.             <property name="enableSubPackages" value="true" />
  29.         </javaClientGenerator>
  31.         <!-- 逆向分析的表 -->
  32.         <table tableName="tb_employee" domainObjectName="Employee"/>
  33.         <table tableName="tb_department" domainObjectName="Department"/>
  35.   </context>
  37. </generatorConfiguration>
  1. @Test
  2. public void testMBG() throws Exception{
  3.     List<String> warnings = new ArrayList<String>();
  4.     boolean overwrite = true;
  5.     File configFile = new File("mbg.xml");
  6.     ConfigurationParser cp = new ConfigurationParser(warnings);
  7.     Configuration config = cp.parseConfiguration(configFile);
  8.     DefaultShellCallback callback = new DefaultShellCallback(overwrite);
  9.     MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config,callback, warnings);
  10.     myBatisGenerator.generate(null);
  11.     }

5>修改mapper文件

6>搭建Spring单元测试

5、测试mapper

三、查询功能

四、新增功能

五、修改功能

六、删除功能

七、总结