粘贴主要代码出来供大家参考下。
StringBuffer sqlBuffer = new StringBuffer(); sqlBuffer.append("select * from ZHAOBIAO_SHENQING_HUIYISHI h where h.submituserid = '" + paramMap.get("id") + "'"); if(null!=paramMap.get("beginDate")&&!paramMap.get("beginDate").isEmpty()){ sqlBuffer.append(" and h.submitdate > to_date('" + paramMap.get("beginDate")+ "','yyyy-MM-dd')"); } if(null!= paramMap.get("endDate")&&!paramMap.get("endDate").isEmpty()){ sqlBuffer.append(" and h.submitdate < to_date('" + paramMap.get("endDate")+ "','yyyy-MM-dd')"); }