第一章：准备工作

  • 导入所需要 jar 包的 Maven 坐标
  1. <!--引入pageHelper分页插件 -->
  2. <dependency>
  3.     <groupId>com.github.pagehelper</groupId>
  4.     <artifactId>pagehelper</artifactId>
  5.     <version>5.0.0</version>
  6. </dependency>
  7. <!-- MBG -->
  8. <dependency>
  9.     <groupId>org.mybatis.generator</groupId>
  10.     <artifactId>mybatis-generator-core</artifactId>
  11.     <version>1.3.5</version>
  12. </dependency>
  13. <dependency>
  14.     <groupId>org.springframework</groupId>
  15.     <artifactId>spring-webmvc</artifactId>
  16.     <version>4.3.7.RELEASE</version>
  17. </dependency>
  18. <!-- 返回json字符串的支持 -->
  19. <dependency>
  20.     <groupId>com.fasterxml.jackson.core</groupId>
  21.     <artifactId>jackson-databind</artifactId>
  22.     <version>2.8.8</version>
  23. </dependency>
  24. <!--JSR303数据校验支持；tomcat7及以上的服务器，
  25. tomcat7以下的服务器：el表达式。额外给服务器的lib包中替换新的标准的el
  26. -->
  27. <dependency>
  28.     <groupId>org.hibernate</groupId>
  29.     <artifactId>hibernate-validator</artifactId>
  30.     <version>5.4.1.Final</version>
  31. </dependency>
  32. <!-- Spring-Jdbc -->
  33. <dependency>
  34.     <groupId>org.springframework</groupId>
  35.     <artifactId>spring-jdbc</artifactId>
  36.     <version>4.3.7.RELEASE</version>
  37. </dependency>
  38. <!--Spring-test -->
  39. <dependency>
  40.     <groupId>org.springframework</groupId>
  41.     <artifactId>spring-test</artifactId>
  42.     <version>4.3.7.RELEASE</version>
  43. </dependency>
  44. <!-- Spring面向切面编程 -->
  45. <dependency>
  46.     <groupId>org.springframework</groupId>
  47.     <artifactId>spring-aspects</artifactId>
  48.     <version>4.3.7.RELEASE</version>
  49. </dependency>
  50. <!--MyBatis -->
  51. <dependency>
  52.     <groupId>org.mybatis</groupId>
  53.     <artifactId>mybatis</artifactId>
  54.     <version>3.4.2</version>
  55. </dependency>
  56. <!-- MyBatis整合Spring的适配包 -->
  57. <dependency>
  58.     <groupId>org.mybatis</groupId>
  59.     <artifactId>mybatis-spring</artifactId>
  60.     <version>1.3.1</version>
  61. </dependency>
  62. <!-- 数据库连接池、驱动 -->
  63. <dependency>
  64.     <groupId>c3p0</groupId>
  65.     <artifactId>c3p0</artifactId>
  66.     <version>0.9.1</version>
  67. </dependency>
  68. <dependency>
  69.     <groupId>mysql</groupId>
  70.     <artifactId>mysql-connector-java</artifactId>
  71.     <version>8.0.21</version>
  72. </dependency>
  73. <!-- （jstl，servlet-api，junit） -->
  74. <dependency>
  75.     <groupId>jstl</groupId>
  76.     <artifactId>jstl</artifactId>
  77.     <version>1.2</version>
  78. </dependency>
  79. <dependency>
  80.     <groupId>javax.servlet</groupId>
  81.     <artifactId>javax.servlet-api</artifactId>
  82.     <version>3.0.1</version>
  83.     <scope>provided</scope>
  84. </dependency>
  85. <!-- junit -->
  86. <dependency>
  87.     <groupId>junit</groupId>
  88.     <artifactId>junit</artifactId>
  89.     <version>4.12</version>
  90. </dependency>
  • sql 脚本：
  1. SET NAMES utf8mb4;
  2. SET FOREIGN_KEY_CHECKS = 0;
  4. -- ----------------------------
  5. -- Table structure for employee
  6. -- ----------------------------
  7. DROP TABLE IF EXISTS `employee`;
  8. CREATE TABLE `employee`  (
  9.   `id` int(11) NOT NULL AUTO_INCREMENT,
  10.   `last_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  11.   `gender` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  12.   `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  13.   PRIMARY KEY (`id`) USING BTREE
  14. ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  16. -- ----------------------------
  17. -- Records of employee
  18. -- ----------------------------
  19. INSERT INTO `employee` VALUES (1, 'jerry', '男', 'jerry@qq.com');
  20. INSERT INTO `employee` VALUES (2, 'aa', '男', 'aa@11.com');
  21. INSERT INTO `employee` VALUES (3, 'bb', '男', 'bb@11.com');
  22. INSERT INTO `employee` VALUES (4, 'aa', '男', 'aa@11.com');
  23. INSERT INTO `employee` VALUES (5, 'bb', '男', 'bb@11.com');
  25. SET FOREIGN_KEY_CHECKS = 1;
  • db.properties
  1. jdbc.url=jdbc:mysql://192.168.134.100:3306/test?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true&allowMultiQueries=true
  2. jdbc.driverClass=com.mysql.cj.jdbc.Driver
  3. jdbc.username=root
  4. jdbc.password=123456
  • log4j.xml
  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
  4. <log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
  6.  <appender name="STDOUT" class="org.apache.log4j.ConsoleAppender">
  7.    <param name="Encoding" value="UTF-8" />
  8.    <layout class="org.apache.log4j.PatternLayout">
  9.     <param name="ConversionPattern" value="%-5p %d{MM-dd HH:mm:ss,SSS} %m  (%F:%L) \n" />
  10.    </layout>
  11.  </appender>
  12.  <logger name="java.sql">
  13.    <level value="debug" />
  14.  </logger>
  15.  <logger name="org.apache.ibatis">
  16.    <level value="info" />
  17.  </logger>
  18.  <root>
  19.    <level value="debug" />
  20.    <appender-ref ref="STDOUT" />
  21.  </root>
  22. </log4j:configuration>
  • Employee.java
  1. package com.sunxiaping.domain;
  3. import org.apache.ibatis.type.Alias;
  5. import java.io.Serializable;
  7. @Alias("emp")
  8. public class Employee implements Serializable {
  10.     private Integer id;
  12.     private String lastName;
  14.     private String email;
  16.     private String gender;
  18.     public Integer getId() {
  19.         return id;
  20.     }
  22.     public void setId(Integer id) {
  23.         this.id = id;
  24.     }
  26.     public String getLastName() {
  27.         return lastName;
  28.     }
  30.     public void setLastName(String lastName) {
  31.         this.lastName = lastName;
  32.     }
  34.     public String getEmail() {
  35.         return email;
  36.     }
  38.     public void setEmail(String email) {
  39.         this.email = email;
  40.     }
  42.     public String getGender() {
  43.         return gender;
  44.     }
  46.     public void setGender(String gender) {
  47.         this.gender = gender;
  48.     }
  50.     @Override
  51.     public String toString() {
  52.         return "Employee{" +
  53.                 "id=" + id +
  54.                 ", lastName='" + lastName + '\'' +
  55.                 ", email='" + email + '\'' +
  56.                 ", gender='" + gender + '\'' +
  57.                 '}';
  58.     }
  59. }

第二章：配置

  • 新建 mybatis-config.xml 文件
  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>
  8.         <!-- 开启自动驼峰命名规则映射 -->
  9.         <setting name="mapUnderscoreToCamelCase" value="true"/>
  10.         <!-- 开启对jdbcType的NULL的支持 -->
  11.         <setting name="jdbcTypeForNull" value="NULL"/>
  12.         <!-- 开启延迟加载 -->
  13.         <setting name="lazyLoadingEnabled" value="true"/>
  14.         <!-- 开启按需加载 -->
  15.         <setting name="aggressiveLazyLoading" value="false"/>
  16.         <!-- 开启二级缓存 -->
  17.         <setting name="cacheEnabled" value="true"/>
  18.     </settings>
  20.     <databaseIdProvider type="DB_VENDOR">
  21.         <!--
  22.             为不同的数据库厂商起别名
  23.         -->
  24.         <property name="MySQL" value="mysql"/>
  25.         <property name="Oracle" value="oracle"/>
  26.         <property name="SQL Server" value="sqlserver"/>
  27.     </databaseIdProvider>
  29. </configuration>
  • 新建 applicationContext.xml
  1. <beans xmlns="http://www.springframework.org/schema/beans"
  2.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3.        xmlns:tx="http://www.springframework.org/schema/tx"
  4.        xmlns:jdbc="http://www.springframework.org/schema/jdbc"
  5.        xmlns:context="http://www.springframework.org/schema/context"
  6.        xmlns:mybatis="http://mybatis.org/schema/mybatis-spring"
  7.        xsi:schemaLocation="http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
  8.      http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
  9.      http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc.xsd
  10.      http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd
  11.      http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd">
  13.     <!-- 引入数据库配置文件 -->
  14.     <context:property-placeholder location="classpath*:db.properties"/>
  16.     <!-- 开启组件扫描 -->
  17.     <context:component-scan base-package="com.sunxiaping">
  18.         <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
  19.     </context:component-scan>
  22.     <!-- 配置数据库连接池 -->
  23.     <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
  24.         <property name="jdbcUrl" value="${jdbc.url}"/>
  25.         <property name="password" value="${jdbc.password}"/>
  26.         <property name="driverClass" value="${jdbc.driverClass}"/>
  27.         <property name="user" value="${jdbc.username}"/>
  28.     </bean>
  30.     <!-- 整合Mybatis -->
  31.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  32.         <property name="dataSource" ref="dataSource"/>
  33.         <!-- 指定Mybatis的全局配置文件的位置 -->
  34.         <property name="configLocation" value="classpath:mybatis-config.xml"/>
  35.         <!--  指定Mapper映射文件 -->
  36.         <property name="mapperLocations" value="classpath:com/sunxiaping/mapper/*.xml"/>
  37.     </bean>
  39.     <!-- 扫描所有的Mapper接口，让所有的Mapper自动注入 -->
  40.     <mybatis:scan base-package="com.sunxiaping.mapper"></mybatis:scan>
  42.     <!-- 配置事务管理器 -->
  43.     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  44.         <property name="dataSource" ref="dataSource"/>
  45.     </bean>
  48.     <!-- 开启事务注解驱动 -->
  49.     <tx:annotation-driven transaction-manager="transactionManager"/>
  51. </beans>
  • 新建 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:context="http://www.springframework.org/schema/context"
  5.        xmlns:mvc="http://www.springframework.org/schema/mvc"
  6.        xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
  7.         http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
  8.         http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">
  10.     <!--SpringMVC只是控制网站跳转逻辑  -->
  11.     <!-- 只扫描控制器 -->
  12.     <context:component-scan base-package="com.sunxiaping" use-default-filters="false">
  13.         <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
  14.     </context:component-scan>
  16.     <!-- 视图解析器 -->
  17.     <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  18.         <property name="prefix" value="/WEB-INF/pages/"></property>
  19.         <property name="suffix" value=".jsp"></property>
  20.     </bean>
  22.     <mvc:annotation-driven/>
  24.     <mvc:default-servlet-handler/>
  26. </beans>
  • 在 web.xml 中配置启动 Spring 的容器以及前端控制器…
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3.          xmlns="http://java.sun.com/xml/ns/javaee"
  4.          xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
  5.          id="WebApp_ID" version="2.5">
  7.     <!--1、启动Spring的容器  -->
  8.     <context-param>
  9.         <param-name>contextConfigLocation</param-name>
  10.         <param-value>classpath:applicationContext.xml</param-value>
  11.     </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.         <init-param>
  22.             <param-name>contextConfigLocation</param-name>
  23.             <param-value>classpath*:springmvc.xml</param-value>
  24.         </init-param>
  25.         <load-on-startup>1</load-on-startup>
  26.     </servlet>
  28.     <servlet-mapping>
  29.         <servlet-name>dispatcherServlet</servlet-name>
  30.         <url-pattern>/</url-pattern>
  31.     </servlet-mapping>
  33.     <!-- 3、字符编码过滤器，一定要放在所有过滤器之前 -->
  34.     <filter>
  35.         <filter-name>CharacterEncodingFilter</filter-name>
  36.         <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>
  41.         <init-param>
  42.             <param-name>forceRequestEncoding</param-name>
  43.             <param-value>true</param-value>
  44.         </init-param>
  45.         <init-param>
  46.             <param-name>forceResponseEncoding</param-name>
  47.             <param-value>true</param-value>
  48.         </init-param>
  49.     </filter>
  50.     <filter-mapping>
  51.         <filter-name>CharacterEncodingFilter</filter-name>
  52.         <url-pattern>/*</url-pattern>
  53.     </filter-mapping>
  55.     <!-- 4、使用Rest风格的URI，将页面普通的post请求转为指定的delete或者put请求 -->
  56.     <filter>
  57.         <filter-name>HiddenHttpMethodFilter</filter-name>
  58.         <filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class>
  59.     </filter>
  60.     <filter-mapping>
  61.         <filter-name>HiddenHttpMethodFilter</filter-name>
  62.         <url-pattern>/*</url-pattern>
  63.     </filter-mapping>
  64.     <filter>
  65.         <filter-name>HttpPutFormContentFilter</filter-name>
  66.         <filter-class>org.springframework.web.filter.HttpPutFormContentFilter</filter-class>
  67.     </filter>
  68.     <filter-mapping>
  69.         <filter-name>HttpPutFormContentFilter</filter-name>
  70.         <url-pattern>/*</url-pattern>
  71.     </filter-mapping>
  74. </web-app>

第三章：编码

  • 新建 EmployeeMapper.java
  1. package com.sunxiaping.mapper;
  3. import com.sunxiaping.domain.Employee;
  4. import org.apache.ibatis.annotations.Mapper;
  6. @Mapper
  7. public interface EmployeeMapper {
  9.     Employee findById(Integer id);
  10. }
  • 新建 EmployeeMapper.xml
  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE mapper
  3.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  5. <mapper namespace="com.sunxiaping.mapper.EmployeeMapper">
  7.     <select id="findById" resultType="com.sunxiaping.domain.Employee">
  8.         SELECT id as id,last_name as lastName,gender as gender,email as email
  9.         FROM employee
  10.         WHERE id = #{id,jdbcType=INTEGER}
  11.     </select>
  13. </mapper>
  • 新建 EmployeeService.java
  1. package com.sunxiaping.service;
  3. import com.sunxiaping.domain.Employee;
  5. public interface EmployeeService {
  7.     Employee findById(Integer id);
  8. }
  • 新建 EmployeeServiceImpl.java
  1. package com.sunxiaping.service.impl;
  3. import com.sunxiaping.domain.Employee;
  4. import com.sunxiaping.mapper.EmployeeMapper;
  5. import com.sunxiaping.service.EmployeeService;
  6. import org.springframework.beans.factory.annotation.Autowired;
  7. import org.springframework.stereotype.Service;
  8. import org.springframework.transaction.annotation.Transactional;
  10. @Service
  11. @Transactional
  12. public class EmployeeServiceImpl implements EmployeeService {
  14.     @Autowired
  15.     private EmployeeMapper employeeMapper;
  17.     @Override
  18.     public Employee findById(Integer id) {
  19.         return employeeMapper.findById(id);
  20.     }
  21. }
  • 新建 EmployeeController.java
  1. package com.sunxiaping.web;
  3. import com.sunxiaping.domain.Employee;
  4. import com.sunxiaping.service.EmployeeService;
  5. import org.springframework.beans.factory.annotation.Autowired;
  6. import org.springframework.web.bind.annotation.GetMapping;
  7. import org.springframework.web.bind.annotation.PathVariable;
  8. import org.springframework.web.bind.annotation.RequestMapping;
  9. import org.springframework.web.bind.annotation.RestController;
  11. @RestController
  12. @RequestMapping(value = "/emp")
  13. public class EmployeeController {
  15.     @Autowired
  16.     private EmployeeService employeeService;
  18.     @GetMapping(value = "/findById/{id}")
  19.     public Employee findById(@PathVariable("id") Integer id){
  21.         Employee employee = employeeService.findById(id);
  23.         return employee;
  24.     }
  26. }
  • 新建测试类：
  1. package com.sunxiaping;
  3. import com.sunxiaping.domain.Employee;
  4. import com.sunxiaping.service.EmployeeService;
  5. import com.sunxiaping.web.EmployeeController;
  6. import org.junit.Test;
  7. import org.junit.runner.RunWith;
  8. import org.springframework.beans.factory.annotation.Autowired;
  9. import org.springframework.test.context.ContextConfiguration;
  10. import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
  12. @RunWith(SpringJUnit4ClassRunner.class)
  13. @ContextConfiguration(locations={"classpath:applicationContext.xml","classpath:springmvc.xml"})
  14. public class EmployeeTest {
  16.     @Autowired
  17.     private EmployeeService employeeService;
  19.     @Autowired
  20.     private EmployeeController employeeController;
  22.     @Test
  23.     public void test(){
  24.         Employee employee = employeeService.findById(1);
  25.         System.out.println("employee = " + employee);
  27.         Employee employee1 = employeeController.findById(1);
  28.         System.out.println("employee1 = " + employee1);
  29.     }
  31. }