StringBuilder querySQL = new StringBuilder(
"select S.IL_ID,S.DI_ID,Y.DI_MC,S.IL_SJ,");
querySQL.append("S.IL_WJM,S.IL_JLS,S.IL_CGSBBJ,S.IL_SBYY FROM S_IMPORT_LOG S LEFT JOIN Y_DATA_INFO Y ON S.DI_ID=Y.DI_ID");
querySQL.append(" WHERE 1=1");
if(vo!=null){
if(vo.getJksj()!=null){
querySQL.append(" AND S.DI_ID=?");
queryParams.add(vo.getJksj());
}
if(vo.getWjm()!=null&&"".equals(vo.getWjm())){
querySQL.append(" AND S.IL_WJM LIKE \'?");
queryParams.add("%" + vo.getWjm().trim() + "%");
querySQL.append("\'");
}
错误写法:把单引号分开追加。会报错,提示占位符对不上
正确写法:
querySQL.append(" AND S.IL_WJM LIKE ?");
queryParams.add("\'%" + vo.getWjm().trim() + "%\'");
"select S.IL_ID,S.DI_ID,Y.DI_MC,S.IL_SJ,");
querySQL.append("S.IL_WJM,S.IL_JLS,S.IL_CGSBBJ,S.IL_SBYY FROM S_IMPORT_LOG S LEFT JOIN Y_DATA_INFO Y ON S.DI_ID=Y.DI_ID");
querySQL.append(" WHERE 1=1");
if(vo!=null){
if(vo.getJksj()!=null){
querySQL.append(" AND S.DI_ID=?");
queryParams.add(vo.getJksj());
}
if(vo.getWjm()!=null&&"".equals(vo.getWjm())){
querySQL.append(" AND S.IL_WJM LIKE \'?");
queryParams.add("%" + vo.getWjm().trim() + "%");
querySQL.append("\'");
}
错误写法:把单引号分开追加。会报错,提示占位符对不上
正确写法:
querySQL.append(" AND S.IL_WJM LIKE ?");
queryParams.add("\'%" + vo.getWjm().trim() + "%\'");