e家园项目源代码使用hibernate编写

package dao; import entity.Article; import factory.HibernateSessionFactory; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.hibernate.LockMode; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.Transaction; import org.hibernate.criterion.Example; /** * Data access object (DAO) for domain model class Article. * * @see entity.Article * @author MyEclipse Persistence Tools */ public class ArticleDAO extends BaseHibernateDAO { private static final Log log = LogFactory.getLog(ArticleDAO.class); private static final int n = 3; // property constants public static final String TITLE = "title"; public static final String TYPE = "type"; public static final String CONTENT = "content"; public static final String WRITER = "writer"; public static final String WRITE_DATE = "writeDate"; public void save(Article transientInstance) { log.debug("saving Article instance"); try { getSession().save(transientInstance); log.debug("save successful"); } catch (RuntimeException re) { log.error("save failed", re); throw re; } } public void delete(Article persistentInstance) { log.debug("deleting Article instance"); try { getSession().delete(persistentInstance); log.debug("delete successful"); } catch (RuntimeException re) { log.error("delete failed", re); throw re; } } public Article findById(java.lang.Integer id) { log.debug("getting Article instance with id: " + id); try { Article instance = (Article) getSession().get("entity.Article", id); return instance; } catch (RuntimeException re) { log.error("get failed", re); throw re; } } public List findByExample(Article instance) { log.debug("finding Article instance by example"); try { List results = getSession().createCriteria("entity.Article").add( Example.create(instance)).list(); log.debug("find by example successful, result size: " + results.size()); return results; } catch (RuntimeException re) { log.error("find by example failed", re); throw re; } } public List findByProperty(String propertyName, Object value) { log.debug("finding Article instance with property: " + propertyName + ", value: " + value); try { String queryString = "from Article as model where model." + propertyName + "= ? order by articleId desc"; Query queryObject = getSession().createQuery(queryString); queryObject.setParameter(0, value); return queryObject.list(); } catch (RuntimeException re) { log.error("find by property name failed", re); throw re; } } /* * 根据用户名和typeId查询相关资料的集合 */ public List findByTypeIdAndUserName(int typeId,String userName ) { try { String queryString = "select top "+n+" * from Article as model where model.type=? and model.writer=?"; Query queryObject = getSession().createQuery(queryString); queryObject.setParameter(0, typeId); queryObject.setParameter(1, userName); return queryObject.list(); } catch (RuntimeException re) { log.error("find by property name failed", re); throw re; } } /*public List findByTypeIdOrUserNameOrTitle(int page ,int typeId,String title,String writer) { try { String queryString = "select top "+n+" * from Article where type=? and title like ? "; Query queryObject = getSession().createQuery(queryString); queryObject.setParameter(0, typeId); queryObject.setParameter(1, "%"+title+"%"); queryObject.setParameter(2, "%"+writer+"%"); queryObject.setParameter(3, (page-1)*n); return queryObject.list(); } catch (RuntimeException re) { log.error("find by property name failed", re); throw re; } }*/ /* * 根据用户名和typeId查询相关资料的集合 */ public List findByTypeIdOrUserNameOrTitle(int page ,int typeId,String title,String writer) { System.out.println("aaa"+page+"bbb"+typeId+"ccc"+title+"ddd"+writer); List articleList=new ArrayList(); Session session=HibernateSessionFactory.getSession(); Transaction tx=session.beginTransaction(); Connection conn=null; String sql="select top "+n+" * from Article where type=? and title like ? and writer like ? " + "and articleId not in (select top "+(page-1)*n+" articleId from article " + "where type=? and title like ? and writer like ? order by articleId)"; PreparedStatement Pstmt; ResultSet rs=null; try { conn=session.connection(); Pstmt = conn.prepareStatement(sql); Pstmt.setInt(1, typeId); Pstmt.setString(2, "%"+title+"%"); Pstmt.setString(3, "%"+writer+"%"); Pstmt.setInt(4, typeId); Pstmt.setString(5, "%"+title+"%"); Pstmt.setString(6, "%"+writer+"%"); rs = Pstmt.executeQuery(); while(rs.next()){ Article article = new Article();//书对象 //设置书的信息 article.setArticleId(rs.getInt(1)); article.setTitle(rs.getString(2)); article.setType(rs.getInt(3)); article.setContent(rs.getString(4)); article.setWriter(rs.getString(5)); article.setWriteDate(rs.getString(6)); articleList.add(article); } tx.commit(); } catch (SQLException e) { if(tx!=null){ tx.rollback(); } e.printStackTrace(); }finally{ HibernateSessionFactory.closeSession(); } return articleList; } /* * 根据用户名和typeId查询相关资料的集合 */ public List findByUserNameOrTitle( int page,String title,String writer) { List articleList=new ArrayList(); Session session=HibernateSessionFactory.getSession(); Transaction tx=session.beginTransaction(); Connection conn=null; String sql="select top "+n+" * from Article where title like ? and writer like ? " + "and articleId not in (select top "+(page-1)*n+" articleId from article " + "where title like ? and writer like ? )"; PreparedStatement Pstmt; ResultSet rs=null; try { conn=session.connection(); Pstmt = conn.prepareStatement(sql); Pstmt.setString(1, "%"+title+"%"); Pstmt.setString(2, "%"+writer+"%"); Pstmt.setString(3, "%"+title+"%"); Pstmt.setString(4, "%"+writer+"%"); rs = Pstmt.executeQuery(); while(rs.next()){ Article article = new Article();//书对象 //设置书的信息 article.setArticleId(rs.getInt(1)); article.setTitle(rs.getString(2)); article.setType(rs.getInt(3)); article.setContent(rs.getString(4)); article.setWriter(rs.getString(5)); article.setWriteDate(rs.getString(6)); articleList.add(article); } tx.commit(); } catch (SQLException e) { if(tx!=null){ tx.rollback(); } e.printStackTrace(); }finally{ HibernateSessionFactory.closeSession(); } return articleList; } /*public List findByUserNameOrTitle( int page,String title,String writer) { try { String queryString = "from Article where title like ? and writer like ?"; Query queryObject = getSession().createQuery(queryString); queryObject.setParameter(0, "%"+title+"%"); queryObject.setParameter(1, "%"+writer+"%"); return queryObject.list(); } catch (RuntimeException re) { log.error("find by property name failed", re); throw re; } }*/ //返回总页数 public int getPageCount(int page,int typeId,String title,String writer){ int pagecount = 0;//总页数 Session session=HibernateSessionFactory.getSession();