详解Mybatis中的CRUD

//根据id查询用户
  User getUserById(int id);

    select * from mybatis.user where id = #{id}

@Test
  public void getUserLike(){

    SqlSession sqlSession = MybatisUtils.getSqlSession();

    UserMapper mapper = sqlSession.getMapper(UserMapper.class);

    List userList = mapper.getUserLike("李");

    for (User user : userList) {
      System.out.println(user);
    }

    sqlSession.close();
  }

  insert into mybatis.user (id,name,pwd) values (#{id},#{name},#{pwd});

  update mybatis.user set name = #{name},pwd=#{pwd} where id = #{id};

  delete from mybatis.user where id = #{id};