jobsinfosave.java

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

package com.logistic.servlet;

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

public class JobsInfoSave extends HttpServlet {


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

		request.setCharacterEncoding("GB2312");
		response.setContentType("text/html; charset=gb2312");
		session=request.getSession();
		
/*
* 获取Jobsinfotable表的JobsId字段的最后插入的值，生成下一条记录的JobsId
* 字段的值！
* */
		String sql="select * from jobsinfotable order by ID desc limit 1";
		try{
			stat=dc.getStmtread();				 
		    rs=stat.executeQuery(sql);
		    rs.previous();
		       while(rs.next()){
		        	 id=Integer.valueOf(rs.getString("JobsId"));
		         	 }
		         	if(id>0){
		         		id+=1;
		         		}else{
		         			id=1000+1;
		         		}

			}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
     
//从页面获取参数进行添加操作
	   jobsid=String.valueOf(id);
	   jobsname=(String)request.getParameter("jobsname");  //取得职务名称
	   jobsdescrible=(String)request.getParameter("jobsdescrible");
	   
	   if(jobsname==null){
		   
		   session.setAttribute("errors", "职务名称必须填写!");
		   requestdispatcher=request.getRequestDispatcher("/errors/errorpage.jsp");
		   requestdispatcher.forward(request, response);
	   }else{
		   
		  try{ 
			  	JobsManager jm=new JobsManager();
			  	flag=jm.AddJobs(jobsid, jobsname, jobsdescrible);
		   
			  	if(flag>0){
			  			requestdispatcher=request.getRequestDispatcher("/viewpage/showpage/adminjobsinfo.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);
    }

}