struts技术实现留言功能

/* * 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: 10-28-2008 * * 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;// TODO Auto-generated method stub String sql = "insert into guestbook(id,name,email,phone,title,content,time) values(gb_seq.nextval,?,?,?,?,?,?)"; String name = (String)f.get("name"); String email = (String)f.get("email"); String phone = (String)f.get("phone"); String title = (String)f.get("title"); String content = (String)f.get("content"); SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); String time = sdf.format(new Date()); String[] params = {name,email,phone,title,content,time}; try { Context context = new InitialContext(); DataSource ds = (DataSource)context.lookup("java:/comp/env/jdbc/oracleds"); //ds.getConnection(); QueryRunner qr = new QueryRunner(ds); int result = qr.update(sql, params); if(result==1) { System.out.println("插入数据成功!"); } for(int i=0; i<params.length; i++) { System.out.println(" "+params[i]); } } catch (NamingException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return mapping.findForward("guestbook.read"); } }