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);<input type="text" name="feeds.datetime" class="input" readonly="readonly" onClick="WdatePicker();" /> <span class="search_title">结束时间：</span> <input type="text" name="feeds.datetime" class="input" readonly="readonly" onClick="WdatePicker();" />