【正文】 較流行的 SSH 框架，提高系統(tǒng)的可擴(kuò)展性。use inventory。, 39。create table warehouse (wareid int primary key identity(1,1),warename varchar(50) unique)。create table space (spaceid int primary key identity(1,1),spacename varchar(50) unique, areaid int,foreign key(areaid) references area(areaid))。create table goods(goodsid int primary key identity(1,1),goodsname varchar(50), price int,number int,sortid int, wareid int,areaid int,spaceid int,maxnumber int, minnumber int,foreign key(sortid) references sort(sortid),foreign key(wareid) references warehouse(wareid),foreign key(areaid) references area(areaid),foreign key(spaceid) references space(spaceid) )。create table transfer(transferid int primary key identity(1,1),goodsid int,username varchar(20),number int, transtime datetime,inputware int,inputarea int,inputspace int, outputware int,outputarea int,outputspace int,foreign key(username) references users(username),foreign key(goodsid) references goods(goodsid),foreign key(inputware) references warehouse(wareid),foreign key(inputarea) references area(areaid),foreign key(inputspace) references space(spaceid),foreign key(outputware) references warehouse(wareid),foreign key(outputarea) references area(areaid),foreign key(outputspace) references space(spaceid))。select * from system。 + u + 39。}} else {str = 用戶名錯(cuò)誤 !。}添加功能業(yè)務(wù)邏輯代碼：public boolean addWare(WareBean wb) {boolean b = false。, + () + ,39。int i = ()。}return b。String sql = select count(*) from warehouse。36 / 49}if(rowCount% pageSize == 0) {pageCount = rowCount/pageSize。rs = ()。((3))。} finally {()。String sql = update warehouse set warename = 39。 where wareid = + () 。}} catch (SQLException e) {()。try {conn = new ConnectionProcess().getConn()。if(i 0) {37 / 49b =true。}添加入出庫記錄業(yè)務(wù)邏輯代碼：public boolean addInventory(InventoryBean ib) {boolean b = false。String sql = insert into inventory values( + ().getGoodsid() + , + ().getWareid() + , + ().getAreaid() + , + ().getSpaceid() + ,39。,39。)。}} catch (SQLException e) {()。try {conn = new ConnectionProcess().getConn()。if(i 0) {b = true。}彈出貨物選擇對(duì)話框是用 JavaScript 實(shí)現(xiàn)的，代碼如下：function show() {[39。}function closeDiv() {[39。}function change() {var str。}div align=center div id=Layer1 table width=400 border=0 cellpadding=0 cellspacing=0 id=table1 %for(int i=0。%=() %/a/td %}if(gb2 != null){ % tda id=%=() % onclick=change()。%=() %/a/td %} % /tr % } % tr td colspan=5 align=center valign=middle input type=button value=關(guān)閉 onClick=closeDiv()。pstmt = (sql)。} finally {()。SimpleDateFormat sdf = new SimpleDateFormat(yyyyMMdd HH:mm:ss)。, + () + ,39。int i = ()。}return b。pstmt = (sql)。} finally {()。String str1 = 。if(() != 0) {str1 = goodsid = + ()。}if(() != 0) {str3 = and areaid = + ()。}str = str1 + str2 + str3 + str4。rs = ()。}return count。String sql = select count(*) from inventory where type=39。 and 39。rs = ()。}String。}if(rowCount% pageSize == 0) {pageCount = rowCount/pageSize。 。 and modifytime between 39。int rowCount = 0。}} catch (SQLException e) {()。String sql = select sum(number) from stock where + str。}if(() != 0) {str4 = and spaceid = + ()。}if(() != 0) {str2 = and wareid = + ()。String str3 = 。}庫存統(tǒng)計(jì)功能代碼：public int count(GoodsBean gb, WareBean ware, AreaBean area, SpaceBean space) {int count = 0。if(i 0) {b =true。try {conn = new ConnectionProcess().getConn()。}} catch (SQLException e) {()。, + ().getWareid() + , + ().getAreaid() + ,+ ().getSpaceid() + ,+ ().getWareid() + ,+ ().getAreaid() + ,+ ().getSpaceid() + )。String sql = insert into transfer(goodsid,username,number,transtime, + inputware,inputarea,inputspace,outputware,outputarea,outputspace) values( + ().getGoodsid() + ,39。}添加移庫記錄業(yè)務(wù)邏輯代碼：public boolean addTransfer(TransferBean tb) {boolean b = false。if(i 0) {b = true。try {conn = new ConnectionProcess().getConn()。%=() %/a/td %}if(gb4 != null){ % tda id=%=() % onclick=change()。i=i+5) { try { gb1 = (i)。 = str。].=39。].=39。} finally {38 / 49()。pstmt = (sql)。}return b。int i = ()。,39。, + () + ,39。String modifytime = (())。} finally {()。pstmt = (sql)。}return b。int i = ()。, maxarea = + () + , address = 39。}修改功能業(yè)務(wù)邏輯代碼：public boolean modifyWare(WareBean wb) {boolean b = false。(wb)。((1))。}String sql1 = select top + pageSize + * from warehouse where wareid not in(select top + (pageNo1)*pageSize+ wareid from warehouse) order by wareid desc。rs = ()。int rowCount = 0。}} catch (SQLException e) {()。)。String sql = insert into warehouse values(39。} finally {()。rs = ()。try {conn = new ConnectionProcess().getConn()。create table system(wareinitial bit,areainitial bit,spaceinitial bit,sortinitial bit,goodsinitial bit)。create table stock(stockid int primary key identity(1,1) ,goodsid int, username varchar(20), number int, modifytime datetime, type varchar(10),audit bit,remark varchar(500)foreign key(username) references users(username),foreign key(goodsid) references goods(goodsid))。create table sort (sortid int primary key identity(1,1),sortname varchar(50) unique)。create table area (areaid int primary key identity(1,1),areaname varchar(50) unique, wareid int,foreign key(wareid) references warehouse(wareid))。 ,1)。insert into users(username, password, grade) values(39。在這期間，指導(dǎo)教師xxx老師給了我細(xì)致、專業(yè)的指點(diǎn)以及耐心的輔導(dǎo)，在此深表敬意和感謝！同時(shí)，在我完成畢業(yè)論文的過程中，教研室的老師、輔導(dǎo)員老師以及同學(xué)們也給予了我莫大的幫助，對(duì)他們的關(guān)心、幫助我深表感謝！我更要感謝大學(xué)四年來所有教過我的老師，沒有他們深厚的專業(yè)理論知識(shí)和經(jīng)驗(yàn)的授予，就沒有我今天的成績(jī)。綜合以上不足，系統(tǒng)的仍需不斷改進(jìn)。31 / 49但是，本系統(tǒng)設(shè)計(jì)依然不夠完善，有許多不足之處。本系統(tǒng)的主要特點(diǎn)有以下幾個(gè)方面：（1）由于本系統(tǒng)采用的設(shè)計(jì)語言是基于 java 的，所以本系統(tǒng)能夠跨平臺(tái)運(yùn)行，即在 windows，unix，linux 等不同