SpringBoot学习笔记十九、整合Mybatis

添加pom依赖

<!-- 引入mybatis--> <dependency>     <groupId>org.mybatis.spring.boot</groupId>     <artifactId>mybatis-spring-boot-starter</artifactId>     <version>1.3.2</version>            </dependency>          <!-- MySQL的JDBC驱动包    -->     <dependency>     <groupId>mysql</groupId>     <artifactId>mysql-connector-java</artifactId>     <scope>runtime</scope> </dependency> 

<!-- 引入第三方数据源 -->         <dependency>     <groupId>com.alibaba</groupId>     <artifactId>druid</artifactId>     <version>1.1.6</version> </dependency>

数据源连接配置

 #数据源连接配置 spring.datasource.driver-class-name =com.mysql.jdbc.Driver spring.datasource.type =com.alibaba.druid.pool.DruidDataSource spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8 spring.datasource.username =root spring.datasource.password =123456

开启mybatis日志打印

#开启mybatis日志打印 mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

Application类添加mapper扫描注解

@MapperScan("com.example.demo.mapper") 

创建表user

 CREATE TABLE `user` (               `id` int(11) unsigned NOT NULL AUTO_INCREMENT,               `name` varchar(128) DEFAULT NULL COMMENT '名称',               `phone` varchar(16) DEFAULT NULL COMMENT '用户手机号',               `create_time` datetime DEFAULT NULL COMMENT '创建时间',               `age` int(4) DEFAULT NULL COMMENT '年龄',               PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

 User实体类

package com.example.demo.entity;

import java.util.Date;

import com.fasterxml.jackson.annotation.JsonFormat;

public class User {

    private long id;          private String name;          private String phone;          private int age;          @JsonFormat(pattern="yyyy-MM-dd HH:mm:ss", locale="zh", timezone="GMT+8")     private Date createTime;

    public long getId() {         return id;     }

    public void setId(long id) {         this.id = id;     }

    public String getName() {         return name;     }

    public void setName(String name) {         this.name = name;     }

    public String getPhone() {         return phone;     }

    public void setPhone(String phone) {         this.phone = phone;     }

    public int getAge() {         return age;     }

    public void setAge(int age) {         this.age = age;     }

    public Date getCreateTime() {         return createTime;     }

    public void setCreateTime(Date createTime) {         this.createTime = createTime;     }

     }  

 UserMapper 

package com.example.demo.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete; import org.apache.ibatis.annotations.Insert; import org.apache.ibatis.annotations.Options; import org.apache.ibatis.annotations.Result; import org.apache.ibatis.annotations.Results; import org.apache.ibatis.annotations.Select; import org.apache.ibatis.annotations.Update;

import com.example.demo.entity.User;

public interface UserMapper {          @Insert("insert into user(name,phone,age,create_time) values(#{name},#{phone},#{age},#{createTime})")     @Options(useGeneratedKeys=true, keyProperty="id", keyColumn="id")     int insert(User user);

    @Select("select * from user")     @Results({         @Result(column="create_time", property="createTime")     })     List<User> findAll();          @Select("select * from user where id=#{id}")     @Results({         @Result(column="create_time", property="createTime")     })     User findById(long id);          @Update("update user set name=#{name} where id=#{id} ")     void update(User user);          @Delete("delete from user where id=#{id}")     void delete(long id);

}  

UserService

package com.example.demo.service;

import com.example.demo.entity.User;

public interface UserService {

    public int add(User user);      }

UserServiceImpl

package com.example.demo.service.impl;

import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Propagation; import org.springframework.transaction.annotation.Transactional;

import com.example.demo.entity.User; import com.example.demo.mapper.UserMapper; import com.example.demo.service.UserService;

@Service public class UserServiceImpl implements UserService{

    @Autowired     private UserMapper userMapper;          @Transactional(propagation=Propagation.REQUIRED)     public long add(User user) {         userMapper.insert(user);         return user.getId();     }

}  

UserController

package com.example.demo.controller;

import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController;

import com.example.demo.entity.User; import com.example.demo.mapper.UserMapper; import com.example.demo.service.UserService;

@RestController @RequestMapping("/user") public class UserController {          @Autowired     private UserService userService;          @Autowired     private UserMapper userMapper;          @PostMapping("/add")     public Object add(@RequestBody User user){         long id = userService.add(user);         return id;     }          @RequestMapping("/findAll")     public Object findAll(){         return userMapper.findAll();     }          @RequestMapping("/findById")     public Object findById(long id){         return userMapper.findById(id);     }          @PostMapping("/update")     public Object update(@RequestBody User user){         userMapper.update(user);         return "update success!";     }          @PostMapping("/delete")     public Object delete(long id){         userMapper.delete(id);         return "delete success!";     }     

}