loginaction.java

基于j2ee中structs写软件

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

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

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 com.util.DB;
import com.yourcompany.struts.form.LoginForm;

/** 
 * MyEclipse Struts
 * Creation date: 11-05-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
	 * @throws IOException 
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws IOException {
		LoginForm loginForm = (LoginForm) form;// TODO Auto-generated method stub
		String id=loginForm.getId();
		String password=loginForm.getPassword();
		String check=loginForm.getCheck();
		String CONTENT_TYPE="text/html;charset=GB2312";
		response.setContentType(CONTENT_TYPE);
		PrintWriter out=response.getWriter();
		try{
			DB db=new DB();
			Connection conn=db.getConnection();
			Statement sm=conn.createStatement();
			String sql="select * from user where userId='"+id+"'";
			ResultSet rs=sm.executeQuery(sql);
			if(rs.next()){
				if(password.equals(rs.getString("userPassword"))){
					if(check.equals(rs.getString("userFlag"))){
						if(check.equals("0")){
						    return mapping.findForward("find");
						}
						else{
							return mapping.findForward("manager");
						}
						
					}
					else{
						out.println("<script language=javascript>alert('登入类型不正确!')");
						out.println("location.href='login.jsp'</script>");
					}
				}
				else{
					out.println("<script language=javascript>alert('登入密码不正确!')");
					out.println("location.href='login.jsp'</script>");
				}
			}
			else{
				out.println("<script language=javascript>alert('此用户不存在!')");
				out.println("location.href='login.jsp'</script>");
			}
			conn.close();
		}catch(SQLException e){
			return mapping.findForward("login");
		}
		return null;

	}
}