backbookprocess.java

简单的图书馆管理系统

package com.common.DBaccess;

import java.awt.datatransfer.DataFlavor;
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 java.util.logging.Formatter;

import com.common.DBParent.DBBase;
import com.controller.BackBookControlPro;

public class BackBookProcess {

	public int getBackBook(String ZSH,String SQH)

	{
		Vector v = new Vector();
		PreparedStatement ps = null;
		ResultSet rs = null;
		Hashtable hs = null;
		int i=0;
		DBBase db = new DBBase();
		// 调用 - 连接数据库
		Connection conn = db.getConnection();
		String sql = "update KJB2_KJXX_JYB set ZT=?,GHRQ=? where BookID=(select BookID from KJB2_KJXX_Store where SQH=?) and ReaderID=(select ReaderID from KJB2_KJXX_Reader where ZJH=?)";
		try {
			ps = conn.prepareStatement(sql);
			ps.setString(1,"已还");
			ps.setDate(2,new Date(new java.util.Date().getTime()));
			ps.setString(3,SQH);
			ps.setString(4,ZSH);
			i=ps.executeUpdate();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		db.closeDB(conn);
		return i;
	}

}