【正文】
t extends HttpServlet public GetouttypeServlet super public void destroy superdestroy Just puts destroy string in log Put your code here Public void doGet HttpServletRequest request HttpServletResponse response throws ServletException IOException doPost request response Public void doPost HttpServletRequest request HttpServletResponse response 從數(shù)據(jù)庫獲取數(shù)據(jù) throws ServletException IOException responsesetContentType texthtmlcharset gb2312 requestsetCharacterEncoding gb2312 String mark requestgetParameter mark String id requestgetParameter id String name requestgetParameter name String str String sql 出庫并且更新數(shù)據(jù)庫 InsertUpdateDelBean ib new InsertUpdateDelBean if mark null markequals add str admingetouttype_listjsp sql insert into getouttype name values name int flag ibinsertANDupdateANDdel sql if flag 1 str admingetouttypejsp requestsetAttribute message 出庫類型名稱重復(fù) else requestsetAttribute message 操作成功 if mark null markequals update str admingetouttypejspmark markid id sql update getouttype set name name where id id int flag ibinsertANDupdateANDdel sql if flag 1 requestsetAttribute message 出庫類型名稱重復(fù) else requestsetAttribute message 操作成功 RequestDispatcher rd requestgetRequestDispatcher str rdforward requestresponse 53 盤點(diǎn)模塊的實(shí)現(xiàn) 當(dāng)每個(gè)月的盤點(diǎn)時(shí)間到后需要對數(shù)據(jù)庫中的貨物數(shù)量跟實(shí)際的相比對如果數(shù)量不對就要查清原因并進(jìn)行相應(yīng)處理以使貨物信息明了此模塊通過定期對倉庫信息做清點(diǎn)有效的了解了貨物的流通情況和倉庫貨物的損耗情況方便對貨物信息的管理界面如圖 5- 3 所示 圖 53 盤點(diǎn)圖 主要代碼 public class PandianServlet extends HttpServlet public PandianServlet super public void destroy superdestroy Just puts destroy string in log Put your code here public void doGet HttpServletRequest request HttpServletResponse response throws ServletException IOException doPost request response public void doPost HttpServletRequest request HttpServletResponse response throws ServletException IOException responsesetContentType texthtmlcharset gb2312 requestsetCharacterEncoding gb2312 String mark requestgetParameter mark String id requestgetParameter id String name requestgetParameter name String str adminstockjsp String sql rtUpdateDelBean ib new rtUpdateDelBean ean ab new ean date v new date ctBean sb new ctBean String time vgetSystemDate sql select from pandian where datediff daytimetimes 0 String args[] idproductidstocktimes ArrayList al sbselect sql args if al null alsize 0 ArrayList product abgetProduct for int i 0i productsize i ArrayList alRow ArrayList productget i sql insert into pandian productidstock values alRowget 0 alRowget 8 ibinsertANDupdateANDdel sql requestsetAttribute message 操作成功 else requestsetAttribute message 本日庫存已盤點(diǎn) RequestDispatcher rd requestgetRequestDispatcher str rdforward requestresponse public void init throws ServletException Put your code here 54 計(jì)量單位設(shè)置模塊的實(shí)現(xiàn) 當(dāng)新增加計(jì)量單位時(shí)在這里輸入即可將新增的計(jì)量單位信息保存到數(shù)據(jù)庫界面如圖 5- 4 所示 圖 54 計(jì)量單位模 塊 主要代碼 public class UnitServlet extends HttpServlet public UnitServlet super public void destroy superdestroy Just puts destroy string in log Put your code here public void doGet HttpServletRequest request HttpServletResponse response throws ServletException IOException doPost request response public void doPost HttpServletRequest request HttpServletResponse response throws Se