3、CRUD

1、namespace

namespace中的包含要和Dao/mapper接口的包含名一致

2、select

选择/查询语句：

• id就是对应的namespace中的方法名；
• resultType：sql语句执行的返回值！
• parameterType:参数类型；

3、insert

4、update

5、delete

1、编写接口

package com.xiao.dao;

import com.xiao.pojo.User;

import java.util.List;

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

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

    //insert一个用户
    int addUser(User user);

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

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

2、编写对应的mapper中的sql语句

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--namespace=绑定一个对应的Dao/Mapper接口-->
<mapper namespace="com.xiao.dao.UserMapper">


    <select id="getUserList" resultType="com.xiao.pojo.User" >
        select * from mybatis.user
    </select>

    <select id="getUserByID" parameterType="int" resultType="com.xiao.pojo.User">
     select * from mybatis.user where id = #{id}
    </select>
<!--    对象中的数据可以直接取出来-->
    <insert id="addUser" parameterType="com.xiao.pojo.User" >
        insert into mybatis.user (id,name,pwd) value (#{id},#{name},#{pwd});
    </insert>

    <update id="updateUser" parameterType="com.xiao.pojo.User">
        update mybatis.user
        set name=#{name},pwd=#{pwd}
        where id=#{id};
    </update>

    <delete id="deleteUser" >
        delete from mybatis.user where id = #{id}
    </delete>
</mapper>

3、测试

package com.xiao.dao;

import com.xiao.pojo.User;
import com.xiao.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.List;

public class UserDaoTest {
    @Test
    public void text() {
        //第一步：获得sqlSession对象
        SqlSession sqlSession = MybatisUtils.getSqlSession();

        try {
            //执行sql
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            List<User> userList = mapper.getUserList();

            for (User user : userList) {
                System.out.println(user);
            }
        } catch (Exception e) {
        } finally {
            sqlSession.close();
        }
    }
    @Test
    public void getUserByID(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        User userByID = mapper.getUserByID(1);
        System.out.println(userByID);


        sqlSession.close();
    }

    //增删改需要增加事务
    @Test
    public void addUser(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        mapper.addUser(new User(4,"哈哈","123123"));

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

    @Test
    public void updateUser(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        mapper.updateUser(new User(4,"呵呵","123456"));

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

    @Test
    public void deleteUser(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);

        mapper.deleteUser(1);
        sqlSession.commit();
        sqlSession.close();
    }
}

6、万能的map

假设我们的实体类，或者数据库中的表，字段或者参数过多，我们应该考虑使用map！

// 万能的map
int addUser2(Map<String,Object> map);

<insert id="addUser2" parameterType="map">
    insert into mybatis.user (id,name,pwd) value (#{Userid},#{Username},#{password});
</insert>

@Test
public void addUser2(){
    SqlSession sqlSession = MybatisUtils.getSqlSession();
    UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    Map<String, Object> map = new HashMap<>();
    map.put("Userid",5);
    map.put("Username","hello");
    map.put("password","123123");

    mapper.addUser2(map);
    sqlSession.close();
}

Map传递参数，直接在sql中取出key即可！

对象传递参数，直接在sql中取对象的属性即可！

只有一个基本类型参数的情况下，可以直接在sql中渠道

7、模糊查询

模糊查询怎么写？

1. java代码执行的时候，传递通配符%%

   List<User> UserList = mapper.getUserLike("%李%");
   

2. 在sql拼接中使用通配符

   select * from user where name like "%"#{value}"%"