return user;
}
public void setUser(User user) {
this.user = user;
}
}
1.4、在UserMapper当中创建getUserByQueryVo方法
/*
- 传递包装pojo
*/
List getUserByQueryVo(QueryVo vo);
1.5、在UserMapperTest类当中创建testGetUserByQueryVo方法
@Test
public void testGetUserByQueryVo() {
SqlSession openSession = SqlSessionFactoryUtils.getSqlSessionFactory().openSession();
// 获取接口的代理实现类
UserMapper userMapper = openSession.getMapper(UserMapper.class);
QueryVo vo = new QueryVo();
User user = new User();
user.setUsername(“张”);
vo.setUser(user);
List list = userMapper.getUserByQueryVo(vo);
for (User user2 : list) {
System.out.println(user2);
}
openSession.close();
}
运行测试
2、统计个数
(1)修改UserMapper.xml创建对应的内容
SELECT COUNT(1) FROM user
(2)创建对应的接口当中的方法
/*
- 查询用户总记录数
*/
Integer getUserCount();
(3)在UserMapperTest类当中创建对应的方法
@Test
public void testGetUserByCount() {
SqlSession openSession = SqlSessionFactoryUtils.getSqlSessionFactory().openSession();
// 获取接口的代理实现类
UserMapper userMapper = openSession.getMapper(UserMapper.class);
System.out.println(“用户总记录数为:”+userCount);
System.out.println(userCount);
openSession.close();
}
运行测试结果
3、查询订单列表
(1)创建OrderMapper接口当中的getOrderList方法
package com.itzheng.mybatis.mapper;
import java.util.List;
import com.itzheng.mybatis.pojo.Order;
/*
- 订单的持久化接口
*/
public interface OrderMapper {
/*
- 获取订单列表
*/
List getOrderList();
}