Mybatis之使用注解开发CRUD

最新推荐文章于 2021-12-19 23:47:43 发布

www-1234

最新推荐文章于 2021-12-19 23:47:43 发布

阅读量266

点赞数

分类专栏： Mybatis 文章标签： mybatis

Mybatis 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

Mybatis之使用注解开发CRUD

1、创建接口

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 {  
    @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();  
}

2、在配置文件中注册

<mappers>  
    <mapper resource="com/bird/mybatis/bean/userMapper.xml" />  
    <mapper class="com.bird.mybatis.bean.UserMapper"/>  
</mappers>

3、使用

    @Test  
    public void testAdd2() {  
        SqlSession openSession = factory.openSession();  
        UserMapper mapper = openSession.getMapper(UserMapper.class);  
        mapper.add(new Users(-1,"娃娃",99));  
        openSession.commit();  
        openSession.close();  
    }

转载地址： http://blog.csdn.net/a352193394/article/details/39940259