mybatis笔记二

 

1.创建springboot项目

2.在pom文件加入mybatis等坐标

<dependency>
   <groupId>org.mybatis.spring.boot</groupId>
   <artifactId>mybatis-spring-boot-starter</artifactId>
   <version>2.1.1</version>
</dependency>
<dependency>
   <groupId>mysql</groupId>
   <artifactId>mysql-connector-java</artifactId>
   <version>6.0.5</version>
</dependency>
<dependency>
   <groupId>com.alibaba</groupId>
   <artifactId>druid</artifactId>
   <version>1.1.12</version>
</dependency>

 

3.配置

server.port=8089

#druid���ݿ�����
spring.datasource.url=jdbc:mysql://localhost:3306/user?serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
#ʹ��Druid����Դ
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource

mybatis.mapper-locations=classpath:/mapper/*.xml

4.单个用户插入数据：

代码：userMapper

@Mapper
public interface UserMapper {
    public void save(User user);

    public User selectById(Long id);
}

 

user：

@Data
@Accessors
@ToString
public class User {
    private Long id;
    private String password;
    private String name;
    private Long roleId;
    private Date createTime;
    private Date updateTime;
    private Role role;
}

 

userMapper.xml

<?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.example.demo.mapper.UserMapper">
    <resultMap id="user" type="com.example.demo.po.User">
        <id column="id" property="id" jdbcType="BIGINT"></id>
        <result column="name" property="name" jdbcType="VARCHAR"></result>
        <result column="role_id" property="roleId" jdbcType="BIGINT"></result>
        <result column="password" property="password" jdbcType="VARCHAR"></result>
        <result column="create_time" property="createTime" jdbcType="TIMESTAMP"></result>
        <result column="update_time" property="updateTime" jdbcType="TIMESTAMP"></result>

 

测试代码：

@Test
public void testSave() {
    User user = new User();
    user.setPassword("111");
    user.setRoleId(1l);
    user.setName("aaa")