bookoper.java

图书馆管理系统,用java编写,有原码,有检索,查询,修改,删除等功能

package com.autumn.pojo.oper;

import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;

import com.autumn.pojo.Book;

public class BookOper {
	private Session session ;
	public BookOper()
	{
		this.session = new Configuration().configure().buildSessionFactory().openSession() ;
	}
	
	public boolean insert(Book b)
	{
		boolean suc = false ;
		try {
			this.session.save(b) ;
			this.session.beginTransaction().commit() ;
			suc = true ;
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return suc ;
	}
	
	public boolean delete(Book b)
	{
		boolean suc = false ;
		try {
			String hql = "delete from Book where code=?" ;
			Query q = this.session.createQuery(hql) ;
			q.setString(0, b.getCode()) ;
			q.executeUpdate() ;
			this.session.beginTransaction().commit() ;
			suc = true ;
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return suc ;
	}
	public Book queryByCode(String code)
	{
		Book b = null ;
		String hql = "from Book as b where b.id=?" ;
		Query q = this.session.createQuery(hql) ;
		q.setString(0, code) ;
		List l = q.list() ;
		if(l.size()>0)
		{
			b = (Book)l.get(0) ;
		}
		return b ;
	}
	public List queryByLike(String cond)
	{
		List l = null ;
		String hql = "from Book as b where b.name like ? or b.author like ?" ;
		Query q = this.session.createQuery(hql) ;
		q.setString(0, "%"+cond+"%") ;
		q.setString(1, "%"+cond+"%") ;
		l = q.list() ;
		return l ;
	}
}