.#borrowbookinspectprocess.java.1.3

简单的图书馆管理系统

/***********************************************************************
*                          图书管理系统
* Team : ？？？
* Author：金日新                                                          
* StartTime：2006/1/4                                                   
* VersionNumber：1.1                                                            
* ProgrammeLanguage：java 															  
* Remark:图书借阅验证
*************************************************************************/
package com.common.DBaccess;

import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.Hashtable;
import java.util.Vector;

import com.common.DBParent.DBBase;

/**
 * @author cy011
 *
 */
public class BorrowBookInspectProcess
{
	public BorrowBookInspectProcess()
	{
		super();
	}
	public int borrowInspectProcess(String ZJH,String SQH)
	{
		DBBase dbb=new DBBase();
		int flag=0;
		Vector v=new Vector();
		Hashtable hs=null;
		int KeJieTianShu=0;
		Connection con=dbb.getConnection();
		String sql1="select KJYSJ from KJB2_KJXX_Rule where RuleID=(select RuleID from KJB2_KJXX_Reader where ZJH=?)";
		PreparedStatement pss;
		try {
			pss = con.prepareStatement(sql1);
			ResultSet rs=pss.executeQuery();
			while(rs.next())
			{
				KeJieTianShu=rs.getInt(1);
			}
		} catch (SQLException e1) {
			// TODO 自动生成 catch 块
			e1.printStackTrace();
		}
		
		Date date=new Date(new java.util.Date().getTime());
		System.out.println(new java.sql.Date(new java.util.Date().getTime()+24*60*60*1000*KeJieTianShu));
		
		String sql2="insert KJB2_KJXX_JYB(ReaderID,BookID,JYSJ,DQSJ,CHRQ,ZT,XJCS) values(select ReaderID from KJB2_KJXX_Reader where ZJH=?" +
				",select BookID form KJB2_KJXX_Store where SQH=?,?,?,?,?,?)";
		PreparedStatement ps;
		int n=0;
		try
		{
			ps=con.prepareStatement(sql2);
			ps.setString(1, ZJH);
			ps.setString(2, SQH);
			ps.setDate(3,date);
			ps.setDate(4,new java.sql.Date(new java.util.Date().getTime()+24*60*60*1000*KeJieTianShu));
			ps.setDate(5,null);
			ps.setString(6,"已借出");
			ps.setInt(7,0);
			flag=ps.executeUpdate();	
		} 
		catch (SQLException e) 
		{
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		dbb.closeDB(con);
		return flag;				
			
	}
	public static void main(String[] args)
	{
		BorrowBookInspectProcess b=new BorrowBookInspectProcess();
		int ha=b.borrowInspectProcess("","");
		
	}
}