loan.java

图书管理系统,可以查询 图书管理系统,可以查询

import java.sql.*;
import javax.swing.*;
import javax.swing.JOptionPane;
import java.awt.*;
import java.net.*;
import java.lang.*;
import java.util.Calendar;
import java.util.Vector;


public class Loan{
    String readerID;
    String bookID;
    Date lendDate;//get the time
    Integer timeLimit=30;
    
    public String getReaderID(){
        return readerID;
    }   
    public String getBookID(){
        return bookID;
    } 
    public Date getLendDate(){
        return lendDate;
    }
    public Integer getTimeLimit(){
        return timeLimit;
    }
    
    public void setReaderID(String readerID){
        this.readerID = readerID;
    }        
    public void setBookID(String bookID){
        this.bookID = bookID;
    }        
    public void setLendDate(Date lendDate){
        this.lendDate = lendDate;
    }
    public void setTimeLimit(Integer timeLimit){
        this.timeLimit = timeLimit;
    }
    
    //create loan
    public boolean createLoan(String readerID, Vector bookIDs){
        boolean insertok=false;
    	try{
    		Calendar now = Calendar.getInstance();
    		java.sql.Date dat = new java.sql.Date(now.getTimeInMillis());
    		Connection con = DBAccess.getConnection();
    		String sql = "insert into load(readerID,bookID,lendDate,timeLimit) values(?,?,?,?)"; 
			PreparedStatement pst = con.prepareStatement(sql);
        	for(int i = 0;i < bookIDs.size();i++){
                pst.setString(1, readerID);
                pst.setString(2, (String)bookIDs.get(i));
				pst.setDate(3,dat);
				pst.setInt(4,30);
        	    pst.executeUpdate(); 
        	    insertok=true;
             }
        }catch(SQLException e){
        	    System.out.print("SQLException"+e.getMessage());
        }  
         return insertok;     
    }
}
//邬老师：不知我数据库中的变量的类型有没有设置错，也帮我看下，好吗？
//呵呵，应该没什么问题了