SqlManager中get(key)获取beetl中自定义的sql语句中语句拼接中空格被处理掉
在beetl中定义的语句
/* BASEADDR.LIST */
SELECT id, code, name, tenet, surver, simple, link, address, found_time, show_tag, logo
FROM cyfh_base WHERE 1=1
<%
if (!isEmpty(name)) {
print(" AND name LIKE CONCAT('%', @name, '%') ");
}
%>
ORDER BY show_tag DESC, seqno ASC, create_time DESC
获取后的语句：
SELECT id, code, name, tenet, surver, simple, link, address, found_time, show_tag, logo
FROM cyfh_base WHERE 1=1ORDER BY show_tag DESC, seqno ASC, create_time DESC
5 回复
看看有没有这个类 org.nutz.plugins.sqltpl.impl.beetl.BeetlSqlTpl
按Beetl的规则来说, 如果当前行只有beetl的代码(<%开头或者>%结尾>),那么前后的空格都会移除.
所以呢, 变通一下就, 把<%放到上一行,就能解决了
/* BASEADDR.LIST */
SELECT id, code, name, tenet, surver, simple, link, address, found_time, show_tag, logo
FROM cyfh_base WHERE 1=1 <%
if (!isEmpty(name)) {
print(" AND name LIKE CONCAT('%', @name, '%') ");
}
%>
ORDER BY show_tag DESC, seqno ASC, create_time DESC
添加回复
请先登陆