版权声明:转载原创文章请以超链接形式请注明原文章出处,尊重作者,尊重原创!
恰饭广告
前端页面:
Document//通过class类名取input的所有值
function searchCondition(className){
var str = "";
$("."+className).each(function () {
var value=$(this).val().trim().replace("'", "");
value="'"+value+"',";
str+=value;
})
return str; }
$("#btn").click(function () {
var str=searchCondition("search");
console.log(str); //传到后端的值
});
Patient实体类
public class Patient {
private String id;
private String panme;
private String page;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getPanme() {
return panme;
}
public void setPanme(String panme) {
this.panme = panme;
}
public String getPage() {
return page;
}
public void setPage(String page) {
this.page = page;
}
}
后台代码:
/**
* 替换'字符防止错位
* @param cond
* @return
*/
private String replace(String cond) {
String str="";
String[] arr = cond.split(",");
for(int i=0;i
str+="'"+arr[i].trim().replace("'", "")+"',";
}
return str;
}
/**
* where条件后的复合查询语句拼接
* @param cond
* @return
*/
public String searchWhere(String cond) {
cond=replace(cond);
String[] arr = cond.split(",");
StringBuilder where = new StringBuilder(" 1=1");
Patient patient=new Patient();
patient.setId(arr[0]);
patient.setPanme(arr[1]);
patient.setPage(arr[2]);
if(!patient.getId().equals("''")) {
where.append(" and id="+patient.getId());
}
if(!patient.getPanme().equals("''")) {
where.append(" and pname="+patient.getPanme());
}
if(!patient.getPage().equals("''")) {
where.append(" and page="+patient.getPage());
}
return where.toString();
}
输出打印:
1=1 and id='7' and page='9'
让我恰个饭吧.ヘ( ̄ω ̄ヘ)
支付宝 ——————- 微信
恰饭广告