logonaction.java

基于STRUTS的试卷分析系统,实现JFREECHART画图片和POI生成EXCEL文档,开发平台:eclipse3.0+myclipse+tomcat5.0+mysql4.0

//Created by MyEclipse Struts
// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_3.8.3/xslt/JavaClass.xsl

package com.hbnu.action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.sql.SQLException;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import com.hbnu.common.DBConn;
import com.hbnu.common.DUtilBean;
import java.util.ArrayList;
import org.apache.struts.validator.DynaValidatorForm;
import com.hbnu.common.CodingConvert;
/**
 * @author jackie
 * @version 1.0 
 * 
 */
public class LogonAction extends Action {
	/** 
	 * <br>画面初始化处理<br>
	 * 
	 *  @param mapping 		ActionMapping对象
	 *  @param form 		ActionForm对象
	 *  @param request 		HttpServletRequest对象
	 *  @param response 	HttpServletResponse对象
	 *  @return af			ActionForward对象
	 *  @throws Exception 
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
	        HttpServletRequest request, HttpServletResponse response) throws Exception {
	    DynaValidatorForm logonForm = (DynaValidatorForm) form;
	    String username = String.valueOf(logonForm.get("username"));	//获得FORM的字段结果
	    String passWord = String.valueOf(logonForm.get("password"));
	    CodingConvert convert = new CodingConvert();
	    String userName = convert.toGb(username);
	    DBConn db = new DBConn();
	   
	    try{
	        db.start();
	        
	        /*查询SQL语句*/
	        StringBuffer sbSql = new StringBuffer();
	        sbSql.append(" SELECT");
	        sbSql.append(" *");
	        sbSql.append("FROM jsxxb ");
	        sbSql.append("WHERE ");
	        sbSql.append(" jsxm =  ");
	        sbSql.append(DUtilBean.sqlEscape(userName)); 
	        sbSql.append(" AND jsbh =  ");
	        sbSql.append(DUtilBean.sqlEscape(passWord)); 
	        /*SQL语句执行*/
	        ArrayList ar = db.execSelect(sbSql.toString());
	        
	        if (ar != null&&!ar.isEmpty()) {
	            HttpSession session = request.getSession();
	            session.setAttribute("user_name", userName);
	        } else {
	            ActionErrors errors = new ActionErrors();
	            logonForm.reset(mapping,request);
	            return (mapping.findForward("failure"));
	        }
	    } catch(SQLException ex){
	        System.out.print("Logon Error：" + ex.getMessage());
	    } finally{
	        db.execClose();
	    }
	    
	    return (mapping.findForward("success"));
	}
}