loginformbean.java

此资源是jsp应用开发 邓子云等编写的一书里的源代码

package formBean;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.servlet.http.HttpServletRequest;
import javax.sql.DataSource;

import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionMessage;

/**
 * @author dengziyun
 * 封装登录表单数据的FormBean
 */
public class loginFormBean extends ActionForm{
	String oaUserName;//用户名
	String oaUserPassword;//密码
	/**
	 * 重置所有属性的值
	 */
	public void reset(ActionMapping arg0, HttpServletRequest request) {
		oaUserName=null;
		oaUserPassword=null;
	}
	/**
	 * 验证表单中的数据
	 */
	public ActionErrors validate(ActionMapping arg0, HttpServletRequest request) {
		ActionErrors errors=new ActionErrors();
		//------用户名非空校验------
		if(oaUserName==null||oaUserName.trim().length()<1)
			errors.add("oaUserNameIsNull",new ActionMessage("oaUserNameIsNull"));
		//------密码非空校验------
		if(oaUserPassword==null||oaUserPassword.trim().length()<1)
			errors.add("oaUserPasswordIsNull",new ActionMessage("oaUserPasswordIsNull"));	
		//------到数据库中检验------
		try{
			//------得到数据库连接------
			Context initCtx = new InitialContext(); 
			Context ctx = (Context) initCtx.lookup("java:comp/env");
			Object obj = (Object) ctx.lookup("jdbc/sqlserver");
			DataSource ds = (javax.sql.DataSource)obj;
			Connection conn = ds.getConnection();
			//------查询数据------
			String sqlStr=new String("select * from oaUser where oaUsername=? and oaUserPassword=?");
			PreparedStatement preSQLSelect=conn.prepareStatement(sqlStr,ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
			oaUserName=new String(oaUserName.getBytes("ISO-8859-1"));
		  	preSQLSelect.setString(1,oaUserName);
		  	oaUserPassword=new String(oaUserPassword.getBytes("ISO-8859-1"));
		  	preSQLSelect.setString(2,oaUserPassword);
		  	ResultSet rs=preSQLSelect.executeQuery();
		  	if(rs.next()){//找到数据
		  		request.getSession().setAttribute("oaUserName",rs.getString("oaUserName"));
		  		request.getSession().setAttribute("oaUserTrueName",rs.getString("oaUserTrueName"));
		  		request.getSession().setAttribute("oaUserId",rs.getString("oaUserId"));
		  		request.getSession().setAttribute("departmentId",rs.getString("departmentId"));
		  	}else{//找不到数据
		  		errors.add("nameOrPassError",new ActionMessage("nameOrPassError"));
		  	}
		  	//------关闭数据库连接------
		  	if(conn!=null)
		  		conn.close();
		}catch(Exception e){
			errors.add("DBOPError",new ActionMessage("DBOPError"));
		}
		return errors;
	}

	public String getOaUserName() {
		return oaUserName;
	}
	public void setOaUserName(String oaUserName) {
		this.oaUserName = oaUserName;
	}
	public String getOaUserPassword() {
		return oaUserPassword;
	}
	public void setOaUserPassword(String oaUserPassword) {
		this.oaUserPassword = oaUserPassword;
	}
}