MyBatis学习(二)代码

package com.lotus.mybatis.mapper; import com.lotus.mybatis.pojo.User; import com.lotus.mybatis.utils.SqlSessionUtils; import org.apache.ibatis.session.SqlSession; import org.junit.Test; import java.io.IOException; import java.util.HashMap; import java.util.List; import java.util.Map; /** * Administrator * 2024/6/11 */ public class ParamemterTest { @Test public void test1() throws IOException { SqlSession sqlSession = SqlSessionUtils.getSqlSession(); ParameterMapper mapper = sqlSession.getMapper(ParameterMapper.class); //UserMapper mapper = sqlSession.getMapper(UserMapper.class); List<User> allUser = mapper.getAllUser(); allUser.forEach(user-> System.out.println(user)); } @Test public void testGetUserByUsername() throws IOException { SqlSession sqlSession = SqlSessionUtils.getSqlSession(); ParameterMapper mapper = sqlSession.getMapper(ParameterMapper.class); User user = mapper.getUserByUsername("dizzy"); System.out.println(user); } @Test public void testCheckLogin() throws IOException { SqlSession sqlSession = SqlSessionUtils.getSqlSession(); ParameterMapper mapper = sqlSession.getMapper(ParameterMapper.class); User user = mapper.checkLogin("dizzy","12345"); System.out.println(user); } @Test public void testCheckLoginByMap() throws IOException { SqlSession sqlSession = SqlSessionUtils.getSqlSession(); ParameterMapper mapper = sqlSession.getMapper(ParameterMapper.class); Map<String,Object> map = new HashMap<>(); map.put("arg0","dizzy"); map.put("arg1","12345"); map.put("param1","dizzy"); map.put("param2","12345"); map.put("username","dizzy"); map.put("password","12345"); User user = mapper.checkLoginByMap(map); System.out.println(user); } @Test public void testInsertUser() throws IOException { SqlSession sqlSession = SqlSessionUtils.getSqlSession(); ParameterMapper mapper = sqlSession.getMapper(ParameterMapper.class); int res = mapper.insertUser(new User(null,"water","123456",11,"男","[email protected]")); System.out.println(res); } @Test public void testCheckLoginByParam() throws IOException { SqlSession sqlSession = SqlSessionUtils.getSqlSession(); ParameterMapper mapper = sqlSession.getMapper(ParameterMapper.class); User user = mapper.checkLoginByParam("water","123456"); System.out.println(user); } }