package cn.test;
import static org.junit.Assert.*;
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.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(12);
user.setUserCode("bad");
user.setUserName("Jim");
user.setUserPassword("123");
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);
}
}
}
import static org.junit.Assert.*;
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.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(12);
user.setUserCode("bad");
user.setUserName("Jim");
user.setUserPassword("123");
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);
}
}
}