一:新建springboot项目
二:添加pom依赖
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.1.1</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</dependency>
三:在数据库中新建user表
CREATE TABLE `user` (
`id` int(23) NOT NULL AUTO_INCREMENT,
`username` varchar(34) DEFAULT NULL,
`password` varchar(34) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;
四:修改application.properties
#MySQL
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/mybatis?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=FALSE
spring.datasource.username=root
spring.datasource.password=1234
mybatis.configuration.map-underscore-to-camel-case=true
server.port=7373
五:在项目中新建entity包和实体类User,字段要与数据库对应
package com.example.mybatiesplus.entity;
import lombok.Data;
/**
* @program: mybatiesplus
* @Date: 2020/1/5 22:20
* @Author: Mr.huang
* @Description:
*/
@Data
public class User {
private int id;
private String username;
private String password;
}
六:在项目中新建mapper包和UserMapper接口,接口继承BaseMapper接口,泛型给实体类User
package com.example.mybatiesplus.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.mybatiesplus.entity.User;
import org.apache.ibatis.annotations.Mapper;
/**
* @program: mybatiesplus
* @Date: 2020/1/5 21:48
* @Author: Mr.huang
* @Description:
*/
@Mapper
public interface UserMapper extends BaseMapper<User> {
}
至此,完成基本的配置,开始测试。
在test目录下新建UserMapperTest类,如下图。
package com.example.mybatiesplus;
import com.example.mybatiesplus.entity.User;
import com.example.mybatiesplus.mapper.UserMapper;
import org.junit.Assert;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;
import java.util.ArrayList;
import java.util.List;
/**
* @program: mybatiesplus
* @Date: 2020/1/5 22:25
* @Author: Mr.huang
* @Description:
*/
@SpringBootTest
@RunWith(SpringRunner.class)
public class UserMapperTest {
@Autowired
private UserMapper userMapper;
//测试添加操作
@Test
public void testAdd(){
User user1 = new User();
user1.setUsername("xinz");
user1.setPassword("33333");
int insert = userMapper.insert(user1);
System.out.println(insert);
Assert.assertEquals(1,insert);
}
//测试查询操作
@Test
public void testSelect(){
//根据单个ID查询
// User user = userMapper.selectById(21);
// System.out.println(user);
//根据批量ID查询
ArrayList<Integer> integers = new ArrayList<>();
integers.add(1);
integers.add(2);
integers.add(3);
integers.add(4);
List<User> users = userMapper.selectBatchIds(integers);
for (User user2 : users) {
System.out.println(user2);
}
}
//测试删除
@Test
public void testDelete(){
int i = userMapper.deleteById(22);
System.out.println(i);
}
//测试根据id更新
@Test
public void update(){
User user = userMapper.selectById(1);
user.setUsername("hhhhhhhhhh");
user.setPassword("33333333");
userMapper.updateById(user);
}
}
最终项目结构如下