Mybatis的神奇CRUD

1. CRUD

1,namespce

namespce中的包名要和dao/mapper中的一致

2, select

• id：它就是dao/mapper中的对应方法名

• resultType：代表返回值的类型(sql范围的类型)

• parameterType：代表类型

1. 编写接口

    public List<user> getUse();
   

2. 编写sql语言

     <select id="getUse" resultType="com.pojo.user">
           select * from mybatis.user
       </select>
   

3. 测试代码

     public void getUser(){
           SqlSession sqlSession = MybatisUtils.getSqlSession();
           UserDao mapper = sqlSession.getMapper(UserDao.class);
           List<user> User = mapper.getUse();
           for (user user : User) {
               System.out.println(user);
           }
           sqlSession.close();
       }//查询所以用户信息
   

3,update

1. 编写接口

public int UpdateUser(user user);

2. 编写sql

   <update id="UpdateUser">
       update mybatis.user set name=#{name},pwd=#{pwd} Where id=4;
   </update>
   

3. 测试代码

   public void UpdateUser(){
       SqlSession sqlSession = MybatisUtils.getSqlSession();
       UserDao mapper = sqlSession.getMapper(UserDao.class);
       int i = mapper.UpdateUser(new user(4, "哈哈", "415546"));
       sqlSession.commit();
       sqlSession.close();
   }//更新用户信息
   

4, insert

1. 编写接口

   //增加用户
   public int AddUser(user item);
   

2. 编写sql

   <update id="UpdateUser">
       update mybatis.user set name=#{name},pwd=#{pwd} Where id=4;
   </update>
   

3. 测试代码

   public void AddUser(){
       SqlSession sqlSession = MybatisUtils.getSqlSession();
       UserDao mapper = sqlSession.getMapper(UserDao.class);
       int i = mapper.AddUser(new user(4, "呵呵", "12a35"));
       if (i>0){
       System.out.println("插入数据成功!");
   }
       //增删改一定要数据事务提交!!!!!!!
       sqlSession.commit();
       sqlSession.close();
   }//添加用户
   

5,delet

1. 编写接口

   //删除用户
   public void DeleteUser(int id);
   

2. 编写sql

   <delete id="DeleteUser">
     delete from mybatis.user where id=4
   </delete>
   

3. 测试代码

   public void DeleteUser(){
       SqlSession sqlSession = MybatisUtils.getSqlSession();
       UserDao mapper = sqlSession.getMapper(UserDao.class);
        mapper.DeleteUser(4);
       sqlSession.commit();
       sqlSession.close();
   }//删除用户信息
   

6,实用传参方式

1. 编写接口

   //增加用户传参方法二
   public void AddUser2(Map<String,Object> map);
   

2. 编写sql

   <insert id="AddUser2">
     insert into mybatis.user (id, name, pwd) VALUES (#{num},#{Name},#{password})
   </insert>
   

3. 测试代码

   public void ADDUser(){
       SqlSession sqlSession = MybatisUtils.getSqlSession();
       UserDao mapper = sqlSession.getMapper(UserDao.class);
       Map<String, Object> map = new HashMap<>();
       map.put("num",4);
       map.put("Name","哈哈");
       map.put("password","1564");  
       mapper.AddUser2(map);
       sqlSession.commit();
       sqlSession.close();
   }//添加方法二用户信息
   

7,注意

• 增删改要一定要事务提交