Spring boot Mybatis整合构建Rest服务（超细版）

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 3 <mapper namespace="com.wuji.mapper.UserMapper">
 4   <resultMap id="BaseResultMap" type="com.wuji.entity.po.User">
 5     <id column="id" jdbcType="INTEGER" property="id" />
 6     <result column="name" jdbcType="VARCHAR" property="name" />
 7     <result column="age" jdbcType="INTEGER" property="age" />
 8   </resultMap>
 9   <sql id="Base_Column_List">
10     id, name, age
11   </sql>
12   <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
13     select 
14     <include refid="Base_Column_List" />
15     from users
16     where id = #{id,jdbcType=INTEGER}
17   </select>
18   <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
19     delete from users
20     where id = #{id,jdbcType=INTEGER}
21   </delete>
22   <insert id="insert" parameterType="com.wuji.entity.po.User">
23     insert into users (id, name, age
24       )
25     values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR}, #{age,jdbcType=INTEGER}
26       )
27   </insert>
28   <insert id="insertSelective" parameterType="com.wuji.entity.po.User">
29     insert into users
30     <trim prefix="(" suffix=")" suffixOverrides=",">
31       <if test="id != null">
32         id,
33       </if>
34       <if test="name != null">
35         name,
36       </if>
37       <if test="age != null">
38         age,
39       </if>
40     </trim>
41     <trim prefix="values (" suffix=")" suffixOverrides=",">
42       <if test="id != null">
43         #{id,jdbcType=INTEGER},
44       </if>
45       <if test="name != null">
46         #{name,jdbcType=VARCHAR},
47       </if>
48       <if test="age != null">
49         #{age,jdbcType=INTEGER},
50       </if>
51     </trim>
52   </insert>
53   <update id="updateByPrimaryKeySelective" parameterType="com.wuji.entity.po.User">
54     update users
55     <set>
56       <if test="name != null">
57         name = #{name,jdbcType=VARCHAR},
58       </if>
59       <if test="age != null">
60         age = #{age,jdbcType=INTEGER},
61       </if>
62     </set>
63     where id = #{id,jdbcType=INTEGER}
64   </update>
65   <update id="updateByPrimaryKey" parameterType="com.wuji.entity.po.User">
66     update users
67     set name = #{name,jdbcType=VARCHAR},
68       age = #{age,jdbcType=INTEGER}
69     where id = #{id,jdbcType=INTEGER}
70   </update>
71 </mapper>

 1 server:
 2   port: 8080
 3 spring:
 4   datasource:
 5            name: daducha
 6            type: com.alibaba.druid.pool.DruidDataSource
 7            druid:
 8                 url: jdbc:mysql://127.0.0.1:3306/daducha
 9                 username: root
10                 password: root
11                 maxActive: 20
12                 initialSize: 1
13                 maxWait: 60000
14                 minIdle: 1
15                 timeBetweenEvictionRunsMillis: 60000
16                 minEvictableIdleTimeMillis: 300000
17                 testWhileIdle: true
18                 testOnBorrow: false
19                 testOnReturn: false
20                 poolPreparedStatements: true
21                 maxOpenPreparedStatements: 20
22                 driver-class-name: com.mysql.jdbc.Driver
23 
24 mybatis:
25   mapper-locations: classpath:mapping/*.xml
26   type-aliases-package: com.wuji.entity.po

 1 package com.wuji.service;
 2 
 3 import com.wuji.entity.po.User;
 4 
 5 public interface UserService {
 6     int addUser(User user);
 7     int delUserById(int id);
 8     int updateUserById(int id,String userName);
 9     User getUserById(int id);
10 }

 1 package com.wuji.service;
 2 
 3 import com.wuji.entity.po.User;
 4 import com.wuji.mapper.UserMapper;
 5 import org.springframework.beans.factory.annotation.Autowired;
 6 import org.springframework.stereotype.Service;
 7 
 8 @Service
 9 public class UserServiceImpl implements UserService {
10 
11     @Autowired
12     private UserMapper userMapper;
13 
14     public int addUser(User user) {
15         return userMapper.insert(user);
16     }
17 
18     public int delUserById(int id) {
19         return userMapper.deleteByPrimaryKey(id);
20     }
21 
22     public int updateUserById(int id,String userName) {
23         User user=getUserById(id);
24         user.setName(userName);
25         return userMapper.updateByPrimaryKey(user);
26     }
27 
28     public User getUserById(int id) {
29         return userMapper.selectByPrimaryKey(id);
30     }
31 }

 1 package com.wuji.controller;
 2 /**
 3  * author:zhangwuji
 4  * date:2018-12-31
 5  * weixin:17091005779
 6  */
 7 import com.wuji.entity.po.User;
 8 import com.wuji.service.UserService;
 9 import org.springframework.beans.factory.annotation.Autowired;
10 import org.springframework.web.bind.annotation.RequestMapping;
11 import org.springframework.web.bind.annotation.RequestMethod;
12 import org.springframework.web.bind.annotation.RestController;
13 
14 import java.util.List;
15 
16 @RestController
17 @RequestMapping("/api/user")
18 public class UserController {
19 
20     @Autowired
21     private UserService userService;
22 
23     @RequestMapping(value = "/add",method = RequestMethod.POST)
24     public int addUser(User user){
25         return userService.addUser(user);
26     }
27 
28     @RequestMapping(value = "/get",method = RequestMethod.GET)
29     public User getUser(int id){
30         return userService.getUserById(id);
31     }
32 
33     @RequestMapping(value = "/del",method = RequestMethod.DELETE )
34     public int delUser(int id){return userService.delUserById(id);}
35 
36     @RequestMapping(value = "/update",method = RequestMethod.POST)
37     public int updateUser(User user){return userService.updateUserById(user);}
38 
39 
40 }

 1 package com.wuji.springboot;
 2 /**
 3  * author:zhangwuji
 4  * date:2018-12-31
 5  * weixin:17091005779
 6  */
 7 
 8 import org.mybatis.spring.annotation.MapperScan;
 9 import org.springframework.boot.SpringApplication;
10 import org.springframework.boot.autoconfigure.SpringBootApplication;
11 import org.springframework.context.annotation.ComponentScan;
12 import org.springframework.context.annotation.ComponentScans;
13 
14 @SpringBootApplication
15 @ComponentScan(basePackages = {"com.wuji"})
16 @MapperScan("com.wuji.mapper")
17 public class Application {
18     public static void main(String[] args) {
19         SpringApplication.run(Application.class,args);
20     }
21 }