loan.java.bak

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

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


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, ArrayList bookIDs){
        //Vector lst=new Vector();
    	try{
    		/*String s1 = "%" + readerID + "%";
    		String s2 = "%" + password+ "%";//?
    		                                //?
    		                                //?
			*/
        	String sql = "insert into load values (?,?,?,?)"; 
			PreparedStatement pst = con.prepareStatement(sql);
        	for(int i = 0;i < bookIDs.size();i++){
                pst.setString(1, readerID);
                pst.setString(2, bookIDs.get(i));
				pst.setDate(3,new Date());
				pst.setString(4,timeLimit)
        	    pst.executeUpdate(); 
                }
            }
            
        }catch(SQLException e){
        	System.out.print("SQLException"+e.getMessage());
        }  
         return lst;     
    }
}
//邬老师：不知我数据库中的变量的类型有没有设置错，也帮我看下，好吗？