if判断提交到后台的checkbox动态实现sql语句条件

虽然方法很笨，但还是记下来，万一以后忘了

insert语句的字段与值都为动态，此处为5个checkbox，后边还有个select的

public boolean isInsertKK_BlacklistVehicleRegister(
   String kK_BlacklistVehicleRegister_LRDW_Input,
   String kK_BlacklistVehicleRegister_CZY_Input,
   String kK_BlacklistVehicleRegister_LRSJ_Input,
   String kK_BlacklistVehicleRegister_YXQ_Input,
   String kK_BlacklistVehicleRegister_WFXZ_Input,
   String kk_BlacklistVehicleRegister_CheckBox1,
   String kk_BlacklistVehicleRegister_CheckBox2,
   String kk_BlacklistVehicleRegister_CheckBox3,
   String kk_BlacklistVehicleRegister_CheckBox4,
   String kk_BlacklistVehicleRegister_CheckBox5
  ) 
 {
  boolean flag = false ;

  // 声明一个SQL变量，用于保存SQL语句
  String sql = null ;
  String LRDW = null ;
  String CZY = null ;
  String LRSJ = null ;
  String YXQ = null ;
  String WFXZ = null ;
  
  String lrdw = null ;
  String czy = null ;
  String lrsj = null ;
  String yxq = null ;
  String wfxz = null ;
  
  if(kk_BlacklistVehicleRegister_CheckBox1!=null)
  {
   if(kk_BlacklistVehicleRegister_CheckBox2!=null||kk_BlacklistVehicleRegister_CheckBox3!=null||kk_BlacklistVehicleRegister_CheckBox4!=null||kk_BlacklistVehicleRegister_CheckBox5!=null)
   {
    //此内部嵌套if作用为判断后边还有没有被选中的checkbox，有则在变量后加逗号，没有则不加，表示为最后的一个变量，此处为value内值，
    LRDW = "'"+kK_BlacklistVehicleRegister_LRDW_Input+"'," ;
   }
   else
   {
    LRDW = "'"+kK_BlacklistVehicleRegister_LRDW_Input+"'" ;
   }
   
   if(kk_BlacklistVehicleRegister_CheckBox2!=null||kk_BlacklistVehicleRegister_CheckBox3!=null||kk_BlacklistVehicleRegister_CheckBox4!=null||kk_BlacklistVehicleRegister_CheckBox5!=null)
   {
    //同上，此内部嵌套if作用为判断后边还有没有被选中的checkbox，有则在变量后加逗号，没有则不加，表示为最后的一个变量，此处为数据库字段名
    lrdw = "lrdw," ;
   }
   else
   {
    lrdw = "lrdw" ;
   }
  }
  else
  {
   LRDW = "" ;
   lrdw = "" ;
  }
  if(kk_BlacklistVehicleRegister_CheckBox2!=null)
  {
   if(kk_BlacklistVehicleRegister_CheckBox3!=null||kk_BlacklistVehicleRegister_CheckBox4!=null||kk_BlacklistVehicleRegister_CheckBox5!=null)
   {
    CZY = "'"+kK_BlacklistVehicleRegister_CZY_Input+"'," ;
   }
   else
   {
    CZY = "'"+kK_BlacklistVehicleRegister_CZY_Input+"'" ;
   }
   
   if(kk_BlacklistVehicleRegister_CheckBox3!=null||kk_BlacklistVehicleRegister_CheckBox4!=null||kk_BlacklistVehicleRegister_CheckBox5!=null)
   {
    czy = "czy," ;
   }
   else
   {
    czy = "czy" ;
   }
  }
  else
  {
   CZY = "" ;
   czy = "" ;
  }
  if(kk_BlacklistVehicleRegister_CheckBox3!=null)
  {
   if(kk_BlacklistVehicleRegister_CheckBox4!=null||kk_BlacklistVehicleRegister_CheckBox5!=null)
   {
    LRSJ = "to_date('"+kK_BlacklistVehicleRegister_LRSJ_Input+"','YYYY-MM-DD HH24:MI:SS')," ;
   }
   else
   {
    LRSJ = "to_date('"+kK_BlacklistVehicleRegister_LRSJ_Input+"','YYYY-MM-DD HH24:MI:SS')" ;
   }
   
   if(kk_BlacklistVehicleRegister_CheckBox4!=null||kk_BlacklistVehicleRegister_CheckBox5!=null)
   {
    lrsj = "lrsj," ;
   }
   else
   {
    lrsj = "lrsj" ;
   }
  }
  else
  {
   LRSJ = "" ;
   lrsj = "" ;
  }
  if(kk_BlacklistVehicleRegister_CheckBox4!=null)
  {
   if(kk_BlacklistVehicleRegister_CheckBox5!=null)
   {
    YXQ = "to_date('"+kK_BlacklistVehicleRegister_YXQ_Input+"','YYYY-MM-DD HH24:MI:SS')," ;
   }
   else
   {
    YXQ = "to_date('"+kK_BlacklistVehicleRegister_YXQ_Input+"','YYYY-MM-DD HH24:MI:SS')" ;
   }
   
   if(kk_BlacklistVehicleRegister_CheckBox5!=null)
   {
    yxq = "yxq," ;
   }
   else
   {
    yxq = "yxq" ;
   }
  }
  else
  {
   YXQ = "" ;
   yxq = "" ;
  }
  if(kk_BlacklistVehicleRegister_CheckBox5!=null)
  {
   WFXZ = "'"+kK_BlacklistVehicleRegister_WFXZ_Input+"'" ;
   wfxz = "wfxz" ;
  }
  else
  {
   WFXZ = "" ;
   wfxz = "" ;
  }
  
  // 编写SQL语句
  
  sql = "insert into kk.kkhmdlr("+lrdw+""+czy+""+lrsj+""+yxq+""+wfxz+") values("+LRDW+""+CZY+""+LRSJ+""+YXQ+""+WFXZ+") ";

select语句的字段与值都为动态，此处为5个checkbox

public List findAll(
   String kK_BlacklistVehicleRegister_LRDW_Input,
   String kK_BlacklistVehicleRegister_CZY_Input,
   String kK_BlacklistVehicleRegister_LRSJ_Input,
   String kK_BlacklistVehicleRegister_YXQ_Input,
   String kK_BlacklistVehicleRegister_WFXZ_Input,
   String kk_BlacklistVehicleRegister_CheckBox1,
   String kk_BlacklistVehicleRegister_CheckBox2,
   String kk_BlacklistVehicleRegister_CheckBox3,
   String kk_BlacklistVehicleRegister_CheckBox4,
   String kk_BlacklistVehicleRegister_CheckBox5 
 )
 {
  String sql = null ;
  String LRDW = null ;
  String CZY = null ;
  String LRSJ = null ;
  String YXQ = null ;
  String WFXZ = null ;
  
  String lrdw = null ;
  String czy = null ;
  String lrsj = null ;
  String yxq = null ;
  String wfxz = null ;
  
  if(kk_BlacklistVehicleRegister_CheckBox1!=null)
  {
    //select的动态条件很简单，只要给一个条件加上and 字段名=变量就可以了，否则为""
   LRDW = "and lrdw="+"'"+kK_BlacklistVehicleRegister_LRDW_Input+"'" ;
  }
  else
  {
   LRDW = "" ;
  }
  if(kk_BlacklistVehicleRegister_CheckBox2!=null)
  {
   CZY = "and czy = "+"'"+kK_BlacklistVehicleRegister_CZY_Input+"'" ;
  }
  else
  {
   CZY = "" ;
  }
  if(kk_BlacklistVehicleRegister_CheckBox3!=null)
  {
   LRSJ = "and lrsj = "+"to_date('"+kK_BlacklistVehicleRegister_LRSJ_Input+"','YYYY-MM-DD HH24:MI:SS')" ;
  }
  else
  {
   LRSJ = "" ;
  }
  if(kk_BlacklistVehicleRegister_CheckBox4!=null)
  {
   YXQ = "and yxq = "+"to_date('"+kK_BlacklistVehicleRegister_YXQ_Input+"','YYYY-MM-DD HH24:MI:SS')" ;
  }
  else
  {
   YXQ = "" ;
  }
  if(kk_BlacklistVehicleRegister_CheckBox5!=null)
  {
   WFXZ = "and wfxz = "+"'"+kK_BlacklistVehicleRegister_WFXZ_Input+"'" ;
  }
  else
  {
   WFXZ = "" ;
  }
  
  List list = new ArrayList();
  ResultSet rs = null;
  DataBaseConnection dbc = new DataBaseConnection() ;
  PreparedStatement pstmt = null ;
  
  String SQL = "select * from kk.kkhmdlr where 1=1 "+LRDW+" "+CZY+" "+LRSJ+" "+YXQ+" "+WFXZ+" " ;
//where1=1是为了让排在第一个位置的变量的and起作用，如果不加1=1，直接where and 字段=变量，这样就会出语法错了

 就这样

 

黑色头发  http://heisetoufa.iteye.com

如果发现本文有误，欢迎批评指正