admin.java

This is module used JSP

/*
 * Created on Mar 10, 2009
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package AdminBean;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Hashtable;

import config.db_config;

/**
 * @author VietHung Romano
 * 
 *         TODO To change the template for this generated type comment go to
 *         Window - Preferences - Java - Code Style - Code Templates
 */
public class Admin {
	private String username;

	private String password;
	private Hashtable errors;

	public Admin() {
		username = "";
		password = "";
		errors = new Hashtable();
	}

	public String getUsername() {
		return username;
	}

	public void setUsername(String username) {
		this.username = username;
	}

	public String getPassword() {
		return password;
	}

	public void setPassword(String password) {
		this.password = password;
	}

	public boolean validate() {
		boolean bool = true;
		if (username.equals("")) {
			errors.put("username", "Please enter your username");
			username = "";
			bool = false;
		}
		if (password.equals("")) {
			errors.put("password", "Please enter your password");
			password = "";
			bool = false;
		}
		return bool;
	}

	public String getErrorMsg(String s) {
		String errorMsg = (String) errors.get(s.trim());
		return (errorMsg == null) ? "" : errorMsg;
	}

	public void setErrors(String key, String msg) {
		errors.put(key, msg);
	}

	public boolean isValid() {
		String _username = null;
		String _password = null;
		try {
			Connection conn = db_config.getConnection();
			Statement stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery("SELECT * FROM Admin");
			while (rs.next()) {
				_username = rs.getString("Username");
				_password = rs.getString("Password");
				if (username.equals(_username) && password.equals(_password)) {
					return true;
				}
			}
		} catch (SQLException ex) {
			ex.printStackTrace();
		}
		return false;
	}
}