String toWhereSQL(String fieldName, String fieldVal, int type) {
String res = "";
switch(type) {
case adText:
if (! "".equals(fieldVal)) {
res = " " + fieldName + " like '%" + fieldVal + "%'";
}
case adNumber:
res = " " + fieldName + " = " + fieldVal + " ";
case adDate:
res = " " + fieldName + " = '" + fieldVal + "' ";
default:
res = " " + fieldName + " = '" + fieldVal + "' ";
}
return res;
}
res = " " + fieldName + " like '%" + fieldVal + "%'"; 尤其是这句谢啦
String res = "";
switch(type) {
case adText:
if (! "".equals(fieldVal)) {
res = " " + fieldName + " like '%" + fieldVal + "%'";
}
case adNumber:
res = " " + fieldName + " = " + fieldVal + " ";
case adDate:
res = " " + fieldName + " = '" + fieldVal + "' ";
default:
res = " " + fieldName + " = '" + fieldVal + "' ";
}
return res;
}
res = " " + fieldName + " like '%" + fieldVal + "%'"; 尤其是这句谢啦
select * from table where fieldname like '%fieldVal%',只要fieldname这个字段中包含fieldVal的值就符合查询条件了
对于字符串,支持模糊查询,即"%%"
建议替换成具体值再看