revertguestinfo.java

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

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.DataBaseUtil;
import com.guestbook.sys.DataBaseConnection;
import com.guestbook.sys.SysInfo;
import javax.servlet.*;
import java.io.*;
import oracle.jdbc.driver.*;
import oracle.sql.*;

public class RevertGuestInfo extends Action
{
	private static final Log logger = LogFactory.getLog( RevertGuestInfo.class );
	
	public ActionForward execute(ActionMapping actionMapping,
            ActionForm actionForm,
            HttpServletRequest request,
            HttpServletResponse httpServletResponse)
	{
		request.setAttribute( "dynamicParameter", SysInfo.getInstance().getDynamicParameter() );

		if( request.getSession().getAttribute( "loginSuccess" ) == null )
		{
			return actionMapping.findForward( "notLogin" );
		}
		
		int guestId = Integer.parseInt( request.getParameter( "id" ) );
		
		try
		{
			Connection conn = DataBaseConnection.getConnection();
			CallableStatement cstm = conn.prepareCall( "{ call pkg_guestInfo.p_guestInfo_ById(?,?) }" );
			cstm.setInt( 1, guestId );
			cstm.registerOutParameter( 2, OracleTypes.CURSOR );

			cstm.executeQuery();
			ResultSet rs = ( ( OracleCallableStatement ) cstm ).getCursor( 2 );
			
			Vector dataTable = DataBaseUtil.getDataTable( rs );
			
			rs.close();
			cstm.close();
			conn.close();

			request.setAttribute( "guestInfo" , dataTable );
		}
		catch( Exception exp )
		{
			logger.error( exp );
		}
		
		return actionMapping.findForward("/admin/revertGuestInfo");
	}
}