libraryinfodao.java

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

package librarymanagement.dao.libraryinfodao;

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.LibraryInfoVo;
import librarymanagement.vo.SearchBooksVo;

public class LibraryInfoDao {

	DBConnectionManager manager = DBConnectionManager.getInstance();

	public boolean updateLibraryInfo(LibraryInfoVo value) {
		Connection con = null;
		PreparedStatement st = null;
		boolean s = false;
		try {
			con = manager.getConnection("oracle");
			st = con.prepareStatement(DbSql.UPDATE_LIBRARY_INFO);
			st.setString(1, value.getName());
			st.setString(2, value.getAddress());
			st.setString(3, value.getMail());
			st.setString(4, value.getTel());

			st.setString(5, value.getSponsorMan());
			st.setFloat(6, value.getFajinPerDay());
			st.setInt(7, value.getNum_limit());
			st.setInt(8, value.getDate_limit());
			st.setInt(9, value.getReborrow_date());
			int i = st.executeUpdate();
			if (i != 0) {
				return true;
			}

		} catch (SQLException e) {
			JOptionPane.showMessageDialog(null, e.getMessage(), "错误提示",
					JOptionPane.YES_OPTION);
		} finally {
			manager.freeConnection("oracle", con);
		}
		return s;

	}

	public Vector selectLibraryInfo(){
		Connection con = null;
		PreparedStatement st = null;
		ResultSet set = null;
		Vector v = null;
		try{
			con = manager.getConnection("oracle");
			st = con.prepareStatement(DbSql.SELECT_LIBRARY_INFO);
			set = st.executeQuery();
			v = new Vector();
			setVector(set,v);
		}catch(SQLException e){
			JOptionPane.showMessageDialog(null, e.getMessage(),"错误提示",JOptionPane.YES_OPTION);			
		}
		finally{
			manager.freeConnection("oracle", con);
		}
		return v;
	}

	private void setVector(ResultSet set, Vector v) throws SQLException {

		while (set.next()) {
			String name = set.getString("name");
			String address = set.getString("address");
			String mail = set.getString("mail");
			String tel = set.getString("tel");
			String sponsorman = set.getString("sponsorman");
			float fajin = set.getFloat("fajin_perday");
			int num_limit = set.getInt("num_limit");
			int date_limit = set.getInt("date_limit");
			int reBorrow_date = set.getInt("reborrow_date");

			v.add(new LibraryInfoVo(name, address, mail, tel, sponsorman,
					fajin, num_limit, date_limit, reBorrow_date));
		}

	}
}