piecedao.java

struts+hibernate BBS mysql数据库 功能基本齐全

package com.elan.forum.dao;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;

import com.elan.db.ElHbnDB;
import com.elan.forum.model.Forumpiece;
import com.elan.forum.util.ElCheck;

public class PieceDAO {
	private static PieceDAO pieceDAO = null;
	static {
		pieceDAO = new PieceDAO();
	}
	public static PieceDAO newInstance() {
		return pieceDAO;
	}
	
	@SuppressWarnings("unchecked")
	public List<Forumpiece> getAllPieceDAO() {
		Session session = ElHbnDB.getSession();
		List<Forumpiece> list = session.createQuery("from Forumpiece").list();
		return !ElCheck.checkListIsEmpty(list) ? list : null;
	}
	
	public Forumpiece getForumPieceById(Integer pieceId) {
		System.out.println(pieceId);
		Session session = ElHbnDB.getSession();
		Query query = null; 
		try {
			query = session.createQuery("from Forumpiece where id = ?");
			query.setParameter(0, pieceId);
			return (Forumpiece)query.list().get(0);
		} catch (RuntimeException re) {
			re.printStackTrace();
		}
		return null;
	}
}