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

public class SupplyInfoUpdate extends HttpServlet {


	private static final long serialVersionUID = -2305260907601477327L;
	HttpSession session=null;
	DataConnect dc=new DataConnect();
	Statement   stat=null;
	ResultSet   rs=null;
	String      sid=null;
	String      sname=null;
	String      scharge=null;
	String      saddress=null;
	String      sphone=null;
	String      smobile=null;
	String      sfax=null;
	String      semail=null;
	String      shttp=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();

//从页面supplymodify.jsp获取修改后的数据进行合法性判断然后更新数据库
		sid=(String)request.getParameter("sid");
		sname=(String)request.getParameter("supplyname");
		scharge=(String)request.getParameter("supplycharge");
		saddress=(String)request.getParameter("supplyaddress");
		sphone=(String)request.getParameter("supplyfixphone");
		smobile=(String)request.getParameter("supplymobile");	
		sfax=(String)request.getParameter("supplyfax");
		semail=(String)request.getParameter("supplyemail");
		shttp=(String)request.getParameter("supplyhttp");
		if(sname==null||scharge==null||saddress==null||sphone==null||smobile==null||sfax==null||semail==null){
			
			   session.setAttribute("errors", "供应商信息修改失败，*标识选项必须填写!");
			   requestdispatcher=request.getRequestDispatcher("/errors/errorpage.jsp");
			   requestdispatcher.forward(request, response);
			
		}else{
			
			try{
				int flag=-10;
				SupplyManager sm=new SupplyManager();
				flag=sm.ModifySupply(sid, sname, scharge, saddress, sphone, smobile, sfax, semail, shttp);
				if(flag>0){
				       session.setAttribute("success", "供应商信息修改成功!");
				       requestdispatcher=request.getRequestDispatcher("/viewpage/showpage/adminsupply.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);
    }

}