基于jspjava的倉庫管理系統(tǒng)設(shè)計(jì)-預(yù)覽頁
【正文】 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 ServletException IOException responsesetContentType texthtmlcharset gb2312 requestsetCharacterEncoding gb2312 String mark requestgetParameter mark String id requestgetParameter id String name requestgetParameter name String str String sql rtUpdateDelBean ib new rtUpdateDelBean if mark null markequals add str adminunit_listjsp sql insert into unit name values name int flag ibinsertANDupdateANDdel sql if flag 1 str adminunitjsp requestsetAttribute message 計(jì)量單位名稱重復(fù) else requestsetAttribute message 操作成功 if mark null markequals update str adminunitjspmark markid id sql update unit set name name where id id int flag ibinsertANDupdateANDdel sql if flag 1 requestsetAttribute message 計(jì)量單位名稱重復(fù) else requestsetAttribute message 操作成功 RequestDispatcher rd requestgetRequestDispatcher str rdforward requestresponse public void init throws ServletException Put your code here 55 貨物存儲信息查詢模塊的實(shí)現(xiàn) 用于查詢貨物存儲表里的信息即在入出庫后對應(yīng)的操作的部分展示如果某貨物在此表中不存在也就不存在其它對此貨物的庫存操作界面如圖 5－ 5 所示 圖 55 存儲信息查詢模塊 主要代碼 public ArrayList getStock String str 查詢數(shù)據(jù) String sql select aid as clientidbid as productidcid as pandianidaname as clientnamenumbernormtimes from client aproduct bpandian c where aid bclientid and bid cproductidstr String args[] clientidproductidpandianidclientnamenumbernormtimes al sbselect sql args return al public ArrayList getSearchEntry String str String sql select aid as clientidbid as productidcid as entryid from client aproduct bentry c where aid bclientid and bid cproductidstr String args[] clientidproductidentryid al sbselect sql args return al public ArrayList getSearchGetout String str String sql select aid as clientidbid as productidcid as getoutid from client aproduct bgetout c where aid bclientid and bid cproductidstr String args[] clientidproductidgetoutid al sbselect sql args return al 總結(jié)與展望 通過一段時(shí)間的努力倉庫管理系統(tǒng)設(shè)計(jì)完成實(shí)現(xiàn)了系統(tǒng)的基本功能在這個(gè)過程中主要完成了數(shù)據(jù)庫的設(shè)計(jì)和系統(tǒng)功能的實(shí)現(xiàn)通過該系統(tǒng)可以方便快捷地實(shí)現(xiàn)倉庫管理中的貨物登記出庫入庫貨物盤點(diǎn)等工作使企業(yè)的倉庫管理井井有條為企業(yè)的健康發(fā)展創(chuàng)造良好的條件 通過本次畢業(yè)設(shè)計(jì)我進(jìn)一步加深了對軟件工程的理解對于 JSP――模型語言與設(shè)計(jì) [M]李天柱等譯北京電子工業(yè)出版社20215 斯蒂夫普盧著數(shù)據(jù)庫設(shè)計(jì) [M]何玉潔等譯北京機(jī)械工業(yè)出版社 20219 郭金鋒林宇等 PHPMySqlWeb 網(wǎng)絡(luò)編程 [M]人民郵電出版社 20213 羅鴻王忠 民編著 ERP 原理1
公司管理相關(guān)推薦
鄂ICP備17016276號-1