mybatis学习笔记

Mybatis

1、UserMapper.xml文件

2、接口文件UserMapper.API

3、User类

package com.kuang.pojo;

//实体类
public class User {
    private int id;
    private String name;
    private String pwd;

    public User() {
    }

    public User(int id, String name, String pwd) {
        this.id = id;
        this.name = name;
        this.pwd = pwd;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPwd() {
        return pwd;
    }

    public void setPwd(String pwd) {
        this.pwd = pwd;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", pwd='" + pwd + '\'' +
                '}';
    }
}

4、测试

• package com.kuang.dao;
  
  import com.kuang.pojo.User;
  import com.kuang.utils.MybatisUtils;
  import org.apache.ibatis.session.SqlSession;
  import org.junit.Test;
  
  import java.util.List;
  
  public class UserDaoTest {
      @Test
      public void test(){
          //第一步：获取SQLSession对象
          SqlSession sqlSession = MybatisUtils.getSqlSession();
          try{
          //方式1：getMapper
          UserMapper userDao = sqlSession.getMapper(UserMapper.class);
          List<User> userList = userDao.getUserList();
          //方式2：
  //        List<User> userList = sqlSession.selectList("com.kuang.dao.UserDao.getUserList");
          for (User user : userList) {
              System.out.println(user.toString());
              }
  
  
          }catch (Exception e){
              e.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();
          UserMapper mapper = sqlSession.getMapper(UserMapper.class);
          int res = mapper.addUser( new User(6,"哈哈3","156728"));
          if (res>0) {
              System.out.println("插入成功！");
          }
          sqlSession.commit();//现在的版本不要也行
          sqlSession.close();
          }
      @Test
      public void testupdateUser(){
          SqlSession sqlSession = MybatisUtils.getSqlSession();
  
          UserMapper mapper = sqlSession.getMapper(UserMapper.class);
  
          mapper.updateUser(new User(4,"pepe","945466"));
  
  
          sqlSession.commit();
          sqlSession.close();
      }
      @Test
      public void deleteUser(){
          SqlSession sqlSession = MybatisUtils.getSqlSession();
  
          UserMapper mapper = sqlSession.getMapper(UserMapper.class);
  
          mapper.deleteUser(4);
  
  
          sqlSession.commit();
          sqlSession.close();
      }
      }
  
  

总结

​ xml内有中文注释可能导致报错，添加功能，直接写入到接口中，然后到Usermapper.xml里实现就行，测试完成后记得关闭sqlSession.