?? warehouseinfosave.java
字號:
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.WareHouseManager;
import java.sql.Statement;
import java.sql.ResultSet;
public class WareHouseInfoSave 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 warehouseid;
String warehousename;
String chargeid;
String warehouseadd;
RequestDispatcher requestdispatcher;
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("GB2312");
response.setContentType("text/html; charset=gb2312");
session=request.getSession();
/*---------------------取得倉庫信息表中的最有一條記錄的WareHouseId值,并生成下條記錄的WareHouseId-------------------*/
String sql="select * from warehouseinfotable order by ID desc limit 1";
try{
stat=dc.getStmtread();
rs =stat.executeQuery(sql);
rs.previous();
while(rs.next()){
id=Integer.valueOf(rs.getInt("WareHouseId"));
}
if(id>0){
id+=1;
}else{
id=10000+1;
}
}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
/*-------------------獲得WareHouseInfoSave.jsp頁面提交數據進行判斷,合法后添加到數據庫-----------------*/
warehouseid=String.valueOf(id);
warehousename=(String)request.getParameter("whname");
chargeid=(String)request.getParameter("cid");
warehouseadd=(String)request.getParameter("whaddress");
if(warehouseid==null||warehousename==null||chargeid==null||warehouseadd==null){
session.setAttribute("errors", "倉庫信息添加失敗!");
requestdispatcher=request.getRequestDispatcher("/errors/errorpage.jsp");
requestdispatcher.forward(request, response);
}else{
try{
flag=-10;
WareHouseManager whm=new WareHouseManager();
flag=whm.AddWareHouseInfo(warehouseid, warehousename, chargeid, warehouseadd);
//如果倉庫信息添加成功跳轉到adminwarehouseinfo頁面
if(flag>0){
requestdispatcher=request.getRequestDispatcher("/viewpage/showpage/adminwarehouseinfo.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);
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -