enterservlet.java

该源代码实现了系统的进货

package EnterServlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.*;
import java.util.Date;
import java.io.*;
import javax.servlet.*;

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

import operation.EnterOperation;
import dataBase.DataBase;

public class EnterServlet extends HttpServlet {
	public final static String jdkDateFormat="yyyy-MM-dd";

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

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

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @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 doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		response.setContentType("text/html");
		
	}

	/**
	 * 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("GB2312");
		response.setContentType("text/html;charset=gb2312");
		PrintWriter out=response.getWriter();
		EnterOperation eo=new EnterOperation();
		
		
		Date date=new Date();
		java.sql.Date sqldate = null;
		String year=request.getParameter("year");
		String month=request.getParameter("month");
		if(Integer.parseInt(month)<10)
			month="0"+month;
		String day=request.getParameter("day");
		if(Integer.parseInt(month)<10)
			day="0"+day;
		String realdate=year+"-"+month+"-"+day;
	    java.sql.Date maindate=java.sql.Date.valueOf(realdate);
		
		SimpleDateFormat dateFormat=new SimpleDateFormat(jdkDateFormat);
		try
		{
			 sqldate=new java.sql.Date(date.getTime());
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
		if(request.getParameter("EnterQuantity")!=""&&request.getParameter("EnterPrice")!="")
		{
		String  EnterID=eo.getEnterID();                                                  //得到商品编号
		String  ProviderName=request.getParameter("ProviderName");                        //得到供货厂家
		String  StockID=request.getParameter("StockID");                                  //得到批次编号
		String  ProductName=request.getParameter("ProductName");                          //得到商品名称
		int    EnterQuantity = Integer.parseInt(request.getParameter("EnterQuantity"));   //得到进货数量
		float  EnterPrice = Float.parseFloat(request.getParameter("EnterPrice"));         //得到进货成本价
		float  ProductPrice=Float.parseFloat(request.getParameter("ProductPrice"));       //得到商品成本价
		
		String EnterNotice=request.getParameter("EnterNotice");                           //得到进货单备注
		HttpSession session=request.getSession();
		String Chargeman=request.getParameter("chargeman");                               //得到经手人    
		float  EnterSum=EnterQuantity*EnterPrice;                                         //得到进货总金额
	//	java.sql.Date EnterDate=sqldate;                                                  //得到进货日期
		
		
		//应付单据相关信息
		String PartEnter=EnterID.substring(1,12);
		String ShouldPayID="SP"+PartEnter;                                                //得到应付编号
		float ShouldPaySum=EnterSum;                                                      //得到应付金额
		float LeaveSum=EnterSum;                                                          //得到剩余金额
		String ShouldPayNotice="";                                                        //得到应付备注
    //	java.sql.Date ShouldPayDate=sqldate;                                              //得到应付日期
		
	
		
		
		int  ProductID=eo.getProductID(ProductName);                                      //得到商品编号
		if(ProductID!=0)		 
		{
			if(!eo.checkStockID(ProductID))
			{
				eo.StockInsert(ProductID,0);
			}
			 eo.EnterInfoInsert(EnterID, StockID,ProductID, ProviderName,EnterQuantity, EnterPrice,ProductPrice, EnterSum, maindate, 
			 Chargeman, EnterNotice, ShouldPayID, ShouldPaySum, LeaveSum, maindate, ShouldPayNotice);
			 out.println("<script>alert('进货成功!');window.location.href='Entering.jsp';</script>");
			
		}
		else
			out.println("<script>alert('没有该商品');window.location.href='Entering.jsp';</script>");
		eo.Close();
		}
		else
		{
			out.println("<script>alert('单价和数量不能为空!');window.location.href='Entering.jsp';</script>");
		}
		
	}

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

}