MyBatis框架学习-获取参数-3

1、MyBatis获取参数值的两种方式：${} 和#{}

 ${}本质字符串拼接
 #{}本质占位符赋值

(1) ${}

mapper接口方法的参数为单个的字面量类型
可以通过KaTeX parse error: Expected 'EOF', got '#' at position 4: {}和#̲{}以任意的名称获取参数值，但…{}的单引号问题

<select id="getUserByUsername"  resultType="User">
        select * from t_user where username = #{username}
    </select>

 // 根据用户名返回用户信息
    @Test
    public void testGetUserByUsername(){
   
        SqlSession sqlSession = SqlSessionUtils.getSqlSession();
        ParameterMapper mapper = sqlSession.getMapper(ParameterMapper.class);
        User user = mapper.getUserByUsername("admin");
        System.out.println(user);
    }

(2)#{}

注意手动加上单引号 ’ ’

<?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">
<!--User getUserByUsername(String username);-->
<mapper namespace