loginaction.java

图书商城系统

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



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

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionErrors;
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 com.tang.foruse.GetConn;
import com.tang.struts.form.LoginForm;

/**
 * MyEclipse Struts Creation date: 05-17-2008
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 * @struts.action-forward name="failure" path="login.jsp"
 */
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) {
		// TODO Auto-generated method stub
		String target = "failure";
		LoginForm myform = (LoginForm) form;
		String username =  myform.getUsername();
		GetConn gc = new GetConn();
		Connection conn = null;
		PreparedStatement pstm = null;
		ResultSet rs = null;
		ActionErrors errors = new ActionErrors();
		conn = gc.GetConnectioon();
		String password = null;
		int id =0;
		try {
			pstm = conn
					.prepareStatement("select password,id from users where username='"+username+"'");
			rs = pstm.executeQuery();
			if (rs.next()) {
				password = rs.getString(1);
				id = rs.getInt(2);
			} 
			if(myform.getPassword().equals(password))
			{
				HttpSession session = request.getSession();
				session.setAttribute("user", myform.getUsername());
				session.setAttribute("userid",new Integer(id));
				session.setAttribute("password", myform.getPassword());
				target = "success";
			}else {
				ActionMessage msg = new ActionMessage("�û�������벻��ȷ", false);
				errors.add("login", msg);
				request.setAttribute(org.apache.struts.Globals.ERROR_KEY,
						errors);
				mapping.findForward(target);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally
		{
			try {
				if(rs!=null)
				{
					rs.close();
					rs = null;
				}
				if(pstm!=null)
				{
					pstm.close();
					pstm = null;
				}
				if(conn!=null&&!conn.isClosed()){
					conn.close();
					conn = null;
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return mapping.findForward(target);
	}
}