ssm:SpringMVC+Spring+MyBatis

CRUD：Create（创建）
Retrieve（查询）
Update（更新）
Delete（删除）

功能点

•1、分页
•2、数据校验
•jquery前端校验+JSR303后端校验
•3、ajax
•4、Rest风格的URI；使用HTTP协议请求方式的动词，来表示对资源的操作（GET（查询），POST（新增），PUT（修改），DELETE（删除））

技术点

•基础框架-ssm（SpringMVC+Spring+MyBatis）
•数据库-MySQL
•前端框架-bootstrap快速搭建简洁美观的界面
•项目的依赖管理-Maven
•分页-pagehelper
•逆向工程-MyBatis Generator

基础环境搭建

• 1、创建一个maven工程
• 2、引入项目依赖的jar包
• spring
• springmvc
• mybatis
• 数据库连接池，驱动包
• 其他（jstl，servlet-api，junit）

  1.     <dependency>
  2.       <groupId>junit</groupId>
  3.       <artifactId>junit</artifactId>
  4.       <version>4.11</version>
  5.       <scope>test</scope>
  6.     </dependency>
  8.       <!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
  9.       <dependency>
  10.           <groupId>org.springframework</groupId>
  11.           <artifactId>spring-webmvc</artifactId>
  12.           <version>4.3.7.RELEASE</version>
  13.       </dependency>
  15.       <!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
  16.       <dependency>
  17.           <groupId>org.springframework</groupId>
  18.           <artifactId>spring-jdbc</artifactId>
  19.           <version>4.3.7.RELEASE</version>
  20.       </dependency>
  22.       <!-- https://mvnrepository.com/artifact/org.springframework/spring-aspects -->
  23.       <dependency>
  24.           <groupId>org.springframework</groupId>
  25.           <artifactId>spring-aspects</artifactId>
  26.           <version>4.3.7.RELEASE</version>
  27.       </dependency>
  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>
  36.       <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
  37.       <dependency>
  38.           <groupId>org.mybatis</groupId>
  39.           <artifactId>mybatis-spring</artifactId>
  40.           <version>2.0.6</version>
  41.       </dependency>
  43.       <!--数据库连接池-->
  44.       <!-- https://mvnrepository.com/artifact/c3p0/c3p0 -->
  45.       <dependency>
  46.           <groupId>c3p0</groupId>
  47.           <artifactId>c3p0</artifactId>
  48.           <version>0.9.1.2</version>
  49.       </dependency>
  51.       <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
  52.       <dependency>
  53.           <groupId>mysql</groupId>
  54.           <artifactId>mysql-connector-java</artifactId>
  55.           <version>5.1.41</version>
  56.       </dependency>
  58.       <!--jstl servlet junit-->
  59.       <!-- https://mvnrepository.com/artifact/jstl/jstl -->
  60.       <dependency>
  61.           <groupId>jstl</groupId>
  62.           <artifactId>jstl</artifactId>
  63.           <version>1.2</version>
  64.       </dependency>
  66.       <!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api -->
  67.       <dependency>
  68.           <groupId>javax.servlet</groupId>
  69.           <artifactId>javax.servlet-api</artifactId>
  70.           <version>4.0.1</version>
  71.           <scope>provided</scope>
  72.       </dependency>

• 3、引入bootstrap前端框架

  1.     <%--引入jq--%>
  2.     <script type="text/javascript" src="static/js/jquery-1.12.4.min.js"></script>
  4.     <%--引入样式--%>
  5.     <link href="static/bootstrap-3.3.7-dist/css/bootstrap.min.css" rel="stylesheet">
  6.     <script src="static/bootstrap-3.3.7-dist/js/bootstrap.min.js" type="text/javascript"></script>

