网上书店完整代码

1、WORD格式"网上书店信息管理系统的设计与实现"第1页共34页附录全部源代码package com.shoeShop.db;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class Connect private static Connection con = null;private static String url="jdbc:oracle:thin:localhost:1521:ORCL" private s

2、tatic String driver = "oracle.jdbc.driver.OracleDriver" private static String user = "scott"private static String pwd = "tiger"public static Connection getConnection()try Class.forName(driver);con = DriverManager.getConnection(url, user, pwd);System.out.println(" 数

3、据库连接成功！"); catch (ClassNotFoundException e) System.out.println(" 驱动加载失败！ "); catch (SQLException e) System.out.println(" 数据库连接失败！");return con;public static void main(String args) Connect.getConnection();专业资料整理WORD格式专业资料整理WORD格式"网上书店信息管理系统的设计与实现"第2页共34页package com.

4、shoeShop.action;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.JPanel;import com.shoeShop.view.RegisterFrame;public class docMenuAction implements ActionListener RegisterFrame register = null;JPanel cusPanel = null;JPanel docPanel = null;public docMenuActio

5、n(RegisterFrame register)this.register = register;this.cusPanel = register.cusPanel;this.docPanel = register.docPanel;public void actionPerformed(ActionEvent e) / TODO Auto-generated method stub register.flag = 1; /System.out.println(register.flag); register.remove(cusPanel); register.add(docPanel);

6、 docPanel.updateUI();专业资料整理WORD格式package com.shoeShop.dao;专业资料整理WORD格式"网上书店信息管理系统的设计与实现"第3页共34页import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import com.shoeShop.db.Connect;import com.shoeShop.entity.Buyer;import com.shoeShop.ent

7、ity.Seller;public class BuyerDao private static Connection conn;private static Statement statement;private static ResultSet resultSet;/插入数据，用于注册public int insertBuyer(Buyer buyer)int flag = 0;conn = Connect.getConnection();try statement = conn.createStatement();String sql = "insert into buyer v

8、alues('"+buyer.getId()+"','"+buyer.getName()+"','"+buyer.getPwd()+"','"+buyer.getAddress()+"')" ;/System.out.println("buyer"+sql);flag = statement.executeUpdate(sql);statement.close();conn.close(); catch (SQLExcep

9、tion e) / TODO Auto-generated catch block专业资料整理WORD格式"网上书店信息管理系统的设计与实现"第4页共34页e.printStackTrace();/ System.out.println(flag);return flag;/通过用户名和密码查询，用于登录public static Buyer getBuyer(String name,String pwd)conn = Connect.getConnection();Buyer buyer = new Buyer();try statement = conn.createS

