editguestinfo.java

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

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

import com.guestbook.sys.*;

/** 
 * MyEclipse Struts
 * Creation date: 09-24-2007
 * 
 * XDoclet definition:
 * @struts.action validate="true"
 * @struts.action-forward name="/admin/editguestinfo" path="/"
 */
public class EditGuestInfo 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
		if( request.getSession().getAttribute( "loginSuccess" ) == null )
		{
			return mapping.findForward( "notLogin" );
		}
		
		request.setAttribute( "dynamicParameter", SysInfo.getInstance().getDynamicParameter() );
		int id=0;
		try
		{
			 id =Integer.parseInt(request.getParameter("id"));
			 request.setAttribute("guestinfo", getTable(id));
		  
		
		}catch(Exception ex){
			logger.info("id exceoption s");
			logger.info(ex.getMessage());
		}
		
		return mapping.findForward("/admin/editguestinfo");
	}
	
	private Hashtable getTable(int id){
		Hashtable tables=new Hashtable(2);
		//logger.error("Select leaveword info start");
		try
		{
			Connection con=DataBaseConnection.getConnection();
			CallableStatement stmt=con.prepareCall("{call pkg_guestadmin.p_getguestinfo(?,?)}");
			stmt.setInt(1, id);
			stmt.registerOutParameter(2, OracleTypes.CURSOR);
			stmt.execute();
			ResultSet rs=((OracleCallableStatement)stmt).getCursor(2);
			if(rs.next())
			{
				tables.put("id", (rs.getObject(1)!=null)?rs.getObject(1).toString():"0");
				//logger.error("tables.get(id):"+((tables.get("id")==null)?"sss":tables.get("id").toString()));
				tables.put("guestcontent", getClob(rs.getClob(6)));				
			}
			stmt.close();
			con.close();
			//logger.error("Select leaveword info end");
		}
		catch(Exception ex){
			logger.error("Select leaveword info err");
			logger.error(ex.getMessage());
		}
		
		return tables;
	}
	
	
	private String getClob(Clob clob) throws SQLException{
		if(clob!=null){
			return clob.getSubString(((long)1), ((int)(clob.length())));
		}
		
		return "";
	}
	
	private static Log logger=LogFactory.getLog(EditGuestInfo.class);
	
}