perfectreaderdao.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.GetPerfectReader;
import librarymanagement.common.SetCommitStyle;
import librarymanagement.dao.common.DBConnectionManager;
import librarymanagement.dao.common.DbSql;
import librarymanagement.vo.PerfectReaderVO;

public class PerfectReaderDao {

	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.FOUN_READER_INFORMATION);

			state.setLong(1, reader_id);
			int a = state.executeUpdate();
			result = state.executeQuery();
			if (a == 0) {
				JOptionPane.showMessageDialog(null, "数据库中不存在此记录!!!");
				GetPerfectReader.getPerfect().getIdTxt().setEditable(true);
				GetPerfectReader.getPerfect().getIdTxt().setText("");
			}
			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 void changeInfo(String acd, String tel, String certificate,
			String zheng_id, String reader_id) {
		int a = JOptionPane.showConfirmDialog(null, "是否真的要进行数据修改？", "确认信息",
				JOptionPane.YES_NO_OPTION);
		if (a == JOptionPane.YES_OPTION) {
			try {
				con = manager.getConnection("oracle");
				state = con.prepareStatement(DbSql.CHANGE_READER_INFORMATION);
				new SetCommitStyle(con, manager);
				state.setString(1, acd);
				state.setString(2, tel);
				state.setString(3, certificate);
				state.setString(4, zheng_id);
				state.setString(5, reader_id);
				int count = state.executeUpdate();
				if (count != 0) {
					JOptionPane.showMessageDialog(null, "修改信息成功");
				}

			} catch (SQLException e) {
				JOptionPane.showConfirmDialog(null, e.getMessage(), "异常提示",
						JOptionPane.YES_OPTION);
			}
		} else {
			return;
		}

	}

	// 读者编号", "读者姓名", "所 在 院 系", "注 册 日 期", "有 效 日 期 至", "状 态 信 息",
	// "图 书 未 还 数 量", "电 话", "性 别", "有 效 证 件", "证 件 号 码", " E_mail ", "读 者 身 份
	public Vector resetVector(Vector v, ResultSet result) throws SQLException {
		while (result.next()) {

			long reader_id = result.getLong("读者编号");
			String reader_name = result.getString("读者姓名");
			String acd = result.getString("所在院系");
			String regist_date = result.getString("注册日期");
			String available_date = result.getString("有效日期至");
			String condition = result.getString("状态信息");
			long not_return_num = result.getLong("图书未还数量");
			String tel = result.getString("电话");
			String sex = result.getString("性别");
			String certificate = result.getString("有效证件");
			String zheng_id = result.getString("证件号码");
			String e_mail = result.getString("E_mail");
			String job = result.getString("读者身份");
			v.addElement(new PerfectReaderVO(reader_id, reader_name, acd,
					regist_date, available_date, condition, not_return_num,
					tel, sex, certificate, zheng_id, e_mail, job));
		}

		return v;
	}

}