mybatis利用注解实现增删改查

最新推荐文章于 2023-08-11 18:16:54 发布

原创最新推荐文章于 2023-08-11 18:16:54 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis #sql #注解

MyBatis 专栏收录该内容

7 篇文章

订阅专栏

本文介绍了一个使用MyBatis实现的简单用户增删改查(CRUD)操作示例，包括添加用户、删除用户、更新用户信息及查询用户详情的方法。通过两个不同的Mapper接口展示了如何执行SQL语句。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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.youkuaiyun.com/postedit/48471481