MyBatis获取参数的两种方法和各种情况

MyBatis获取参数的两种方法（重点）

MyBatis获取参数的两种方法:${}和#{}
${}本质就是字符串拼接，#{}的本质就是占位符赋值
${}使用字符串拼接的方式拼接sql，若为字符串类型或日期类型的字段进行赋值时,需要手动加单引号；
但是#{}使用占位符赋值的方式拼接sql，此时为字符串类型或日期类型的字段进行赋值时，可以自动添加单引号

MyBatis获取参数值的各种情况

package com.mybatis.utils;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.IOException;
import java.io.InputStream;

public class SqlSessionUtils {
    public static SqlSession getSqlSession(){
        SqlSession sqlSession = null;
        try {
            InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
            sqlSession = sqlSessionFactory.openSession(true);

        }catch (IOException e){
            e.printStackTrace();
        }
        return sqlSession;
    }
}

import org.junit.Test;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class ParameterMapperTest {
    @Test
    public void testgetAllUser(){
        SqlSession sqlSession = SqlSessionUtils.getSqlSession();
        ParameterMapper mapper = sqlSession.getMapper(ParameterMapper.class);
        List<User> list = mapper.getAllUser();
        list.forEach(user -> System.out.println(user));
    }
    /**
     * MyBatis获取数值的两种方式${} #{}
     * ${}本质是字符串拼接
     * #{}本质是占位符赋值
     * MyBatis获取参数值的各种情况
     * 1.mapper接口方法的参数为单个的字面量类型
     * ${任意名称}，#{任意名称}，注意${}的单引号问题
     * 2.mapper接口方法的参数为多个时
     * 此时MyBatis会将这些参数放在一个map集合中，以两种方式进行存储
     * 以arg0,arg1...为键。以参数为值
     * 或以param1,param2...为键，以参数为值
     * 3.若mapper接口方法的参数有多个时，可以手动将这些参数放在一个map中存储
     * 4.mapper接口方法的参数是实体类类型的参数
     * 只需要通过#{}和${}以属性的方式访问属性值即可
     * 5.使用@Param注解命名参数
     */
    @Test
    public void testgetUserByUsername(){
        SqlSession sqlSession = SqlSessionUtils.getSqlSession();
        ParameterMapper mapper = sqlSession.getMapper(ParameterMapper.class);
        User user = mapper.getUserByUsername("admin");
        System.out.println(user);
    }
    @Test
    public void testCheckLogin(){
        SqlSession sqlSession = SqlSessionUtils.getSqlSession();
        ParameterMapper mapper = sqlSession.getMapper(ParameterMapper.class);
        User user = mapper.checkLogin("黄捷文","12345");
        System.out.println(user);
    }
    @Test
    public void testCheckLoginByMap(){
        SqlSession sqlSession = SqlSessionUtils.getSqlSession();
        ParameterMapper mapper = sqlSession.getMapper(ParameterMapper.class);
        Map<String,Object> map = new HashMap<>();
        map.put("username","admin");
        map.put("password","12345");
        User user = mapper.checkLoginByMap(map);
        System.out.println(user);
    }
    @Test
    public void testinsertUser(){
        SqlSession sqlSession = SqlSessionUtils.getSqlSession();
        ParameterMapper mapper = sqlSession.getMapper(ParameterMapper.class);
        int result = mapper.insertUser(new User(null,"李四","12345",23,"男","123@qq.com"));
        System.out.println(result);
    }
    @Test
    public void testCheckLoginByParam(){
        SqlSession sqlSession = SqlSessionUtils.getSqlSession();
        ParameterMapper mapper = sqlSession.getMapper(ParameterMapper.class);
        User user = mapper.checkLoginByParam("李四","12345");
        System.out.println(user);
    }
}

package com.mybatis.mapper;

import com.mybatis.pojo.User;
import org.apache.ibatis.annotations.Param;
import java.util.List;
import java.util.Map;

public interface ParameterMapper {
    //查询所有员工信息
    List<User> getAllUser();

    //根据用户名查询用户信息
    User getUserByUsername(String username);

    //验证登录1
    User checkLogin(String username,String password);

    //验证登录2(参数为map)
    User checkLoginByMap(Map<String,Object> map);

    //添加用户信息
    int insertUser(User user);

    //验证登录(@param)
    User checkLoginByParam(@Param("username") String username,@Param("password") String password);
}

<?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">
<mapper namespace="com.mybatis.mapper.ParameterMapper">

    <!--List<User> getAllUser();-->
    <select id="getAllUser" resultType="User">
        select * from t_user
    </select>

    <!--User GetUserByUsername(String username);-->
    <!--select * from t_user where username = '${username}'-->
    <select id="getUserByUsername">
        select * from t_user where username = #{username}
    </select>

    <!--User checkLogin(String username,String password);-->
    <select id="checkLogin" resultType="User">
        <!--多个参数的时候，用arg0,arg1...或者param1,param2...-->
        <!--select * from t_user where username=#{arg0} and password=#{arg1}-->
        select * from t_user where username='${param1}' and password='${param2}'
    </select>

    <!--User checkLoginByMap(Map<String,Object> map);-->
    <select id="checkLoginByMap" resultType="User">
        select * from t_user where username='${username}' and password='${password}'
    </select>

    <!--int insertUser(User user);-->
    <insert id="insertUser">
        insert into t_user values(null,#{username},#{password},#{age},#{sex},#{email})
    </insert>

    <!--User checkLoginByParam(@Param("username") String username,@Param("password") String password);-->
    <select id="checkLoginByParam" resultType="User">
        select * from t_user where username=#{username} and password=#{password}
    </select>

</mapper>