inputaction.java

来自「《v512工作室_Java高端培训系列视频》(Java JSP Servlet 」· Java 代码 · 共 69 行

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

import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Date;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;

import org.apache.commons.dbutils.QueryRunner;
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 org.apache.struts.validator.DynaValidatorForm;

/**
 * MyEclipse Struts Creation date: 11-13-2006
 * 
 * XDoclet definition:
 * 
 * @struts.action path="/input" name="inputForm" input="/input.jsp"
 *                scope="request" validate="true"
 */
public class InputAction 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) {
	DynaValidatorForm f = (DynaValidatorForm) form;
	String sql = "insert into guestbook (id,name,email,url,title,content,time) values(gb_seq.nextval,?,?,?,?,?,?)";
	
	SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd hh:MM:ss");
	
	String params[] = { (String) f.get("name"), (String) f.get("email"), (String) f.get("url"),
		(String) f.get("title"), (String) f.get("content"),sdf.format(new Date()) };
	try {
	    Context context = new InitialContext();
	    DataSource ds = (DataSource) context.lookup("java:/comp/env/jdbc/oracleds");
	    QueryRunner qr = new QueryRunner(ds);
	    qr.update(sql, params);
	} catch (NamingException e) {
	    e.printStackTrace();
	} catch (SQLException e) {	   
	    e.printStackTrace();
	}
	return mapping.findForward("guestbook.read");

    }
}