updatenote.java

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

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


import com.guestbook.form.*;
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 com.guestbook.sys.*; 

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;


/** 
 * MyEclipse Struts
 * Creation date: 09-19-2007
 * 
 * XDoclet definition:
 * @struts.action path="/admin/updatenote" name="NoteAdmin" scope="request" validate="true"
 * @struts.action-forward name="/admin/notemanage" path="/admin/notemanage.do" redirect="true"
 */
public class updatenote 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) {
		if( request.getSession().getAttribute( "loginSuccess" ) == null )
		{
			return mapping.findForward( "notLogin" );
		}
		
		NoteAdmin noteAdmin = (NoteAdmin) form;// TODO Auto-generated method stub
		updateNotes(noteAdmin.getTitle(),noteAdmin.getGuestcontent());
		
		SysInfo.getInstance().LoadBulletinInfoConfig();
		
		return mapping.findForward("/admin/notemanage");
	}
	
	private static Log logger=LogFactory.getLog(updatenote.class);
	
	/**
	 * 更新公告
	 * @param title
	 * @param content
	 */
	private void updateNotes(String title,String content){
		Connection con=null;
		CallableStatement stmt=null;
		try{ 
			con=DataBaseConnection.getConnection();
            stmt=con.prepareCall("{call pkg_guestadmin.p_u_bulletininfo(?,?)}");
            stmt.setString(1, title);
            stmt.setString(2, content); 
            stmt.execute();
		}
		catch(Exception ex){
			logger.error("\n----------noteupdate ERROR!----------\n");
			logger.error(ex.getMessage());
			logger.error("\n----------noteupdate ERROR!----------\n");
			
		}
		finally{
			try{
			   stmt.close();
			   con.close();	
			}
			catch(Exception ex){
				logger.error("\n----------noteupdate Close ERROR!----------\n");
				logger.error(ex.getMessage());
				logger.error("\n----------noteupdate Close ERROR!----------\n");					
			}
			
		}
	}
}