mybatis利用注解实现增删改查

public interface UserMapper {

    @Insert("insert into users(name, age) values(#{name}, #{age})")  
    public int add(Users user);  
      
    @Delete("delete from users where id = #{id}")  
    public int deleteById(int id);  
      
    @Update("update users set name = #{name}, age = #{age} where id = #{id}")  
    public int update(Users user);  
      
    @Select("select * from users where id = #{id}")  
    public Users getUserById(int id);  
      
    @Select("select * from users")  
    public List<Users> getAllUsers();  
}  

public interface UserMapper {
    @Select("select * from blog_db.user where id=#{id}")
    @Results(
      {
        @Result(id = true, column = "id", property = "id"),
        @Result(column = "name", property = "name"),
        @Result(column = "email", property = "email"),
        @Result(column = "password", property = "password")
      })
    User findById(int id);
    @Insert("INSERT INTO blog_db.user (name, email, password) " +
      "VALUES (#{name}, #{email}, #{password} )")
    @Options(useGeneratedKeys=true, keyProperty="id")
    void insertUser1(User user);
    @Insert("INSERT INTO blog_db.user (name, email, password) " +
      "VALUES ( #{user.name}, #{user.email}, CONCAT(#{user.password}, #{passwordSuffix}) )")
    void insertUser2(@Param("user")User user, @Param("passwordSuffix")String passwordSuffix);
}

转自： http://write.blog.csdn.net/postedit/48471481