masterindex.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.util.*;
import java.sql.*;
import oracle.sql.*;
import oracle.jdbc.driver.*;

import com.guestbook.sys.*;

import org.apache.commons.logging.*;

/** 
 * MyEclipse Struts
 * Creation date: 09-23-2007
 * 
 * XDoclet definition:
 * @struts.action validate="true"
 * @struts.action-forward name="/index" path="d"
 */
public class MasterIndex extends Action {
	/*
	 * Generated Methods
	 */

	private static Log logger =LogFactory.getLog(MasterIndex.class);
	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		if( request.getSession().getAttribute( "loginSuccess" ) == null )
		{
			return mapping.findForward( "notLogin" );
		}
		
		request.setAttribute( "dynamicParameter", SysInfo.getInstance().getDynamicParameter() );
		 request.setAttribute("masterinfo", getTable() ); 
		 
		 return mapping.findForward("/admin/masterindex");
	}
	
	private Hashtable getTable(){
		logger.error(" start Master!");
		Hashtable tables=new Hashtable();
		try{
		   Connection con=DataBaseConnection.getConnection();
		   CallableStatement stmt=con.prepareCall("{call pkg_guestadmin.p_getmasterinfo(?)}");
		   stmt.registerOutParameter(1, OracleTypes.CURSOR);
		   stmt.execute();
		   logger.error(" exec  Master!");
		   ResultSet rs=((OracleCallableStatement)stmt).getCursor(1);
		   if(rs.next()){ 
			   tables.put("id", rs.getObject(1).toString());
			   tables.put("nickname",( rs.getObject(2)!=null)?rs.getObject(2).toString():"");
			   tables.put("oid", (rs.getObject(3)!=null)?rs.getObject(3).toString():"");
			   tables.put("qq", (rs.getObject(4)!=null)?rs.getObject(4).toString():"" ); 
			   tables.put("mail", (rs.getObject(5)!=null)?rs.getObject(5).toString():"");
			   tables.put("msn", (rs.getObject(6)!=null)?rs.getObject(6).toString():"");
			   tables.put("icq", (rs.getObject(7)!=null)?rs.getObject(7).toString():"");
			   tables.put("homepage", (rs.getObject(8)!=null)?rs.getObject(8).toString():"");
			   tables.put("explain", getClob(rs.getClob(9)));		   
		   }
		} 
		catch(Exception ex){
			logger.error("\nGetTable Error MasterInfo ERROR!\n");
			logger.error(ex);
		}
		return tables;		
	}
	
	private String getClob(Clob clob) throws SQLException{
		if(clob!=null){
			return clob.getSubString(((long)1), ((int)(clob.length())));
		}
		return "";
	}
}