mybatis-中级篇-RoleDaoTest

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.RoleMapper;
import cn.pojo.Role;
import cn.util.MybatisUtil;


public class RoleDaoTest {


private Logger logger = Logger.getLogger(RoleDaoTest.class);

@Test
public void addTest() {
SqlSession sqlSession = null;
Role role = new Role();
role.setRoleCode("SALE");
role.setRoleName("销售");
try {
sqlSession = MybatisUtil.createSqlSession();
sqlSession.getMapper(RoleMapper.class).add(role);
sqlSession.commit();
} catch (Exception e) {
sqlSession.rollback();
}finally{
MybatisUtil.closeSqlSession(sqlSession);
}
}

@Test
public void updateTest() {
SqlSession sqlSession = null;
Role role = new Role();
role.setId(2);
role.setRoleCode("tttttt");
role.setRoleName("ee");
try {
sqlSession = MybatisUtil.createSqlSession();
sqlSession.getMapper(RoleMapper.class).update(role);
sqlSession.commit();
} catch (Exception e) {
sqlSession.rollback();
}finally{
MybatisUtil.closeSqlSession(sqlSession);
}
}

@Test
public void deleteTest() {
SqlSession sqlSession = null;
Role role = new Role();
role.setId(5);
try {
sqlSession = MybatisUtil.createSqlSession();
sqlSession.getMapper(RoleMapper.class).delete(role);
sqlSession.commit();
} catch (Exception e) {
sqlSession.rollback();
}finally{
MybatisUtil.closeSqlSession(sqlSession);
}
}

@Test
public void getRoleListTest() {
SqlSession sqlSession = null;
List<Role> roleList = new ArrayList<Role>();
Role role = new Role();
role.setRoleCode("A");
role.setRoleName("财");
try {
sqlSession = MybatisUtil.createSqlSession();
roleList = sqlSession.getMapper(RoleMapper.class).getRoleList(role);
for (Role role1 : roleList) {
logger.debug("name:" + role1.getRoleName());
}
} catch (Exception e) {
}finally{
MybatisUtil.closeSqlSession(sqlSession);
}
}


}