互联网书店管理系统-代码

最新推荐文章于 2024-09-15 16:45:45 发布

彡亽

最新推荐文章于 2024-09-15 16:45:45 发布

阅读量575

点赞数

文章标签： java sql 单例模式

本文链接：https://blog.csdn.net/qq_51884866/article/details/125044731

版权

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 stub
register.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 buyer values('"+buyer.getId()+"','"+buyer.getName()+"','"+buyer.getPwd()+"','"+buyer.getAddress()+"')";

// System.out.println(“buyer”+sql);
flag = statement.executeUpdate(sql);
statement.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
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.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 block
		e.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 com.shoeShop.imp.User;

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 where a.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 block
e.printStackTrace();
}finally{
try {
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.getConnection();
	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.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"));

//根据商品号查询商品信息
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 block
		e.printStackTrace();
	}finally{
		try {
			resultSet.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();
		String sql = "update goods set goods_name='"+goods.getName()+"',price ="+goods.getPrice()
				+",discount ="+goods.getDiscount()+",num="+goods.getNum()+" where goods_id="+goods.getId();
	
		flag = statement.executeUpdate(sql);
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}finally{
		try {
			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();
		String sql = "delete goods where goods_id = "+id;
		flag = statement.executeUpdate(sql);
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}finally{
		try {
			statement.close();
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.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) from goods),'"+User.getUserName()+"','"+goods.getName()+"',"+goods.getPrice()+","+goods.getDiscount()+","+goods.getNum()+")";
		flag = statement.executeUpdate(sql);
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}finally{
		try {
			statement.close();
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.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 com.shoeShop.imp.User;

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) from orders),"+goods.getId()+",'"+goods.getSeller_id()+"','"+User.getUserName()+"',"+num+")";
		flag = statement.executeUpdate(sql);
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}finally{
		try {
			statement.close();
			conn.close();
		} catch (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 * 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 block
e.printStackTrace();
}finally{
try {
resultSet.close();
statement.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.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 block
		e.printStackTrace();
	}finally{
		try {
			resultSet.close();
			statement.close();
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.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 seller values('”+seller.getId()+“‘,’”+seller.getName()+“‘,’”+seller.getPwd()+“‘,’”+seller.getAddress()+“')”;
flag = statement.executeUpdate(sql);
statement.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.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 where seller_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 block
			e.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.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:sqlserver://localhost:1433;databaseName=软件工程;user=text;password=123456789;”;
private static String driver = “com.microsoft.sqlserver.jdbc.SQLServerDriver”;
public static Connection getConnection(){
try {
Class.forName(driver);
con = DriverManager.getConnection(url);
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.entity;
/**
*功能：商家实体类

@author：
*2022-5-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) {
this.name = name;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}

@Override
public String toString() {
return “Buyer [id=” + id + “, name=” + name + “, address=” + address
+ “]”;
}
}

package com.shoeShop.entity;
/**
*
*功能：商品实体类

@author：
*2022-5-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) {
this.name = name;
}
public int getPrice() {
return price;
}
public void setPrice(int price) {
this.price = price;
}
@Override
public 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：
*2022-5-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;
}
@Override
public 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：
*2022-5-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) {
this.name = name;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
@Override
public 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) {
	User.userName = 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() {		
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			setVisible(false);
		}
	});
	btSure.addActionListener(new ActionListener() {	
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			if(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) {
	System.out.println("hello");
	AddGoodsFrame frame = new AddGoodsFrame();
	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(new String[]{“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);
}

//borderlayout 北边面板设置
private void setMenuBar(){
	menuBar.add(goodsMenu);
	goodsMenu.add(goodsMenuItem);
	goodsMenuItem.addActionListener(new ActionListener() {	
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			setAr();
			remove(orderPanel);
			add(goodsPanel);
			goodsPanel.updateUI();
		}
	});
	
	menuBar.add(orderMenu);
	orderMenu.add(orderMenuItem);
	orderMenuItem.addActionListener(new ActionListener() {	
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			setOr();
			remove(goodsPanel);
			add(orderPanel);
			orderPanel.updateUI();
		}
	});
}

//borderlayout 南边面板设置
private void setSouthPanel(){
	southPanel.add(new JLabel("请输入商品编号："));
	southPanel.add(fieldId);
	southPanel.add(new JLabel("商品数量："));
	southPanel.add(numBox);
	//修改
	southPanel.add(btAdd);
	btAdd.addActionListener(new ActionListener() {	
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			GoodsDao dao = new GoodsDao();
			Goods goods = new Goods();
			if("".equals(fieldId.getText())){
				JOptionPane.showMessageDialog(null, "请输入商品编号或商品数量！");		
			}else{
				int id = Integer.parseInt(fieldId.getText());
				int num = Integer.parseInt((String) numBox.getSelectedItem());
				goods = dao.getOneGoods(id);
				if(JOptionPane.showConfirmDialog(null, "您确定要购买吗？")==0){
					if(goods.getId()==0){
						JOptionPane.showMessageDialog(null, "商品编号输入错误！");	
					}else{
						if(goods.getNum()<num){
							JOptionPane.showMessageDialog(null, "商品数量不足！");	
						}else{
							goods.setNum(goods.getNum()-num);
							dao.updateGoods(goods);
							OrderDao order = new OrderDao();
							order.inserOerderByGoods(goods, num);
							JOptionPane.showMessageDialog(null, "购买成功！");
							setAr();
							setOr();

							goodsPanel.updateUI();
						}
					}
				}else{
				}
			}
			
		}
	});
}

//borderlayout 中间商品面板设置
private void setGoodsPanel(){
	Object columnName[]={"商品号","商品名","单价","折扣","折后价","剩余数量","商家名称","商家地址"};
	JTable table=new JTable(ar,columnName);//ar存放表中的数据，columnname表示列名
	setAr();
	JScrollPane scrollpane = new JScrollPane(table);
	goodsPanel.add(scrollpane);
}
private void setAr(){
	setArNull();
	GoodsDao dao = new GoodsDao();
	ArrayList list = new ArrayList();
	list = dao.getAllSellerGoods();
	for(int i=0;i<list.size();++i){
		Goods goods = (Goods) list.get(i);
		ar[i][0]=goods.getId();
		ar[i][1]=goods.getName();
		ar[i][2]=goods.getPrice();
		ar[i][3]=goods.getDiscount();
		ar[i][4]=goods.getPrice()*goods.getDiscount()+0.1;
		ar[i][5]=goods.getNum();
		ar[i][6]=goods.getSeller().getName();
		ar[i][7]=goods.getSeller().getAddress();
	}
}
private void setArNull(){
	for(int i=0;i<ar.length;i++){
		for(int j=0;j<ar[i].length;j++){
			ar[i][j]="";
		}
	}
}

//订单面板
private void setOrderPanel(){
	Object columnName[]={"订单号","商品号","商品名","单价","折扣","折后价","购买数量","商家名称","商家地址"};
	JTable table=new JTable(or,columnName);//ar存放表中的数据，columnname表示列名
	setOr();
	JScrollPane scrollpane = new JScrollPane(table);
	orderPanel.add(scrollpane);
}
private void setOr(){
	setOrNull();
	OrderDao dao = new OrderDao();
	ArrayList list = new ArrayList();
	list = dao.getOrder();
	for(int i=0;i<list.size();++i){
		Order order = (Order) list.get(i);
		or[i][0]=order.getId();
		or[i][1]=order.getGoods_id();
		or[i][2]=order.getGoods().getName();
		or[i][3]=order.getGoods().getPrice();
		or[i][4]=order.getGoods().getDiscount();
		or[i][5]=order.getGoods().getPrice()*order.getGoods().getDiscount()*0.1;
		or[i][6]=order.getNum();
		or[i][7]=order.getSeller().getName();
		or[i][8]=order.getSeller().getAddress();
	}
}
private void setOrNull(){
	for(int i=0;i<or.length;i++){
		for(int j=0;j<or[i].length;j++){
			or[i][j]="";
		}
	}
}

public static void main(String[] args) {
	BuyerFrame frame = new BuyerFrame();
	frame.setVisible(true);
}

}

package com.shoeShop.view;

import java.awt.Color;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JTextField;

import com.shoeShop.dao.BuyerDao;
import com.shoeShop.dao.SellerDao;
import com.shoeShop.entity.Buyer;
import com.shoeShop.entity.Seller;
import com.shoeShop.imp.User;

public class LoginFrame extends JFrame{
private JLabel userNameLabel = new JLabel(“用户名：”);
private JLabel pwdLabel = new JLabel(“密码：”);
private JTextField useNameText = new JTextField();
private JPasswordField pws = new JPasswordField();
private JLabel roleLabel = new JLabel(“角色：”);
private JComboBox roleBox = new JComboBox(new String[]{“商家”,“买家”});
private JButton bt = new JButton(“确定”);
private JButton btR = new JButton(“取消”);
private String flag = null;

public LoginFrame(){
	init();
}

private void init(){
	this.setSize(320, 280);
	this.setTitle("登录");
	this.setIconImage(new ImageIcon("images/1.png").getImage());
	this.setLocationRelativeTo(null);
	this.setResizable(false);
	this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
	this.setLayout(null);
	userNameLabel.setBounds(40, 20, 150, 30);
	this.add(userNameLabel);
	useNameText.setBounds(120, 20, 150, 30);
	this.add(useNameText);
	pwdLabel.setBounds(40, 80, 150, 30);
	this.add(pwdLabel);
	pws.setBounds(120, 80, 150, 30);
	this.add(pws);
	roleLabel.setBounds(40, 140, 70, 30);
	this.add(roleLabel);
	roleBox.setBounds(120, 140, 150, 30);
	this.add(roleBox);
	btR.setBounds(40, 200, 70, 30);
	this.add(btR);
	btR.addActionListener(new ActionListener() {		
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub			
				setVisible(false);
		}
	});
	bt.setBounds(200, 200, 70, 30);
	this.add(bt);
	bt.addActionListener(new ActionListener() {
		
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			User.setUserName(useNameText.getText());
			User.setPwd(pws.getText());
			String f = (String) roleBox.getSelectedItem();
			if("商家".equals(f)){
				flag = "seller";
			}
			if("买家".equals(f)){
				flag = "customer";
			}
			
			if("seller".equals(flag)){
				Seller seller = SellerDao.getSeller(useNameText.getText(), pws.getText());
				System.out.println("-----"+seller.toString());
				if(seller.getId()==null){
					JOptionPane.showMessageDialog(null, "用户名或密码输入错误");
				}else{
					setVisible(false);
					SellerFrame fame = new SellerFrame();
					fame.setVisible(true);
				}
			}if("customer".equals(flag)){
				Buyer buyer = BuyerDao.getBuyer(useNameText.getText(), pws.getText());
				if(buyer.getId()==null){
					JOptionPane.showMessageDialog(null, "用户名或密码输入错误");			
				}else{
					setVisible(false);
					BuyerFrame frame = new BuyerFrame();
					frame.setVisible(true);
				}
			}

// System.out.println(flag);
}
});

	this.setBackground(Color.gray);
}

public static void main(String[] args) {
	LoginFrame frame = new LoginFrame();
	frame.setVisible(true);
}

}

package com.shoeShop.view;

import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import javax.swing.BorderFactory;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JMenu;
import javax.swing.JMenuBar;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JTextArea;
import javax.swing.JTextField;

import com.shoeShop.action.docMenuAction;
import com.shoeShop.dao.BuyerDao;
import com.shoeShop.dao.SellerDao;
import com.shoeShop.entity.Buyer;
import com.shoeShop.entity.Seller;

/**
*
*功能：

@author：
*2012-9-20下午9:37:44
*/
public class RegisterFrame extends JFrame{

public JPanel docPanel = new JPanel();
public JPanel cusPanel = new JPanel();

private JMenuBar menuBar = new JMenuBar();
private JButton sellerMenu = new JButton(“seller”);
private JButton cusMenu = new JButton(“customer”);

private JButton btSure = new JButton(“确定”);
private JButton btReset = new JButton(“重置”);

//private JLabel label[] = new JLabel[7] ;
private JLabel label0 = new JLabel(“用户名*：”);
private JLabel label1 = new JLabel(“店铺名*：”);
private JLabel label2 = new JLabel(“密码*：”);
private JLabel label3 = new JLabel(“地址：”);

private JTextField fieldCus0 = new JTextField();
private JTextField fieldCus1 = new JTextField();
private JPasswordField fieldCus2 = new JPasswordField();
private JTextField fieldCus3 = new JTextField();
//private JTextField []fieldDoc = new JTextField[4];
JTextField fieldDoc0 = new JTextField();
JTextField fieldDoc1 = new JTextField();
JTextField fieldDoc2= new JTextField();
JTextField fieldDoc3 = new JTextField();
public static int flag = 0;//用于标记是顾客还是医生,0代表是顾客，1代表医生

// private JPanel cusPanel = null;
// private JPanel docPanel = null;

//构造函数
public RegisterFrame(){
	init();
}


//初始化JFrame
private void init(){
	setMenuBar();
	setCusPanel();
	setDocPanle();
	this.setTitle("注册");
	this.setIconImage(new ImageIcon("images/1.png").getImage());
	this.setSize(300, 400);

// this.setResizable(false);
this.setLocationRelativeTo(null);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

	this.add(menuBar,BorderLayout.NORTH);
	this.add(cusPanel,BorderLayout.CENTER);
	//this.add(docPanel,BorderLayout.CENTER);

// this.remove(docPanel);
//this.add(cusPanel);
this.add(setSPanel(),BorderLayout.SOUTH);
}

//设置JMenuBar
private void setMenuBar(){
	menuBar.add(sellerMenu);
	sellerMenu.addActionListener(new docMenuAction(this));
	
	menuBar.add(cusMenu);
	cusMenu.addActionListener(new ActionListener() {
		
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			flag = 0;
			//System.out.println(flag);
			remove(docPanel);
			add(cusPanel);
			cusPanel.updateUI();
		}
	});
}

//设置cusPanel
private void setCusPanel(){
	//设置组件与边框的间距
	cusPanel.setBorder(BorderFactory.createEmptyBorder(40, 30, 10, 30));
	cusPanel.setLayout(new GridLayout(5, 20, 10, 20));//设置布局方式为网格布局，组件间的间距为20
		cusPanel.add(new JLabel("用户名*："));
		//cusPanel.add(new JLabel("new jlabel"));
		cusPanel.add(fieldCus0);
		cusPanel.add(new JLabel("姓名*："));
		cusPanel.add(fieldCus1);
		cusPanel.add(new JLabel("密码*："));
		cusPanel.add(fieldCus2);
		cusPanel.add(new JLabel("地址："));
		cusPanel.add(fieldCus3);
	//设置字体为红色
	JLabel lb = new JLabel("带*为必填");
	lb.setForeground(Color.red);
	cusPanel.add(lb);
}

//设置docPanel
private void setDocPanle(){
	//设置组件与边框的间距
	docPanel.setBorder(BorderFactory.createEmptyBorder(40, 30, 10, 30));
	docPanel.setLayout(new GridLayout(5, 20, 10, 20));//设置布局方式为网格布局，组件间的间距为20

		docPanel.add(label0);
		docPanel.add(fieldDoc0);
		docPanel.add(label1);
		docPanel.add(fieldDoc1);
		docPanel.add(label2);
		docPanel.add(fieldDoc2);
		docPanel.add(label3);
		docPanel.add(fieldDoc3);

	//设置字体为红色
	JLabel lb = new JLabel("带*为必填");
	lb.setForeground(Color.red);
	docPanel.add(lb);
}

//设置南面的JPanel
private JPanel setSPanel(){
	JPanel SPanel = new JPanel();		
	//设置提示信息、确定和重置按钮		
	JPanel panel = new JPanel();
	panel.add(btSure,BorderLayout.WEST);
	//确定按钮事件
	btSure.addActionListener(new ActionListener() {		
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			if(flag==0){
				Buyer buyer = new Buyer();
				buyer.setId(fieldCus0.getText());
				buyer.setName(fieldCus1.getText());
				buyer.setPwd(fieldCus2.getText());
				buyer.setAddress(fieldCus3.getText());
				System.out.println(buyer.toString());
				
				BuyerDao dao = new BuyerDao();
				int flag_1 = dao.insertBuyer(buyer);
				if(flag_1!=0){
					JOptionPane.showMessageDialog(cusPanel, "注册成功");
				}
			}else{
				Seller seller = new Seller();
				System.out.println("fieldCus0.getText():"+fieldDoc0.getText());
				seller.setId(fieldDoc0.getText());
				seller.setName(fieldDoc1.getText());
				seller.setPwd(fieldDoc2.getText());
				seller.setAddress(fieldDoc3.getText());
				
				System.out.println("seller:"+seller.toString());
				
				SellerDao sellerDao = new SellerDao();
				int flag_1 = sellerDao.insertSeller(seller);
				if(flag_1!=0){
					JOptionPane.showMessageDialog(cusPanel, "注册成功");
				}	
			}
		}
	});
	
	panel.add(btReset,BorderLayout.EAST);
	btReset.addActionListener(new ActionListener() {
		
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			if(flag==0){
					fieldCus0.setText("");
					fieldCus1.setText("");
					fieldCus2.setText("");
					fieldCus3.setText("");
					docPanel.updateUI();
			}else{
				fieldDoc0.setText("");
				fieldDoc1.setText("");
				fieldDoc2.setText("");
				fieldDoc3.setText("");
				cusPanel.updateUI();
				cusPanel.updateUI();
			}

// cusPanel.updateUI();
// docPanel.updateUI();
}
});

	//设置spanel
	SPanel.add(panel,BorderLayout.SOUTH);
	return SPanel;
}

public static void main(String[] args) {
	RegisterFrame register = new RegisterFrame();
	register.setVisible(true);
}

}

package com.shoeShop.view;

import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Menu;
import java.awt.MenuBar;
import java.awt.MenuItem;
import java.awt.Rectangle;
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.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 SellerFrame 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 JButton btUpdate = new JButton(“修改”);
private JTextField field = new JTextField(15);
Object ar[][] =new Object[80][8];
Object or[][] =new Object[80][8];

public SellerFrame(){
	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.yellow);
	this.add(goodsPanel,BorderLayout.CENTER);
	
	orderPanel.setBackground(Color.orange);
	
	setSouthPanel();
	setOrderPanel();
	this.add(southPanel,BorderLayout.SOUTH);
}

//borderlayout 北边面板设置
private void setMenuBar(){
	menuBar.add(goodsMenu);
	goodsMenu.add(goodsMenuItem);
	goodsMenuItem.addActionListener(new ActionListener() {	
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			remove(orderPanel);
			setAr();
			add(goodsPanel);
			goodsPanel.updateUI();
		}
	});
	
	menuBar.add(orderMenu);
	orderMenu.add(orderMenuItem);
	orderMenuItem.addActionListener(new ActionListener() {	
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			remove(goodsPanel);
			setOr();
			add(orderPanel);
			orderPanel.updateUI();
		}
	});
}

