2、后台:GongchengchaxunForm myform = (GongchengchaxunForm) form;// TODO Auto-generated method stub
// 招标方式
String gongkai = myform.getGongkai();
String yaoqing = myform.getYaoqing();
String zhijie = myform.getZhijie();
String erci = myform.getErci();
// 时间性质
String shijianfangshi = myform.getShijianfangshi();
// 具体时间
String begin = myform.getBegin();
String end = myform.getEnd();
// 工程类别
String fangwu = myform.getFangwu();
String shizheng = myform.getShizheng();
String yuanlin = myform.getYuanlin();
String zhuangshi = myform.getZhuangshi();
String jianshe = myform.getJianshe();
String jidian = myform.getJidian();
String caigou = myform.getCaigou();
String qita = myform.getQita();
System.out.println(shijianfangshi);
System.out.println(gongkai+" "+yaoqing+" "+zhijie+" "+erci+" "+shijianfangshi);
System.out.println(fangwu+" "+shizheng+" "+yuanlin+" "+zhuangshi+" "+jianshe);
System.out.println();
boolean kong1 = true;
boolean kong2 = true;
StringBuilder sql ;
// /登记时间
if(shijianfangshi.equals("dengji")){
sql = new StringBuilder();
if(gongkai!= null){////公开招标
sql.append(" select id,gcbh,gcmc,zbxs,xmlx,tjrq from gongchengxinxi where (");
kong2 = false;
//工程类别
if(fangwu != null){
sql.append(" xmlx = '"+fangwu+"'");
kong1 = false;
}
if(shizheng != null){
if(kong1==false){
sql.append(" or xmlx = '"+shizheng+"'");
}else{
sql.append(" xmlx = '"+shizheng+"'");
}
kong1 = false;
}
if(yuanlin != null){
if(kong1==false){
sql.append(" or xmlx = '"+yuanlin+"'");
}else{
sql.append(" xmlx = '"+yuanlin+"'");
}
kong1 = false;
}
if(zhuangshi != null){
if(kong1==false){
sql.append(" or xmlx = '"+zhuangshi+"'");
}else{
sql.append(" xmlx = '"+zhuangshi+"'");
}
kong1 = false;
}
if(jianshe != null){
if(kong1==false){
sql.append(" or xmlx = '"+jianshe+"'");
}else{
sql.append(" xmlx = '"+jianshe+"'");
}
kong1 = false;
}
if(jidian != null){
if(kong1==false){
sql.append(" or xmlx = '"+jidian+"'");
}else{
sql.append(" xmlx = '"+jidian+"'");
}
kong1 = false;
}
if(caigou != null){
if(kong1==false){
sql.append(" or xmlx = '"+caigou+"'");
}else{
sql.append(" xmlx = '"+caigou+"'");
}
kong1 = false;
}
if(qita != null){
if(kong1==false){
sql.append(" or xmlx = '"+qita+"'");
}else{
sql.append(" xmlx = '"+qita+"'");
}
}
//时间范围
if(begin != null){
sql.append(" and tjrq > '"+begin+"'");
}
if(end != null){
sql.append(" and tjrq <= '"+end+"'");
}
kong1 = true;
sql.append(")");
}
//结束公开招标
if(yaoqing != null){///邀请招标
if(kong2 = false){
sql.append(" union select id,gcbh,gcmc,zbxs,xmlx,tjrq from yaoqingzhaobiao where(");
}else{
sql.append(" select id,gcbh,gcmc,zbxs,xmlx,tjrq from yaoqingzhaobiao where(");
}
if(fangwu != null){
sql.append(" xmlx = '"+fangwu+"'");
kong1 = false;
}
if(shizheng != null){
if(kong1==false){
sql.append(" or xmlx = '"+shizheng+"'");
}else{
sql.append(" xmlx = '"+shizheng+"'");
}
kong1 = false;
}
if(yuanlin != null){
if(kong1==false){
sql.append(" or xmlx = '"+yuanlin+"'");
}else{
sql.append(" xmlx = '"+yuanlin+"'");
}
kong1 = false;
}
if(zhuangshi != null){
if(kong1==false){
sql.append(" or xmlx = '"+zhuangshi+"'");
}else{
sql.append(" xmlx = '"+zhuangshi+"'");
}
kong1 = false;
}
if(jianshe != null){
if(kong1==false){
sql.append(" or xmlx = '"+jianshe+"'");
}else{
sql.append(" xmlx = '"+jianshe+"'");
}
kong1 = false;
}
if(jidian != null){
if(kong1==false){
sql.append(" or xmlx = '"+jidian+"'");
}else{
sql.append(" xmlx = '"+jidian+"'");
}
kong1 = false;
}
if(caigou != null){
if(kong1==false){
sql.append(" or xmlx = '"+caigou+"'");
}else{
sql.append(" xmlx = '"+caigou+"'");
}
kong1 = false;
}
。。。。。。。。。。。。。。。。。
[该贴被jiyanliang于2007年08月30日 19:26修改过]