userloginaction.java

eclipse+struts+sqlserver 简单图书管理系统,内有文档

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package kignbi.dong.action;

import javax.servlet.ServletContext;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import javax.sql.DataSource;

import kignbi.dong.form.UserLoginForm;
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 org.apache.struts.action.ActionMessage;
import org.apache.struts.action.ActionMessages;

import kignbi.dong.Constants;
import kignbi.dong.DB;
import kignbi.dong.*;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

/** 
 * MyEclipse Struts
 * Creation date: 01-28-2008
 * 
 * XDoclet definition:
 * @struts.action path="/userLogin" name="userLoginForm" input="/login.jsp" scope="request" validate="true"
 * @struts.action-forward name="success0_2" path="/main0_2.jsp"
 * @struts.action-forward name="false" path="/login.jsp"
 */
public class UserLoginAction extends Action {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response){
		   UserLoginForm userLoginForm = (UserLoginForm) form;// TODO Auto-generated method stub
		    String uid = userLoginForm.getUid();
			String upassword = userLoginForm.getUpassword();
			
			System.out.print("uid="+uid+":");
			System.out.print(" password:"+upassword+"");//nnnnnnnnnnnn
			
			
			HttpSession session = request.getSession(true);
			ActionMessages errors = new ActionMessages();
			String PageForward = "false";
			ServletContext context = servlet.getServletContext();
			DataSource dataSource = (DataSource) context.getAttribute(Constants.DATASOURCE_KEY);
			DB db = new DB(dataSource);
			String sql="select * from users  where uid=dbo.trim('"+uid
			+"') and upassword='"+upassword+"'";
			
			try{ ResultSet rs=db.OpenSql(sql);
			     if(rs.next())
			     {String  ugrade=rs.getString("ugrade");
			      System.out.print("uid="+uid+":");
			      System.out.print("ugrade="+ugrade+":");
			      ArrayList re=new ArrayList();
			      Users user=new Users();
			      user.setUid(rs.getString(2));
			      user.setUname(rs.getString(3));
			      user.setUpassword(rs.getString(4));
			      user.setUsex(rs.getString(5));
			      user.setUclass(rs.getString(6));
			      user.setUgrade(rs.getString(7));
			      re.add(user);
			     if(ugrade.equals("0")){
			    	   session.setAttribute("user", re.get(0));
			    	   PageForward="success2";
			       }
			       else if(ugrade.equals("1")){
			    	   session.setAttribute("user", re.get(0));
						PageForward="success0";
			       }
			       else if(ugrade.equals("2")){
			    	   session.setAttribute("user", re.get(0));
						PageForward="success1";
			       } 
			     }
			else { 
				   errors.add(ActionMessages.GLOBAL_MESSAGE, new ActionMessage(
				   "error.login.failed"));
		      if (!errors.isEmpty()) {
			     saveErrors(request, errors);
			    } 
			}
		}
	  catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		    }
			db.close();
			return mapping.findForward(PageForward);
	}
}