#springBoot属性赋值方式
##1.直接写死在代码中,耦合性较高
##2.通过@Value赋值
1)YML编写格式
2)编辑JDBCController实现属性赋值
##3.批量为属性赋值
1)添加jar包
2)编辑JdbcController2
##4.指定配置文件为属性赋值
1)编辑pro文件
2)编辑实体类,动态赋值
#多环境切换问题
#lombok面试问题
#mybatis配置问题
#mybatis-Plus
#mp练习
package com.jt.demo.test;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;
import com.baomidou.mybatisplus.core.conditions.query.Query;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.jt.demo.mapper.UserMapper;
import com.jt.demo.pojo.User;
@SpringBootTest
public class TestMybatis {
@Autowired
private UserMapper userMapper;
@Test
public void testFindUser() {
List<User> userList = userMapper.findAll();
System.out.println(userList);
}
//1.案例1:利用MP实现查询所有的数据
@Test
public void selectList() {
List<User> userList = userMapper.selectList(null);
System.out.println(userList);
}
//1.用户入库操作
//注意事项: MP操作时,将对象中不为null的数据 当做执行要素
@Test
public void insert() {
User user = new User();
user.setName("特朗普");
user.setAge(60);
user.setSex("男");
userMapper.insert(user);
}
//1.查询name="特朗普"的用户
//SELECT id,sex,name,age FROM user WHERE name=?
//只能操作=号业务关系的数据
@Test
public void select01() {
//定义条件构造器 动态拼接where条件之后的数据
User user = new User();
user.setName("特朗普");
//where name="xxxx"
QueryWrapper<User> queryWrapper = new QueryWrapper<>(user);
List<User> userList = userMapper.selectList(queryWrapper);
System.out.println(userList);
}
//2.查询sex="女" age > 200 用户
//逻辑运算符 = eq, > gt ,< lt , >= ge , <= le
@Test
public void select02() {
QueryWrapper<User> queryWrapper = new QueryWrapper<User>();
queryWrapper.eq("sex", "女");
queryWrapper.gt("age", 200);
List<User> userList = userMapper.selectList(queryWrapper);
System.out.println(userList);
}
/**
* 3. 查询name中包含"精"的用户 like
sql: SELECT id,sex,name,age FROM user WHERE (name LIKE ?)
3.1 查询name中 以"精"结尾的数据 like %精
sql:SELECT id,sex,name,age FROM user WHERE (name LIKE ?)
Parameters: %精(String)
*/
@Test
public void select03() {
QueryWrapper<User> queryWrapper = new QueryWrapper<User>();
//queryWrapper.like("name", "精");
queryWrapper.likeLeft("name", "精");
List<User> userList = userMapper.selectList(queryWrapper);
System.out.println(userList);
}
/**
* 案例: 查询age 位于 18-35, and 并且要求性别 "男"
* 规则: 在多条件测试下 默认采用and连接
* SELECT id,sex,name,age FROM user WHERE (age BETWEEN ? AND ? AND sex = ?)
*/
@Test
public void select04() {
QueryWrapper<User> queryWrapper = new QueryWrapper<User>();
queryWrapper.between("age", 18, 35)
.eq("sex", "男");
List<User> userList = userMapper.selectList(queryWrapper);
System.out.println(userList);
}
/**
* 要求: 查询name不为null的用户信息,
* 并且根据age降序排列,如果age相同则按照sex排序
* SELECT id,sex,name,age FROM user WHERE (name IS NOT NULL) ORDER BY age DESC , sex DESC
*/
@Test
public void select05() {
QueryWrapper<User> queryWrapper = new QueryWrapper<User>();
queryWrapper.isNotNull("name")
.orderByDesc("age","sex");
userMapper.selectList(queryWrapper);
}
//查询单个用户数据
@Test
public void select06() {
//1.根据主键进行查询 返回值结果单个对象
User user = userMapper.selectById(1);
System.out.println(user);
//2.根据非主键的字段查询单个数据
QueryWrapper<User> queryWrapper = new QueryWrapper<User>();
queryWrapper.eq("name", "特朗普");
User user2 = userMapper.selectOne(queryWrapper);
System.out.println(user2);
}
//批量查询数据 要求查询id 1 3 5 8 10..
//SELECT id,sex,name,age FROM user WHERE id IN ( ? , ? , ? , ? )
//单表操作可以使用 in/or 但是多表操作时慎用.
@Test
public void select07() {
//1. idList 自己进行封装
List<Integer> idList = new ArrayList<>();
idList.add(1);
idList.add(3);
idList.add(5);
idList.add(8);
//2.Id信息一般都是由前端进行传递 所以一般都是数组格式
//一般在定义数组格式时,最好采用对象类型
Integer[] ids = {1,3,5,8};
//需要将数组类型转化为集合
List<Integer> list2 = Arrays.asList(ids);
List<User> userList = userMapper.selectBatchIds(list2);
System.out.println(userList);
}
//查询记录总数 name不为null的
@Test
public void select08() {
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.isNotNull("name");
int count = userMapper.selectCount(queryWrapper);
System.out.println(count);
}
//自己练习删除案例
@Test
public void delete() {
userMapper.delete(null);
}
//更新数据库
//将id=53的用户信息 改为 name="奥巴马" age=66
@Test
public void update01() {
//根据主键更新. 要求对象中必须传递主键信息
User user = new User();
user.setId(53).setName("奥巴马").setAge(66) ;
userMapper.updateById(user);
}
//将name=null的用户信息 name改为="测试案例" sex="男" age=1;
/**
* 参数:
* 1.entity 用户赋值封装的对象
* 2.修改的条件构造器
*
* UPDATE user SET sex=?, name=?, age=? WHERE (name IS NULL)
*/
@Test
public void update02() {
User user = new User();
user.setName("测试案例").setAge(1).setSex("男");
UpdateWrapper<User> updateWrapper = new UpdateWrapper<>();
updateWrapper.isNull("name");
userMapper.update(user, updateWrapper);
}
}