欧美天天综合网,中文字幕日韩在线,91免费在线播放

Hibernate　DAO 類

package org.huy.fram.hibernate;

import java.io.Serializable;

import java.math.BigDecimal;

import java.util.List;

import org.hibernate.Query;

import org.hibernate.Session;

/**

*

* Title:[Hibernate Data Access Object Support]

*

*

* Description: [操作數(shù)據(jù)庫支持類,其它DAO可能繼承該類]

*

*

*

*

*

* @version 1.0

*

* Created by [Huyvanpull] [Jun 26, 2009]

*

*

* Midified by [修改人] [修改時間]

*

public class HibDAOSupport

{

/** DAO的操作po的類型 */

private Class<?> claz = null;

/** 構(gòu)造方法,且只應(yīng)提供此種構(gòu)造方法 */

public HibDAOSupport(Class<?> claz)

{

this.claz = claz;

}

/**

*

* Description:[加載對象,返回代理實例]

*

*

* Created by [Huyvanpull] [Jun 26, 2009]

*

*

* Midified by [修改人] [修改時間]

*

* @param id

* @return

public Object load(Serializable id)

{

Object entity = null;

try

{

Session session = HibernateSessionFactory.getSession();

entity = session.load(this.claz, id);

}

catch (RuntimeException re)

{

throw re;

}

return entity;

}

/**

*

* Description:[得到對象,返回實體類]

*

*

* Created by [Huyvanpull] [Jun 26, 2009]

*

*

* Midified by [修改人] [修改時間]

*

* @param id

* @return

public Object get(Serializable id)

{

Object entity = null;

try

{

Session session = HibernateSessionFactory.getSession();

entity = session.get(this.claz, id);

}

catch (RuntimeException re)

{

throw re;

}

return entity;

}

/**

*

* Description:[把實例保存到數(shù)據(jù)庫]

*

*

* Created by [Huyvanpull] [Jun 26, 2009]

*

*

* Midified by [修改人] [修改時間]

*

* @param entity

* @return

public Object save(Object entity)

{

try

{

/** 如果entity不是claz的實例,此處會拋出異常,下面代碼不會執(zhí)行 */

this.isInstance(entity);

Session session = HibernateSessionFactory.getSession();

session.save(entity);

}

catch (RuntimeException re)

{

throw re;

}

return entity;

}

/**

*

* Description:[把實例保存到數(shù)據(jù)庫]

*

*

* Created by [Huyvanpull] [Jun 26, 2009]

*

*

* Midified by [修改人] [修改時間]

*

* @param entity

* @return

public Object update(Object entity)

{

try

{

/** 如果entity不是claz的實例,此處會拋出異常,下面代碼不會執(zhí)行 */

this.isInstance(entity);

Session session = HibernateSessionFactory.getSession();

session.update(entity);

}

catch (RuntimeException re)

{

throw re;

}

return entity;

}

/**

*

* Description:[根據(jù)實列刪除對象]

*

*

* Created by [Huyvanpull] [Jun 26, 2009]

*

*

* Midified by [修改人] [修改時間]

*

* @param object

* @return

public Object delete(Object entity)

{

try

{

/** 如果entity不是claz的實例,此處會拋出異常,下面代碼不會執(zhí)行 */

this.isInstance(entity);

Session session = HibernateSessionFactory.getSession();

session.delete(entity);

}

catch (RuntimeException re)

{

throw re;

}

return entity;

}

