通用List查询
来源:互联网 发布:java培训班有证吗 编辑:程序博客网 时间:2024/06/07 01:44
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;
}
1 0
- 通用List查询
- JDBC查询表返回List通用方法
- 通用查询
- 通用查询
- 通用查询
- List排序通用方法
- 通用查询组件设计
- 通用SQL查询语句
- 通用查询组件设计
- MySQL通用查询程序
- 通用分页查询
- 自定义通用查询组件
- 通用分页查询
- 通用分页查询
- JDBC 关于通用查询
- SQL 通用递归查询
- jdbc通用查询实例
- JDBC通用查询
- (很容易懂) hibernate的inverse和casecade的理解——写的很透彻
- cdh5.4、cm5.4 安装详细步骤
- 【1】基于TQ2440的MP3设计——【4、U-Boot 移植与改写】
- 【Unity3d】3d角色换装实现原理及步骤
- Android HttpURLConnection.getContentLength() 等于 -1
- 通用List查询
- 2.Ionic 环境搭建(ios创建环境运行)
- Linux重新学习--shell--正则表达式
- 求一个数阶乘的位数
- 【Unity3D】3D角色换装++ Advance
- 大小端字节序
- 专访Tiny框架创始人悠然:好的软件设计是“品”出来的
- php的字符串操作与正则表达式
- 盘点国内外在线app制作平台:分分钟做款app