mybatis-初级篇-UserDaoTest

package cn.test;


import static org.junit.Assert.*;


import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;


import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.apache.log4j.Logger;
import org.junit.Assert;
import org.junit.Test;


import cn.pojo.User;
import cn.util.MybatisUtil;


public class UserDaoTest {


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

/*查个数*/
@Test
public void countTest() {
SqlSession sqlSession = null;
int count = 0;
try {
sqlSession = MybatisUtil.createSqlSession();
count = sqlSession.selectOne("cn.dao.UserMapper.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.insert("cn.dao.UserMapper.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(12);
user.setUserCode("bad");
user.setUserName("Jim");
user.setUserPassword("123");
sqlSession = MybatisUtil.createSqlSession();
sqlSession.update("cn.dao.UserMapper.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.delete("cn.dao.UserMapper.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.selectList("cn.dao.UserMapper.getUserList");
for (User user : userList) {
logger.debug("userId--->" + user.getId());
}
} catch (Exception e) {
}finally{
MybatisUtil.closeSqlSession(sqlSession);
}
}


}
/*===============================================*/
/*单词*/
/*assert [ə'sɜːt]vt. 维护，坚持；断言；主张；声称*/