【mybatis的CRUD增删改查语句】

UsersMapper接口:
//方法存在多个参数，所有参数必须加上param注解 @Param("id")
@Select("select * from users where id = #{id}")
Users getUsersById(@Param("id") int id);

@Insert("insert into users(id,name,password) values (#{id},#{name},#{password})")
int addUser (Users users);

@Update("update users set name=#{name},password=#{password} where id=#{id}")
int updateUsers (Users users);

@Delete("delete from  users where id = #{uid}")
int deleteUsers (@Param("uid") int id);

 @Test
    public void getUsersList(){
        SqlSession sqlSession = MybatisUtil.getSqlSession();
        //
        UsersMapper mapper = sqlSession.getMapper(UsersMapper.class);

//        mapper.addUser(new Users(2,"hhxx","18881888"));

//        List<Users> usersList =mapper.getUsersList();
//        for (Users users : usersList) {
//            System.out.println(users);
//
//        }
//        Users users = mapper.getUsersById(1);
//        System.out.println(users);

//        mapper.updateUsers(new Users(5,"Mai","147258369"));

        mapper.deleteUsers(6);

        sqlSession.close();