ParameterRow pr = new ParameterRow();//com.borland.dx.dataset.ParameterRowsql.append(" where 1=1 "); if (!utilString.isNullOrEmpty(evt.getCaseId())) { sql.append(" and a.case_id like :caseId"); pr.setString("caseId", evt.getCaseId()+ "%"); } if (!utilString.isNullOrEmpty(evt.getPolNO())) { sql.append(" and a.polno like :polNO"); pr.setString("polNO", evt.getPolNO()+ "%"); } if (!utilString.isNullOrEmpty(evt.getClaimStat())) { sql.append(" and a.claim_stat=:claimStat"); pr.setString("claimStat", evt.getClaimStat()); }
上面不太完整,这个完整一些。Column caseId = new Column("caseId", "caseId", com.borland.dx.dataset.Variant.STRING);//com.borland.dx.dataset.Column Column polNO = new Column("polNO", "polNO", com.borland.dx.dataset.Variant.STRING); Column claimStat = new Column("claimStat", "claimStat", com.borland.dx.dataset.Variant.STRING); ParameterRow pr = new ParameterRow();//com.borland.dx.dataset.ParameterRow pr.setColumns(new Column[] { caseId, polNO, claimStat }); sql.append(" where 1=1 "); if (!utilString.isNullOrEmpty(evt.getCaseId())) { sql.append(" and a.case_id like :caseId"); pr.setString("caseId", evt.getCaseId()+ "%"); } if (!utilString.isNullOrEmpty(evt.getPolNO())) { sql.append(" and a.polno like :polNO"); pr.setString("polNO", evt.getPolNO()+ "%"); } if (!utilString.isNullOrEmpty(evt.getClaimStat())) { sql.append(" and a.claim_stat=:claimStat"); pr.setString("claimStat", evt.getClaimStat()); }
ParameterRow pr = new ParameterRow();//com.borland.dx.dataset.ParameterRowsql.append(" where 1=1 ");
if (!utilString.isNullOrEmpty(evt.getCaseId())) {
sql.append(" and a.case_id like :caseId");
pr.setString("caseId", evt.getCaseId()+ "%");
}
if (!utilString.isNullOrEmpty(evt.getPolNO())) {
sql.append(" and a.polno like :polNO");
pr.setString("polNO", evt.getPolNO()+ "%");
}
if (!utilString.isNullOrEmpty(evt.getClaimStat())) {
sql.append(" and a.claim_stat=:claimStat");
pr.setString("claimStat", evt.getClaimStat());
}
Column polNO = new Column("polNO", "polNO", com.borland.dx.dataset.Variant.STRING);
Column claimStat =
new Column("claimStat", "claimStat", com.borland.dx.dataset.Variant.STRING);
ParameterRow pr = new ParameterRow();//com.borland.dx.dataset.ParameterRow
pr.setColumns(new Column[] { caseId, polNO, claimStat });
sql.append(" where 1=1 ");
if (!utilString.isNullOrEmpty(evt.getCaseId())) {
sql.append(" and a.case_id like :caseId");
pr.setString("caseId", evt.getCaseId()+ "%");
}
if (!utilString.isNullOrEmpty(evt.getPolNO())) {
sql.append(" and a.polno like :polNO");
pr.setString("polNO", evt.getPolNO()+ "%");
}
if (!utilString.isNullOrEmpty(evt.getClaimStat())) {
sql.append(" and a.claim_stat=:claimStat");
pr.setString("claimStat", evt.getClaimStat());
}