1、select
-
Dao接口;
//根据id查询用户 User getUserById(int id);
-
接口实现类(由原来的UserDaoImpl转变为一个Mapper.xml配置文件);
<select id="getUserById" parameterType="int" resultType="com.beyond.pojo.User"> select * from mybatis.user where id=#{id} </select>
-
测试
@Test public void getUserById(){ //1、获得SqlSession对象 SqlSession sqlSession= MyBatisUtil.getSqlSession(); //2、执行SQL //方式一:getMapper UserDao user=sqlSession.getMapper(UserDao.class); User userById = user.getUserById(1); System.out.println(userById); //关闭SqlSession sqlSession.close(); }
2、insert
-
Dao接口;
//insert一个用户 void addUser(User user);
-
接口实现类(由原来的UserDaoImpl转变为一个Mapper.xml配置文件);
<insert id="addUser" parameterType="com.beyond.pojo.User"> insert into mybatis.user (id,name,pwd) values (#{id},#{name},#{pwd}); </insert>
-
测试
//增删改必需要提交事务 @Test public void addUser(){ //1、获得SqlSession对象 SqlSession sqlSession= MyBatisUtil.getSqlSession(); //2、执行SQL //方式一:getMapper UserDao user=sqlSession.getMapper(UserDao.class); user.addUser(new User(4,"小明","ibicbm")); //提交事务 sqlSession.commit(); //关闭SqlSession sqlSession.close(); }
3、update
-
Dao接口;
//修改用户 int updateUser(User user);
-
接口实现类(由原来的UserDaoImpl转变为一个Mapper.xml配置文件);
<update id="updateUser" parameterType="com.beyond.pojo.User"> update mybatis.user set name=#{name},pwd=#{pwd} where id=#{id}; </update>
-
测试
//增删改必需要提交事务 @Test public void updateUser(){ //1、获得SqlSession对象 SqlSession sqlSession= MyBatisUtil.getSqlSession(); //2、执行SQL //方式一:getMapper UserDao user=sqlSession.getMapper(UserDao.class); user.updateUser(new User(3,"李斯","uiioop")); //提交事务 sqlSession.commit(); //关闭SqlSession sqlSession.close(); }
4、delete
-
Dao接口;
//删除一个用户 void deleteUser(int id);
-
接口实现类(由原来的UserDaoImpl转变为一个Mapper.xml配置文件);
<delete id="deleteUser" parameterType="int"> delete from mybatis.user where id=#{id}; </delete>
-
测试
//增删改必需要提交事务 @Test public void deleteUser(){ //1、获得SqlSession对象 SqlSession sqlSession= MyBatisUtil.getSqlSession(); //2、执行SQL //方式一:getMapper UserDao user=sqlSession.getMapper(UserDao.class); user.deleteUser(4); //提交事务 sqlSession.commit(); //关闭SqlSession sqlSession.close(); }