遇到了一個(gè)很棘手的問(wèn)題，Hibernate查詢(xún)時(shí)，附帶查詢(xún)條件，下面是使用到的查詢(xún)語(yǔ)句：select a.AURE_INVEST,c.ENGI_COST,c.EQUI_COST,c.DEMO_COST,c.TWOCL_COST,c.NOTE_COST,c.INTEREST_COST,sum(cast(c.FUNDS_PAID as float)) as sumGovPay,sum(cast(e.FUNDS_IN as float)) as lastMonthArrive,sum(cast(c.FUNDS_PAID as float)) as lastMonthPay,f.QUARTER1_BUDGET,f.QUARTER2_BUDGET,f.QUARTER3_BUDGET,f.QUARTER4_BUDGET,sum(cast(c.FUNDS_PAID as float)) as thisQuarterPay,f.ID,f.PROJ_CODE,b.PROJ_TYPE,b.PROJ_NAME,b.PROJ_SORT,b.PROJ_STAT,b.P_RECORD_TIME from GOV_CODE a,PROJ_CODE b,PROJ_FUNDS_PAID c,PROJ_FUNDS_SOURCE e,PROJ_YEAR_BUDGET f where e.DATA_YEAR<'"+year+"' and e.DATA_MONTH<'"+month+"' and c.DATA_DATE<"+DataParser.formatStringDate(newDate)+" and f.DATA_YEAR='"+year+"' and c.DATA_DATE>="+DataParser.formatStringDate(year+"-"+"10-01 00:00:00")+" and c.DATA_DATE<="+DataParser.formatStringDate(year+"-"+"12-31 00:00:00")+" and a.GOV_CODE=b.GOV_CODE and c.PROJ_CODE=b.PROJ_CODE and f.PROJ_CODE=b.PROJ_CODE and e.PROJ_CODE=b.PROJ_CODE group by a.AURE_INVEST,c.ENGI_COST,c.EQUI_COST,c.DEMO_COST,c.TWOCL_COST,c.NOTE_COST,c.INTEREST_COST,
f.QUARTER1_BUDGET,f.QUARTER2_BUDGET,f.QUARTER3_BUDGET,f.QUARTER4_BUDGET,f.ID,f.PROJ_CODE,b.PROJ_TYPE,
b.PROJ_NAME,b.PROJ_SORT,b.PROJ_STAT,b.P_RECORD_TIME
其中DATA_YEAR和DATA_MONTH在數(shù)據(jù)庫(kù)中的存儲(chǔ)類(lèi)型是String型， DATA_DATE存儲(chǔ)的類(lèi)型是Date型，使用到的DataParser.formatStringDate方法如下：
public static Date formatStringDate(String sDate)
{
DateFormat df = new SimpleDateFormat("yyyy-MM-dd 00:00:00");
Date tDate = null;
try {
tDate = df.parse(sDate);
} catch (ParseException e) {
e.printStackTrace();
}
return tDate;
}
但是無(wú)論如何都是出不來(lái)結(jié)果，報(bào)的是一個(gè)Not all named parameters have been set: [00:00]的錯(cuò)誤，格式化出來(lái)的時(shí)間也不是想要的類(lèi)型，而是這個(gè)衰樣：Sat Nov 01 00:00:00 CST 2008，與我想要的“yyyy-MM-dd hh:mm:ss”相去甚遠(yuǎn)，不知道該怎么格式化一下，麻煩那位高手指點(diǎn)一下，感激不盡！