getsaleinfo.java

基于struts的网上商店源码

package com.mole.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.mole.struts.dao.DBConnector;

public class getSaleInfo extends HttpServlet {
	private static final String CONTENT_TYPE = "text/html; charset=UTF-8";
	private HttpServletRequest request;
	private HttpServletResponse response;
	private DBConnector dbc = new DBConnector();

	/**
	 * Constructor of the object.
	 */
	public getSaleInfo() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * The doPost method of the servlet. <br>
	 * 
	 * This method is called when a form has its tag value method equals to
	 * post.
	 * 
	 * @param request
	 *            the request send by the client to the server
	 * @param response
	 *            the response send by the server to the client
	 * @throws ServletException
	 *             if an error occurred
	 * @throws IOException
	 *             if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("UTF-8");
		response.setContentType(CONTENT_TYPE);
		this.request = request;
		this.response = response;
		String action = request.getParameter("action");
		if ("1".equals(action))
			getUserInfo(request.getParameter("name"), request
					.getParameter("store"), request.getParameter("pass"));
		else if ("2".equals(action))
			getVoucherInfo(request.getParameter("userid"), request
					.getParameter("store"));
		else if ("3".equals(action))
			getBizGroupDiscount(request.getParameter("user"), request
					.getParameter("store"));
		else if ("4".equals(action))
			getGoodsType(request.getParameter("store"));
		else if ("5".equals(action))
			getGoodsName(request.getParameter("store"), request
					.getParameter("type"));
	}

	/**
	 * Initialization of the servlet. <br>
	 * 
	 * @throws ServletException
	 *             if an error occurs
	 */
	public void init() throws ServletException {
		// Put your code here
	}

	public void getUserInfo(String name, String store, String pass) {
		if (name.length() > 0 && pass.length() > 0) {
			ArrayList<Object[]> al = null;
			String sql = "SELECT TOP 1 a.[CustomerID],a.[CustomerName],a.[Score],b.[Discount] FROM "
					+ "[v_CustomerScore] a,[ScoreDiscount] b WHERE a.[StoreID]=? AND a.[Password]=? "
					+ "AND (a.[LoginName]=? OR a.[CardID]=?) AND b.[Score]<=a.[Score] ORDER BY b.[Score] DESC";
			try {
				al = dbc.executeQuery(sql, store, pass, name, name);
				output(al);
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
	}

	public void getVoucherInfo(String userid, String store) {
		if (userid.length() > 0 && store.length() > 0) {
			ArrayList<Object[]> al = null;
			String sql = "SELECT a.[ID],b.[Name],a.[Amount]-a.[UsedAmount],b.[Discount] FROM [CustomerVoucher] a,"
					+ "[MerchantVoucher] b WHERE a.[VoucherID]=b.[ID] AND a.[CustomerID]=? AND b.[StoreID]=?";
			try {
				al = dbc.executeQuery(sql, userid, store);
				output(al);
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
	}

	public void getBizGroupDiscount(String user, String store) {
		if (user.length() > 0 && store.length() > 0) {
			ArrayList<Object[]> al = null;
			try {
				al = dbc.executeStoredProcedure(
						"sp_GetBizGroupScoreDiscount(?,?)", user, store);
				output(al);
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
	}

	public void getGoodsType(String storeID) {
		ArrayList<Object[]> al = null;
		String sql = "SELECT DISTINCT [GoodsTypeName],[GoodsTypeID] "
				+ "FROM [v_StoreGoods] WHERE [Amount]>0 AND [StoreID]=?";
		try {
			al = dbc.executeQuery(sql, storeID);
			output(al);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public void getGoodsName(String storeID, String typeID) {
		ArrayList<Object[]> al = null;
		String sql = "SELECT DISTINCT [Name],[ID],[Price],[Amount] FROM [v_StoreGoods] "
				+ "WHERE [Amount]>0 AND [StoreID]=? AND [GoodsTypeID]=?";
		try {
			al = dbc.executeQuery(sql, storeID, typeID);
			output(al);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public void output(ArrayList<Object[]> al) {
		if (al != null && al.size() > 0) {
			StringBuilder sb = new StringBuilder();
			for (int i = 0; i < al.size(); i++) {
				Object[] obj = al.get(i);
				for (Object o : obj) {
					sb.append(o.toString() + ",");
				}
			}
			String str = sb.substring(0, sb.length() - 1);
			System.out.println(str);
			try {
				PrintWriter out = response.getWriter();
				out.print(str);
				out.flush();
				out.close();
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
	}

}