stockinsave.java

基于J2EE的网络物流系统 用户操作： 1． 录入出库商品信息 2． 查询出库单信息 3． 录入入库商品信息 4． 查询入库单信息 5． 查询商品位置信息 6． 查询商品信息 7． 查

package com.logistic.servlet;

import java.io.IOException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.logistic.business.StockInManager;
import com.logistic.data.DataConnect;
import javax.servlet.http.HttpSession;
import java.sql.Statement;
import java.sql.ResultSet;
import java.util.Calendar;
import java.text.*;

public class StockInSave extends HttpServlet {
	
	private static final long serialVersionUID = -2305260907601477327L;
	HttpSession session=null;
	DataConnect dc=new DataConnect();
	Statement stat=null;
	ResultSet rs=null;
	int stockinid=0;				//商品入库单编号
	String id=null;
	String chargeid=null;			//负责人编号
	String   indate=null;			//入库日期
	String goodsid=null;			//商品编号
	String commodityid=null;		//商品分类编号
	String typeid=null;				//商品型号编号
	int    stockinnum=0;			//商品入库数量
	int    goodsnum=0;				//商品库存量
	String stockinmemo=null;		//商品入库备注信息
	int    flag=0;	
	RequestDispatcher requestdispatcher;
	
	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		
		request.setCharacterEncoding("GB2312");
		response.setContentType("text/html; charset=gb2312");
		session=request.getSession();
/*
 * 获取stockininfotable表的StockId字段的最后插入的值，生成下一条记录的StockInId
 * 字段的值！
 * 
 * */
		String sql="select * from stockininfotable order by ID desc limit 1";
		try{
		 stat=dc.getStmtread();
		 
         rs=stat.executeQuery(sql);
         rs.previous();
         while(rs.next()){
        	 stockinid=Integer.valueOf(rs.getString("StockInId"));
         	}
         	if(stockinid>0){
         		stockinid+=1;
         		}else{       	 
         			stockinid=10000+1;
         		}

		 }catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
		 
/* 进行数据类型转化，把stockinid（原为Int型）转化为String类型把stockinnum（原为String类型）转化为Int类型 */
 		 
		 try{
			 
			 id=String.valueOf(stockinid);
			 stockinnum=Integer.valueOf((String)request.getParameter("stockinnum"));
		
		    }catch(NumberFormatException ex){System.out.print("StockInNum类型转换错误！");ex.printStackTrace();}
		 
		 indate=(String)new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime()); //格式化系统时间格式
		 chargeid=(String)request.getParameter("stockincharge");//获得入库负责人编号
		 goodsid=(String)request.getParameter("stockinname");   //获得商品编号
		 commodityid=(String)request.getParameter("commodityid");//获得商品分类编号
		 typeid=(String)request.getParameter("goodstype");		//获得商品型号编号
		 stockinmemo=(String)request.getParameter("stockinmemo");//获得入库备注信息
		 
		 if((stockinnum==0||stockinnum<0)||chargeid==null||goodsid==null||typeid==null){			 
			   session.setAttribute("errors", "入库单数据添加失败，*标识选项必须填写!");
			   requestdispatcher=request.getRequestDispatcher("/errors/errorpage.jsp");
			   requestdispatcher.forward(request, response);
		 }
		 

		try{
			
			int flag_get=-10;   //查询商品信息表的flag_get标志
			int flag_update=-10;//更新商品信息表的flag_update标志
			//下面的sqlgoods,select语句的功能是：从数据表goodsinfotabl检索是否有符合goodsid,commodityid和typeid数据。
			String sqlgoods="select * from goodsinfotable  where GoodsId='"+goodsid+"'and GoodsCateId='"+commodityid+"'and TypeId='"+typeid+"'";
			flag_get=dc.selectdata(sqlgoods);
			
		    if(flag_get>0){
			 	
				try{
					 stat=dc.getStmtread();
			         rs=stat.executeQuery(sqlgoods);
			         rs.previous();
			         //取得商品库存数量
			         while(rs.next()){
			        	 goodsnum=Integer.valueOf(rs.getString("GoodsStockNumber"));
			         	}
			         //商品库存量＝原商品库存＋新入库量
			         goodsnum=goodsnum+stockinnum;
			         //更新商品信息表的商品库存量
			         flag_update=dc.updata("update goodsinfotable set GoodsStockNumber='"+goodsnum+"' where GoodsId='"+goodsid+"' and GoodsCateId='"+commodityid+"'and TypeId='"+typeid+"'");
			         //如果更新商品信息表成功，则添加商品入库信息
			         if(flag_update>0){
						 StockInManager sm=new StockInManager();
						 flag=sm.AddStockIn(id, indate, chargeid, goodsid, stockinnum, typeid, commodityid, stockinmemo);
						 //如果添加商品入库信息成功，则跳转到stockinsave.jsp页面
						 if(flag>0){
			        	  
							 session.setAttribute("success","入库单数据添加成功!");
							 requestdispatcher=request.getRequestDispatcher("/viewpage/datainput/stockinsave.jsp");
							 requestdispatcher.forward(request, response);
						 
						  }else{
						 //如果添加商品入库信息失败，则跳转到errorpage.jsp页面	  
							  session.setAttribute("errors", "入库单数据添加失败!");
							  requestdispatcher=request.getRequestDispatcher("/errors/errorpage.jsp");
							  requestdispatcher.forward(request, response);
						  }
						}
					 }catch(Exception ex){
						ex.printStackTrace();
					 }			 
			}else{
					//如果flag_get<=0（符合的商品信息不存在）跳转到errorpage.jsp
					session.setAttribute("errors","入库商品信息不存在，请先添加商品信息!");
					requestdispatcher=request.getRequestDispatcher("/errors/errorpage.jsp");
					requestdispatcher.forward(request, response);
		         }				 
		 }catch(Exception ex){ ex.printStackTrace();}
	}

	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {

		 doPost(request,response);
   }
}