//borderlayout 南边面板设置
private void setSouthPanel(){
	southPanel.add(new JLabel("请输入商品编号："));
	southPanel.add(field);
	southPanel.add(btUpdate);
	//修改
	btUpdate.addActionListener(new ActionListener() {		
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			if("".equals(field.getText())){
				JOptionPane.showMessageDialog(null, "请输入商品编号！");		
			}else{
				int id = Integer.parseInt(field.getText());
				UpdateFrame frame = new UpdateFrame();
				Goods goods = new GoodsDao().getOneGoods(id);
				if(goods.getId()!=0){
					frame.setGoods(goods);
					frame.setText(goods);
					frame.setVisible(true);
				}else{
					JOptionPane.showMessageDialog(null, "商品编号输入错误！");
				}
			}
		}
	});
	southPanel.add(btDelet);
	//删除
	btDelet.addActionListener(new ActionListener() {	
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			if("".equals(field.getText())){
				JOptionPane.showMessageDialog(null, "请输入商品编号！");		
			}else{
				int id = Integer.parseInt(field.getText());
				GoodsDao dao = new GoodsDao();
				if(JOptionPane.showConfirmDialog(null, "您确定要删除吗？")==0){
					if(dao.deleteById(id)!=0){
						JOptionPane.showMessageDialog(null, "删除成功！");
					}else{
						JOptionPane.showMessageDialog(null, "商品编号输入错误！！");
					}
				}else{}
			}
		}
	});
	southPanel.add(btAdd);
	btAdd.addActionListener(new ActionListener() {	
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			AddGoodsFrame frame = new AddGoodsFrame();
			frame.setVisible(true);
		}
	});
}

