batchguestlistdel.java

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

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 BatchGuestListDel extends Action
{
	private static final Log logger = LogFactory.getLog( BatchGuestListDel.class );
	
	public ActionForward execute(ActionMapping actionMapping,
            ActionForm actionForm,
            HttpServletRequest request,
            HttpServletResponse httpServletResponse)
	{

		if( request.getSession().getAttribute( "loginSuccess" ) == null )
		{
			return actionMapping.findForward( "notLogin" );
		}
		
		String[] guestListId = request.getParameterValues( "guestListId" );
		
		try
		{
			Connection conn = DataBaseConnection.getConnection();
			PreparedStatement pstm = conn.prepareStatement( "delete t_guestInfo where id = ?" );
			for( int i = 0 ; i < guestListId.length ; i++ )
			{
				pstm.setInt( 1, Integer.parseInt( guestListId[ i ].trim() ) );
				pstm.executeUpdate();
			}
			
			conn.commit();
		}
		catch( Exception exp )
		{
			logger.error( exp );
		}
		
		return actionMapping.findForward("/admin/index");
	}
}