package com.badao.test;
import java.sql.Connection;
import java.util.ArrayList;
import java.util.Arrays;
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", "霸")
);
}
/***
*条件构造器 删除操作
*/
@Test
public void testEntitymapperDelete() {
employeeMapper.delete(new EntityWrapper<Employee>()
.
没有合适的资源?快使用搜索试试~ 我知道了~
MyBatisPlus条件构造器带条件排序方法orderBy、orderByDesc、orderByAsc使用示例代码
共22个文件
xml:8个
class:3个
java:3个
1星 需积分: 40 128 下载量 141 浏览量
2019-04-24
21:10:07
上传
评论 2
收藏 21KB ZIP 举报
温馨提示
MyBatisPlus条件构造器带条件排序方法orderBy、orderByDesc、orderByAsc使用示例代码
资源推荐
资源详情
资源评论
收起资源包目录
MyBatisPlus条件构造器带条件排序方法orderBy、orderByDesc、orderByAsc使用示例代码.zip (22个子文件)
hellomp
.project 559B
src
test
resources
java
com
badao
test
TestMp.java 8KB
main
resources
log4j.xml 698B
applicationContext.xml 3KB
mybatis-config.xml 197B
db.properties 118B
java
com
badao
beans
Employee.java 1KB
mapper
EmployeeMapper.java 355B
target
classes
log4j.xml 698B
applicationContext.xml 3KB
com
badao
beans
Employee.class 2KB
mapper
EmployeeMapper.class 289B
mybatis-config.xml 197B
db.properties 118B
META-INF
MANIFEST.MF 115B
maven
com.badao.mp
hellomp
pom.properties 219B
pom.xml 2KB
test-classes
com
badao
test
TestMp.class 9KB
.settings
org.eclipse.m2e.core.prefs 90B
org.eclipse.jdt.core.prefs 291B
pom.xml 2KB
.classpath 1KB
共 22 条
- 1
资源评论
- T~E2019-09-24不值得 50 积分/c币霸道流氓气质2019-09-24现在积分都是CSDN自己修改的 ,自己控制不了,原来只有5积分
霸道流氓气质
- 粉丝: 1w+
- 资源: 589
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功