/**

*

* Description:[根據(jù)id刪除對象]

*

*

* Created by [Huyvanpull] [Jun 26, 2009]

*

*

* Midified by [修改人] [修改時間]

*

* @param id

public void deleteById(Serializable id)

{

delete(load(id));

}

/**

*

* Description:[不附加條件查詢所有對象]

*

*

* Created by [Huyvanpull] [Jun 26, 2009]

*

*

* Midified by [修改人] [修改時間]

*

* @return

public List<?> findAll()

{

String hsql = "from ".concat(this.getEntityClassName());

return this.find(hsql, 0, 0);

}

/**

*

* Description:[根據(jù)hsql查詢數(shù)據(jù)]

*

*

* Created by [Huyvanpull] [Jun 30, 2009]

*

*

* Midified by [修改人] [修改時間]

*

* @param hsql

* HSQL

* @param beginIndex

* 查詢起始位置

* @param pageSize

* 每頁長度

* @return

public List<?> find(final String hsql, final int beginIndex,

final int pageSize)

{

List<?> entityLst = null;

try

{

Session session = HibernateSessionFactory.getSession();

Query query = session.createQuery(hsql);

if (beginIndex != 0)

{

query.setFirstResult(beginIndex);

}

if (pageSize != 0)

{

query.setMaxResults(pageSize);

}

entityLst = query.list();

}

catch (RuntimeException re)

{

throw re;

}

return entityLst;

}

/**

*

* Description:[根據(jù)SQL查詢數(shù)據(jù)]

*

*

* Created by [Huyvanpull] [Jun 30, 2009]

*

*

* Midified by [修改人] [修改時間]

*

* @param sql

* SQL

* @param beginIndex

* 查詢起始位置

* @param pageSize

* 每頁長度

* @return

public List<?> findBySql(final String sql, final int beginIndex,

final int pageSize)

{

List<?> entityLst = null;

try

{

Session session = HibernateSessionFactory.getSession();

Query query = session.createSQLQuery(sql);

if (beginIndex != 0)

{

query.setFirstResult(beginIndex);

}

if (pageSize != 0)

{

query.setMaxResults(pageSize);

}

entityLst = query.list();

}

catch (RuntimeException re)

{

throw re;

}

return entityLst;

}

/**

*

* Description:[根據(jù)HQL統(tǒng)計合符條件的數(shù)目]

*

*

* Created by [Huyvanpull] [Jun 26, 2009]

*

*

* Midified by [修改人] [修改時間]

*

* @param hql

* @return

public int count(final String hql)

{

int count = 0;

try

{

Session session = HibernateSessionFactory.getSession();

Query query = session.createQuery(hql);

count = ((Integer) query.uniqueResult()).intValue();

}

catch (RuntimeException re)

{

throw re;

}

return count;

}

/**

*

* Description:[根據(jù)原生SQL統(tǒng)計合符條件的數(shù)目]

*

*

* Created by [Huyvanpull] [Jun 26, 2009]

*

*

* Midified by [修改人] [修改時間]

*

* @param sql

* @return

public int countBySql(final String sql)

{

int count = 0;

try

{

Session session = HibernateSessionFactory.getSession();

Query query = session.createSQLQuery(sql);

count = ((BigDecimal) query.uniqueResult()).intValue();

}

catch (RuntimeException re)

{

throw re;

}

return count;

}

/**

*

* Description:[執(zhí)行原生SQL,返回更改的條數(shù)]

*

*

* Created by [Huyvanpull] [Jun 26, 2009]

*

*

* Midified by [修改人] [修改時間]

*

* @param sql

* @return

public int executeSQL(final String sql)

{

int updateCount = 0;

try

{

Session session = HibernateSessionFactory.getSession();

Query query = session.createSQLQuery(sql);

updateCount = query.executeUpdate();

}

catch (RuntimeException re)

{

throw re;

}

return updateCount;

}

/**

*

* Description:[如果不是claz的實例,則拋出異常]

*

*

* Created by [Huyvanpull] [Jun 26, 2009]

*

*

* Midified by [修改人] [修改時間]

*

* @param entity

private void isInstance(Object entity)

{

if (!this.claz.isInstance(entity))

{

/** 如果所傳的對象不是claz的實例,則拋出異常由上一級進行處理 */

StringBuffer exceptionInfo = new StringBuffer(512);

exceptionInfo.append("entity is not instance of ");

exceptionInfo.append(this.claz.getName());

exceptionInfo.trimToSize();

throw new RuntimeException(exceptionInfo.toString());

}

/**

*

* Description:[本方法用于得到claz的名字]

*

*

* Created by [Huyvanpull] [Jun 26, 2009]

*

*

* Midified by [修改人] [修改時間]

*

* @return

private String getEntityClassName()

{

String name = this.claz.getName();

/** 得到類名 */

return name.substring(name.lastIndexOf(".") + 1, name.length());

}

DAO繼承該類,幾乎不用寫代碼了.

posted on 2009-06-29 09:52 HUIKK 閱讀(599) 評論(0) 編輯收藏

新用戶注冊刷新評論列表


只有注冊用戶登錄后才能發(fā)表評論。




網(wǎng)站導(dǎo)航: 博客園 IT新聞 Chat2DB C++博客博問管理

夢幻之旅

公告

常用鏈接

留言簿(21)

隨筆分類(644)

隨筆檔案(669)

文章檔案(6)

最新隨筆

積分與排名

最新評論

閱讀排行榜

評論排行榜