//borderlayout 中间商品面板设置
private void setGoodsPanel(){
	Object columnName[]={"商品号","商品名","单价","折扣","折后价","剩余数量","商家名称","商家地址"};
	JTable table=new JTable(ar,columnName);//ar存放表中的数据，columnname表示列名
	setAr();
	JScrollPane scrollpane = new JScrollPane(table);
	goodsPanel.add(scrollpane);
}
private void setAr(){
	setArNull();
	GoodsDao dao = new GoodsDao();
	ArrayList list = new ArrayList();
	list = dao.getAllGoods();
	for(int i=0;i<list.size();++i){
		Goods goods = (Goods) list.get(i);
		ar[i][0]=goods.getId();
		ar[i][1]=goods.getName();
		ar[i][2]=goods.getPrice();
		ar[i][3]=goods.getDiscount();
		ar[i][4]=goods.getPrice()*goods.getDiscount()*0.1;
		ar[i][5]=goods.getNum();
		ar[i][6]=goods.getSeller().getName();
		ar[i][7]=goods.getSeller().getAddress();
	}
}
private void setArNull(){
	for(int i=0;i<ar.length;i++){
		for(int j=0;j<ar[i].length;j++){
			ar[i][j]="";
		}
	}
}

//订单面板
	private void setOrderPanel(){
		Object columnName[]={"订单号","商品号","商品名","单价","折扣","折后价","购买数量","客户名称"};
		JTable table=new JTable(or,columnName);//ar存放表中的数据，columnname表示列名
		setOr();
		JScrollPane scrollpane = new JScrollPane(table);
		orderPanel.add(scrollpane);
	}
	private void setOr(){
		setOrNull();
		OrderDao dao = new OrderDao();
		ArrayList list = new ArrayList();
		list = dao.getSellerOrder();
		for(int i=0;i<list.size();++i){
			Order order = (Order) list.get(i);
			or[i][0]=order.getId();
			or[i][1]=order.getGoods_id();
			or[i][2]=order.getGoods().getName();
			or[i][3]=order.getGoods().getPrice();
			or[i][4]=order.getGoods().getDiscount();
			or[i][5]=order.getGoods().getPrice()*order.getGoods().getDiscount()*0.1;
			or[i][6]=order.getNum();
			or[i][7]=order.getBuyer_id();
		}
	}
	private void setOrNull(){
		for(int i=0;i<or.length;i++){
			for(int j=0;j<or[i].length;j++){
				or[i][j]="";
			}
		}
	}

public static void main(String[] args) {
	SellerFrame frame = new SellerFrame();
	frame.setVisible(true);
}

}

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.JPanel;
import javax.swing.JTextField;

import com.shoeShop.dao.GoodsDao;
import com.shoeShop.entity.Goods;

public class UpdateFrame 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 UpdateFrame(){
	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);
setText(goods);
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() {		
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			setVisible(false);
		}
	});
	btSure.addActionListener(new ActionListener() {	
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			if(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.updateGoods(goods);
				setVisible(false);
				JOptionPane.showMessageDialog(null, "修改成功！");
			}else{
				//
			}
		}
	});
}

public void setText(Goods goods){
	fieldName.setText(goods.getName());
	fieldPrice.setText(String.valueOf(goods.getPrice()));
	fieldDiscount.setText(String.valueOf(goods.getDiscount()));
	fieldNum.setText(String.valueOf(goods.getNum()));
}
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);
}

}