springboot整合mybatis实现数据的持久化

SET FOREIGN_KEY_CHECKS=0;
 
-- ----------------------------
-- Table structure for user_t
-- ----------------------------
DROP TABLE IF EXISTS `user_t`;
CREATE TABLE `user_t` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `age` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

<dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>
 
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
 
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
 
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.0</version>
        </dependency>
    </dependencies>

mybatis:
  typeAliasesPackage: com.javazhiyin.entity
  mapperLocations: classpath:mapper/*.xml
 
spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/springboot?useUnicode=true&characterEncoding=UTF-8&useSSL=false
    username: root
    password: 1011

package com.javazhiyin.entity;
 
/**
* Created by 57783 on 2018/7/6.
*/
public class User {
    private Integer id;
 
    private String userName;
 
    private String password;
 
    private Integer age;
 
    public Integer getId() {
        return id;
    }
 
    public void setId(Integer id) {
        this.id = id;
    }
 
    public String getUserName() {
        return userName;
    }
 
    public void setUserName(String userName) {
        this.userName = userName == null ? null : userName.trim();
    }
 
    public String getPassword() {
        return password;
    }
 
    public void setPassword(String password) {
        this.password = password == null ? null : password.trim();
    }
 
    public Integer getAge() {
        return age;
    }
 
    public void setAge(Integer age) {
        this.age = age;
    }
}

package com.javazhiyin.dao;
 
import com.javazhiyin.entity.User;
 
import java.util.List;
 
/**
* Created by 57783 on 2018/7/6.
*/
public interface UserDao {
 
    List<User> findAll();
 
    void addUser(User user);
 
    void updUser(User user);
 
    int delUser(Integer id);
 
}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.javazhiyin.dao.UserDao" >
 
    <resultMap id="BaseResultMap" type="com.javazhiyin.entity.User" >
        <id column="id" property="id" jdbcType="INTEGER" />
        <result column="user_name" property="userName" jdbcType="VARCHAR" />
        <result column="password" property="password" jdbcType="VARCHAR" />
        <result column="age" property="age" jdbcType="INTEGER" />
    </resultMap>
 
    <sql id="Base_Column_List" >
        id, user_name, password, age
    </sql>
 
    <select id="findAll" resultMap="BaseResultMap">
        select
        <include refid="Base_Column_List" />
        from user_t
    </select>
 
    <insert id="addUser" parameterType="com.javazhiyin.entity.User">
        insert into user_t (user_name, password, age)
        values (#{userName,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR},
        #{age,jdbcType=INTEGER})
    </insert>
 
    <update id="updUser" parameterType="com.javazhiyin.entity.User" >
        update user_t
        set user_name = #{userName,jdbcType=VARCHAR},
        password = #{password,jdbcType=VARCHAR},
        age = #{age,jdbcType=INTEGER}
        where id = #{id,jdbcType=INTEGER}
    </update>
 
    <delete id="delUser" parameterType="java.lang.Integer" >
            delete from user_t
            where id = #{id,jdbcType=INTEGER}
        </delete>
 
</mapper>

package com.javazhiyin.service;
 
import com.javazhiyin.entity.User;
 
import java.util.List;
 
/**
* Created by 57783 on 2018/7/6.
*/
public interface UserService {
    List<User> getUser();
 
    void addUser(User user);
 
    void updUser(User user);
 
    int delUser(Integer id);
 
}

package com.javazhiyin.service.impl;
 
import com.javazhiyin.dao.UserDao;
import com.javazhiyin.entity.User;
import com.javazhiyin.service.UserService;
import org.springframework.stereotype.Service;
 
import javax.annotation.Resource;
import java.util.List;
 
/**
* Created by 57783 on 2018/7/6.
*/
@Service("userService")
public class UserServiceImpl implements UserService {
 
    @Resource
    private UserDao userDao;
 
 
    public List<User> getUser() {
        return userDao.findAll();
    }
 
    public void addUser(User user){
        userDao.addUser(user);
    }
 
    public void updUser(User user){
        userDao.updUser(user);
    }
 
    public int delUser(Integer id){
        return userDao.delUser(id);
    }
 
}

package com.javazhiyin.controller;
 
import com.javazhiyin.entity.User;
import com.javazhiyin.service.UserService;
import org.springframework.web.bind.annotation.*;
import javax.annotation.Resource;
import java.util.List;
 
/**
* Created by 57783 on 2018/7/6.
*/
@RestController
public class UserController {
    @Resource
    private UserService userService;
 
    @GetMapping("/showUser")
    public List<User> getUser(){
        List<User> user = this.userService.getUser();
        return user;
    }
 
    @PostMapping(value = "/addUser")
    public void addUser(@RequestParam("username") String username,
                            @RequestParam("password") String password,
                        @RequestParam("age") Integer age){
        User user = new User();
        user.setUserName(username);
        user.setPassword(password);
        user.setAge(age);
        userService.addUser(user);
    }
 
    @PutMapping(value = "updUser/{id}")
    public void updUser(@PathVariable("id") Integer id,
                            @RequestParam("username") String username,
                            @RequestParam("password") String password,
                           @RequestParam("age") Integer age){
        User user = new User();
        user.setId(id);
        user.setUserName(username);
        user.setPassword(password);
        user.setAge(age);
        userService.updUser(user);
 
    }
 
    @DeleteMapping(value = "delUser/{id}")
    public void delUser(@PathVariable("id") Integer id){
        userService.delUser(id);
    }
 
}

package com.javazhiyin;
 
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.web.servlet.support.SpringBootServletInitializer;
 
@SpringBootApplication
@MapperScan("com.javazhiyin.dao")
public class Bootdemo03Application extends SpringBootServletInitializer {
 
    public static void main(String[] args) {
        SpringApplication.run(Bootdemo03Application.class, args);
    }
}