customerrecorddetailaction.java

基于struts的网上商店源码

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.mole.struts.action;

import java.util.ArrayList;

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 com.mole.struts.bean.CustomerRecordCommentBean;
import com.mole.struts.dao.DBConnector;

/**
 * MyEclipse Struts Creation date: 12-17-2007 Creator: Li Bin XDoclet
 * definition:
 * 
 * @struts.action validate="true"
 * @struts.action-forward name="goDetail" path="/customerRecordDetail.jsp"
 */
public class CustomerRecordDetailAction 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
		DBConnector dbc = new DBConnector();
		String swiftID = request.getParameter("swiftID");
		ArrayList<Object[]> list = null;
		CustomerRecordCommentBean bean = null;
		String sql = "SELECT distinct a.[StoreName],b.[GoodsName],b.[Amount],convert(numeric(10,2),b.[NominalPrice]),b.[FactPrice],b.[Discount],convert(char(20),a.[dealTime],120) FROM [v_CustomerRecord] a,[v_BusinessRecordDetail] b WHERE b.[SwiftID]=? AND a.[ID]=b.[SwiftID]";
		String sql1 = "SELECT a.[CommentContext],a.[ReleaseDate],a.[Grade] from RecordComment a where swiftid="
				+ swiftID;
		try {
			list = dbc.executeQuery(sql, swiftID);
			bean = dbc.getComment(sql1);
		} catch (Exception e) {
			e.printStackTrace();
		}
		request.setAttribute("RecordOfSwift", swiftID);
		request.setAttribute("RecordDetail", list);
		request.setAttribute("CommentBean", bean);
		return mapping.findForward("goDetail");
	}
}