添加用户
public class TestMybatisData{ @Test public void addUserTest(){ // 通过字节输入流获取核心配置文件 InputStream is = TestMybatisData.class.getClassLoader.getResouceAsStream("mybatis-config"); // 构建Sql会话工厂对象 SqlSessionFactory sessionFactory = new SqlSessionFactoryBuild().builder(is); // 通过会话工厂对象获取session SqlSession session = sessionFactory.openSession(); // 实例化持久化对象,并且完成赋值操作 User u = new User(); u.setId(3); u.setUsername("李白"); //insert 中传入的第一个参数为映射文件的全包名+映射文件名 // 第二个参数为持久化对象 int rows = session.insert("cn.javabs.mybatisdemo.mapper.UserMapper.addUser",u); if(rows > 0){ System.out.println("执行成功,已插入"+rows+"条语句"); }else{ System.out.println("执行失败); } } session.commit(); session.close(); }
删除用户
@Test public void delUserById() { InputStream is = TestData.class.getClassLoader().getResourceAsStream("mybatis-config.xml"); SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(is); SqlSession session = sessionFactory.openSession(); User u = new User(); u.setId(3); int rows = session.delete("cn.javabs.mybatisdemo.mapper.UserMapper.deleteUserById",u); if(rows>0){ System.out.println("语句执行成功,删除"+rows+"条数"); }else{ System.out.println("删除语句失败"); } session.commit(); session.close(); }
映射配置文件:
<delete id="deleteUserById" parameterType="Integer"> delete from user where id = #{id} </delete>
更改用户
@Test public void updateUserTest { InputStream is = TestData.class.getClassLoader().getResourceAsStream("mybatis-config.xml"); SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(is); SqlSession session = sessionFactory.openSession(); User u = new User(); u.setId(31); u.setUsername("赵云"); int rows = session.update("cn.javabs.mybatisdemo.mapper.UserMapper.updateUserById", u); if(rows > 0){ System.out.println("更新了"+rows+"条记录"); }else{ System.out.println("更新失败"); } session.commit(); session.close(); }
配置文件可以更改为
<update id="updateUserById" parameterType="cn.javabs.mybatisdemo.po.User"> update user set username = #{username} where id = #{id} </update>
查询全部用户
@Test public void findAll() { InputStream is = TestData.class.getClassLoader().getResourceAsStream("mybatis-config.xml"); SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(is); SqlSession session = sessionFactory.openSession(); User u = new User(); u.setId(3); List<Object> list = session.selectList("cn.javabs.mybatisdemo.mapper.UserMapper.queryUser"); if(list.size()>0){ for (int i = 1; i < list.size(); i++) { System.out.println("。。。"+list.toString()); } }else{ System.out.println("查询语句失败"); } session.commit(); session.close(); }
配置文件可以更改为:
<select id="queryUser" resultType="cn.javabs.mybatisdemo.po.User"> select * from user </select>
根据Id查询用户
@Test public void findUserById() { InputStream is = TestData.class.getClassLoader().getResourceAsStream("mybatis-config.xml"); SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(is); SqlSession session = sessionFactory.openSession(); User u = new User(); u.setId(31); u = session.selectOne("cn.javabs.mybatisdemo.mapper.UserMapper.queryUserById", u); if(u != null ){ System.out.println("当前用户是:"+u); }else{ System.out.println("查询失败"); } session.commit(); session.close(); }
配置文件可以更改为
<select id="queryUserById" parameterType="Integer" resultType="cn.javabs.mybatisdemo.po.User"> select * from user where id = #{id} </select>