以下是数据层的方法:
@Override
public List<Integer> countTrainDemandPublish(String queryFromTime, String queryToTime) {
StringBuffer sbHql = new StringBuffer();
List<Integer> aList = null;
Query query = null;
sbHql.append("select count(t1.ifProductKnowhow), ");
sbHql.append("count(t1.ifSellingSkills), ");
sbHql.append("count(t1.ifMindestConstruction), ");
sbHql.append("count(t1.ifCustomerDevelopment), ");
sbHql.append("count(t1.ifContractOfKnowledge), ");
sbHql.append("count(t1.ifMeaningUsageInsurance), ");
sbHql.append("count(t1.ifOthers) ");
sbHql.append("from CourseDemandPublish t1");
sbHql.append(" where 1=1");
SimpleDateFormat df1 = new SimpleDateFormat("yyyy-MM-dd");
if (queryFromTime!=null && !"".equals(queryFromTime.trim()) && queryToTime!=null && !"".equals(queryToTime.trim())) {
sbHql.append(" and (t1.updateDate >=:sortDate ");
sbHql.append(" or t1.updateDate <=:sortEndDate) ");
query = getSession().createQuery(sbHql.toString());
try {
java.util.Date date1 = df1.parse( queryFromTime );
java.util.Date date2 = df1.parse( queryToTime );
query.setParameter("sortDate", date1);
query.setParameter("sortEndDate", date2);
System.out.println(date1);
} catch (ParseException e) {
e.printStackTrace();
}
aList = (ArrayList<Integer>) query.list();
}else if(queryFromTime!=null && !"".equals(queryFromTime.trim())){
sbHql.append(" and t1.updateDate >=:sortDate ");
query = getSession().createQuery(sbHql.toString());
try {
java.util.Date date1 = df1.parse( queryFromTime );
query.setParameter("sortDate", date1);
System.out.println(date1);
} catch (ParseException e) {
e.printStackTrace();
}
aList = (ArrayList<Integer>) query.list();
}else if(queryToTime!=null && !"".equals(queryToTime.trim())){
sbHql.append(" and t1.updateDate <=:sortEndDate ");
query = getSession().createQuery(sbHql.toString());
try {
java.util.Date date1 = df1.parse( queryToTime + "23:59:59" );
query.setParameter("sortEndDate", date1);
System.out.println(date1);
} catch (ParseException e) {
e.printStackTrace();
}
aList = (ArrayList<Integer>) query.list();
}
else{
query = getSession().createQuery(sbHql.toString());
aList = (ArrayList<Integer>) query.list();
}
return aList;
}
下面将取出数据:
//结果列表
List<Integer> aList = trainDemandGatherSev.countTrainDemandPublish(
queryFromTime,
queryToTime);
Object[] tObject = null ;
for(Object obj1:aList){
tObject = (Object[])obj1;
}
for (int i=0 ; i < tObject.length ; i++){
Integer tInteger = Integer.parseInt(tObject[i].toString()) ;
}