StringBuffer sql = new StringBuffer("select count(*) cnt from "
+ _z.getTARGET_TABLENAME() + " " + " where " +_z.getTARGET_WHERESQL().replaceAll(
"\\{MAXDATE\\}", maxdate)+ " and exists(select * from "
+ _z.getSOURCE_TABLENAME() + " where "+_z.getSOURCE_WHERESQL().replaceAll(
"\\{MAXDATE\\}", maxdate) + " and " + _z.getSORKEYID()
+ "=" + _z.getTARGET_TABLENAME() + "." + _z.getTARKEYID()
+ ")");
replaceAll("\\{MAXDATE\\}", maxdate) 这样去拼接替换可以吗?
+ _z.getTARGET_TABLENAME() + " " + " where " +_z.getTARGET_WHERESQL().replaceAll(
"\\{MAXDATE\\}", maxdate)+ " and exists(select * from "
+ _z.getSOURCE_TABLENAME() + " where "+_z.getSOURCE_WHERESQL().replaceAll(
"\\{MAXDATE\\}", maxdate) + " and " + _z.getSORKEYID()
+ "=" + _z.getTARGET_TABLENAME() + "." + _z.getTARKEYID()
+ ")");
replaceAll("\\{MAXDATE\\}", maxdate) 这样去拼接替换可以吗?
建议使用preparedStatement