editsysconfig.java

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

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


import java.util.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse; 

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
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 com.guestbook.sys.SysInfo;
import java.sql.*;
  
import oracle.jdbc.*;

/**  
 * MyEclipse Struts
 * Creation date: 09-16-2007
 *  
 * XDoclet definition:
 * @struts.action validate="true"
 * @struts.action-forward name="success" path="/success.jsp"
 * @struts.action-forward name="failure" path="/failure.jsp"
 */
public class Editsysconfig extends Action {
	private static final Log logger = LogFactory.getLog(Editsysconfig.class);
	/*
	 * 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
		
		if( request.getSession().getAttribute( "loginSuccess" ) == null )
		{
			return mapping.findForward( "notLogin" );
		}
		request.setAttribute( "dynamicParameter", SysInfo.getInstance().getDynamicParameter() );
		try{
		  request.setAttribute( "Editsysconfig", this.getConfig()); 
		 
		}catch(Exception ex){
			logger.error( ex.getMessage() );
		} 
		 return mapping.findForward("/admin/editsysconfig"); 		   
	}
	
	private Hashtable  getConfig(){ 
		Hashtable  hashmap=new Hashtable (15); 
		try
		{
			Connection con=DataBaseConnection.getConnection();
			CallableStatement stmt=con.prepareCall("{call pkg_guestadmin.p_systemconfig(?)}");
			stmt.registerOutParameter(1, OracleTypes.CURSOR);
			stmt.execute();	
			ResultSet rs=((OracleCallableStatement)stmt).getCursor(1);
		 
			if(rs.next()){ 
				hashmap.put("ID",rs.getObject(1).toString());
				hashmap.put("GUESTBOOKNAME", (rs.getObject(2)!=null)?rs.getObject(2).toString():"");
				hashmap.put("WEBSITEURL",(rs.getObject(3)!=null)?rs.getObject(3).toString():""); 
		    	hashmap.put("PAGESIZE",  rs.getObject(4).toString() ); 
		    	hashmap.put("COPYRIGHT", (rs.getObject(5)!=null)?rs.getObject(5).toString():"");
			 	hashmap.put("VERSIONNUMBER",(rs.getObject(6)!=null)?rs.getObject(6).toString():"");
				hashmap.put("AUDITING", rs.getObject(7).toString());
				hashmap.put("FACEPIC",  rs.getObject(8).toString() );
				hashmap.put("UBBPIC",  rs.getObject(9).toString() );
				hashmap.put("SECRETLY",  rs.getObject(10).toString() ); 
				hashmap.put("DISPLAYSTYLE",  rs.getObject(11).toString() );	  
				hashmap.put("LEAVEWORDLENGTH",  rs.getObject(12).toString() ); 
				hashmap.put("FILTERCHAR", (rs.getObject(13)!=null)?rs.getObject(13).toString():"");
	 		} 
			
		}catch(Exception ex){
			logger.error(ex.getMessage());
		} 
        return hashmap; 
	} 
	 
}