基于jspjava的倉(cāng)庫(kù)管理系統(tǒng)設(shè)計(jì)-全文預(yù)覽
【正文】 系統(tǒng)界面與功能實(shí)現(xiàn) 51 入庫(kù)模塊 的實(shí)現(xiàn) 當(dāng)某種已有物品進(jìn)貨后就需要在此輸入庫(kù)存記錄信息并同時(shí)輸入相應(yīng)貨物入庫(kù)信息并加入到庫(kù)存中為以后進(jìn)行入庫(kù)貨物的查詢和出庫(kù)操作產(chǎn)生操作數(shù)據(jù)供管理人員掌握倉(cāng)庫(kù)內(nèi)存儲(chǔ)的貨物情況界面如圖 5－ 1 所示 圖 51 入庫(kù)模塊 主要代碼 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 String sql InsertUpdateDelBean ib new InsertUpdateDelBean 入庫(kù) if mark null markequals add str adminentrytype_listjsp sql insert into entrytype name values name int flag ibinsertANDupdateANDdel sql if flag 1 str adminentrytypejsp requestsetAttribute message 入庫(kù)類型名稱重復(fù) else requestsetAttribute message 操作成功 if mark null markequals update str adminentrytypejspmark markid id sql update entrytype set name name where id id int flag ibinsertANDupdateANDdel sql if flag 1 requestsetAttribute message 入庫(kù)類型名稱重復(fù) else requestsetAttribute message 操作成功 RequestDispatcher rd requestgetRequestDispatcher str rdforward requestresponse 圖 52 產(chǎn)品出庫(kù) 主要 代碼 public class GetouttypeServlet 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ù)庫(kù)獲取數(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 出庫(kù)并且更新數(shù)據(jù)庫(kù) 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 出庫(kù)類型名稱重復(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 出庫(kù)類型名稱重復(fù) else requestsetAttribute message 操作成功 RequestDispatcher rd requestgetRequestDispatcher str rdforward requestresponse 53 盤點(diǎn)模塊的實(shí)現(xiàn) 當(dāng)每個(gè)月的盤點(diǎn)時(shí)間到后需要對(duì)數(shù)據(jù)庫(kù)中的貨物數(shù)量跟實(shí)際的相比對(duì)如果數(shù)量不對(duì)就要查清原因并進(jìn)行相應(yīng)處理以使貨物信息明了此模塊通過(guò)定期對(duì)倉(cāng)庫(kù)信息做清點(diǎn)有效的了解了貨物的流通情況和倉(cāng)庫(kù)貨物的損耗情況方便對(duì)貨物信息的管理界面如圖 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
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1