returnbookdao.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.common.SetCommitStyle;
import librarymanagement.dao.common.DBConnectionManager;
import librarymanagement.dao.common.DbException;
import librarymanagement.dao.common.DbSql;
import librarymanagement.dao.dialogInterface.ReturnBookInterface;
import librarymanagement.vo.ReaderBackVO;

public class ReturnBookDao implements ReturnBookInterface {

	DBConnectionManager manager = DBConnectionManager.getInstance();

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

			long reader_id = result.getLong("借书证号");
			String reader_name = result.getString("读者姓名");
			long book_id = result.getLong("图书编号");
			String book_name = result.getString("图书名称");
			String borrow_date = result.getString("借阅日期");
			String avability_date = result.getString("应还日期");

			v.addElement(new ReaderBackVO(reader_id, reader_name, book_id,
					book_name, borrow_date, avability_date));
		}
		return v;
	}

	public Vector commonVector(long common, String word) throws DbException {
		Vector v = null;
		Connection con = null;
		PreparedStatement state = null;
		ResultSet result = null;
		try {
			con = manager.getConnection("oracle");
			state = con.prepareStatement(word);
			state.setLong(1, common);
			result = state.executeQuery();
			if (result != null) {
				v = new Vector();
				resetVector(v, result);
				if (v.size() == 0) {
					JOptionPane.showMessageDialog(null, "您查找的数据项不存在请重新输入");
				}
			}
		} catch (SQLException e) {
			JOptionPane.showConfirmDialog(null, e.getMessage(), "异常提示",
					JOptionPane.YES_OPTION);
		} finally {
			manager.freeConnection("oracle", con);
		}
		return v;

	}

	public Vector selectByReader_ID(long reader_id) throws DbException {

		return commonVector(reader_id, DbSql.LOOKFOUNDBYREADER);
	}

	public Vector selectByBook_ID(long book_id) throws DbException {

		return commonVector(book_id, DbSql.LOOKFOUNDBYBOOK);

	}

	public boolean deleteVector(long backReaderID, long backBookID) {
		boolean flag = false;

		Connection con = null;
		PreparedStatement state = null;
		ResultSet result = null;
		try {

			con = manager.getConnection("oracle");
			con.setAutoCommit(false);
			state = con.prepareStatement(DbSql.BACKBOOK);
			state.setLong(1, backReaderID);
			state.setLong(2, backBookID);

			result = state.executeQuery();
			if (result != null) {
				flag = true;
				getCommitStyle(con, manager);
			}
		} catch (SQLException e) {
			JOptionPane.showConfirmDialog(null, e.getMessage(), "异常提示",
					JOptionPane.YES_OPTION);
		}
		return flag;
	}

	public void getCommitStyle(Connection con, DBConnectionManager manager) {
		new SetCommitStyle(con, manager);
	}

}