MyBatis快速入门——第二章、DML语句操作

MyBatis快速入门——第二章、DML语句操作

目录

在接口类中添加【UsersMapper.java】

修改【com.item.mapper.UsersMapper.】

【action.java】

---

在接口类中添加【UsersMapper.java】

    
    int AddInfo(@Param("nickName")String nickName,
                @Param("sex")int sex,
                @Param("age")int age,
                @Param("introduce")String introduce);

    
    int UpdateInfo(@Param("nickName")String nickName,
                   @Param("id")int id);

    
    int DeleteById(@Param("id")int id);

修改【com.item.mapper.UsersMapper.】

    
        insert into users values(0,Now(),"${nickName}",${sex},${age},"${introduce}");
    
    
        update users set nickName="${nickName}" where id=#{id}
    
    
        delete from users where id=#{id}
    

【action.java】

    public static void main(String[] args) throws IOException {
        Reader reader = Resources.getResourceAsReader("mybatis-config.xml");
        SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
        SqlSession sqlSession = sessionFactory.openSession();
        UsersMapper db = sqlSession.getMapper(UsersMapper.class);
        //添加
        int rows = db.AddInfo("安琦", 0, 20, "美貌");
        System.out.println(rows>0?"添加成功":"添加失败");
        rows = db.UpdateInfo("安琦", 5);
        System.out.println(rows>0?"修改成功":"修改失败");
        rows = db.DeleteById(6);
        System.out.println(rows>0?"删除成功":"删除失败");
        sqlSession.commit();
        sqlSession.close();
    }

执行效果：