loginbean.java

仓库管理系统

package edu.scau.login;

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

import javax.faces.application.FacesMessage;
import javax.faces.component.UIComponent;
import javax.faces.context.FacesContext;
import javax.faces.validator.ValidatorException;

import edu.scau.database.DBUtil;

public class LoginBean {
	private String number;

	private String name;

	private String pwd;

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getNumber() {
		return number;
	}

	public void setNumber(String number) {
		this.number = number;
	}

	public String getPwd() {
		return pwd;
	}

	public void setPwd(String pwd) {
		this.pwd = pwd;
	}

	// 用户登录过程
	public String login() {
		String returnStr = "failure";
		Connection conn = null;
		String getPasswordByName = null;
		Statement sm = null;
		ResultSet rs = null;
		DBUtil dbUtil = new DBUtil();
		String number = getNumber();
		String pwd = getPwd();
		// System.out.println("name="+number);
		// System.out.println("pwd="+pwd);
		try {
			// 1.获取数据库连接
			conn = dbUtil.getConn();
			// 2.按照name查找pwd
			getPasswordByName = "select name,pwd from t_bd_user where number = '" + number + "'";
			sm = conn.createStatement();
			rs = sm.executeQuery(getPasswordByName);
			// 3.判断pwd是否一致
			if (rs != null && rs.next()) {
				if (pwd.equals(rs.getString("pwd"))) {
					setName(rs.getString("name"));
					returnStr = "success";
				}
			}
			rs.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			dbUtil.closeStatement(sm);
			dbUtil.closeConnection(conn);
		}
		return returnStr;
	}

	public void validate(FacesContext context, UIComponent component, Object obj) throws ValidatorException {
		String number = (String) obj;
		if (number.length() < 2) {
			FacesMessage message = new FacesMessage(FacesMessage.SEVERITY_ERROR, "用户编号小于2", "用户编号小于2");
			throw new ValidatorException(message);
		}

	}
}