网上书店完整代码

1、附录全部源代码package class Connect private static Connection con = null;private static String url=jdbc:oracle:thin:localhost:1521:ORCL;private static String driver = ;private static String user = scott;private static String pwd = iger;public static Connection getConnection()try(driver);con = (url, user, p

2、wd);数据库连接成功！)； catch (ClassNotFoundException e) 驱动加栽失畋！)； catch (SQLException e) )；数据库连接失败！ return con; public static void main(String args) (); package class docMenuAction implements ActionListener RegisterFrame register=null; JPanel cusPanel = null; JPanel docPanel = null;public docMenuAction(Regi

3、sterFramG register)=register;-9Jpublic void actionPerformed(ActionEvent e) 于用户搜索商品public ArrayList getAllSellerGoods()ArrayList list = new ArrayList();conn =();trystateme nt =();String sql = select * from goods a,seller b where =;resultSet = (sql);while()Seller seller = new Seller();(seller name);(a

4、ddress);Goods goods = new Goods();(seller);(goodsjd);(goods _n ame);(sellerjd);(disco unt);um); (Price);2012-9-192012-9-192012-9-192012-9-19etlmage();(null);(null);(false);etlmage();(600, 400);/(null);(menuBao；setGoodsPanel();t(goodsPa nel,;setSouthPa nel();setOrderPanel();(southPanel,;quals()泯泠?勘请输

5、入商品编号或商品数量！)；elseint id =()；int num = (String) ();goods = (id);晚隈泠?勘您确定要购买吗)=0)讦()=0)泯泠?妙商品编号输入错误！)；elseif()num)泯泠?妙商品数量不足！)；else()-num);(goods);OrderDao order = new OrderDao();(goods, num);浪泠?勘购买成功！)；setAr();setOr();0；else)；etName();3r(i7=().getAddress(); private void setArNull() for(int i=O;i;i+)f

6、or(int j=O;jari.length;j+) arij=;etName();ori3=().getPrice();ori4=().getDiscount();ori5=().getPrice()*().getDiscount()*;ori6=();ori7=().getName();ori8=().getAddress(); private void setOrNull()for(int i=O;i;i+)for(int j=0;jori.length;j+) orij=； public static void main (String!) args) BuyerFrame frame

7、 = new BuyerFrame();(true);packageclass LoginFrame extends JFrame抽癩瑯?抱決咗数杳浮?撇支?渠睥?慌敢?用户名:)；抽癞f師?抱技潔扌巢慌敢?敝?抱注龙密码：);private JTextField useNameText = new JTextField();private JPasswordField pws = new JPasswordField();抽癩獅?牠注地淀?抱洼?渠睥?慌敢?角色：);抽癞砸?涪潢湿?i稍敬湿?敲?涪潢淡?蔽?球械柿崙叨商家？买家)； 抽癞砸?璜潴?珞?渠睥?畋毀湯龙确定)；抽癩獅?璜潴?珞?

8、蔽?瑾潴?取消);private String flag = null;public LoginFrame()init();private void init()(320, 280);登录)；龙(new lmagelcon(images/).getlmage();(null);(false);/(null);(40, 20,150, 30);(userNameLabel);(120, 20, 150, 30);(useNameText);(40, 80, 150, 30);(pwdLabel); (120, 80, 150, 30); (pws);(40, 140, 70, 30);(role

9、Label);(120,140, 150z 30);(roleBox);(40, 200, 70, 30);(btR);(new ActionListener() (Overridepublic void actionPerformed(ActionEvent e) quals(f) flag = seller; .equals(f)晚龙买家flag = customer;if(seller.equals(flag)Seller seller = (), ();)；else-+()； if()=null)泯泠?擀用户名或密码输入错误setVisible(false);SellerFrame f

10、ame = new SellerFrame();(true);if(customer.equals(flag)Buyer buyer =(),()；if()=null)泯泠?妙 用户名或密码输入错误);elsesetVisible(false);BuyerFrame frame = new BuyerFrame();(true);2012-9-20etlmage();(300, 400); etlmage();(600, 400);f(null);(me nuBar;setGoodsPanel();/(goodsPa nel,;setSouthPanel();setOrderPanel();(

11、southPanel,;quals)泯泠?勘请输入商品编号！)；elseint id =()；UpdateFrame frame = new UpdateFrame();Goods goods = new GoodsDao().getOneGoods(id); if()!=0)(goods);(goods);(true);else浪泠?勘商品编号输入错误！)； )；(btDelet);quals()隈泠?妙请输入商品编号！)；elseint id =()；GoodsDao dao = new GoodsDaof);晩隈泠?勘您确宦要删除吗)=0)if(id)!=O)浪泠?妙删除成功！)；els

