addreaderdao.java

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

package librarymanagement.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import javax.swing.JOptionPane;

import librarymanagement.dao.common.DBConnectionManager;
import librarymanagement.dao.common.DbException;
import librarymanagement.dao.common.DbSql;
import librarymanagement.vo.AddReaderVO;

public class AddReaderDao {

	DBConnectionManager manager = DBConnectionManager.getInstance();

	public void RegisterReader(AddReaderVO vo) throws DbException {
		Connection con = null;
		PreparedStatement state = null;
		try {
			con = manager.getConnection("oracle");

			state = con.prepareStatement(DbSql.REGISTER_READER);

			state.setLong(1, vo.getReader_id());

			state.setString(2, vo.getReader_name());

			state.setString(3, vo.getSex());

			state.setString(4, vo.getJob());

			state.setString(5, vo.getAcd());

			state.setString(6, vo.getTell());

			state.setString(7, vo.getCertificate());

			state.setString(8, vo.getZheng_id());

			state.setString(9, vo.getE_mail());

			state.setString(10, vo.getRegist_date());
			int count = state.executeUpdate();
			if (count != 0) {
				JOptionPane.showMessageDialog(null, "注册成功");
			}

		} catch (SQLException e) {
			JOptionPane.showConfirmDialog(null, e.getMessage(), "异常提示",
					JOptionPane.YES_OPTION);
			
		} finally {
			manager.freeConnection("oracle", con);
		}
	}

}