sql无限添加查询条件
String condition = " and ";if (null != feeds.getDatetime()&& feeds.getDatetime().trim().length() > 1) {String[] date = feeds.getDatetime().split(",");SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");try {if (date.length > 1) {if (date[0].trim().length() == 0) {condition += "weight = " + sdf.parse(date[1]).getTime()/ 1000;} else if (date[1].trim().length() == 0) {condition += "weight = " + sdf.parse(date[0]).getTime()/ 1000;} else {condition += "weight in ("+ sdf.parse(date[0]).getTime() / 1000 + ","+ sdf.parse(date[1]).getTime() / 1000 + ")";}}} catch (ParseException e) {e.printStackTrace();}}if ("and".equals(condition.trim())) {condition = "";}System.out.println(condition);<inputtype="text"name="feeds.datetime"class="input"readonly="readonly"onClick="WdatePicker();"/><span class="search_title">结束时间：</span><inputtype="text"name="feeds.datetime"class="input"readonly="readonly"onClick="WdatePicker();"/>