导入jar包
<!--spring整合mybatis-plus -->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.2.0</version>
</dependency>
编辑POJO
@Data
@Accessors(chain=true)
@NoArgsConstructor
@AllArgsConstructor
@TableName
public class User {
@TableId(type=IdType.AUTO)
private Integer id;
private String name;
private Integer age;
private String sex;
}
继承公共的接口
public interface UserMapper extends BaseMapper<User>{
List<User> findAll();
}
MybatisPlusAPI
@Test
public void test01() {
Integer[] ids = {1,3,5,9};
List idList = Arrays.asList(ids);
List<User> userList = userMapper.selectBatchIds(idList);
System.out.println(userList);
}
@Test
public void test02() {
Map<String, Object> columnMap = new HashMap<>();
columnMap.put("name", "王昭君");
columnMap.put("sex", "女");
List<User> userList = userMapper.selectByMap(columnMap);
System.out.println(userList);
}
@Test
public void test03() {
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.gt("age", 18)
.eq("sex", "男");
List<User> userList = userMapper.selectList(queryWrapper);
System.out.println(userList);
}
@Test
public void test04() {
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.likeLeft("name", "精")
.eq("sex", "女");
List<User> userList = userMapper.selectList(queryWrapper);
System.out.println(userList);
}
@Test
public void test05() {
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.between("age", 18, 35)
.eq("sex", "女");
List<User> userList = userMapper.selectList(queryWrapper);
System.out.println(userList);
}
@Test
public void test06() {
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.gt("age",100)
.orderByDesc("age","id");
List<User> userList = userMapper.selectList(queryWrapper);
System.out.println(userList);
}
@Test
public void test07() {
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
String name = "'孙尚香'";
queryWrapper.lt("age", 100)
.inSql("sex", "select sex from user where name="+name);
List<User> userList = userMapper.selectList(queryWrapper);
System.out.println(userList);
}
@Test
public void test08() {
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.select("id","name").gt("age", 100);
List<User> userList = userMapper.selectList(queryWrapper);
System.out.println(userList);
List<Map<String,Object>> mapList = userMapper.selectMaps(queryWrapper);
System.out.println(mapList);
List<Object> list = userMapper.selectObjs(queryWrapper);
System.out.println(list);
}
@Test
public void test09() {
String name = "黑熊精";
String sex = "男";
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.eq(!StringUtils.isEmpty(name), "name", name)
.eq(!StringUtils.isEmpty(sex), "sex", sex);
List<User> userList = userMapper.selectList(queryWrapper);
System.out.println(userList);
}
@Test
public void test10() {
User user = new User();
user.setName("黑熊精")
.setSex("男");
QueryWrapper<User> queryWrapper = new QueryWrapper<User>(user);
List<User> userList = userMapper.selectList(queryWrapper);
System.out.println(userList);
}
@Test
public void test11() {
User user = userMapper.selectById(1111);
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.eq("id", "3");
User user2 = userMapper.selectOne(queryWrapper);
System.out.println(user);
System.out.println(user2);
}
@Test
public void test12() {
QueryWrapper<User> queryWrapper = new QueryWrapper<User>();
queryWrapper.eq("name", "无名英雄永垂不朽");
userMapper.delete(queryWrapper);
System.out.println("数据库删除成功!!!!");
}
@Test
public void test13() {
User user = new User();
user.setAge(10001).setSex("男");
UpdateWrapper<User> updateWrapper = new UpdateWrapper<>();
updateWrapper.eq("name","大日如来");
userMapper.update(user, updateWrapper);
}
@Test
public void test14() {
User user = new User();
user.setId(1915)
.setName("人民英雄")
.setAge(100)
.setSex("男/女");
userMapper.updateById(user);
}
}