lockip.java

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

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

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import java.sql.*;
import org.apache.commons.logging.*;
import com.guestbook.sys.*;
/** 
 * MyEclipse Struts
 * Creation date: 09-25-2007
 * 
 * XDoclet definition:
 * @struts.action validate="true"
 * @struts.action-forward name="/admin/index" path="/admin/index.do" redirect="true"
 */
public class LockIP 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 
	 
		banip(request.getParameter("ip"));
		SysInfo.getInstance().LoadBanIp();
		return mapping.findForward("/admin/index");
	} 
	
	private static Log logger=LogFactory.getLog(LockIP.class);
	
	private void banip(String ip){
		
		try
		{   
			Connection con=DataBaseConnection.getConnection();
			CallableStatement stmt=con.prepareCall("{call pkg_guestadmin.p_b_banip(?)}");
			stmt.setString(1,ip);
			stmt.execute();
			stmt.close();
			con.close();
		}catch(Exception ex){	
			
			logger.error("banip Error!");
			logger.error(ex.getMessage());
		}
	} 
	
}