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

1、附錄 全部源代碼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.d

2、river.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);intln("數(shù)據(jù)庫(kù)連接成功！"); catch (ClassNotFoundException e) System.

3、out.println("驅(qū)動(dòng)加載失??！"); catch (SQLException e) System.out.println("數(shù)據(jù)庫(kù)連接失??！");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;impor

4、t 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;

5、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.SQLExcep

6、tion;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;/插入數(shù)據(jù)，用于注冊(cè)public int insertBuyer(Buyer buyer)int

7、 flag = 0;conn = Connect.getConnection();try statement = conn.createStatement();String sql = "insert into buyer values('"+buyer.getId()+"','"+buyer.getName()+"','"+buyer.getPwd()+"','"+buyer.getAddress()+"')"/System.ou

8、t.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;/通過(guò)用戶名和密碼查詢，用于登錄public static Buyer getBuyer(String name,String pwd)conn = Connect.ge

9、tConnection();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(&

10、quot;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.print

11、StackTrace();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("長(zhǎng)理專賣");/buyer.setPwd("123456");/buyer.setAdd

12、ress("湖南長(zhǎng)沙");/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.Se

13、ller;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.crea

14、teStatement();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_nam

15、e");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.setDi

16、scount(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();finallytry resultSet.close

17、();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 = &quo

18、t;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 Good

19、s();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"

20、;);goods.setPrice(resultSet.getInt("price");/System.out.println(goods.toString();list.add(goods); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();finallytry resultSet.close();statement.close();conn.close(); catch (SQLException e) / TODO Auto-generated catch bloc

21、ke.printStackTrace();return list;/根據(jù)商品號(hào)查詢商品信息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(

22、)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.se

23、tNum(resultSet.getInt("num"); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();finallytry resultSet.close();statement.close();conn.close(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return goods;/修改商品信息public int updateGoods(Good

24、s 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 g

25、oods_id="+goods.getId();flag = statement.executeUpdate(sql); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();finallytry statement.close();conn.close(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return flag;/通過(guò)id刪除商品public int deleteB

26、yId(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();finallytry statement.close();conn.

27、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) from goods),&#

28、39;"+User.getUserName()+"','"+goods.getName()+"',"+goods.getPrice()+","+goods.getDiscount()+","+goods.getNum()+")"flag = statement.executeUpdate(sql); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();finall

29、ytry 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("niclas

30、cage");/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.setDiscou

31、nt(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.

32、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 inserOerderByG

33、oods(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()+"

34、',"+num+")"flag = statement.executeUpdate(sql); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();finallytry statement.close();conn.close(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return flag;/查詢登錄用戶的所有訂單public ArrayLi

35、st 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()+"'"resu

36、ltSet = 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.

37、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(&

38、quot;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();finallytry resultSet.close();statement.cl

39、ose();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,se

40、ller 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.s

41、etId(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("p

42、rice");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");ord

43、er.setSeller(seller);order.setGoods(goods);list.add(order); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();finallytry resultSet.close();statement.close();conn.close(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return list;public static v

44、oid main(String args) OrderDao dao = new OrderDao();dao.getOrder();package com.shoeShop.dao;import java.sql.Connection;import java.sql.ResultSet;ception;import java.sql.Statement;import com.shoeShop.db.Connect;import com.shoeShop.entity.Seller;public class SellerDao private static Connection conn;pr

45、ivate static Statement statement;private static ResultSet resultSet;/插入數(shù)據(jù)，用于注冊(cè)public int insertSeller(Seller seller)int flag = 0;conn = Connect.getConnection();try statement = conn.createStatement();String sql = "insert into seller values('"+seller.getId()+"','"+selle

46、r.getName()+"','"+seller.getPwd()+"','"+seller.getAddress()+"')"flag = statement.executeUpdate(sql);statement.close();conn.close(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return flag;/通過(guò)用戶名和密碼查詢，用于登錄public static

47、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.executeQuer

48、y(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.clos

49、e(); 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");/sel

50、ler.setName("長(zhǎng)理專賣");/seller.setPwd("123456");/seller.setAddress("湖南長(zhǎng)沙");/dao.insertSeller(seller);package com.shoeShop.entity;/* *功能：商家實(shí)體類 * author：蔣斌 *2012-9-19下午4:17:40 */public class Buyer private String id;private String name;private String address;private String pw

51、d;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 setA

52、ddress(String address) this.address = address;Overridepublic String toString() return "Buyer id=" + id + ", name=" + name + ", address=" + address+ ""package com.shoeShop.entity;/* * *功能：商品實(shí)體類 * author：蔣斌 *2012-9-19下午4:26:05 */public class Goods private int id

53、;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)

54、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 getN