goodstypeinfosave.java

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

package com.logistic.servlet;

import java.io.IOException;
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 javax.servlet.RequestDispatcher;
import java.sql.Statement;
import java.sql.ResultSet;
import com.logistic.data.DataConnect;
import com.logistic.business.GoodsTypeManager;

public class GoodsTypeInfoSave extends HttpServlet {

	private static final long serialVersionUID=-2305260907601477327L;
	HttpSession session;
	Statement   stat=null;
	ResultSet   rs=null;
	DataConnect dc=new DataConnect();
	RequestDispatcher requestdispatcher;
	
	int id=0;
	int flag=0;
	String typeid=null;
	String typename=null;
	String categoryid=null;

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		
		request.setCharacterEncoding("GB2312");
		response.setContentType("text/html; charset=gb2312");
		session=request.getSession();
/*--------取得goodsinfotable表的GoodsId并转换成整型，并生成下条记录的GoodsId-------*/		
		String sql="select * from typetable order by ID desc limit 1";
		try{
			stat=dc.getStmtread();
			rs  =stat.executeQuery(sql);
			rs.previous();
			while(rs.next()){
				id=Integer.valueOf(rs.getInt("TypeId"));
			}
			if(id>0){
				id+=1;
			     }else{
				    id=10000+1;
			         }
			
		}catch(Exception ex){
			ex.printStackTrace();
		}finally{dc.close();}	
		
/*-------------取得页面goodstypeinfosave.jsp提交的数据，进行验证合法后插入数据------------*/
		typeid=String.valueOf(id);
		typename=(String)request.getParameter("goodsname");
		categoryid=(String)request.getParameter("goodstype");
		
		if(typeid==null||typename==null||categoryid==null){
			
			session.setAttribute("errors", "商品型号数据添加失败，*标识选项必须填写!");
			requestdispatcher=request.getRequestDispatcher("/errors/errorpage.jsp");
			requestdispatcher.forward(request, response);
		 }else{
			 try{
				  flag=-10;
				  GoodsTypeManager gtm=new GoodsTypeManager();
				  flag=gtm.AddGoodsType(typeid, typename, categoryid);
					if(flag>0){
						session.setAttribute("success","商品型号数据添加成功!");
						requestdispatcher=request.getRequestDispatcher("/viewpage/datainput/goodstypeinfosave.jsp");
						requestdispatcher.forward(request,response);
					}else{
						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);

	}

}