package com.demo.hibernate.service;
import java.util.Iterator;
import java.util.List;
import org.hibernate.Session;
import com.demo.hibernate.utils.HibernateSessionFactory;
public class Main {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Session session = HibernateSessionFactory.getSession();
List list = session.createSQLQuery(
"SELECT T_CARD.CARD_NUM,SUM(T_CARD_EXPENSE.MONEY) "
+ "FROM T_CARD_EXPENSE,T_CARD "
+ "WHERE T_CARD_EXPENSE.CARD_ID=T_CARD.ID "
+ "AND TO_CHAR(T_CARD_EXPENSE.CREATE_DT, 'yymmdd') BETWEEN '120701' AND '120707' "
+ "GROUP BY T_CARD.CARD_NUM "
+ "ORDER BY SUM(T_CARD_EXPENSE.MONEY) DESC")
.setMaxResults(10).list();
session.close();
for (Iterator iter = list.iterator(); iter.hasNext();) {
Object[] object = (Object[]) iter.next();
System.out.println(object[0] + " " + object[1]);
}
}
}
Java代码 收藏代码
//通用List查询
@Override
public List QueryForGeneralEntity(String hql, int currentRecordIndex,
int resultMaxSize) {
// TODO Auto-generated method stub
List list=new ArrayList();
Session session=HibernateSessionFactory.getSession();
Query query=session.createQuery(hql);
query.setFirstResult(currentRecordIndex);
query.setMaxResults(resultMaxSize);
list=query.list();
session.close();
return list;
}
import java.util.Iterator;
import java.util.List;
import org.hibernate.Session;
import com.demo.hibernate.utils.HibernateSessionFactory;
public class Main {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Session session = HibernateSessionFactory.getSession();
List list = session.createSQLQuery(
"SELECT T_CARD.CARD_NUM,SUM(T_CARD_EXPENSE.MONEY) "
+ "FROM T_CARD_EXPENSE,T_CARD "
+ "WHERE T_CARD_EXPENSE.CARD_ID=T_CARD.ID "
+ "AND TO_CHAR(T_CARD_EXPENSE.CREATE_DT, 'yymmdd') BETWEEN '120701' AND '120707' "
+ "GROUP BY T_CARD.CARD_NUM "
+ "ORDER BY SUM(T_CARD_EXPENSE.MONEY) DESC")
.setMaxResults(10).list();
session.close();
for (Iterator iter = list.iterator(); iter.hasNext();) {
Object[] object = (Object[]) iter.next();
System.out.println(object[0] + " " + object[1]);
}
}
}
Java代码 收藏代码
//通用List查询
@Override
public List QueryForGeneralEntity(String hql, int currentRecordIndex,
int resultMaxSize) {
// TODO Auto-generated method stub
List list=new ArrayList();
Session session=HibernateSessionFactory.getSession();
Query query=session.createQuery(hql);
query.setFirstResult(currentRecordIndex);
query.setMaxResults(resultMaxSize);
list=query.list();
session.close();
return list;
}