storelactiondao.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.DbException;
import librarymanagement.dao.common.DbSql;

import librarymanagement.vo.StoreLactionVO;

public class StoreLactionDao {
	private DBConnectionManager manager = DBConnectionManager.getInstance();
	private Connection con = null;
	private PreparedStatement state = null;
	private ResultSet set = null;
	private Vector v = null;

	public void addCommonBase(StoreLactionVO vo, String sql, String name1,
			String name2) throws DbException {

		try {
			con = manager.getConnection("oracle");
			state = con.prepareStatement(sql);
			state.setString(1, vo.getReading_room());
			state.setString(2, vo.getBookLocation());
			state.setString(3, vo.getBookInformation());
			state.setString(4, vo.getBookClass());
			int count = state.executeUpdate();

			if (count != 0) {
				JOptionPane.showMessageDialog(null, name1);
			} else {
				JOptionPane.showMessageDialog(null, name2);
			}
		} catch (SQLException e) {
			JOptionPane.showConfirmDialog(null, e.getMessage(), "异常提示",
					JOptionPane.YES_OPTION);
		} finally {
			manager.freeConnection("oracle", con);
		}
	}

	public void deleteLocation(String name) throws DbException {
		try {
			con = manager.getConnection("oracle");
			state = con.prepareStatement(DbSql.DELETE_STORE);
			state.setString(1, name);
			state.executeQuery();
		} catch (SQLException e) {
			JOptionPane.showConfirmDialog(null, e.getMessage(), "异常提示",
					JOptionPane.YES_OPTION);
		} finally {
			manager.freeConnection("oracle", con);
		}
	}

	public void addDateBase(StoreLactionVO vo) throws DbException {
		addCommonBase(vo, DbSql.INSERT_BOOK_STORELOCATION, "数据添加成功", "数据添加失败");

	}

	public void changeDate(StoreLactionVO vo) throws DbException {
		addCommonBase(vo, DbSql.CHANG_DATE, "数据修改成功", "数据修改失败");
	}

	public Vector foundDate1(String reading_room, String bookStore)
			throws DbException {

		return foundCommon(reading_room, bookStore, DbSql.FOUND_STORE);

	}

	public Vector foundDate2(String bookInformation, String bookClass)
			throws DbException {

		return foundCommon(bookInformation, bookClass,
				DbSql.FOUND_BOOK_STORELOCATION);

	}

	public Vector foundCommon(String index1, String index2, String name) {
		try {
			con = manager.getConnection("oracle");
			state = con.prepareStatement(name);
			state.setString(1, index1);
			state.setString(2, index2);
			set = state.executeQuery();
			v = new Vector();
			init(v, set);
			int count = state.executeUpdate();
			if (count == 0) {
				JOptionPane.showMessageDialog(null, "数据库中不存在此信息");
			} else {
				JOptionPane.showMessageDialog(null, "搜索完成");
			}
		} catch (SQLException e) {
			JOptionPane.showConfirmDialog(null, e.getMessage(), "异常提示",
					JOptionPane.YES_OPTION);
		} finally {
			manager.freeConnection("oracle", con);
		}
		return v;
	}

	public void init(Vector v, ResultSet set) throws SQLException {
		while (set.next()) {

			String reading_room = set.getString("reading_room");

			String bookLocation = set.getString("bookLocation");

			String bookInformation = set.getString("bookInformation");

			String bookClass = set.getString("bookClass");

			v.addElement(new StoreLactionVO(reading_room, bookLocation,
					bookInformation, bookClass));

		}

	}

}