pom文件添加mybatis与mysql

  <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.36</version>
        </dependency>

使用jdbc和spring-data连接数据库

在application.properties中配置mysql的连接配置

#mybatis
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf8&autoReconnect=true&zeroDateTimeBehavior=convertToNull
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=root
        

使用MyBatis

• 表

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `age` int(3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

• 类

package com.ghgcn.mysb.chapter02.entity;

import java.io.Serializable;

public class User implements Serializable {

    private static final long serialVersionUID = -4430880678690213064L;
    private Long id;
    private String name;
    private Integer age;

    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 Integer getAge() {
        return age;
    }

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

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", age=" + age +
                '}';
    }
}

• mapper

@Mapper
public interface UserMapper {

    @Select("SELECT * FROM USER WHERE NAME = #{name}")
    User findByName(@Param("name") String name);

    @Insert("INSERT INTO USER(NAME, AGE) VALUES(#{name}, #{age})")
    int insert(@Param("name") String name, @Param("age") Integer age);


    @Update("UPDATE `user` SET `name` =#{name}, age =#{age} WHERE id = #{id}")
    int updateUser(User user);
}

测试

@RunWith(SpringRunner.class)
@SpringBootTest(classes = Chapter02Application.class)
public class Test1 {

    @Autowired
    private UserMapper userMapper;

 

    @Test
    public void testUserMapper() throws IOException {


        System.out.println("userMapper  "+userMapper);

    }

    @Test
    @Rollback
    public void findByName() throws Exception {
        userMapper.insert("AAA", 20);
        User u = userMapper.findByName("AAA");
        System.err.println("User  "+u);
        Assert.assertEquals(20, u.getAge().intValue());
    }


    @Test
    @Rollback
    public void update() throws Exception {

        User u = userMapper.findByName("AAA");
        u.setName("我是Update322423");
        u.setAge(99);
        int i = userMapper.updateUser(u);
        System.err.println("i  "+i);

    }
}