mybatis-中级篇-UserDaoTestByMapper

package cn.test;


import java.util.ArrayList;
import java.util.List;


import org.apache.ibatis.session.SqlSession;
import org.apache.log4j.Logger;
import org.junit.Test;


import cn.dao.UserMapper;
import cn.pojo.Address;
import cn.pojo.Role;
import cn.pojo.User;
import cn.util.MybatisUtil;


public class UserDaoTestByMapper {


/*日志*/
private Logger logger = Logger.getLogger(UserTest.class);

/*查个数*/
@Test
public void countTest() {
SqlSession sqlSession = null;
int count = 0;
try {
sqlSession = MybatisUtil.createSqlSession();
count = sqlSession.getMapper(UserMapper.class).count();
logger.debug("countTest-->" + count);
} catch (Exception e) {
}finally{
MybatisUtil.closeSqlSession(sqlSession);
}

}

/*============================================================*/
/*增加*/

@Test
public void addTest(){
SqlSession sqlSession = null;
try {
User user = new User();
user.setUserCode("good");
user.setUserName("Tom");
user.setUserPassword("123456");
sqlSession = MybatisUtil.createSqlSession();
sqlSession.getMapper(UserMapper.class).add(user);
sqlSession.commit();
} catch (Exception e) {
sqlSession.rollback();
}finally{
MybatisUtil.closeSqlSession(sqlSession);
}
}
/*============================================================*/
/*修改*/
@Test
public void updateTest(){
SqlSession sqlSession = null;
try {
User user = new User();
user.setId(3);
user.setUserCode("bad");
sqlSession = MybatisUtil.createSqlSession();
sqlSession.getMapper(UserMapper.class).update(user);
sqlSession.commit();
} catch (Exception e) {
sqlSession.rollback();
}finally{
MybatisUtil.closeSqlSession(sqlSession);
}
}

/*============================================================*/
/*删除*/
@Test
public void deletTest(){
SqlSession sqlSession = null;
try {
User user = new User();
user.setId(10);
sqlSession = MybatisUtil.createSqlSession();
sqlSession.getMapper(UserMapper.class).delete(user);
sqlSession.commit();
} catch (Exception e) {
sqlSession.rollback();
}finally{
MybatisUtil.closeSqlSession(sqlSession);
}
}

/*============================================================*/
/*查询*/
@Test
public void getUserListTest(){
SqlSession sqlSession = null;
try {
List<User> userList = new ArrayList<User>();
sqlSession = MybatisUtil.createSqlSession();
userList = sqlSession.getMapper(UserMapper.class).getUserList();
for (User user : userList) {
logger.debug("userId--->" + user.getId());
}
} catch (Exception e) {
}finally{
MybatisUtil.closeSqlSession(sqlSession);
}
}
/*============================================================*/
/*根据roleId获取数据列表*/
@Test
public void getUserListByRoleIdTest(){
SqlSession sqlSession = null;
List<User> userList = new ArrayList<User>();
Role role = new Role();
role.setId(1);
try {
sqlSession = MybatisUtil.createSqlSession();
userList = sqlSession.getMapper(UserMapper.class).getUserListByRoleId(role);
for (User user : userList) {
logger.debug("userName--->" + user.getUserName()+"  "+user.getRoleName());
logger.debug("roleCode--->" + user.getRole().getRoleCode());
}
} catch (Exception e) {
}finally{
MybatisUtil.closeSqlSession(sqlSession);
}
}
/*============================================================*/
/*查找指定用户的地址*/
@Test
public void getAddressListByUserIdTest(){
SqlSession sqlSession = null;
User user = new User();
user.setId(1);
try {
sqlSession = MybatisUtil.createSqlSession();
user = sqlSession.getMapper(UserMapper.class).getAddressListByUserId(user);
for (Address address : user.getAddressList()) {
logger.debug("address:" + address.getAddressContent());
}
} catch (Exception e) {
e.printStackTrace();
}finally{
MybatisUtil.closeSqlSession(sqlSession);
}
}
/*============================================================*/
/*动态SQL查询*/
@Test
public void serchUserListTest(){
SqlSession sqlSession = null;
User user = new User();
user.setRoleId(1);
user.setUserCode("");
user.setUserName("");
List<User> list = new ArrayList<User>();
try {
sqlSession = MybatisUtil.createSqlSession();
list = sqlSession.getMapper(UserMapper.class).serchUserList(user);
for (User user2 : list) {
logger.debug("user:" + user2.getUserName());
}
} catch (Exception e) {
e.printStackTrace();
}finally{
MybatisUtil.closeSqlSession(sqlSession);
}

}
/*============================================================*/
/*用foreach in查询*/
@Test
public void getUserByDepIdTest(){
SqlSession sqlSession = null;
String[] depIds = {"1","2"};
List<User> list = new ArrayList<User>();
try {
sqlSession = MybatisUtil.createSqlSession();
list = sqlSession.getMapper(UserMapper.class).getUserByDepId(depIds);
for (User user2 : list) {
logger.debug("user:" + user2.getUserName());
}
} catch (Exception e) {
e.printStackTrace();
}finally{
MybatisUtil.closeSqlSession(sqlSession);
}
}
/*============================================================*/
/*用foreach in查询*/
@Test
public void getUserByDepId2Test(){
SqlSession sqlSession = null;
List<String> depIds = new ArrayList<String>();
depIds.add("1");
depIds.add("2");
List<User> list = new ArrayList<User>();
try {
sqlSession = MybatisUtil.createSqlSession();
list = sqlSession.getMapper(UserMapper.class).getUserByDepId2(depIds);
for (User user2 : list) {
logger.debug("user:" + user2.getUserName());
}
} catch (Exception e) {
e.printStackTrace();
}finally{
MybatisUtil.closeSqlSession(sqlSession);
}
}
}