managerdao.java

来自「一个简单的图书馆的管理系统,该系统主要是针对学校的图书馆而做的」· Java 代码 · 共 57 行

package librarymanagement.dao.managerdao;

import java.io.File;
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;
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.view.common.CheckInputText;
import librarymanagement.view.frame.Entry;

public class ManagerDao {
	DBConnectionManager manager = DBConnectionManager.getInstance();
	CheckInputText check = new CheckInputText();

	public boolean checkManager(String name, String passWord) {
		boolean flag = false;
		PreparedStatement pstmt = null;
		Connection con = null;
		ResultSet set = null;
		try {
			//System.out.println(manager);
			con = manager.getConnection("oracle");
			System.out.println(con);
			pstmt = con.prepareStatement(DbSql.MANAGER_PASSWORD_SELECT
					+ DbSql.WHERE + DbSql.BY_NAME);
			pstmt.setString(1, name);
			set = pstmt.executeQuery();
			String password = null;
			while(set.next()){
			password = set.getString("manager_password");
			}
			System.out.println(password);
			if (password == null) {
				JOptionPane.showMessageDialog(null, "您输入的密码用户名或密码不正确，请重新输入",
						"提示信息", JOptionPane.YES_OPTION);
			} else if (passWord.equals(password)) {
				flag = true;
			}
		} catch (SQLException e) {
			System.out.println("根据管理者名称查找密码信息dao异常: " + e.getMessage());
		} finally {
			manager.freeConnection("oracle", con);
		}
		return flag;
	}

}