package com.badao.test;
import java.sql.Connection;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.sql.DataSource;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import com.badao.beans.Employee;
import com.badao.mapper.EmployeeMapper;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.plugins.Page;
public class TestMp {
private ApplicationContext ioc = new ClassPathXmlApplicationContext("applicationContext.xml");
private EmployeeMapper employeeMapper =ioc.getBean("employeeMapper",EmployeeMapper.class);
@Test
public void testDataSource() throws Exception{
DataSource ds = ioc.getBean("dataSource",DataSource.class);
System.out.println("******************************************"+ds);
Connection connection = ds.getConnection();
System.out.println("******************************************"+connection);
}
/***
* 测试通用插入操作
*/
@Test
public void testCommonInsert() {
Employee employee = new Employee();
employee.setName("霸道插入测试");
employee.setAge(23);
employee.setEmail("123@163.com");
employee.setGender(1);
int result = employeeMapper.insert(employee);
System.out.println("************************"+result);
}
/***
* 测试插入数据获取主键
*/
@Test
public void testInsertReturnId() {
Employee employee = new Employee();
employee.setName("霸道获取主键");
employee.setAge(23);
employee.setEmail("123@163.com");
employee.setGender(1);
int result = employeeMapper.insert(employee);
System.out.println("************************"+result);
Integer id = employee.getId();
System.out.println("*********************"+id);
}
/***
* 测试insert
*/
@Test
public void testInsert() {
Employee employee = new Employee();
employee.setName("insert测试");
employee.setAge(23);
int result = employeeMapper.insert(employee);
System.out.println("************************"+result);
Integer id = employee.getId();
System.out.println("*********************"+id);
}
/***
* 测试insertAllColumn
*/
@Test
public void testInsertAllColumn() {
Employee employee = new Employee();
employee.setName("insertAllColumn测试");
employee.setAge(23);
int result = employeeMapper.insertAllColumn(employee);
System.out.println("************************"+result);
Integer id = employee.getId();
System.out.println("*********************"+id);
}
/***
* 通用更新操作
*/
@Test
public void testCommomUpdate() {
//
Employee employee = new Employee();
employee.setId(1);
employee.setName("更新测试成功");
int result=employeeMapper.updateById(employee);
System.out.println("*******************"+result);
}
/***
* updateAllColumnById操作
*/
@Test
public void testCommomUpdateAllColumnById() {
Employee employee = new Employee();
employee.setId(2);
employee.setName("更新测试成功");
int result=employeeMapper.updateAllColumnById(employee);
System.out.println("*******************"+result);
}
/***
* 通用查询操作 通过ID查询
*/
@Test
public void testCommomSelectById() {
Employee employee=employeeMapper.selectById(1);
System.out.println("*******************"+employee);
}
/***
* 通用查询操作 selectOne 最多只能查到一个
*/
@Test
public void testCommomSelectOne() {
Employee employee = new Employee();
employee.setId(3);
employee.setName("气质");
Employee employeeresult=employeeMapper.selectOne(employee);
System.out.println("*******************"+employeeresult);
}
/***
* 通用查询操作 selectBatchIds 通过多个ID进行查询
*/
@Test
public void testCommomSelectBatchIds() {
List<Integer> idList = new ArrayList<Integer>();
idList.add(1);
idList.add(2);
idList.add(3);
List<Employee>employeeList=employeeMapper.selectBatchIds(idList);
System.out.println("*******************"+employeeList);
for (Employee employee : employeeList) {
System.out.println(employee.getName());
}
}
/***
* 通用查询操作 selectByMap map要写列名条件 不能是实体属性名
*/
@Test
public void testCommomSelectByMap() {
Map<String, Object> columnMap = new HashMap<String, Object>();
columnMap.put("name", "气质");
columnMap.put("gender", "0");
List<Employee> employeeList=employeeMapper.selectByMap(columnMap);
System.out.println("*******************"+employeeList);
for (Employee employee : employeeList) {
System.out.println(employee.getName());
}
}
/***
* 通用查询操作 selectByPage
*/
@Test
public void testCommomSelectByPage() {
List<Employee> employeeList=employeeMapper.selectPage(new Page<Object>(2, 2), null);
System.out.println("*******************"+employeeList);
for (Employee employee : employeeList) {
System.out.println(employee.getName());
}
}
/***
* 通用删除操作 通过ID删除
*/
@Test
public void testCommomDeleteById() {
int result=employeeMapper.deleteById(8);
System.out.println("*******************"+result);
}
/***
* 通用删除操作 deleteByMap map要写列名条件 不能是实体属性名
*/
@Test
public void testCommomDeleteByMap() {
Map<String, Object> columnMap = new HashMap<String, Object>();
columnMap.put("name", "更新测试成功");
columnMap.put("gender", "1");
int result=employeeMapper.deleteByMap(columnMap);
System.out.println("*******************"+result);
}
/***
* 通用查询操作 deleteBatchIds 通过多个ID进行删除
*/
@Test
public void testCommomDeleteBatchIds() {
List<Integer> idList = new ArrayList<Integer>();
idList.add(5);
idList.add(6);
int result=employeeMapper.deleteBatchIds(idList);
System.out.println("*******************"+result);
}
/***
*条件构造器 查询操作selectPage
*/
@Test
public void testEntitymapperSelect() {
//分页查询数据库,年龄字段在某个区间内,并且性别为男(1),并且名字为霸道的记录
List<Employee> employeeList=employeeMapper.selectPage(new Page<Object>(1, 2), new EntityWrapper<Employee>()
.between("age", 20, 30)
.eq("gender",1)
.eq("name", "霸道")
);
System.out.println("*******************"+employeeList);
for (Employee employee : employeeList) {
System.out.println(employee.getName());
}
}
/***
*条件构造器 查询操作SelectList
*/
@Test
public void testEntitymapperSelectList() {
//查询数据库,性别为男(1),并且名字中带有霸的记录或者email中带有123的记录。
List<Employee> employeeList=employeeMapper.selectList(new EntityWrapper<Employee>()
.eq("gender",1)
.like("name", "霸")
//.or()//SELECT id AS id,`name`,email,gender,age FROM employee WHERE (gender = ? AND name LIKE ? OR email LIKE ?)
.orNew()//SELECT id AS id,`name`,email,gender,age FROM employee WHERE (gender = ? AND name LIKE ?) OR (email LIKE ?)
.like("email", "123")
);
System.out.println("*******************"+employeeList);
for (Employee employee : employeeList) {
System.out.println(employee.getName());
}
}
/***
*条件构造器 更新操作
*/
@Test
public void testEntitymapperUpdate() {
Employee employee =new Employee();
employee.setEmail("456@163.com");
employeeMapper.update(employee,new EntityWrapper<Employee>()
.eq("gender",1)
.like("name", "霸")
);
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
MyBatisPlus条件构造器带条件更新update使用示例代码
共22个文件
xml:8个
class:3个
java:3个
5星 · 超过95%的资源 需积分: 50 59 下载量 57 浏览量
2019-04-23
22:57:43
上传
评论
收藏 21KB ZIP 举报
温馨提示
MyBatisPlus条件构造器带条件更新update使用示例代码
资源推荐
资源详情
资源评论
收起资源包目录
MyBatisPlus条件构造器带条件更新update使用示例代码.zip (22个子文件)
hellomp
pom.xml 2KB
target
test-classes
com
badao
test
TestMp.class 8KB
classes
mybatis-config.xml 197B
META-INF
maven
com.badao.mp
hellomp
pom.xml 2KB
pom.properties 219B
MANIFEST.MF 115B
com
badao
beans
Employee.class 2KB
mapper
EmployeeMapper.class 289B
db.properties 118B
log4j.xml 698B
applicationContext.xml 3KB
.settings
org.eclipse.m2e.core.prefs 90B
org.eclipse.jdt.core.prefs 291B
src
test
resources
java
com
badao
test
TestMp.java 8KB
main
resources
mybatis-config.xml 197B
db.properties 118B
log4j.xml 698B
applicationContext.xml 3KB
java
com
badao
beans
Employee.java 1KB
mapper
EmployeeMapper.java 355B
.project 559B
.classpath 1KB
共 22 条
- 1
资源评论
- weixin_386696282020-05-08不错不错的,很实用很完美
- slg082021-10-29真是坑,太多的坑。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
霸道流氓气质
- 粉丝: 1w+
- 资源: 589
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功