borrowinfodao.java

用eclipse编写的图书管理系统

package sever.dao;

import java.sql.ResultSet;
import java.sql.SQLException;

import sever.db.ConnectionDB;
import sever.entity.BookInfo;
import sever.entity.BorrowInfo;
import sever.entity.ReaderInfo;

//按书名查询书籍

public class BorrowInfoDAO {
	ResultSet rs;
	ResultSet rsm;
	ResultSet r;
	ResultSet rr;
	//按书名查询
	public ResultSet lookup(BookInfo book){
		
		try{
		String sql="select * from BookInfo  where BookName like('"+book.getBookName()+"%')";
		ConnectionDB conn=new ConnectionDB();
		System.out.println(sql);
	      rs=conn.queryData(sql);
		}catch(Exception ce){
			ce.getMessage();
		}
		return rs;
	}
	
	//按编号查询
	public ResultSet lookupNumber(BookInfo book){
		try{
			String sql="select *from BookInfo where BookNumber like('"+book.getBookNumber()+"%')";
			ConnectionDB con=new ConnectionDB();
			rsm=con.queryData(sql);
			
		}catch(Exception e){
			e.getMessage();
		}
		return rsm;
	}
	 
	//按类别查询
	
	public ResultSet lookupType(BookInfo book){
		try{
			String sql="select * from BookInfo where BookTypes like('"+book.getBookTypes()+"%')";
			ConnectionDB con=new ConnectionDB();
			r=con.queryData(sql);
		}catch(Exception ee){
			ee.getMessage();
		}
		return r;
	}
     
	//借阅管理
	public boolean borrcheck(BorrowInfo borr){
		String sql="insert into BorrowInfo values('"+borr.getBorrowName()+"','"+borr.getBorrowId()+"','"+
		borr.getBorrowBName()+"','"+borr.getBorrowTime()+"')";
		ConnectionDB co=new ConnectionDB();
		co.updateData(sql);
		return true;
	}
	//查询已借出书籍
	public ResultSet bookLise(BorrowInfo borr){
		String sql="select * from BorrowInfo";
		ConnectionDB conn=new ConnectionDB();
		rr=conn.queryData(sql);
		return rr;
		
	}
	
	//书籍归还
	public boolean bookin(BorrowInfo boon){
		String sql="delete from BorrowInfo where BorrowId=('"+boon.getBorrowId()+"')";
		ConnectionDB connec=new ConnectionDB();
		connec.updateData(sql);
		return true;
	}
	//减MONEY
	public boolean retime(ReaderInfo read){

		String sql="update ReaderInfo set ReaderMoney= (select ReaderMoney from ReaderInfo where ReaderName='"+read.getReaderName()+"')-10 where ReaderName=('"+read.getReaderName()+"')";
		ConnectionDB conne=new ConnectionDB();
		//ResultSet rr=conne.queryData(sql);
		
		
		
		conne.updateData(sql);
		System.out.println(sql);
		
		return true;
	}
}