package cn.sicko.dao;
import cn.sicko.pojo.User;
import cn.sicko.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import java.util.List;
public class UserTest {
@Test
public void Test1(){
// 第一步：获得SqlSession对象
SqlSession sqlSession = MybatisUtils.getSqlSession();
try{
// 方式一：getMapper执行SQL
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
List<User> userList = userMapper.getUserList();
// 方式二：
// List<User> userList = sqlSession.selectList("cn.sicko.dao.UserMapper.getUserList");
for (User user : userList) {
System.out.println(user);
}
}catch (Exception ex){
ex.printStackTrace();
}finally {
// 关闭SqlSession
sqlSession.close();
}
}
@Test
public void getUserById(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
User user = mapper.getUserById(1);
System.out.println(user);
sqlSession.close();
}
// 增删改需要提交事物
@Test
public void addUser(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
try {
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
int i = mapper.addUser(new User(4,"小心","156247"));
if(i>0){
System.out.println("插入数据成功");
}else{
System.out.println("插入数据失败");
}
// 提交事物
sqlSession.commit();
}catch (Exception ex){
ex.printStackTrace();
}finally {
sqlSession.close();
}
}
@Test
public void updateUser(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
try {
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
int i = mapper.updateUser(new User(4, "呵呵", "111111"));
if(i>0)
System.out.println("更改成功");
else
System.out.println("失败");
sqlSession.commit();
}catch (Exception ex){
ex.printStackTrace();
}finally {
sqlSession.close();
}
}
@Test
public void deleteUser(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
try{
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
int i = mapper.deleteUser(4);
if(i>0)
System.out.println("成功");
else
System.out.println("失败");
sqlSession.commit();
}catch (Exception ex){
ex.printStackTrace();
}finally {
sqlSession.close();
}
}
}
2022/4/25上传Mybatis简单增删改查
需积分: 10 46 浏览量
2022-04-25
12:00:06
上传
评论
收藏 27KB ZIP 举报
Mybatis-Study.zip （28个子文件） 
Mybatis-Study 
pom.xml 2KB .idea dataSources.xml 545B uiDesigner.xml 9KB misc.xml 513B jarRepositories.xml 864B encodings.xml 200B compiler.xml 543B workspace.xml 7KB .gitignore 188B dataSources.local.xml 1006B dataSources d5357059-4600-4d15-bd29-2c63ebcd4850.xml 36KB d5357059-4600-4d15-bd29-2c63ebcd4850 storage_v2 _src_ schema performance_schema.kIw0nw.meta 76B information_schema.FNRwLQ.meta 76B sys.zb4BAA.meta 61B mysql.osA4Bg.meta 63B mybatis-01 pom.xml 503B target test-classes cn sicko dao UserTest.class 3KB generated-test-sources test-annotations classes mybatis-config.xml 1002B cn sicko dao UserMapper.class 333B UserMapper.xml 1018B pojo User.class 1KB utils MybatisUtils.class 1KB generated-sources annotations src test java cn sicko dao UserTest.java 3KB main resources mybatis-config.xml 1002B java cn sicko dao UserMapper.java 406B UserMapper.xml 1KB pojo User.java 898B utils MybatisUtils.java 1KB
评论0