按照图片选的条件进行搜索数据库里的内容.
例如;TEXT框的name=zpmc
多选框的name分别为:csdx,zplx,zpfg
TEXT框的name为zz,dw
数据库与其有关的表,和列的名为:student(表名),zpmc,csdx,zplx,zpfg,zz,dw(列名)
应该先判断是否为空..后再...
我的语句这样:
String sql = "SELECT * FROM ppt WHERE 1=1";
if(!zpmc.equals("")&&zpmc!=null){
sql=sql+ " OR zpmc like '%"+zpmc+"%'";
}else
if(!csdx.equals("")&&csdx!=null){
sql=sql+ " OR csdx like '%"+csdx+"%'";
}else
if(!zplx.equals("")&&zplx!=null){
sql=sql+ " OR zplx like '%"+zplx+"%'";
}else
if(!zpfg.equals("")&&zpfg!=null){
sql=sql+ " OR zpfg like '%"+zpfg+"%'";
}else
if(!zz.equals("")&&zz!=null){
sql=sql+ " OR zz like '%"+zz+"%'";
}else
if(!dw.equals("")&&dw!=null){
sql=sql+ " OR dw like '%"+dw+"%'";
}
------------------------------------------------------------
搜索出来的不符合我的意思..
String zpmc = request.getParameter("zpmc");
String csdx = request.getParameter("csdx");
String zplx = request.getParameter("zplx");
String zpfg = request.getParameter("zpfg");
String zz = request.getParameter("zz");
String dw = request.getParameter("dw");
我不懂..能给些例子我吗-_-!..麻烦了!!!