carteaminfosave.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.RequestDispatcher;
import javax.servlet.http.HttpSession;
import java.sql.ResultSet;
import java.sql.Statement;
import com.logistic.business.CarTeamManager;
import com.logistic.data.DataConnect;

public class CarTeamInfoSave extends HttpServlet {

	private static final long serialVersionUID = -2305260907601477327L;
	DataConnect dc=new DataConnect();
	HttpSession session;
	Statement   stat=null;
	ResultSet   rs=null;
	RequestDispatcher requestdispatcher;
	int         id=0;
	String       carteamid=null;
	String       carteamname=null;
	String       chargeid=null;
	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		request.setCharacterEncoding("GB2312");
		response.setContentType("text/html;charset=gb2312");
		session=request.getSession();
		
/*--------取得carteaminfotable表的CarTeamId并转换成整型，并生成下条记录的CarTeamId-------*/		
		String sql="select * from carteaminfotable order by ID desc limit 1";
		try{
			stat=dc.getStmtread();
			rs  =stat.executeQuery(sql);
			rs.previous();
			while(rs.next()){
				id=Integer.valueOf(rs.getInt("CarTeamId"));
			}
			if(id>0){
				id+=1;
			     }else{
				    id=10000+1;
			         }
			
		}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}		
		
/*-------------从carteaminfosave.jsp页面取得所提交的数据，进行检验合法后插入数据库---------*/
		carteamid=String.valueOf(id);
		carteamname=request.getParameter("carteamname");
		chargeid=request.getParameter("chargeid");
		
		if(carteamname==null||chargeid==null){
			session.setAttribute("errors","车队信息添加失败，*标识项必须填写!");
			requestdispatcher=request.getRequestDispatcher("/errors/errorpage.jsp");
			requestdispatcher.forward(request, response);
		}else{
			
			try{
				int flag=-10;
				CarTeamManager ctm=new CarTeamManager();
				flag=ctm.AddCarTeam(carteamid, carteamname, chargeid);
				if(flag>0){
					session.setAttribute("success", "车队信息添加成功!");
					requestdispatcher=request.getRequestDispatcher("/viewpage/datainpug/carteaminfosave.jsp");
		  			requestdispatcher.forward(request, response);
				}else{
		  			session.setAttribute("errors", " 车队信息添加失败!");
		  			requestdispatcher=request.getRequestDispatcher("/errors/errorpage.jsp");
		  			requestdispatcher.forward(request, response);
				}
								
			}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
		}
		
	}
	
	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {

		doPost(request,response);
    
	}

}