網(wǎng)上書店完整代碼

1、網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁附錄全部源代碼package shoeShop db； import javasql. Connection；import java sql. DriverMaruigei；import javasql. SQLException；publicclass Connect privatestaticConnection con = null；privatestaticString url=Mjdbc：oracle：thin：localhost：1521：ORCL；privatestaticString driver = woracle jdbc.d

2、river.0racleDriver11 ；privatestaticString user = scott；privatestaticpub!ic static Connection getConnectionO try Class forName(driver)； con = DriverManagergetConnection(url, user, pwd):System, out. println(M數(shù)據(jù)庫連接成功!); catch (ClassNotFoundException e) System, out. println(M驅(qū)動加載失敗!; catch (SQLException

3、 e) System, out. printing數(shù)據(jù)庫連接失敗!); return con；public static void ma in(String args) Connect getConnection()；網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁package shoeShop.action；import java awt event ActionEvent；import java awt event /ctionListener；import javax swing JPanel；import shoeShop view RegisterFrame；public clas

4、s docMenuAction implements ActionListener RegisterFrame register = null；JPanel cusPanel = null；JPanel docPane1 = null；public docMenuAct ion(RegisterFrame register)this. register = register；this .cusPsne = registercusPanel；this. docPane = register. docPanel；public void actionPerformed(ActionEvent e)

5、/ TODO Auto-generated method stubregister flsg = 1;/System. out println(register flag);register. remove(cusPane1)；register add(docPanel)；docPane1. updoteUI ()； package shoeShop. dao；網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁import javasq】Connection；import java sql.ResultSet；import javasql. SQLException；import java sq

6、l. Statement；import shoeShop db.Connect；import shoeShop.entityBuyer；import shoeShop.entity.Seller；public class BuyerDao private static Connection corm；private static Statement statement；private static ResultSet resultSet；插入數(shù)據(jù)，用于注冊pub1ic int insertBuyer(Buyer buyer) int flag = 0；corm = ConnectgetConn

7、ection()；try statement = conn. createStatement():Stringsql=Hinsertintobuyervalues(r +buyer getld() + f, w+buyer getName() + H *, * rT+buyer getPwd() + t 1 +buyer getAddress()+n)；/System out printinCbuyer”+sql)；flag = statementexecuteUpdate(sql)；statement close();conn. closeO ； catch (SQLException e)

8、 / TODO Auto-generated catch block網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁e. printStackTraceO ；/System out println(flag)；return flag；通過用戶名和密碼查詢，用于登錄public static Buyer getBuyer(String name,String pwd)conn = ConnectgetConnection()；Buyer buyer = new Buyer():try statement = conn. createStatement():String sql = select

