updatemaster.java

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

/*
 * 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 com.guestbook.form.MasterForm;

import java.sql.*;
import com.guestbook.sys.*;
import org.apache.commons.logging.*;
/** 
 * MyEclipse Struts
 * Creation date: 09-23-2007
 * 
 * XDoclet definition:
 * @struts.action path="/admin/updatemaster" name="MasterForm" scope="request" validate="true"
 * @struts.action-forward name="/index" path="/admin/masterindex.do" redirect="true"
 */
public class UpdateMaster 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" );
		}
		updateMaster((MasterForm) form); 
		return mapping.findForward("/admin/updatemaster");
		
	}
	
	private void updateMaster(MasterForm form){
		try{   
			Connection con=DataBaseConnection.getConnection();
			CallableStatement stmt=con.prepareCall("{call pkg_guestadmin.p_u_masterinfo(?,?,?,?,?,?,?,?,?)}");
			stmt.setInt(1, form.getId());
			stmt.setString(2, form.getNickname());
			stmt.setString(3, form.getOid()); 
			stmt.setString(4, form.getQq());
			stmt.setString(5, form.getMail());
			stmt.setString(6, form.getMsn());
			stmt.setString(7, form.getIcq());
			stmt.setString(8, form.getHomepage());
			stmt.setString(9, form.getExplain());
			stmt.execute(); 
			stmt.close();
			con.close();
		}catch(Exception ex){
			logger.error("\n MasterUpdate Exception!\n");
			logger.error(ex.getMessage());
		}
	}
	
	private static Log logger=LogFactory.getLog(UpdateMaster.class);
}