saverevertguestinfo.java

留言簿架构 oracle 9i + jsp + struts 留言簿基本功能： 1 、客人签写留言 2 、基本的UBB支持

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.*;

import com.guestbook.form.LeaveWordForm;
import com.guestbook.form.RevertGuestInfoForm;

public class SaveRevertGuestInfo extends Action
{
	private static final Log logger = LogFactory.getLog( SaveRevertGuestInfo.class );
	
	public ActionForward execute(ActionMapping actionMapping,
            ActionForm actionForm,
            HttpServletRequest request,
            HttpServletResponse response)
	{
		response.setCharacterEncoding( "gb2312" );
		
		if( request.getSession().getAttribute( "loginSuccess" ) == null )
		{
			return actionMapping.findForward( "notLogin" );
		}
		
		
		RevertGuestInfoForm form = ( RevertGuestInfoForm )actionForm;
		

			try
			{

				PrintWriter out = response.getWriter();
				if( saveRevert( form ) )
				{
					out.println( "<script>alert('修改成功！');window.close();</script>" );
				}
				else
				{
					out.println( "<script>alert('修改失败！');window.close();</script>" );
				}
			}
			catch( Exception exp )
			{
				logger.error( exp );
			}
		
		return null;
	}
	
	private boolean saveRevert( RevertGuestInfoForm form )
	{
		try
		{
			Connection conn = DataBaseConnection.getConnection();
			CallableStatement cstm = conn.prepareCall( "{call pkg_guestInfo.p_guestInfo_Reply(?,?,?)}" );
			cstm.setInt( 1 , form.getId() );		
			cstm.setString( 2 , form.getGuestReply() );
			cstm.registerOutParameter( 3, OracleTypes.INTEGER );
			cstm.executeUpdate();
			
			int out_return = cstm.getInt( 3 );

			cstm.execute();
			cstm.close();
			conn.close();
			
			if( out_return == 0 )
			{
				return true;
			}
			else
			{
				return false;
			}
		}
		catch( Exception exp )
		{
			logger.error( exp );
			return false;
		}
	}	
}