mybatis中$和#的区别

Mybatis中$和#的区别

区别一:

如果要动态生成sql语句;

​ ${}里面只能填value这个值 ;

​ #{}里面着任何字符都可以 ;

区别二:

​ ${}预编译后回会用字符串拼接的方式生成完整的sql语句 ;

例如:
<select id="queryByUsername" parameterType="string" resultType="User">
        select * from user where username like '%${value}%'
</select>

传参:
List<User> list = userMapper.queryByUsername("张");

log4j打印生成的sql语句为:
Preparing: select * from user where username like '%张%' 
Parameters:

注意:使用 '%${value}%' 模糊查询的时候要加上'',否则生成的sql就会是这样:
select * from user where username like %张%   ------>sql语法错误;

​

#{}预编译后会变成?占位符,以传参数的方式处理sql语句:

例如:
<select id="queryById" parameterType="string" resultType="user">
        select * from user where id = #{value}
</select>

传参:
User user = userMapper.queryById(1);

log4j打印生成的sql语句为:
Preparing: select * from user where id = ? 
Parameters: 1(Integer)


JDBC回顾:

//获取连接
Connection con = JDBCTools.getConnection();
//准备sql语句
String sql = "select * from user where id = ? ";
PreparedStatement ps = con.prepareStatement(sql);
//调用PreparedStatement的setXXX(int index, Object obj);
ps.setString(1, "1");
//执行sql
ps.executeQuery();