• 4、编写ssm整合的关键配置文件
• web.xml，spring,springmvc,mybatis，使用mybatis的逆向工程生成对应的bean以及mapper
web.xml

  1. <!DOCTYPE web-app PUBLIC
  2.  "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
  3.  "http://java.sun.com/dtd/web-app_2_3.dtd" >
  5. <web-app>
  6.   <display-name>Archetype Created Web Application</display-name>
  8.     <!--1. 启动 spring 的容器-->
  9.     <context-param>
  10.         <param-name>contextConfigLocation</param-name>
  11.         <param-value>classpath:applicationContext.xml</param-value>
  12.     </context-param>
  13.     <listener>
  14.         <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  15.     </listener>
  17.     <!--2.springMVC的前端控制器拦截所有请求-->
  18.     <servlet>
  19.         <servlet-name>dispatcherServlet</servlet-name>
  20.         <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  21.         <load-on-startup>1</load-on-startup>
  22.     </servlet>
  23.     <servlet-mapping>
  24.         <servlet-name>dispatcherServlet</servlet-name>
  25.         <url-pattern>/</url-pattern>
  26.     </servlet-mapping>
  28.     <!--3.字符编码过滤器  放在所有过滤器之前-->
  29.     <filter>
  30.         <filter-name>CharacterEncodingFilter</filter-name>
  31.         <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
  32.         <init-param>
  33.             <param-name>encoding</param-name>
  34.             <param-value>utf-8</param-value>
  35.         </init-param>
  36.         <init-param>
  37.             <param-name>forceRequestEncoding</param-name>
  38.             <param-value>true</param-value>
  39.         </init-param>
  40.         <init-param>
  41.             <param-name>forceResponseEncoding</param-name>
  42.             <param-value>utf-8</param-value>
  43.         </init-param>
  44.     </filter>
  45.     <filter-mapping>
  46.         <filter-name>CharacterEncodingFilter</filter-name>
  47.         <url-pattern>/*</url-pattern>
  48.     </filter-mapping>
  50.     <!--4. rest 风格 uri  将普通请求转为put  delete请求-->
  51.     <filter>
  52.         <filter-name>HiddenHttpMethodFilter</filter-name>
  53.         <filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class>
  54.     </filter>
  55.      <filter-mapping>
  56.          <filter-name>HiddenHttpMethodFilter</filter-name>
  57.          <url-pattern>/*</url-pattern>
  58.      </filter-mapping>
  62. </web-app>

dispatcherServlet-servlet.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:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
  6.        xmlns:tx="http://www.springframework.org/schema/tx" xmlns:mvc="http://www.springframework.org/schema/mvc"
  7.        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
  8.         http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsd
  9.         http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
  10.         http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd">
  12.     <!--SpringMVC 跳转逻辑控制，配置-->
  13.     <context:component-scan base-package="com.atguigu" use-default-filters="false">
  14.         <!--只扫描控制器-->
  15.         <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
  16.     </context:component-scan>
  18.     <!--配置视图解析器-->
  19.     <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  20.         <property name="prefix" value="/WEB-INF/views/"></property>
  21.         <property name="suffix" value=".jsp"></property>
  22.     </bean>
  24.     <!--标配-->
  25.     <!--将mvc不能处理的请求交给tomcat-->
  26.     <mvc:default-servlet-handler/>
  27.     <!--mvc高级功能-->
  28.     <mvc:annotation-driven/>
  30. </beans>

applicationContext.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:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
  6.        xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop"
  7.        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
  8.         http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsd
  9.         http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
  10.         http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
  13.     <context:component-scan base-package="com.atguigu">
  14.         <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
  15.     </context:component-scan>
  16.     <!-- Spring 的配置文件 业务逻辑相关 -->
  18.     <!-- 数据源 -->
  19.     <!--properties文件引入-->
  20.      <context:property-placeholder location="classpath:dbconfig.properties"/>
  21.     <bean id="pooledDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
  22.         <property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property>
  23.         <property name="driverClass" value="${jdbc.driverClass}"></property>
  24.         <property name="user" value="${jdbc.user}"></property>
  25.         <property name="password" value="${jdbc.password}"></property>
  26.     </bean>
  28.     <!--配置mybatis整合-->
  29.     <bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
  30.         <property name="dataSource" ref="pooledDataSource"></property>
  31.         <!-- 指定 mybatis 全局配置文件的位置-->
  32.         <property name="configLocation" value="classpath:mybatis-config.xml"></property>
  33.         <!--指定mapper文件的位置-->
  34.         <property name="mapperLocations" value="classpath:mapper/*.xml"></property>
  35.         <!--别名处理器: -->
  36.         <property name="typeAliasesPackage" value="com.atguigu.crud.bean"></property>
  37.     </bean>
  39.     <!--配置扫描器，将mybatis接口的实现加入到ioc容器中-->
  40.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  41.         <!--扫描所有dao接口的实现加入到ioc容器-->
  42.         <property name="basePackage" value="com.atguigu.crud.dao"></property>
  44.     </bean>
  46.     <!-- spring事务管理器 -->
  47.     <bean id="dataSourceTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  48.         <!--控制数据源-->
  49.         <property name="dataSource" ref="pooledDataSource"></property>
  50.     </bean>
  52.     <!-- 基于注解的事务管理 -->
  53.     <aop:config>
  54.         <!--切入点表达式-->
  55.         <aop:pointcut id="txPoint" expression="execution(* com.atguigu.crud.service..*(..))"/>
  56.         <!--配置事务增强-->
  57.          <aop:advisor advice-ref="txAdvice" pointcut-ref="txPoint"/>
  58.     </aop:config>
  60.     <!--配置事务增强，如何切入-->
  61.     <tx:advice id="txAdvice" transaction-manager="dataSourceTransactionManager">
  62.         <tx:attributes>
  63.             <!--所有方法都是事务方法-->
  64.             <tx:method name="*"/>
  65.             <!--以get开头的所有方法-->
  66.              <tx:method name="get*" read-only="true"/>
  67.         </tx:attributes>
  68.     </tx:advice>
  71. <!--    spring 配置文件的核心点：数据源 事务控制  mybatis-->
  75. </beans>

dbconfig.properties

  1. jdbc.jdbcUrl=jdbc:mysql:///3306/ssm_crud
  2. jdbc.driverClass=com.mysql.jdbc.Driver
  3. jdbc.user=root
  4. jdbc.password=000823

逆向工程

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE generatorConfiguration
  3.         PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
  6. <generatorConfiguration>
  8.     <context id="DB2Tables" targetRuntime="MyBatis3">
  10.         <commentGenerator>
  11.             <property name="suppressAllComments" value="true"/>
  12.         </commentGenerator>
  15.         <!--配置数据库连接信息-->
  16.         <jdbcConnection driverClass="com.mysql.jdbc.Driver"
  17.                         connectionURL="jdbc:mysql:///ssm_crud?useSSL=false"
  18.                         userId="root"
  19.                         password="000823">
  20.         </jdbcConnection>
  22.         <javaTypeResolver>
  23.             <property name="forceBigDecimals" value="false"/>
  24.         </javaTypeResolver>
  26.         <!--指定javaBean位置-->
  27.         <javaModelGenerator targetPackage="com.atguigu.crud.bean" targetProject=".\src\main\java">
  28.             <property name="enableSubPackages" value="true"/>
  29.             <property name="trimStrings" value="true"/>
  30.         </javaModelGenerator>
  32.         <!--指定映射文件-->
  33.         <sqlMapGenerator targetPackage="mapper" targetProject=".\src\main\resources">
  34.             <property name="enableSubPackages" value="true"/>
  35.         </sqlMapGenerator>
  37.         <!--指定dao接口位置-->
  38.         <javaClientGenerator type="XMLMAPPER" targetPackage="com.atguigu.crud.dao" targetProject=".\src\main\java">
  39.             <property name="enableSubPackages" value="true"/>
  40.         </javaClientGenerator>
  42.         <!--指定每个表的生成策略-->
  43.         <table tableName="tbl_emp" domainObjectName="Employee">
  44.         </table>
  45.         <table tableName="tbl_dept" domainObjectName="Department">
  46.         </table>
  48.     </context>
  49. </generatorConfiguration>
  1.  @Test
  2.     public void t1() throws Exception{
  3.         List<String> warnings = new ArrayList();
  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((ProgressCallback)null);
  11.     }

• 5、测试mapper

  1.     <!-- 配置一个可以执行批量的sqlSession -->
  2.     <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
  3.         <constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory"></constructor-arg>
  4.         <constructor-arg name="executorType" value="BATCH"></constructor-arg>
  5.     </bean>
  1.     @Autowired
  2.     DepartmentMapper departmentMapper;
  4.     @Autowired
  5.     EmployeeMapper employeeMapper;
  7.     @Autowired
  8.     SqlSession sqlSession;
  10.     /**
  11.      * 测试departmentMapper
  12.      */
  13.     @Test
  14.     public void t1(){
  15.         ////1、创建springioc容器
  16.         //ApplicationContext ioc = new ClassPathXmlApplicationContext("applicationContext.xml");
  17.         ////2、获取mapper
  18.         //DepartmentMapper bean = ioc.getBean(DepartmentMapper.class);
  20.         System.out.println(departmentMapper);
  22.     //    1.插入部门
  24.         //departmentMapper.insertSelective(new Department(null,"开发部"));
  25.         //departmentMapper.insertSelective(new Department(null,"测试部"));
  27.     //    2.插入员工
  28.     //    employeeMapper.insertSelective(new Employee(null,"小徐","1","3050106006@com",1));
  29.     //    3.批量插入;使用可以执行批量操作的sqlSession
  30.     //    for (int i = 0; i < 1000; i++) {
  31.     //        employeeMapper.insertSelective(new Employee(null,"小徐","1","3050106006@com",1));
  32.     //    }
  33.         EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);
  34.         for (int i = 0; i < 1000; i++) {
  35.             String uid = UUID.randomUUID().toString().substring(0, 5) + ""+i;
  36.             mapper.insertSelective(new Employee(null,uid,"M",uid+"@com",1));
  37.         }
  38.     }