Mybatis注解开发---增删改查-Toy模板网

这篇具有很好参考价值的文章主要介绍了Mybatis注解开发---增删改查。希望对大家有所帮助。如果存在错误或未考虑完全的地方，请大家不吝赐教，您也可以点击"举报违法"按钮提交疑问。

（1）insert测试方法

（2）delete测试方法

（3）update测试方法

（4）select测试方法

一定要记得注册映射文章来源地址https://www.toymoban.com/news/detail-712571.html
<mappers>
        <package name="com.gq.mapper"/>
    </mappers>

public interface UserMapper {
    @Select("select *from user")
    List<User> findAll();
    //添加用户
    @Insert("insert into user(username,sex,address) values(#{username},#{sex},#{address})")
    void add(User user);
    //删除用户，根据id
    @Delete("delete from user where id=#{id}")
    void delete(int id);
    //修改用户
    @Update("update user set username=#{username},sex=#{sex},address=#{address} where id=#{id}")
    void update(User user);
}

（1）insert测试方法

 @Test
    public void Test2() throws Exception {
        InputStream is = Resources.getResourceAsStream("SqlMapConfig.xml");
        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
        SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(is);
        SqlSession session = sqlSessionFactory.openSession();
        UserMapper userMapper=session.getMapper(UserMapper.class);
        List<User> userList=userMapper.findAll();
        userList.forEach(System.out::println);
        session.commit();
        session.close();
        is.close();
    }

（2）delete测试方法

@Test
    public void Test3() throws Exception {
        InputStream is = Resources.getResourceAsStream("SqlMapConfig.xml");
        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
        SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(is);
        SqlSession session = sqlSessionFactory.openSession();
        UserMapper userMapper=session.getMapper(UserMapper.class);
        User user=new User("洒洒水","男","厦门");
        userMapper.add(user);
        session.commit();
        session.close();
        is.close();
    }

（3）update测试方法

 @Test
    public void Test4() throws Exception {
        InputStream is = Resources.getResourceAsStream("SqlMapConfig.xml");
        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
        SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(is);
        SqlSession session = sqlSessionFactory.openSession();
        UserMapper userMapper=session.getMapper(UserMapper.class);
        userMapper.delete(16);
        session.commit();
        session.close();
        is.close();
    }

（4）select测试方法

 @Test
    public void Test5() throws Exception {
        InputStream is = Resources.getResourceAsStream("SqlMapConfig.xml");
        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
        SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(is);
        SqlSession session = sqlSessionFactory.openSession();
        UserMapper userMapper=session.getMapper(UserMapper.class);
        User user=new User(17,"大大","女","北京");
        userMapper.update(user);
        session.commit();
        session.close();
        is.close();
    }

到了这里，关于Mybatis注解开发---增删改查的文章就介绍完了。如果您还想了解更多内容，请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章，希望大家以后多多支持TOY模板网！