读书人

sql无限增添查询条件

发布时间: 2012-09-24 13:49:41 作者: rapoo

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();"/>

读书人网 >SQL Server

热点推荐