使用MyBatis(七)使用java注解完成CRUD

1.修改UserMapper

注意：

 List<User> selectAllUser();

这个必须写成泛型里面具体的User类型。

package com.yw.test05;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

public interface UserMapper
{
    @Select("SELECT * FROM user WHERE id = #{id}")
    User selectUser(int id);
    
    @Select("select * from user")
    List<User> selectAllUser();
    
    @Insert("insert into user(name,age) values(#{name},#{age})")
    void insertUser(User u);
    
    @Update("update user set name=#{name} ,age=#{age} where id=#{id}")
    void updateUser(User u);
    
    @Delete("delete from user where id=#{id}")
    void deleteUser(int id);

}

2.修改测试类