网上书店完整代码.docx

附录全部源代码 package com.shoeShop.db; import java.sql.C onn ecti on; import java.sql.DriverMa nager; import java.sql.SQLExcepti on; public class Conn ect { private static Connection con = n ull; private static Stri ng url="jdbc:oracle:thi n: @localhost:1521:ORCL"; private static String driver = "oracle.jdbc.driver.OracleDriver"; private static String user = "scott"; private static String pwd = "tiger"; public static Connection getC onnection(){ try { Class.forName(driver); con = DriverMa nager.getC onn ecti on( url, user, pwd); System.out.println(” 数据库连接成功！ ”)； } catch (ClassNotF oun dExcepti on e) { System.out.println(” 驱动加载失败！");; } catch (SQLException e) { System.out.println(” 数据库连接失败！ ”)； } return con; } public static void main(String[] args) { Conn ect.getC onn ecti on(); package com.shoeShop.act ion; import java.awt.eve nt.Act ion Eve nt; import java.awt.eve nt.Act ion Liste ner; import javax.swi ng.JPa nel; import com.shoeShop.view.RegisterFrame; public class docMe nu Actio n impleme nts Action Liste ner { RegisterFrame register = nu II; JPa nel cusPa nel = n ull; JPa nel docPa nel = nu II; public docMe nuAction( RegisterFrame register" this.register = register; this.cusPa nel = register.cusPa nel; this.docPa nel = register.docPa nel; } public void action Performed(Acti onEvent e) { // TODO Auto-ge nerated method stub register.flag = 1; //System.out.pri ntln( register.flag); register.remove(cusPa nel); register.add(docPa nel); docPa nel.updateUI(); } } package com.shoeShop.dao; import java.sql.C onn ecti on; import java.sql.ResultSet; import java.sql.SQLExcepti on; import java.sql.Stateme nt; import com.shoeShop.db.C onn ect; import com.shoeShop.e ntity.Buyer; import com.shoeShop.e ntity.Seller; public class BuyerDao { private static Connection conn; private static Stateme nt stateme nt; private static ResultSet resultSet; //插入数据，用于注册 public int in sertBuyer(Buyer buyer){ int flag = 0; conn = Conn ect.getC onnection(); try { stateme nt = conn. createStateme nt();