updatesysconfig.java

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

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

import com.guestbook.sys.*;

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 com.guestbook.form.*;
/** 
 * MyEclipse Struts
 * Creation date: 09-16-2007
 * 
 * XDoclet definition:
 * @struts.action validate="true"
 */
public class updatesysconfig 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" );
		}
		SysConfigForm sform=  (SysConfigForm)form;
		   
		updateSysConfig(sform);
		SysInfo.getInstance().LoadSystemConfig();
		return  mapping.findForward("/admin/updatesysconfig"); 
	}
	private  boolean updateSysConfig(SysConfigForm form)   { 
	  try
			{ 
		        logger.error("update sysconfig start" );
				Connection conn = DataBaseConnection.getConnection();
				CallableStatement cstm = conn.prepareCall( "{call pkg_guestadmin.p_u_systemconfig(?,?,?,?,?,?,?,?,?,?,?,?,?)}" );
				cstm.setInt ( 1 , form.getId() );		//in_guestname
				//logger.error("form.getId():"+form.getId()+"\n");
				cstm.setString( 2 , form.getGuestbookname()  );	
				//logger.error("form.getGuestbookname():"+form.getGuestbookname()+"\n");
			 
				cstm.setString( 3 , form.getWebsiteurl() );	//in_comefromCity
				//logger.error("form.getWebsiteurl():"+form.getWebsiteurl()+"\n");
				cstm.setInt( 4 , form.getPagesize()  );			//in_face
				//logger.error("form.getPagesize():"+form.getPagesize()+"\n");
				
				cstm.setString( 5 , form.getCopyright()  );		//in_guestcontent
				//logger.error("form.getCopyright():"+form.getCopyright()+"\n");
				cstm.setString( 6 , form.getVersionnumber()  );			//in_oicq
				//logger.error("form.getVersionnumber():"+form.getVersionnumber()+"\n");
				cstm.setInt( 7 , form.getAuditing()  );			//in_email
				//logger.error("form.getAuditing():"+form.getAuditing()+"\n");
				cstm.setInt( 8 , form.getFacepic() );		//in_homepage.
				//logger.error("form.getFacepic():"+form.getFacepic()+"\n");
				cstm.setInt( 9 , form.getUbbpic() );	
				//logger.error("form.getUbbpic():"+form.getUbbpic()+"\n");
				 
				cstm.setInt( 10 , form.getSecretly() );		//in_secretly
				//logger.error("form.getSecretly():"+form.getSecretly()+"\n");
				
				cstm.setInt( 11 , form.getDisplaystyle());				//in_ip
				//logger.error("form.getDisplaystyle():"+form.getDisplaystyle()+"\n");
			
				cstm.setInt( 12 , form.getLeavewordlength() );		//in_secretly
				//logger.error("form.getLeavewordlength():"+form.getLeavewordlength()+"\n");
				
				cstm.setString( 13 , form.getFilterchar() );	 
				//logger.error("form.getFilterchar():"+form.getFilterchar()+"\n");
				cstm.execute();
				//logger.error("update sysconfig End" );
				cstm.close();
				conn.close();
				return true;
			}
			catch( Exception exp )
			{
				logger.error("update sysconfig Error" );
				logger.error( exp );
			}
		 
		return false;
	}
	private static final Log logger = LogFactory.getLog(Editsysconfig.class);

}