mybatis demo

package cn.edu.wic.mybatis02.test; import cn.edu.wic.mybatis02.bean.Table; import cn.edu.wic.mybatis02.bean.User; import cn.edu.wic.mybatis02.mapper.UserMapper; import com.alibaba.fastjson2.JSON; import com.alibaba.fastjson2.JSONArray; import com.alibaba.fastjson2.JSONObject; 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.junit.After; import org.junit.Before; import org.junit.Test; import java.io.IOException; import java.io.InputStream; import java.util.List; public class UserMapperTest { private SqlSession session; // 在每一个@Test方法执行之前自动执行 @Before public void before() throws IOException { InputStream in = Resources.getResourceAsStream("mybatis.xml"); SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in); session = factory.openSession(); } // 在每一个@Test方法执行之后自动执行 @After public void after(){ session.commit(); session.close(); } @Test public void get(){ User user = session.selectOne("cn.edu.wic.mybatis02.mapper.UserMapper.get", 57); System.out.println(JSONObject.toJSONString(user)); } @Test public void get1(){ UserMapper mapper = session.getMapper(UserMapper.class); User user = mapper.get(57); System.out.println(JSONObject.toJSONString(user)); } @Test public void save(){ User user = new User(); user.setUsername("test"); user.setPassword("test"); user.setName("测试用户"); UserMapper mapper = session.getMapper(UserMapper.class); int rows = mapper.save(user); System.out.println(String.format("保存了%d个用户", rows)); System.out.println(JSONObject.toJSONString(user)); } @Test public void delete(){ UserMapper mapper = session.getMapper(UserMapper.class); mapper.delete(57); } @Test public void updatePassword(){ UserMapper mapper = session.getMapper(UserMapper.class); User user = new User(); user.setId(59); user.setPassword("111111111111111111"); mapper.updatePassword(user); } @Test public void findSearch(){ List<User> users = session.selectList("cn.edu.wic.mybatis02.mapper.UserMapper.findSearch"); System.out.println(JSONArray.toJSONString(users)); users=session.selectList("cn.edu.wic.mybatis02.mapper.UserMapper.findSearch","a"); System.out.println(JSONArray.toJSONString(users)); } @Test public void deleteByIds(){ int rows = session.delete("cn.edu.wic.mybatis02.mapper.UserMapper.deleteByIds", new Integer[]{ 2, 3, 5, 58}); System.out.println(rows); } @Test public void updateColumn(){ User user = new User(); user.setId(1); user.setUsername("志刚"); int rows = session.delete("cn.edu.wic.mybatis02.mapper.UserMapper.updateColumn", user); System.out.println(rows); } @Test public void findTable(){ Table table = new Table(); table.setSort("id"); table.setOrder("desc"); table.setRows(1); table.setPage(2); List<User> li = session.selectList("cn.edu.wic.mybatis02.mapper.UserMapper.findTable", table); System.out.println(JSONArray.toJSONString(li)); } }