关于自定义SQL中的变量赋值
发布日期:2022-11-12
|
最后更新:2026-02-17 03:08:57
|
阅读:6,349
|
状态:更新中
String sql = "SELECT * FROM CRM_USER WHERE CODE = :PARAM_CODE";
DataSet set = service.querys(sql, "PARAM_CODE:1");
//生成SQL SELECT * FROM CRM_USER WHERE CODE = 1
//特别注意这以下情况 CODE:1与SQL中的变量匹配不成功时，SQL会追加一个条件 WHERE CODE = 1
sql = "SELECT * FROM CRM_USER WHERE CODE = :PARAM_CODE";
set = service.querys(sql, "PARAM_CODE:1", "CODE:1");
//生成SQL SELECT * FROM CRM_USER WHERE CODE = 1 AND CODE = 1
