package com.css.struts.action;
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 org.apache.struts.util.MessageResources;
import org.apache.struts.validator.DynaValidatorForm;
import java.sql.*;
import ycj.database.*;
/**
* Creation date: 02-27-2006
*
* XDoclet definition:
* @struts.action path="/input" name="inputForm" input="/form/input.jsp" scope="request" validate="true"
* @struts.action-forward name="InputSuccess" path="/in.jsp" redirect="true"
* @struts.action-forward name="StyleError" path="/input.jsp" redirect="true"
*/
public class InputAction extends Action {
// --------------------------------------------------------- Instance Variables
// --------------------------------------------------------- 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 dvForm = (DynaValidatorForm)form;
String source=dvForm.getString("source");
double price=Double.parseDouble(dvForm.getString("price"));
String sort=dvForm.getString("sort");
DataAccess dba=new DataAccess(Database.MYSQL);
String sql="insert into T_C(F_NS,F_Price,F_IN,F_Sort) values('"+source+"',"+price+",1,'"+sort+"')";
MessageResources mr = this.getResources(request);
String host=mr.getMessage("MySQL.host");
String database=mr.getMessage("MySQL.database");
String username=mr.getMessage("MySQL.username");
String password=mr.getMessage("MySQL.password");
try{
dba.setConnection(host,database,username,password);
dba.executeUpdate(sql);
dba.closeDatabase();
}catch(SQLException e){
throw new RuntimeException(sql);
}
return mapping.findForward("InputSuccess");
}
}
说明:
MessageResources.getMessage(资源文件中的key关键字);