3.CURD增删改查

文章目录
         1.UserMapper接口

         2.UserMapper.xml

         3.Test进行测试

0.UserMapper编写接口

public interface UserMapper {
   //查询全部用户
   List<User> getUserList();

   //根据id查询用户
   User getUserById(int id);

   //插入用户
   void addUser(User user);

   //修改用户
   int updateUser(User user);

   //删除用户
   int deleteUser(int id);
}

1.UserMapper.xml

<!--namespace命名空间-->
<mapper namespace="com.redeemi.dao.UserMapper">

    <!--查询全部的用户信息-->
    <select id="getUserList" resultType="com.redeemi.pojo.User">
    select * from mybatis.user
  </select>

    <!--按照ID查询用户-->
    <select id="getUserById" parameterType="int" resultType="com.redeemi.pojo.User">
    select * from mybatis.user  where id = #{id}
  </select>

    <!--插入一个用户,对象中的属性可以取出来-->
    <insert id="addUser" parameterType="com.redeemi.pojo.User">
    insert into mybatis.user(id,name,pwd) values (#{id},#{name},#{pwd});
  </insert>

    <!--修改用户的信息-->
    <update id="updateUser" parameterType="com.redeemi.pojo.User">
    update mybatis.user set name = #{name},pwd = #{pwd} where id = #{id};
  </update>

    <!--删除用户的信息-->
    <delete id="deleteUser" parameterType="int">
    delete from mybatis.user where id = #{id};
    </delete>

2.UserDaoTest增删改必须commit提交事务

package com.jay.dao;

import com.jay.pojo.User;
import com.jay.utils.MybatisUtil;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.List;

public class UserDaoTest {

   @Test
   public void test(){

       //第一步：获取SqlSession的对象
       SqlSession sqlSession = MybatisUtil.getSession();

       //方式1：getMapper
       UserMapper userDao= sqlSession.getMapper(UserMapper.class);
       List<User> userList = userDao.getUserList();


       for (User user : userList) {
           System.out.println(user);
       }

       //关闭SqlSession
       sqlSession.close();

   }


   @Test
   public void  testUserById(){

       SqlSession sqlSession = MybatisUtil.getSession();

       UserMapper mapper = sqlSession.getMapper(UserMapper.class);

       User userById = mapper.getUserById(1);

       System.out.println(userById);

       sqlSession.close();
   }

   //增删改查需要提交事务
   @Test
   public void testAddUser(){

       SqlSession sqlSession = MybatisUtil.getSession();

       UserMapper mapper = sqlSession.getMapper(UserMapper.class);

       mapper.addUser(new User("拉拉","12345",5));

       //提交事务
       sqlSession.commit();

       sqlSession.close();
   }

   //按照id修改用户的信息
   //需要提交事务
   @Test
   public void testUpdateUser(){

       SqlSession sqlSession = MybatisUtil.getSession();

       UserMapper mapper = sqlSession.getMapper(UserMapper.class);

       mapper.updateUser(new User("哇哇","567898",5));

       //提交事务
       sqlSession.commit();

       sqlSession.close();

   }

   //按照ID删除用户的信息
   @Test
   public void testDeleteUser(){

       SqlSession sqlSession = MybatisUtil.getSession();

       UserMapper mapper = sqlSession.getMapper(UserMapper.class);

       mapper.deleteUser(5);

       sqlSession.commit();
       sqlSession.close();

   }
}