网上书店完整代码

网上书店完整代码-CAL-FENGHAI-(2020YEAR-YICAI)_JINGBIAN附录全部源代码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 static 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("数据库连接成功！");} catch (ClassNotFoundException e) {System.out.println("驱动加载失败！");;} catch (SQLException e) {System.out.println("数据库连接失败！");}return con;}public static void main(String[] args) {Connect.getConnection();}}package com.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 docMenuAction(RegisterFrame register){this.register = register;this.cusPanel = register.cusPanel;this.docPanel = register.docPanel;}public void actionPerformed(ActionEvent e) {// TODO Auto-generated method stubregister.flag = 1;//System.out.println(register.flag);register.remove(cusPanel);register.add(docPanel);docPanel.updateUI();}}package com.shoeShop.dao;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.entity.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 buyervalues('"+buyer.getId()+"','"+buyer.getName()+"','"+buyer.getPwd()+"','"+buyer.getA ddress()+"')";// System.out.println("buyer"+sql);flag = statement.executeUpdate(sql);statement.close();conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.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.createStatement();String sql = "select * from buyer where 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"));buyer.setPwd(resultSet.getString("pwd"));buyer.setAddress(resultSet.getString("address"));}resultSet.close();statement.close();conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return buyer;}public 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("湖南长沙");// dao.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 er;public class GoodsDao {private static Connection conn;private static Statement statement;private static ResultSet resultSet;//查询登录商家的所有商品，用于商家管理自己的商品public ArrayList getAllGoods(){ArrayList list = new ArrayList();conn = Connect.getConnection();try {statement = conn.createStatement();String sql = "select * from goods a,seller b wherea.seller_id=b.seller_id and b.seller_id='"+User.getUserName()+"'";resultSet = statement.executeQuery(sql);while(resultSet.next()){Seller seller = new Seller();seller.setName(resultSet.getString("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"));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 blocke.printStackTrace();}finally{try {resultSet.close();statement.close();conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}return list;}//查询所有商家的所有商品.用于用户搜索商品public ArrayList getAllSellerGoods(){ArrayList list = new ArrayList();conn = Connect.getConnection();try {statement = conn.createStatement();String sql = "select * from goods a,seller b wherea.seller_id=b.seller_id";resultSet = statement.executeQuery(sql);while(resultSet.next()){Seller seller = new Seller();seller.setName(resultSet.getString("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"));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 blocke.printStackTrace();}finally{try {resultSet.close();statement.close();conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}return list;}//根据商品号查询商品信息public Goods getOneGoods(int id){Goods goods = new Goods();conn = Connect.getConnection();try {statement = conn.createStatement();String sql = "select * from goods where goods_id = "+id;resultSet = statement.executeQuery(sql);while(resultSet.next()){goods.setId(id);goods.setName(resultSet.getString("goods_name"));goods.setPrice(resultSet.getInt("price"));goods.setNum(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();}finally{try {resultSet.close();statement.close();conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}return goods;}//修改商品信息public int updateGoods(Goods goods){int flag = 0;conn = Connect.getConnection();try {statement = conn.createStatement();String sql = "update goods setgoods_name='"+goods.getName()+"',price ="+goods.getPrice()+",discount="+goods.getDiscount()+",num="+goods.getNum()+" wheregoods_id="+goods.getId();flag = statement.executeUpdate(sql);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{try {statement.close();conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}return flag;}//通过id删除商品public int deleteById(int id){int flag = 0;conn = Connect.getConnection();try {statement = conn.createStatement();String sql = "delete goods where goods_id = "+id;flag = statement.executeUpdate(sql);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{try {statement.close();conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}return flag;}//添加public int insertGoods(Goods goods){int flag = 0;conn = Connect.getConnection();try {statement = conn.createStatement();String sql = " insert into goods values((select max(goods_id+1) fromgoods),'"+User.getUserName()+"','"+goods.getName()+"',"+goods.getPrice()+","+goo ds.getDiscount()+","+goods.getNum()+")";flag = statement.executeUpdate(sql);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{try {statement.close();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("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);// goods.setDiscount(8);// goods.setNum(5);// System.out.println(dao.updateGoods(goods));dao.getAllSellerGoods();// System.out.println(dao.getOneGoods(1));}}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.Order;import com.shoeShop.entity.Seller;import er;public class OrderDao {private static Connection conn;private static Statement statement;private static ResultSet resultSet;//插入public int inserOerderByGoods(Goods goods, int num){ int flag = 0;conn = Connect.getConnection();try {statement = conn.createStatement();String sql = "insert into orders values((select max(order_id+1) fromorders),"+goods.getId()+",'"+goods.getSeller_id()+"','"+User.getUserName()+"',"+nu m+")";flag = statement.executeUpdate(sql);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{try {statement.close();conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}return flag;}//查询登录用户的所有订单public ArrayList getOrder(){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.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"));order.setNum(resultSet.getInt("num"));order.setGoods_id(resultSet.getInt("goods_id"));goods.setId(resultSet.getInt("goods_id"));goods.setPrice(resultSet.getShort("price"));goods.setPrice(resultSet.getInt("price"));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.println(order.toString());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 catch blocke.printStackTrace();}}return list;}//查询登录商家的所有订单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.goods_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("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.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);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 catch blocke.printStackTrace();}}return list;}public static void main(String[] args) {OrderDao 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;import com.shoeShop.db.Connect;import com.shoeShop.entity.Seller;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 sellervalues('"+seller.getId()+"','"+seller.getName()+"','"+seller.getPwd()+"','"+seller.getAd dress()+"')";flag = statement.executeUpdate(sql);statement.close();conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return flag;}//通过用户名和密码查询，用于登录public static Seller getSeller(String name,String pwd){conn = Connect.getConnection();Seller seller = new Seller();try {statement = conn.createStatement();String sql = "select * from seller whereseller_id='"+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 blocke.printStackTrace();}return seller;}public static void main(String[] args) {SellerDao dao = new SellerDao();// System.out.println(dao.getSeller("蒋斌", "654321")); // Seller seller = new Seller();// seller.setId("lily");// seller.setName("长理专卖");// seller.setPwd("123456");// seller.setAddress("湖南长沙");// dao.insertSeller(seller);}}package com.shoeShop.entity;/***功能：商家实体类* @author：蒋斌*2012-9-19下午4:17:40*/public class Buyer {private String id;private String name;private String address;private String pwd;public String getPwd() {return pwd;}public void setPwd(String pwd) {this.pwd = pwd;}public String getId() {return id;}public void setId(String id) {this.id = id;}public String getName() {return name;}public void setName(String name) { = name;}public String getAddress() {return address;}public void setAddress(String address) {this.address = address;}@Overridepublic String toString() {return "Buyer [id=" + id + ", name=" + name + ", address=" + address+ "]";}}package com.shoeShop.entity;/****功能：商品实体类* @author：蒋斌*2012-9-19下午4:26:05*/public class Goods {private int id;private String seller_id;private Seller seller;private String name;private int price;private int discount;private int num;public Seller getSeller() {return seller;}public void setSeller(Seller seller) {this.seller = seller;}public int getDiscount() {return discount;}public void setDiscount(int discount) {this.discount = discount;}public int getNum() {return num;}public void setNum(int num) {this.num = num;}public int getId() {return id;}public void setId(int id) {this.id = id;}public String getSeller_id() {return seller_id;}public void setSeller_id(String seller_id) { this.seller_id = seller_id;}public String getName() {return name;}public void setName(String name) { = name;}public int getPrice() {return price;}public void setPrice(int price) {this.price = price;}@Overridepublic String toString() {return "Goods [id=" + id + ", seller_id=" + seller_id + ", seller="+ seller + ", name=" + name + ", price=" + price+ ", discount=" + discount + ", num=" + num + "]";}}package com.shoeShop.entity;/****功能：订单实体类* @author：蒋斌*2012-9-19下午4:26:24*/public class Order {private int id;private int goods_id;private String seller_id;private String buyer_id;private Goods goods;private Seller seller;private Buyer buyer;private int num;public int getNum() {return num;}public void setNum(int num) {this.num = num;}public Goods getGoods() {return goods;}public void setGoods(Goods goods) {this.goods = goods;}public Seller getSeller() {return seller;}public void setSeller(Seller seller) {this.seller = seller;}public Buyer getBuyer() {return buyer;}public void setBuyer(Buyer buyer) {this.buyer = buyer;}public int getId() {return id;}public void setId(int id) {this.id = id;}public int getGoods_id() {return goods_id;}public void setGoods_id(int goods_id) { this.goods_id = goods_id;}public String getSeller_id() {return seller_id;}public void setSeller_id(String seller_id) { this.seller_id = seller_id;}public String getBuyer_id() {return buyer_id;}public void setBuyer_id(String buyer_id) {this.buyer_id = buyer_id;}@Overridepublic String toString() {return "Order [id=" + id + ", goods_id=" + goods_id + ", seller_id="+ seller_id + ", buyer_id=" + buyer_id + ", goods=" + goods+ ", seller=" + seller + ", buyer=" + buyer + ", num=" + num+ "]";}}package com.shoeShop.entity;/***功能：买家实体类* @author：*2012-9-19下午4:16:46*/public class Seller {private String id;private String name;private String pwd;private String address;public String getPwd() {return pwd;}public void setPwd(String pwd) {this.pwd = pwd;}public String getId() {return id;}public void setId(String id) {this.id = id;}public String getName() {return name;}public void setName(String name) { = name;}public String getAddress() {return address;}public void setAddress(String address) {this.address = address;}@Overridepublic String toString() {return "Seller [id=" + id + ", name=" + name + ", pwd=" + pwd+ ", address=" + address + "]";}}package com.shoeShop.imp;public class User {private static int flag = 0;private static String userName;private static String pwd;public static String getPwd() {return pwd;}public static void setPwd(String pwd) {User.pwd = pwd;}public static String getUserName() {return userName;}public static void setUserName(String userName) {erName = userName;}public static int getFlag() {return flag;}public static void setFlag(int flag) {User.flag = flag;}}package com.shoeShop.view;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.ImageIcon;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JTextField;import com.shoeShop.dao.GoodsDao;import com.shoeShop.entity.Goods;public class AddGoodsFrame extends JFrame{private static final Goods Goods = null;private JLabel lbName = new JLabel("商品名：");private JLabel lbPrice = new JLabel("价格：");private JLabel lbDiscount = new JLabel("折扣：");private JLabel lbNum = new JLabel("数量：");private JTextField fieldName = new JTextField(20);private JTextField fieldPrice = new JTextField(20);private JTextField fieldDiscount = new JTextField(20);private JTextField fieldNum = new JTextField(20);private JButton btSure = new JButton("确定");private JButton btCancel = new JButton("取消");private Goods goods = new Goods();public AddGoodsFrame(){init();}private void init(){this.setSize(320, 330);this.setTitle("商品添加");this.setIconImage(new ImageIcon("images/1.png").getImage());this.setLayout(null);this.setLocationRelativeTo(null);this.setResizable(false);// this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);this.setLayout(null);setContentPanel();}private void setContentPanel(){lbName.setBounds(30, 30, 80, 30);fieldName.setBounds(130, 30, 150, 30);lbPrice.setBounds(30, 90, 80, 30);fieldPrice.setBounds(130, 90, 150, 30);lbDiscount.setBounds(30, 150, 80, 30);fieldDiscount.setBounds(130, 150, 150, 30);lbNum.setBounds(30, 200, 80, 30);fieldNum.setBounds(130, 200, 150, 30);btCancel.setBounds(30, 250, 70, 30);btSure.setBounds(210, 250, 70, 30);this.add(lbName);this.add(fieldName);this.add(lbPrice);this.add(fieldPrice);this.add(lbDiscount);this.add(fieldDiscount);this.add(lbNum);this.add(fieldNum);this.add(btCancel);this.add(btSure);btCancel.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {// TODO Auto-generated method stubsetVisible(false);}});btSure.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {// TODO Auto-generated method stubif(JOptionPane.showConfirmDialog(null, "您确定要添加吗")==0){GoodsDao dao = new GoodsDao();goods.setDiscount(Integer.valueOf(fieldDiscount.getText()));goods.setName(fieldName.getText());goods.setNum(Integer.valueOf(fieldNum.getText()));goods.setPrice(Integer.valueOf(fieldPrice.getText()));dao.insertGoods(goods);setVisible(false);JOptionPane.showMessageDialog(null, "添加成功！");}else{//}}});}public Goods getGoods() {return goods;}public void setGoods(Goods goods) {this.goods = goods;}public static void main(String[] args) {UpdateFrame frame = new UpdateFrame();frame.setVisible(true);}}package com.shoeShop.view;import java.awt.BorderLayout;import java.awt.Color;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.util.ArrayList;import javax.swing.ImageIcon;import javax.swing.JButton;import javax.swing.JComboBox;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JMenu;import javax.swing.JMenuBar;import javax.swing.JMenuItem;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.JScrollPane;import javax.swing.JTable;import javax.swing.JTextField;import com.shoeShop.dao.GoodsDao;import com.shoeShop.dao.OrderDao;import com.shoeShop.entity.Goods;import com.shoeShop.entity.Order;public class BuyerFrame extends JFrame{private JPanel goodsPanel = new JPanel();//中间面板private JPanel orderPanel = new JPanel();//订单面板private JPanel southPanel = new JPanel();//南边用于方按钮的面板private JMenuBar menuBar = new JMenuBar();private JMenu goodsMenu = new JMenu("商品管理");private JMenu orderMenu = new JMenu("订单管理");private JMenuItem goodsMenuItem = new JMenuItem("商品购买");private JMenuItem orderMenuItem = new JMenuItem("订单管理"); // private JButton btDelet = new JButton("删除");private JButton btAdd = new JButton("购买");private JComboBox numBox = new JComboBox(newString[]{"1","2","3","4","5","6","7","8","9"});// private JButton btUpdate = new JButton("修改");private JTextField fieldId = new JTextField(15);Object ar[][] =new Object[80][8];Object or[][] =new Object[80][9];public BuyerFrame(){init();}private void init(){setMenuBar();this.setTitle("网上鞋购系统");this.setIconImage(new ImageIcon("images/1.png").getImage());this.setSize(600, 400);this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);this.setLocationRelativeTo(null);this.add(menuBar,BorderLayout.NORTH);setGoodsPanel();goodsPanel.setBackground(Color.GRAY);this.add(goodsPanel,BorderLayout.CENTER);orderPanel.setBackground(Color.LIGHT_GRAY);setSouthPanel();setOrderPanel();this.add(southPanel,BorderLayout.SOUTH);}。