a01ae8790da7001c1a368d0f67fc12e2

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

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

import java.sql.SQLException;

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: 12-10-2007
 * 
 * XDoclet definition:
 * @struts.action path="/input" name="inputForm" input="/input.jsp" scope="request" validate="true"
 */
public class InputAction extends Action {
   
    /** 
     * Method execute
     * @param mapping
     * @param form
     * @param request
     * @param response
     * @return ActionForward
     */
    public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request,
	    HttpServletResponse response) {
	DynaValidatorForm inputForm = (DynaValidatorForm) form;// TODO Auto-generated method stub
	DataSource ds=null;
	String sql = "insert into guestbook (id,name,email,phone,title,content,time) values(gb_seq.nextval,?,?,?,?,?,?)";
	SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
	String param[] = { StringUtil.filterHtml(gb.getName()), StringUtil.filterHtml(gb.getEmail()),
	StringUtil.filterHtml(gb.getPhone()), StringUtil.filterHtml(gb.getTitle()), gb.getContent(),
	sdf.format(new java.util.Date()) };
	
	try {
		Context initContext = new InitialContext();
		ds = (DataSource) initContext.lookup("java:/comp/env/jdbc/oracleds");
	} catch (NamingException e) {
		e.printStackTrace();
	}
	
	
	QueryRunner qr = new QueryRunner(ds);
	try {
		qr.update(sql, null);
	} catch (SQLException e) {
		e.printStackTrace();
	}
	
//	List list = (List) db.query(sql,null, new BeanListHandler(Guestbook.class));
//	for (int i = 0; i < list.size(); i++) {
//		Guestbook gb = (Guestbook) list.get(i);
	
	return mapping.findForward("display");
    }	
}