xml
select * from test
测试
package com.li.mapper;
import com.li.pojo.User;
import com.li.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.jupiter.api.Test;
import java.util.List;
public class MapperTest {
@Test
public void test(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
List userList = mapper.getUserList();
for (User user : userList) {
System.out.println(user);
}
}
@Test
public void byidtest(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
List listbyId = mapper.getListbyId("01");
System.out.println(listbyId);
}
@Test
public void add(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
int res = mapper.addUser(new User("03", "小赵", "333"));
if (res>0){
System.out.println("插入成功");
sqlSession.commit();
sqlSession.close();
}
}
@Test
public void remove(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
int i = mapper.removeUser("02");
if (i>0){
sqlSession.commit();
sqlSession.close();
System.out.println("1");
}
}
@Test
public void update(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
int i = mapper.updateUser(new User("03","aaaa","232"));
if (i>0){
sqlSession.commit();
sqlSession.close();
System.out.println("1");
}
}
}



