finedao.java

图书管理系统

package com.dao;

import java.util.List;

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

import com.bean.Fine;
import com.common.HibernateSessionFactory;

public class FineDao {
	public void addFine(Fine fine){
		Session session = HibernateSessionFactory.getSession();
		session.save(fine);
	}
	
	public List findFine(Integer readerid, String isfine){
		Session session = HibernateSessionFactory.getSession();
		String sql = "from Fine where 1=1";
		if(readerid!=null)
			sql += " and readerid=:readerid";
		if(isfine!=null&&isfine.length()!=0)
			sql += " and isfine=:isfine";
		Query query = session.createQuery(sql);
		if(readerid!=null)
			query.setInteger("readerid", readerid);
		if(isfine!=null&&isfine.length()!=0)
			query.setString("isfine", isfine);
		if(query.list().isEmpty())
			return null;
		return query.list();
	}
	
}