package com.minma;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
public class DAOHelper {
private static SessionFactory sessionFactory;
private static Log log = LogFactory.getLog(DAOHelper.class);
public static SessionFactory getSessionFactory() {
if(sessionFactory == null) {
Configuration cfg = new Configuration();
cfg.configure();
log.info("Create Configuration instance...");
sessionFactory = cfg.buildSessionFactory();
log.info("Build SessionFactory instance...");
}
return sessionFactory;
}
public static void closeSession(Session hSession) {
try{
if(hSession != null){
hSession.close();
}
}catch(HibernateException he){
//Ignore Excpeption
}
}
}
package com.minma.skin.dao;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import com.minma.dao.DAOHelper;
/*author wenhao*/
public class CommonDAO {
public boolean update(String operate,Object object){
Session session = null;
Transaction trx = null;
boolean success=false;
try {
SessionFactory sessionFactory = DAOHelper.getSessionFactory();
session = sessionFactory.openSession();
trx = session.beginTransaction();
if (operate.equals("save")){
session.save(object);
}else if(operate.equals("delete")){
session.delete(object);
}else if(operate.equals("update")){
session.update(object);
}
success=true;
trx.commit();
}catch(Exception e){
if(trx!=null)trx.rollback();
success=false;
e.printStackTrace();
}finally{
DAOHelper.closeSession(session);
}
return success;
}
public Object uniqueQuery(String hql){
SessionFactory sessionFactory = DAOHelper.getSessionFactory();
Session session = sessionFactory.openSession();
Transaction tx=session.beginTransaction();
Object object=null;
try{
Query query=session.createQuery(hql);
object=query.uniqueResult();
tx.commit();
}catch(Exception e){
if(tx!=null){
tx.rollback();
}
e.printStackTrace();
}finally{
session.close();
}
return object;
}
public java.util.List query(String hql){
SessionFactory sessionFactory = DAOHelper.getSessionFactory();
Session session = sessionFactory.openSession();
Transaction tx=session.beginTransaction();
java.util.List list=null;
try{
Query query=session.createQuery(hql);
list=query.list();
tx.commit();
}catch(Exception e){
if(tx!=null){
tx.rollback();
}
e.printStackTrace();
}finally{
session.close();
}
return list;
}
public java.util.List queryHQL(String hql,int size){
SessionFactory sessionFactory = DAOHelper.getSessionFactory();
Session session = sessionFactory.openSession();
Transaction tx=session.beginTransaction();
java.util.List list=null;
try{
Query query=session.createQuery(hql);
query.setMaxResults(size);
list=query.list();
tx.commit();
}catch(Exception e){
if(tx!=null){
tx.rollback();
}
e.printStackTrace();
}finally{
session.close();
}
return list;
}
public boolean delete(String hql){
boolean success=false;
SessionFactory sessionFactory = DAOHelper.getSessionFactory();
Session session = sessionFactory.openSession();
Transaction tx=session.beginTransaction();
try{
Query query=session.createQuery(hql);
query.executeUpdate();
tx.commit();
success=true;
}catch(Exception e){
if(tx!=null){
tx.rollback();
}
success=false;
e.printStackTrace();
}finally{
session.close();
}
return success;
}
public java.util.List sqlQuery(String hql){
java.util.List list=new java.util.ArrayList();
SessionFactory sessionFactory = DAOHelper.getSessionFactory();
Session session = sessionFactory.openSession();
Transaction tx=session.beginTransaction();
try{
Query query=session.createSQLQuery(hql);
list=query.list();
tx.commit();
}catch(Exception e){
if(tx!=null){
tx.rollback();
}
e.printStackTrace();
}finally{
session.close();
}
return list;
}
}
分享到:
相关推荐
hibernater
本文没有提供标签信息,但根据内容可以归类为 Dreamweaver、MySQL、JSP、数据库连接等。 部分内容解读 1. 驱动程序的安装 在使用 Dreamweaver 连接 MySQL 数据库之前,需要安装驱动程序。在 lib 文件夹下只保留一...
springdm整合hibernaterspringdm整合hibernaterspringdm整合hibernaterspringdm整合hibernaterspringdm整合hibernaterspringdm整合hibernaterspringdm整合hibernaterspringdm整合hibernater
Hibernater的jar包,需要的自己下!
hibernater配置proxool!!
struts2+spring +hibernater 整合一个简单的登录系统
Spirng-Structs-Hibernater框架所有要用的包 commons-logging-1.0.4.jar ejb3-persistence.jar jta-1.1.jar 等等
springMVC+Hibernater整合及测试(亲测可运行)所需jar包,包含文件上传,json转换等,亲测正常运行,无问题。
hibernater3jar包全
HIBERNATER 学习资料
spring dwr hibernater ibatis教程
hibernater教学文档 hibernater hibernater初学指南 对象持久化层
spring+springmvc+hibernater框架架包,详细的项目结构会晚点上传
spring+hibernater+struts权限管理, spring+hibernater+struts权限管理
很好的学习hibernater的源代码资料
spring4mvc hibernater4(全注释)
ssh集合文档struts,spring,hibernater集合文档
struts2+Hibernater+spring整合之插入数据
spring2.54+struts2+hibernater3.1