book.java

图书管管理系统是基于JAVA的 很好的

/*
 * Book.java
 *
 * Created on 2007年11月22日, 上午10:47
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package h6.data;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

import h6.action.DataBase;
import h6.action.ShareSubprogram;

/**
 *
 * @author dinga
 */
public class Book {
    
    /** Creates a new instance of Book */
    private String ISBN;
    private String name;
    private String publish;
    private String TP;
    private String language;
    private String author;
    private String year;
    private String totalNumber;
    private String lendNumber;
    private String date;
    
    public Book() {
    }
    
    public void setIsbn(String isbn){
    	ISBN = isbn;
    }
    public void setName(String name){
    	this.name = name;
    }
    public void setPublish(String publish){
    	this.publish = publish;
    }
    public void setTp(String tp){
    	TP = tp;
    }
    public void setLanguage(String language){
    	this.language = language;
    }
    public void setAuthor(String author){
    	this.author = author;
    }
    public void setYear(String year){
    	this.year = year;
    }
    public void setTotalNumber(String total){
    	this.totalNumber = total;
    }
    public void setLendNumber(String lend){
    	this.lendNumber = lend;
    }
    public void setDate(String date){
    	this.date = date;
    }
 
    public String getIsbn(){
        return ISBN;
    }
    
    public String getName(){
        return name;
    }
    
    public String getPublish(){
        return publish;
    }
    
    public String getTp(){
        return TP;
    }
    
    public String getLanguage(){
        return language;
    }
    
    public String getAuthor(){
        return author;
    }
    
    public String getYear(){
        return year;
    }
    
    public String getTotalnumber(){
        return totalNumber;
    }
    
    public String getLendnumber(){
        return lendNumber;
    }
    
    public String getDate(){
        return date;
    }
    
    public  Vector searchBook(String[] request,int start) throws SQLException{
        /**
         *该方法实现了书籍检索的功能
         *返回含有书籍信息的向量
         *参数说明：
         *request[] 检索时的关键字数组
         *start 查询时从哪行元组返回数据
         */
            Vector info =  new Vector();
            
            String []s = {"*"};
            if(ShareSubprogram.analyseRequest(request).length()==0 )
            	return info;
            
            DataBase db = new DataBase();
            ResultSet rs = db.search("book",s," " + ShareSubprogram.analyseRequest(request).concat("LIMIT " + start + ",10"));
            for (int count = 0;count < 10;count ++){
                if (rs.next()){
                    Vector v = new Vector();
                    for (int count2 = 1;count2 <= 10;count2 ++){
                        v.add(rs.getString(count2));
                        info.add(v); 
                    }
                }
                else{
                    rs.close();
                    db.closeConnection();
                    return info;
                }
            }
            rs.close();
            db.closeConnection();
            return info;
        }
    
    public int getTotalPage(String[] request) throws SQLException{
    	int total = 0;
    	
    	if(ShareSubprogram.analyseRequest(request).length()==0 )
    		return 0;
    	
    	String []s = {"count(*)"};
    	DataBase db = new DataBase();
    	ResultSet rs = db.search("book",s," " + ShareSubprogram.analyseRequest(request));
    	if(rs.next())
    		total = rs.getInt(1);
    	
    	rs.close();
    	db.closeConnection();
    	return total;
    }
    
    public boolean getBookInfo() throws SQLException{
    	DataBase db = new DataBase();
    	String[] s = {"*"};
    	ResultSet rs;
    	if(null == ISBN || ISBN.length()==0)
    		return false;
    	
    	rs = db.search("book", s, "ISBN='"+ISBN+"'");
    	if(rs.next()){
    		name = rs.getString(1);
    		publish = rs.getString(2);
    		TP = rs.getString(3);
    		language = rs.getString(4);
    		author = rs.getString(5);
    		year = rs.getString(6);
    		totalNumber = rs.getString(7);
    		lendNumber = rs.getString(8);
    		date = rs.getString(10);
    	}else
    		author = "张李一";
    	
    	rs.close();
    	db.closeConnection();
    	return true;
    }
    
}