mybatis框架：SQL语句映射注解

1. @Insert：实现新增功能

@Insert("insert into user(id,name) values(#{id},#{name})")

public int insert(User user);

2. @Update注解：实现更新功能

@Update("update user set name= #{name},sex = #{sex},age =#{age} where id = #{id}")

void updateUserById(User user);

3. @Delete注解：实现删除功能

@Delete("delete from  user  where id =#{id}")

void deleteById(Integer id);

4. @Select注解：实现查询功能

@Select("Select * from user")

List queryAllUser();