borrow_founddao.java

一个简单的图书馆的管理系统,该系统主要是针对学校的图书馆而做的

package librarymanagement.dao;

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

import javax.swing.JOptionPane;

import librarymanagement.dao.common.DBConnectionManager;
import librarymanagement.dao.common.DbSql;
import librarymanagement.vo.Borrow_FoundVO;

public class Borrow_FoundDao {
	private DBConnectionManager manager = DBConnectionManager.getInstance();
	private Connection con;
	private PreparedStatement state;
	private ResultSet result;
	private Vector v;

	public Vector foundInfo(long reader_id) {
		try {
			con = manager.getConnection("oracle");
			state = con.prepareStatement(DbSql.BORROW_FOUND);
			state.setLong(1, reader_id);
			int a = state.executeUpdate();
			result = state.executeQuery();
			if (a == 0) {
				JOptionPane.showMessageDialog(null, "数据库中不存在此记录!!!");
			}
			if (result != null) {
				v = new Vector();
				resetVector(v, result);
			}
		} catch (SQLException e) {
			JOptionPane.showConfirmDialog(null, e.getMessage(), "异常提示",
					JOptionPane.YES_OPTION);
		} finally {
			manager.freeConnection("oracle", con);
		}

		return v;
	}

	public Vector resetVector(Vector v, ResultSet result) throws SQLException {
		while (result.next()) {

			// reader_id,reader_name,book_id,book_name,borrow_date,should_return_date
			long reader_id = result.getLong("读者编号");
			String reader_name = result.getString("读者姓名");
			String book_id = result.getString("图书编号");
			String book_name = result.getString("图书名称");
			String borrow_date = result.getString("借书日期");
			String should_return_date = result.getString("应还日期");
			v.addElement(new Borrow_FoundVO(reader_id, reader_name, book_id,
					book_name, borrow_date, should_return_date));
		}

		return v;
	}

}