課程設計報告-物流配送系統商務網站設計-資料下載頁

　　

【正文】 areBean wb = new WareBean()。((1))。((2))。((3))。((4))。(wb)。}} catch (SQLException e) {()。} finally {()。}return al。}修改功能業務邏輯代碼：public boolean modifyWare(WareBean wb) {boolean b = false。try {conn = new ConnectionProcess().getConn()。String sql = update warehouse set warename = 39。 + () + 39。, maxarea = + () + , address = 39。 + () + 39。 where wareid = + () 。pstmt = (sql)。int i = ()。if(i 0) {b =true。}} catch (SQLException e) {()。} finally {()。}return b。}刪除功能業務邏輯代碼：public boolean deleteWare(int wareid) {boolean b = false。try {conn = new ConnectionProcess().getConn()。String sql = delete from warehouse where wareid = + wareid。pstmt = (sql)。int i = ()。if(i 0) {37 / 49b =true。}} catch (SQLException e) {()。} finally {()。}return b。}添加入出庫記錄業務邏輯代碼：public boolean addInventory(InventoryBean ib) {boolean b = false。SimpleDateFormat sdf = new SimpleDateFormat(yyyyMMdd HH:mm:ss)。String modifytime = (())。try {conn = new ConnectionProcess().getConn()。String sql = insert into inventory values( + ().getGoodsid() + , + ().getWareid() + , + ().getAreaid() + , + ().getSpaceid() + ,39。 + ().getUsername() + 39。, + () + ,39。 + modifytime + 39。,39。 + () + 39。,39。 + () + 39。)。pstmt = (sql)。int i = ()。if(i 0) {b =true。}} catch (SQLException e) {()。} finally {()。}return b。}入庫時更新貨物庫存業務邏輯代碼：public boolean putin(GoodsBean gb , WareBean wb , AreaBean ab , SpaceBean sb , int number) {boolean b = false。try {conn = new ConnectionProcess().getConn()。String sql = update stock set number = number + + number + where goodsid = + () + and wareid = + ()+ and areaid = + ()+ and spaceid = + ()。pstmt = (sql)。int i = ()。if(i 0) {b = true。}} catch (SQLException e) {()。} finally {38 / 49()。}return b。}彈出貨物選擇對話框是用 JavaScript 實現的，代碼如下：function show() {[39。Layer139。].=39。visible39。}function closeDiv() {[39。Layer139。].=39。hidden39。}function change() {var str。 str = 。 = str。closeDiv()。}div align=center div id=Layer1 table width=400 border=0 cellpadding=0 cellspacing=0 id=table1 %for(int i=0。i()。i=i+5) { try { gb1 = (i)。 % tr %if(gb1 != null){ % tda id=%=() % onclick=change()。%=() %/a/td %}if(gb2 != null){ % tda id=%=() % onclick=change()。%=() %/a/td %}if(gb3 != null){ % tda id=%=() % onclick=change()。%=() %/a/td %}if(gb4 != null){ % tda id=%=() % onclick=change()。%=() %/a/td %}if(gb5 != null){ % tda id=%=() % onclick=change()。%=() %/a/td %} % /tr % } % tr td colspan=5 align=center valign=middle input type=button value=關閉 onClick=closeDiv()。 //td /tr/table/div出庫時更新貨物庫存業務邏輯代碼：public boolean putout(GoodsBean gb , WareBean wb , AreaBean ab , SpaceBean sb , int number) {boolean b = false。try {conn = new ConnectionProcess().getConn()。String sql = update stock set number = number + number 39 / 49+ where goodsid = + () + and wareid = + ()+ and areaid = + ()+ and spaceid = + ()。pstmt = (sql)。int i = ()。if(i 0) {b = true。}} catch (SQLException e) {()。} finally {()。}return b。}添加移庫記錄業務邏輯代碼：public boolean addTransfer(TransferBean tb) {boolean b = false。try {conn = new ConnectionProcess().getConn()。SimpleDateFormat sdf = new SimpleDateFormat(yyyyMMdd HH:mm:ss)。String transfertime = (())。String sql = insert into transfer(goodsid,username,number,transtime, + inputware,inputarea,inputspace,outputware,outputarea,outputspace) values( + ().getGoodsid() + ,39。 + ().getUsername() + 39。, + () + ,39。 + transfertime + 39。, + ().getWareid() + , + ().getAreaid() + ,+ ().getSpaceid() + ,+ ().getWareid() + ,+ ().getAreaid() + ,+ ().getSpaceid() + )。pstmt = (sql)。int i = ()。if(i 0) {b = true。}} catch (SQLException e) {()。} finally {()。}return b。}庫存盤點業務邏輯代碼：public boolean update(int goodsid, int wareid, int areaid, int spaceid, int number) {boolean b = false。try {conn = new ConnectionProcess().getConn()。String sql = update stock set number = + number + where goodsid = + goodsid + and wareid = + wareid40 / 49 + and areaid = + areaid + and spaceid = + spaceid。pstmt = (sql)。int i = ()。if(i 0) {b =true。}} catch (SQLException e) {()。} finally {()。}return b。}庫存統計功能代碼：public int count(GoodsBean gb, WareBean ware, AreaBean area, SpaceBean space) {int count = 0。String str = 。String str1 = 。String str2 = 。String str3 = 。String str4 = 。if(() != 0) {str1 = goodsid = + ()。} else {str1 = 1=1 。}if(() != 0) {str2 = and wareid = + ()。} else {str2 = and 1=1 。}if(() != 0) {str3 = and areaid = + ()。} else {str3 = and 1=1 。}if(() != 0) {str4 = and spaceid = + ()。} else {str4 = and 1=1 。}str = str1 + str2 + str3 + str4。try {conn = new ConnectionProcess().getConn()。String sql = select sum(number) from stock where + str。pstmt = (sql)。rs = ()。if(()) {count = (1)。}} catch (SQLException e) {()。} finally {()。}return count。}出入庫統計功能，按時間統計代碼：41 / 49public ArrayListInventoryBean getInventorys(String type, String starttime , String endtime, int pageNo, int pageSize) {ArrayListInventoryBean al = new ArrayListInventoryBean()。int rowCount = 0。try {conn = new ConnectionProcess().getConn()。String sql = select count(*) from inventory where type=39。 + type + 39。 and modifytime between 39。+ starttime + 39。 and 39。 + endtime + 39。 。pstmt = (sql)。rs = ()。if(()) {rowCount = (1)。}if(rowCount% pageSize == 0) {pageCount = rowCount/pageSize。} else {pageCount = rowCount/pageSize + 1。}Str