12、e隈泠?勘商品编号输入错误!！)；else )；(btAdd);(new ActionListener() Overridepublic void actionPerformed(Acti on Eve nt e) etName();ari=().getAddress(); Jprivate void setArNull()for(int i=0;i;i+)for(int j=O;jari.length;j+)arij=； etName(); ori3=().getPrice(); ori4=().getDiscount(); ori5=().getPrice()*().getDiscount

13、()#; ori6=();ori7=();private void setOrNull()for(int i=0;i;i+)for(int j=0;jori.length;j卄)orij=;public static void main (String! args) SellerFrame frame = new SellerFrame();(true);packageclass UpdateFrame extends JFrameprivate static final Goods Goods = null;抽癩獅?抱注氟iliL浮?蔽?抱注龙商品名：)； 抽癩獅?抱注氤僦械散?渠睥?慌敢?

14、价格：)； 抽癞瑚?抱注氤?猱涸浚?敵?抱注龙折扣：)； 抽癞瑚?抱注氤虬澎?渠睥?慌敢?数量：)； private JTextField fieldName = new JTextField(20);private JTextField fieldPrice = new JTextField(2O); private JTextField fieldDiscount = new JTextField(2O);private JTextField fieldNum = new JTextField(2O);轴癩f師?璜潴?珞沓敲?渠睥?畋毀湯龙修改)； 抽癩獅?璜潴?珞憐据波?渠睥?畋毀湯茏取

15、消); private Goods goods = new Goods();public UpdateFrame()init();private void init()(320z 330);)；龙修改商品信息(new lmagelcon(images/).getlmage();(null);(null); (false);/ ;(null);setText(goods); setContentPanel();private void setContentPanel()(30, 30, 80, 30);(130, 30, 150, 30);(30, 90, 80, 30);(130, 90, 1

16、50, 30);(30, 150, 80, 30);(130, 150, 150, 30)；(30, 200, 80, 30)；(130, 200, 150, 30)；(30, 250, 70, 30)；(210, 250, 70, 30)；(IbName);(fieldName);(IbPrice);(fieldPrice);(IbDiscount);(fieldDisco unt);(IbNum);(fieldNum);(btCancel);(btSure);(new ActionListener() Overridepublic void actionPerformed(ActionEv

17、ent e) / TODO Auto-generatedmethod stub setVisible(false); );(nww ActionListener() Overridepublic void actionPerformed(Acti on Eve nt e) /TODO Auto-generated method stub晩隈泠?妙您确定耍修改吗)=0) GoodsDao dao = new GoodsDao();();();();();(goods);setVisible(false);隈泠?勘修改成功！ )；else/); public void setText(Goods

18、goods)0)；();();(); public Goods getGoods() return goods; public void setGoods(Goods goods) goods; public static void main(String args) UpdateFrame frame = new UpdateFrame(); (true); 数据库SQL语句：create table seller(sellerjd varchar2(2O) primary key,seller name varchar2(2O),pwd varchar2(20),address varch

19、ar2(200)insert into seller valuesfniclascage/长理专卖店/1234567湖南长沙)select * from sellerdrop table sellercommitcreate table buyerfbuyerjd varchar(2O) primary key,buyer_ name varchar(2O)zpwd varchar2(2O)/address varchar(2OO)insert into buyer values(llina/林大专卖店7123456/湖南长沙)select * from buyerdrop table buyercreate table goods(goodsjd int primary key,sellerjd varchar(20),goods _n ame varcharfSO),pri