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();