你是指动根据条件动态生成SQL语句吧,这个网上叫SQL模板。如:
StringBuffer SqlBase = new StringBuffer("select * from table");
String courseNo = request.getParameter("courseNo");
......
//然后
void addCondition(StringBuffer sb,String colName,String val) {
if(val != null && !val.equals("") {
if(sb.indexOf("where") == -1) {
sb.append(" where " + colName + "=" + val);
} else {
sb.append(" and " + colName + "=" + val);
}
}
}
温馨提示:答案为网友推荐,仅供参考