[Java知识库]spring项目中sql语句：#｛｝与￥｛｝的使用

首先要了解两者区别：

select * from user where name = #{name}被解析为select * from user where name = ?

可以看到#｛｝是作为一个参数占位符被使用。

而￥｛｝则是直接字符拼接：

select * from user where name = ${name};

当我们传递参数“sprite”时，sql会解析为：select * from user where name = "sprite";

下面有两个实例：

@Select("SELECT segment.id,segment.`length`,segment.`start_number`,segment.`end_number`
,spot_all1.`name`AS s_name,spot_all2.`name` AS e_name FROM ${bus_name},segment,
spot_all1,spot_all2 \n" +
        "        WHERE segment.`start_number`=spot_all1.`spot_number` AND segment.`end_number`=spot_all2.`spot_number` AND ${bus_name}.`seg_id`=segment.`id` GROUP BY ${bus_name}.`seg_id`")
//以上是sql语句

    List<Bus_reTm_info> bus_reTm_info(@Param("bus_name") String bus_name);

用完记得感谢蔡哥！

该文章借鉴与：Mybatis 将table表名作为参数传入操作 / 张生荣

?