mybatis基于注解的增删改查
2017-09-05 本文已影响0人
wangzaiplus
1. SELECT
@Select("SELECT * FROM user WHERE name = #{name}")
User findByName(@Param("name") String name);
2. INSERT
@Insert("INSERT INTO user(name, age) VALUES(#{name}, #{age})")
int insert(@Param("name") String name, @Param("age") Integer age);
3. UPDATE
@Update("UPDATE user SET age=#{age} WHERE name=#{name}")
void update(User user);
4. DELETE
@Delete("DELETE FROM user WHERE id =#{id}")
void delete(Long id);
