loginaction.java

理发店网上发型设计预约系统

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

import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
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 barbershop.database.DBSQLManager;
import barbershop.*;
import barbershop.struts.form.LoginForm;

/** 
 * MyEclipse Struts
 * Creation date: 12-17-2008
 * 
 * XDoclet definition:
 * @struts.action path="/login" name="loginForm" input="/login.jsp" scope="request" validate="true"
 */
public class LoginAction 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) {
		LoginForm loginForm = (LoginForm) form;// TODO Auto-generated method stub
		DBSQLManager dbsm = new DBSQLManager();
		try
		{
		String vipUser = loginForm.getVipUser();
		String vipPwd = loginForm.getVipPwd();
		String sql = "select * from tb_vip where VIP_USER='"+vipUser+"' and VIP_PWD='"+vipPwd+"'";
		dbsm.setSqlStr(sql);
		dbsm.executeQuery();
		ResultSet rs =  dbsm.getRs();
		if(!rs.next())
		{
			return mapping.findForward("failure");
		}
		else
		{
			String vipName = rs.getString("VIP_NAME");
			String vipSex = rs.getString("VIP_SEX");
			String vipTel = rs.getString("VIP_TEL");
			User vip = new User(vipUser,vipName,vipSex,vipTel);
			Order order = new Order();
			order.setVip(vip);
			request.getSession().setAttribute("vip", vip);
			request.getSession().setAttribute("order", order);
			
			request.getSession().setAttribute("vipEnter", "true");
			return mapping.findForward("success");
		}
		}
		catch(Exception e)
		{
			return mapping.findForward("failure");
		}
		finally
		{
			try
			{
				dbsm.close();
			}
			catch(SQLException se)
			{
				se.printStackTrace();
			}
			
		}
	}
}