10、tatement();Stringsql ="select*frombuyerwhere buyer_id='"+name+"'and pwd='"+pwd+"'"resultSet =statement.executeQuery(sql);while(resultSet.next()buyer.setId(resultSet.getString("buyer_id");buyer.setName(resultSet.getString("buyer_name")

11、;buyer.setPwd(resultSet.getString("pwd");buyer.setAddress(resultSet.getString("address");resultSet.close();statement.close();conn.close(); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace();return buyer;专业资料整理WORD格式"网上书店信息管理系统的设计与实现"第5页共34页publ

12、ic static void main(String args) BuyerDao dao = new BuyerDao();System.out.println(dao.getBuyer("zxk", "654321");/ Buyer buyer = new Buyer();/ buyer.setId("lily");/ buyer.setName("长理专卖 ");/ buyer.setPwd("123456");/ buyer.setAddress("* ");/ d

13、ao.insertBuyer(buyer);package com.shoeShop.dao;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;import com.shoeShop.db.Connect;import com.shoeShop.entity.Goods;import com.shoeShop.entity.Seller;import com.shoeShop.

14、imp.User;public class GoodsDao private static Connection conn;private static Statement statement;private static ResultSet resultSet;专业资料整理WORD格式"网上书店信息管理系统的设计与实现"第6页共34页/查询登录商家的所有商品，用于商家管理自己的商品public ArrayList getAllGoods()ArrayList list = new ArrayList();conn = Connect.getConnection();try

15、 statement = conn.createStatement();String sql = "select *from goods a,seller b where a.seller_id=b.seller_idandb.seller_id='"+User.getUserName()+"'"resultSet = statement.executeQuery(sql);while(resultSet.next()Seller seller = new Seller();seller.setName(resultSet.getStri

16、ng("seller_name");seller.setAddress(resultSet.getString("address");Goods goods = new Goods();goods.setSeller(seller);goods.setId(resultSet.getInt("goods_id");goods.setName(resultSet.getString("goods_name");goods.setSeller_id(resultSet.getString("seller_id

17、");goods.setDiscount(resultSet.getInt("discount");goods.setNum(resultSet.getInt("num");goods.setPrice(resultSet.getInt("price");/System.out.println(goods.toString();list.add(goods); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace();finall

18、ytry 专业资料整理WORD格式"网上书店信息管理系统的设计与实现"第7页共34页resultSet.close();statement.close();conn.close(); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace();return list;/查询所有商家的所有商品.用于用户搜索商品public ArrayList getAllSellerGoods()ArrayList list = new ArrayList();conn = Connect.getC

19、onnection();try statement = conn.createStatement();String sql = "select * from goods a,seller b where a.seller_id=b.seller_id"resultSet = statement.executeQuery(sql);while(resultSet.next()Seller seller = new Seller();seller.setName(resultSet.getString("seller_name");seller.setAdd

20、ress(resultSet.getString("address");Goods goods = new Goods();goods.setSeller(seller);goods.setId(resultSet.getInt("goods_id");goods.setName(resultSet.getString("goods_name");goods.setSeller_id(resultSet.getString("seller_id");goods.setDiscount(resultSet.getIn

21、t("discount");goods.setNum(resultSet.getInt("num");专业资料整理WORD格式"网上书店信息管理系统的设计与实现"第8页共34页goods.setPrice(resultSet.getInt("price");/System.out.println(goods.toString();list.add(goods); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();f

22、inallytry resultSet.close();statement.close();conn.close(); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace();return list;/根据商品号查询商品信息public Goods getOneGoods(int id)Goods goods = new Goods();conn = Connect.getConnection();try statement = conn.createStatement();String sql

23、= "select * from goods where goods_id = "+id;resultSet = statement.executeQuery(sql);while(resultSet.next()专业资料整理WORD格式"网上书店信息管理系统的设计与实现"第9页共34页goods.setId(id);goods.setName(resultSet.getString("goods_name");goods.setPrice(resultSet.getInt("price");goods.setNu

24、m(resultSet.getInt("num");goods.setDiscount(resultSet.getInt("discount");goods.setSeller_id(resultSet.getString("seller_id");goods.setNum(resultSet.getInt("num"); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();finallytry resultSet.

25、close();statement.close();conn.close(); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace();return goods;/修改商品信息public int updateGoods(Goods goods)int flag = 0;conn = Connect.getConnection();try statement = conn.createStatement();专业资料整理WORD格式"网上书店信息管理系统的设计与实现"第 10页

26、共 34页Stringsql="updategoodssetgoods_name='"+goods.getName()+"',price="+goods.getPrice()+",discount ="+goods.getDiscount()+",num="+goods.getNum()+"wheregoods_id="+goods.getId();flag = statement.executeUpdate(sql); catch (SQLException e) / TODO

27、 Auto-generated catch block e.printStackTrace();finallytry statement.close();conn.close(); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace();return flag;/通过 id 删除商品public int deleteById(int id)int flag = 0;conn = Connect.getConnection();try statement = conn.createStatement

28、();String sql = "delete goods where goods_id = "+id;flag = statement.executeUpdate(sql); catch (SQLException e) 专业资料整理WORD格式"网上书店信息管理系统的设计与实现"第 11页共 34页/ TODO Auto-generated catch block e.printStackTrace();finallytry statement.close();conn.close(); catch (SQLException e) / TODO A

29、uto-generated catch block e.printStackTrace();return flag;/添加public int insertGoods(Goods goods)int flag = 0;conn = Connect.getConnection();try statement = conn.createStatement();Stringsql="insertintogoodsvalues(selectmax(goods_id+1)fromgoods),'"+User.getUserName()+"','&qu

30、ot;+goods.getName()+"',"+goods.getPrice()+","+goods.getDiscount()+","+goods.getNum()+")"flag = statement.executeUpdate(sql); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace();finallytry statement.close();专业资料整理WORD格式"网上书店信息管

31、理系统的设计与实现"第 12页共 34页conn.close(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return flag;public static void main(String args) GoodsDao dao = new GoodsDao();/ Goods goods = new Goods();/ goods.setName("c+");/ goods.setPrice(50);/ User.setUserName("

32、niclascage");/ goods.setDiscount(8);/ goods.setNum(10);/ System.out.println("main");/ System.out.println("ii"+dao.insertGoods(goods);/ System.out.println(dao.deleteById(4);/ Goods goods = new Goods();/ goods.setId(1);/ goods.setName("oracle");/ goods.setPrice(50);/

33、 goods.setDiscount(8);/ goods.setNum(5);/ System.out.println(dao.updateGoods(goods);dao.getAllSellerGoods();/ System.out.println(dao.getOneGoods(1);专业资料整理WORD格式"网上书店信息管理系统的设计与实现"第 13页共 34页package com.shoeShop.dao;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLExcep

34、tion;import java.sql.Statement;import java.util.ArrayList;import com.shoeShop.db.Connect;import com.shoeShop.entity.Goods;import com.shoeShop.entity.Order;import com.shoeShop.entity.Seller;import com.shoeShop.imp.User;public class OrderDao private static Connection conn;private static Statement stat

35、ement;private static ResultSet resultSet;/插入public int inserOerderByGoods(Goods goods, int num)int flag = 0;conn = Connect.getConnection();try statement = conn.createStatement();Stringsql="insertintoordersvalues(selectmax(order_id+1)fromorders),"+goods.getId()+",'"+goods.getS

36、eller_id()+"','"+User.getUserName()+"',"+num+")"flag = statement.executeUpdate(sql); catch (SQLException e) 专业资料整理WORD格式"网上书店信息管理系统的设计与实现"第 14页共 34页/ TODO Auto-generated catch block e.printStackTrace();finallytry statement.close();conn.close(); cat

37、ch (SQLException e) / TODO Auto-generated catch block e.printStackTrace();return flag;/查询登录用户的所有订单public ArrayList getOrder()ArrayList list = new ArrayList();conn = Connect.getConnection();try statement = conn.createStatement();String sql = "select * fromorders a,seller b,goods c where a.seller

38、_id=b.seller_idand a.goods_id=c.goods_id and a.buyer_id = '"+User.getUserName()+"'"resultSet = statement.executeQuery(sql);while(resultSet.next()Order order = new Order();Goods goods = new Goods();Seller seller = new Seller();order.setId(resultSet.getInt("order_id");

39、order.setNum(resultSet.getInt("num");order.setGoods_id(resultSet.getInt("goods_id");专业资料整理WORD格式"网上书店信息管理系统的设计与实现"第 15页共 34页goods.setId(resultSet.getInt("goods_id");goods.setPrice(resultSet.getShort("price");goods.setPrice(resultSet.getInt("pric

40、e");goods.setDiscount(resultSet.getInt("discount");goods.setName(resultSet.getString("goods_name");seller.setName(resultSet.getString("seller_name");seller.setAddress(resultSet.getString("address");order.setSeller(seller);order.setGoods(goods);/System.out

41、.println(order.toString();list.add(order); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace();finallytry resultSet.close();statement.close();conn.close(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return list;专业资料整理WORD格式/查询登录商家的所有订单专业资料整理W

42、ORD格式"网上书店信息管理系统的设计与实现"第 16页共 34页public ArrayList getSellerOrder()ArrayList list = new ArrayList();conn = Connect.getConnection();try statement = conn.createStatement();String sql = "select * from orders a,seller b,goods c where a.seller_id=b.seller_id "+"and a.goods_id=c.go

43、ods_id and a.seller_id= '"+User.getUserName()+"'"resultSet = statement.executeQuery(sql);while(resultSet.next()Order order = new Order();Goods goods = new Goods();Seller seller = new Seller();order.setId(resultSet.getInt("order_id");order.setNum(resultSet.getInt(&quo

44、t;num");order.setGoods_id(resultSet.getInt("goods_id");order.setBuyer_id(resultSet.getString("buyer_id");goods.setId(resultSet.getInt("goods_id");goods.setPrice(resultSet.getShort("price");goods.setPrice(resultSet.getInt("price");goods.setDiscou

45、nt(resultSet.getInt("discount");goods.setName(resultSet.getString("goods_name");seller.setName(resultSet.getString("seller_name");seller.setAddress(resultSet.getString("address");order.setSeller(seller);order.setGoods(goods);list.add(order); catch (SQLExceptio

46、n e) 专业资料整理WORD格式"网上书店信息管理系统的设计与实现"第 17页共 34页/ TODO Auto-generated catch block e.printStackTrace();finallytry resultSet.close();statement.close();conn.close(); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace();return list;public static void main(String args) Orde

47、rDao dao = new OrderDao();dao.getOrder();package com.shoeShop.dao;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;专业资料整理WORD格式import com.shoeShop.db.Connect;专业资料整理WORD格式"网上书店信息管理系统的设计与实现"第 18页共 34页import com.shoeShop.entity.Seller

48、;public class SellerDao private static Connection conn;private static Statement statement;private static ResultSet resultSet;/插入数据，用于注册public int insertSeller(Seller seller)int flag = 0;conn = Connect.getConnection();try statement = conn.createStatement();String sql = "insert into seller values

49、('"+seller.getId()+"','"+seller.getName()+"','"+seller.getPwd()+"','"+seller.getAddress()+"')"flag = statement.executeUpdate(sql);statement.close();conn.close(); catch (SQLException e) / TODO Auto-generated catch blocke.pri

50、ntStackTrace();return flag;/通过用户名和密码查询，用于登录public static Seller getSeller(String name,String pwd)conn = Connect.getConnection();Seller seller = new Seller();try statement = conn.createStatement();专业资料整理WORD格式"网上书店信息管理系统的设计与实现"第 19页共 34页String sql = "select * from seller where seller_i

51、d='"+name+"'and pwd ='"+pwd+"'"resultSet =statement.executeQuery(sql);while(resultSet.next()seller.setId(resultSet.getString("seller_id");seller.setName(resultSet.getString("seller_name");seller.setPwd(resultSet.getString("pwd");seller.setAddress(resultSet.getString("address");resultSet.close();statement.close();conn.close(); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace();return seller;public static void main(String args) SellerDao dao = new Selle