borrowedoper.java

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

package com.autumn.pojo.oper;

import java.util.ArrayList;
import java.util.Calendar;
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;
import com.autumn.pojo.Borrowed;
import com.autumn.pojo.Reader;

public class BorrowedOper {
	private Session session ;
	public BorrowedOper()
	{
		this.session = new Configuration().configure().buildSessionFactory().openSession() ;
	}
	
	public boolean insert(Borrowed 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(String bcode)
	{
		boolean suc = false ;
		try {
			String hql = "delete from Borrowed where bcode=?" ;
			Query q = this.session.createQuery(hql) ;
			q.setString(0, bcode) ;
			q.executeUpdate() ;
			this.session.beginTransaction().commit() ;
			suc = true ;
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return suc ;
	}
	public List queryByRid(String rid)
	{
		List list = new ArrayList() ;
		String hql = "from Borrowed as b where rid=?" ;
		Query q = this.session.createQuery(hql) ;
		q.setString(0,rid) ;
		try {
			System.out.println(q.list());
			list = q.list();
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		System.out.println(list) ;
		return list ;
	}
	
	//在borrowed表中插入一天记录
	public boolean add(String bcode,String rid)
	{
		boolean bl = false ;
		
		ReaderOper ro = new ReaderOper() ;
		BookOper booko = new BookOper() ;
		Borrowed bor= new Borrowed() ;
		
		Calendar cal = Calendar.getInstance(); 
		String bout,bback,day,month,year; 
		year = String.valueOf(cal.get(Calendar.YEAR)); 
		month = String.valueOf(cal.get(Calendar.MONTH)+1); 
		day = String.valueOf(cal.get(Calendar.DATE)); 
		bout = year+"-"+month+"-"+day;
		cal.add(Calendar.DAY_OF_YEAR, 60);
		year = String.valueOf(cal.get(Calendar.YEAR)); 
		month = String.valueOf(cal.get(Calendar.MONTH)+1); 
		day = String.valueOf(cal.get(Calendar.DATE)); 
		bback = year+"-"+month+"-"+day;
		
		Reader reader = ro.queryById(rid) ;
		Book book = booko.queryByCode(bcode) ;
		bor.setBcode(bcode) ;
		bor.setRid(rid) ;
		bor.setOut(bout) ;
		bor.setBack(bback) ;
		bor.setBook(book) ;
		bor.setReader(reader);
		bl = this.insert(bor) ;
		return bl ;
	}
}