9、* from buyer where buyer_id=r n+name+n1 and pwd =，n+pwd+;resultSet = statementexecuteQuery(sql)；while(resultSet. next()buyer setld(resultSet getString(nbuyer_idw)；buyer setName(resultSet getString(buyer_namen)；buyer setPwd(resu 1 tSet getStringCpwd1)；buyer setAddress(resultSet getString(naddressH)；r

10、esultSet close():statement close()；conn. close()； catch (SQLException e) / TODO Auto-generated catch blocke. printStackTraceO ； return buyer；網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁public static void main(String args) BuyerDao dao = new BuyerDaoO :System. out. println(dao. getBuyer(zxk, 654321”)；/Buyer buyer = new

11、Buyer ():/buyer setld(nlilyR)；/buyer. setName (M長理專賣);/buyer. setPwd(n 123456,r)；/buyer setAddress(R，T):/dao. insertBuyer(buyer)；package shoeShop. dao；import javasq】Connection；import javasql.ResultSet；import javasql. SQLException；import java sql. Statement；import java .util. ArrayList；import shoeSho

12、p. db. Connect；import shoeShop entity Goods；import shoeShopentity.Seller；import shoeShop imp .User；public class GoodsDao private static Connection corm；private static Statement statement；private static ResultSet resultSet；網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁/查詢登錄商家的所有商品，用于商家管理自己的商品public ArrayList getAllGoodsO

13、ArrayList list = new ArrayList():corm = Connect. getConnection()；try statement = conn createStateinent ()；whereString sql = select * from goods a,sellera. seller id=b. seiler id and b. seller id=f +User. getUserName() +，r resultSet = statementexecuteQuery (sql)； while(resultSet. next() Seller seller

14、 = new Seiler():seller setName(resultSet. getStringCseller name)； seller setAddress(resultSet getString(naddressn)； Goods goods = new Goods(): goods setSeller(seller)；goods set Id(resultSet getlnt(ngoods id”)；goods setName(resultSet getStringtgoods nameH)；goods setSeller_id(resultSet getString(nsell

15、eridH)；goods setDiscount(resultSet getlnt(discount)； goods setNum(resultSet getInt (，numrf)；goods set Price (resultSet getlnt (，pricen)；/System out print In(goods toString()；list add(goods)； catch (SQLException e) / TODO Auto-generated catch blocke. printStackTraceO ；finallytry 網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共

16、34頁resultSet close()；statement close ()；conn. closeO ； catch (SQLException e) / TODO Auto-generated catch blocke. pri ntStackTrace ()；return list；/查詢所有商家的所有商品用于用戶搜索商品public ArrayList getAllSellerGoods()ArrayList list = new ArrayList():conn = ConnectgetConnection()；try statement = conn. createStateme

17、nt()；whereString sql = wselect * from goods a,seller3.seller_id二b.seller id；resultSet = statementexecuteQuery(sql)；while(resultSet. next()Seller seller = new Seiler():seller setName(resu1tSet getString(seller name)；seller setAddress(resultSet getString(address1)；Goods goods = new Goods():goods setSe

18、ller(seiler)；goods setId(resultSet getlnt(goods id)；goods setName(resultSet getString(wgoods_namen)；goods.setSeller id(resultSetgetStringCseller id)；goods setDiscount(resultSet get Int(discount)；網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁goods setNum(resultSet getlnt (num)；goods setPrice(resultSet getlnt(price)；/Syste

19、m out printIn(goods toStringO)；list add(goods); catch (SQLException e) / TODO Auto-generated catch blocke. printStackTrace()；finally try resultSet close()；statement close ()；conn. closeO ； catch (SQLException e) / TODO Auto-generated catch blocke. pri ntStackTrace ()；return list；根據(jù)商品號查詢商品信息pub1ic Go

20、ods getOneGoods(int id)Goods goods = new Goods():conn = ConnectgetConnection()；try statement = conn. createStatement():String sql = select * from goods where goods_id = +id；resultSet = statement .executeQuery(sql):網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁statement = conn. createStatement():String sql = nupdate goods

21、 set goods name=，H+goods getName() + n 1, price 二+goods. getPriceO+ n,discount =+goods getDiscount()+ ,num二+goods getNum() + n where goods id二+goodsgetld()；flag = statementexecuteUpdate (sql)； catch (SQLException e) / TODO Auto-generated catch blocke. printStackTrace()；finallytry statement, close ()

22、；conn. closeO ； catch (SQLException e) / TODO Auto-generated catch blocke. printStackTrace()；return flag；通過id刪除商品pub1ic int deleteById(int id) int flag = 0；conn = ConnectgetConnection()；try statement = conn. createStatement():String sql = delete goods where goods id = +id；flag = statementexecuteUpda

23、te(sql)；網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁 catch (SQLException e) / TODO Auto-generated catch blocke. printStackTrace()；finallytry (statement close ()；conn. close()； catch (SQLException e) / TODO Auto-generated catch blocke. pri ntStackTrace ()；return flag；添加pub1ic int insertGoods(Goods goods)int flag = 0；cor

24、m = ConnectgetConnection()；try statement = conn. createStatement():String sql = n insert into goods values(select max (goods id+1) from goods) t 1 +User getUserNameO, r +goods getName() +，T r. +goods. getPrice()+, H+go ods. getDiscount ()+, +goods getNum()+) ”；flag 二 statementexecuteUpd3te(sql)； cat

25、ch (SQLException e) / TODO Auto-generated catch blocke. “intStackTraceO ；finally!try 網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁statement close ()；conn. closeO ； catch (SQLException e) / TODO Auto-generated catch blocke. pri ntStackTrace ()；return flag；pub1ic static void main(String args) GoodsDao dao = new GoodsDao()

26、:/Goods goods = new Goods():/goods. setName Cc+)；/goods setPrice(50)；/User setUserName(niclascagen)；/goods setDiscount(8)；/goods. setNum(lO)；/System out printlnCmain):/System out printlnC11 i i u+dao. insertGoods(goods)；/System, out. print In(dao. deleteById(4)；/Goods goods = new Goods():/goods, set

27、ld(l)；/goods setName (，oraclen):/goods setPrice(50)；/goods setDiscount(8)；/goods setNum(5)；/System out println(dao. updateGoods(goods)；dao. getAlISellerGoods ()；/System out println(dao. getOneGoods(1)；網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁package shoeShop. dao； import javasql. Connection；import javasql.ResultSet；

28、import java sql. SQLException；import java sql. Statement；import java .util. ArrayList；import shoeShop db.Connect；import shoeShop entity Goods；import shoeShop entity Order；import shoeShop.entity.Seller；import shoeShop imp User；public class OrderDao private static Connection conn；private static Statem

29、ent statement；private static ResultSet resultSet；插入public int inserOerderByGoods(Goods goods, int num) int flag = 0；corm = ConnectgetConnection()；try statement = conn. createStatement():String sql = ninsert into orders values (select max(order_id+l) fromorders),+goods getld()+,1+goods getSeller id()

30、+.n+User getUserName() + n *.M+num+n)”；網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁flag = statementexecuteUpdate (sql)； catch (SQLException e) / TODO Auto-generated catch blocke. printStackTrace ()；finally try statement close ()；conn. closeO ； catch (SQLException e) / TODO Auto-generated catch blocke. printStackTrace()

31、；return flag；查詢登錄用戶的所有訂單publ ic ArrayList getOrderO ArrayList list = new ArrayList():conn = ConnectgetConnection()；try statement = conn. createStatement()；whereidString sql =*select * from orders a,seller b,goods ca. seller_id=b sei ler_idand 日.goods_id=c goods_id and a. buyer+UsegetUserName()+n *re

32、sultSet = statement. executeQuery(sql)；while(resultSet. next() Order order = new Order():Goods goods = new Goods()；Seller seller = new Seiler():網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁order setld(resultSet getInt(order id”)；order setNum(resultSet getInt(num)；order setGoods id(resultSet get Int(wgoods_i dw)；goods se

33、tld(resultSet getlnt(ngoods id”)；goods setPrice(resu1tSet getShort(price)；goods setPrice(resuItSet getlnt(price”)；goods setDiscount(resultSet get Int(discount)； goods setName(resultSet getString(wgoods_namen)； seller setName(resultSet getStringCseller name)； seller setAddress(resultSet getString(nad

34、dressn)； order setSeller(seiler)； order setGoods(goods)；/System out println(order toStringO)；list. add(order)； catch (SQLException e) / TODO Auto-generated catch blocke. printStackTrace()；finally try resultSet close()；statement close ()；conn. close()； catch (SQLException e) / TODO Auto-generated cat

35、ch blocke. pri ntStackTrace ()； return list；網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁查詢登錄商家的所有訂單pub1ic ArrayList getSellerOrder()ArrayList list = new ArrayList():conn = ConnectgetConnection()；try statement = conn. createStatement():String sql =* select * from orders a, seller b, goods c wherea. seller id=bseiler id

36、+and3. goods_id=c goods_idanda. seller id=+UsegetUserName()+n *resultSet = statement. executeQuery(sql)；while(resultSet. next() Order order = new Order():Goods goods = new Goods():Seller seller = new Seiler():order setld(resultSet getlnt(order id)；order setNum(resu1tSet get Int(nnumw)；order setGoods

37、_id(resultSet getlnt(goods_id)；order setBuyer_id(resultSet getString(nbuyer id)；goods setId(resultSet getlnt(ugoods id”)；goods setPrice(resu1tSet getShort(price)；goods setPrice(resultSet getlnt(Hpricen)；goods setDiscount(resultSet get Int(discount)；goods setName(resultSet getString(wgoods,namen)；sel

38、ler setName(resu1tSet getStringCseller name)；seller setAddress(resultSet getString(naddressn)；order setSeller(seiler)；order setGoods(goods)；網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁list. add(order)； catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace()；finally try resultSet close()；statement cl

39、ose ()；conn. close()； catch (SQLException e) / TODO Auto-generated catch blocke. printStackTrace()；return list；public static void main(String args) OrderDao dao = new OrderDao()；dao.getOrder()； package shoeShop dao；import java, sq1. Connection；import java sql.ResultSet；網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁import

40、 java sql. SQLException；import javasq】Statement；import shoeShop db. Connect；import shoeShopentity. Seller；public class Se11erDao private static Connection conn；private static Statement statement；private static ResultSet resultSet；插入數(shù)據(jù)，用于注冊public int insertSe11er(Se11er seiler) int flag = 0；corm = Co

41、nnectgetConnection()；try statement = conn. createStatement():seller,”+selStringsql=winsertintovalues (r +sel ler. getld()+,1 M+seller. getName() + 1, 1 ,r+seller. getPwd() + ler. get/ddiess() + R，) ”；flag = statementexecuteUpdste(sql)；statement close()；conn. closeO ； catch (SQLException e) / TODO Au

42、to-generated catch blocke.printStackTrace()；return flag；/通過用戶名和密碼查詢，用于登錄網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁public static Seiler getSeller(String name,String pwd)conn = ConnectgetConnectionO :Seiler seller = new Seller():try statement = conn. createStatement()；String sql = nselect * from seller where seller id二

43、+n3me+ and pwd = +pwd+:resultSet = statementexecuteQuery (sq】)；while(resultSet next ()(sei ler set Id (resultSet getString(f，sel ler_idn)；seller setName(resu 1 tSet getString(nseller name1)；seller setPwd(resultSet getStringCpwd)；seller setAddress(resultSet getStringCaddress)；resultSet close()；statem

44、ent close():conn. closeO ； catch (SQLException e) / TODO Auto-generated catch blocke. pri ntStackTrace ()；return seller；public static void main(String args) SellerDao dao = new SellerDaoO ；/System, out. printIn(dao. getSeller斌654321”)；/Sellerseller = new Seller():/seller.setId(Tily)；/seller. setName

45、(H長理專賣)；網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁/seller setAddress()；seller. setPwd(n123456n)；/dao. insertSelet(seller)；package shoeShop.entity；*功能：商家實(shí)體類* author：斌*2012-9-19 下午 4:17:40網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁*/public class Buyer private String id；private String name；private String address；private String pwd；public

46、String getPwdO return pwd；public void setPwd(String pwd) thispwd = pwd；public String getldO return id；public void setId(String id) this, id = id；publ ic String getNameO return name；pub1ic void setName(String name) this iKinie = name；pub1ic String getAddress() return address；public void setAddress(St

47、ring address) 網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁this.address = address；Overridepublic String toStringO return Buyer id二+ id + name=r + name + address= + addresspackage shoeShop.entity；/*功能：商品實(shí)體類* author：斌*2012-9-19 下午 4：26：05網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁public class Goods private int id；private String seller_id；pr

48、ivate Seller seller；private String name；private int price；private int discount；private int num；pub1ic Seller getSeller() return seller；pub1ic void setSeller(Seller seller) thisseller = seiler；public int getDiscount() return discount；public void setDiscount(int discount) this.discount = discount；publ

49、 ic int getNumO return num；public void setNum(int num) this num = num；pub1ic int getld() return id；網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁public void setld(int id) this, id = id；public String getSeller id() return seller id；public void setSeller icKString seller id) this .seller id = seller_id；pub 1 ic String getN

50、ameO return name；pub1ic void setName(String name) this rmme = name；public int getPriceO return price；public void setPrice(int price) this price = price；Overridepub1ic String toString() sei ler二return Goods id= + id +seller_id二+ seller_id + seller +name二+ name + price=M + price+ discount + discount +

51、num二+ mim + 丁;網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁package shoeShop entity；*功能：訂單實(shí)體類* author：斌*2012-9-19 下午 4：26：24*/public class Order private int id；private int goods id；網(wǎng)上書店信息管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)第69頁共34頁private String seller id；private String buyer id；private Goods goods；private Seller seller；private Buyer buyer；private int num；public int getNumO return num；public void setNum(int num) this num = num；public Goo