logincheck.java

来自「留言簿架构 oracle 9i + jsp + struts 留言」· Java 代码 · 共 72 行

package com.guestbook.action.admin;

import java.io.IOException;
import java.io.PrintWriter;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.struts.action.*;

import javax.servlet.http.*;

import java.sql.*;
import java.util.*;

import com.guestbook.action.Index;
import com.guestbook.sys.*;

import javax.servlet.*;
import java.io.*;
import oracle.jdbc.driver.*;
import oracle.sql.*;

import com.guestbook.form.LoginForm;

public class LoginCheck extends Action
{
	private static final Log logger = LogFactory.getLog( LoginCheck.class );
	
	public ActionForward execute(ActionMapping actionMapping,
            ActionForm actionForm,
            HttpServletRequest request,
            HttpServletResponse response )
	{
		request.setAttribute( "dynamicParameter", SysInfo.getInstance().getDynamicParameter() ); 
		
		LoginForm form = ( LoginForm ) actionForm;
		form.setPassword( MD5.getMD5Str( form.getPassword() ) );
		
		try
		{
			Connection conn = DataBaseConnection.getConnection();
			CallableStatement stmt = conn.prepareCall("{  call ? := pkg_adminInfo.p_validateLogin(?,?) }");
			stmt.registerOutParameter( 1, OracleTypes.INTEGER );			
			stmt.setString( 2, form.getUserName() );
			stmt.setString( 3, form.getPassword() );
			stmt.executeQuery();
			int rowCount = stmt.getInt( 1 );
			
			stmt.close();
			conn.close();
			
			if( rowCount == 0 )
			{
				//response.sendRedirect( "/admin/index.do" );
				request.getSession().setAttribute( "loginSuccess" , "true");
				return actionMapping.findForward("/admin/index");
			}
			else
			{
				return actionMapping.findForward("login");
			}

		}
		catch( Exception exp )
		{
			logger.error( exp );
		}
		
		return actionMapping.findForward("login");
	}
}