【文章內(nèi)容簡介】 nnection(){try {(driver)。con = (url, user, pwd)。(數(shù)據(jù)庫連接成功！)。} catch (ClassNotFoundException e) {(驅(qū)動加載失??！)。} catch (SQLException e) {(數(shù)據(jù)庫連接失?。?。}return con。}public static void main(String[] args) {()。}}package 。import 。import 。import 。import 。public class docMenuAction implements ActionListener {RegisterFrame register = null。JPanel cusPanel = null。JPanel docPanel = null。public docMenuAction(RegisterFrame register){ = register。 = 。 = 。}public void actionPerformed(ActionEvent e) {// TODO Autogenerated method stub = 1。//()。(cusPanel)。(docPanel)。()。}}package 。import 。import 。import 。import 。import 。import 。import 。public class BuyerDao {private static Connection conn。private static Statement statement。private static ResultSet resultSet。//插入數(shù)據(jù)，用于注冊public int insertBuyer(Buyer buyer){int flag = 0。conn = ()。try {statement = ()。String sql = insert into buyer values(39。+()+39。,39。+()+39。,39。+()+39。,39。+()+39。)。// (buyer+sql)。flag = (sql)。()。()。} catch (SQLException e) {// TODO Autogenerated catch block()。}// (flag)。return flag。}//通過用戶名和密碼查詢，用于登錄public static Buyer getBuyer(String name,String pwd){conn = ()。Buyer buyer = new Buyer()。try {statement = ()。String sql = select * from buyer where buyer_id=39。+name+39。 and pwd = 39。+pwd+39。resultSet = (sql)。while(()){((buyer_id))。((buyer_name))。((pwd))。((address))。}()。()。()。} catch (SQLException e) {// TODO Autogenerated catch block()。}return buyer。}public static void main(String[] args) {BuyerDao dao = new BuyerDao()。((zxk, 654321))。// Buyer buyer = new Buyer()。// (lily)。// (長理專賣)。// (123456)。// (湖南長沙)。// (buyer)。}}package 。import 。import 。import 。import 。import 。import 。import 。import 。import 。public class GoodsDao {private static Connection conn。private static Statement statement。private static ResultSet resultSet。//查詢登錄商家的所有商品，用于商家管理自己的商品public ArrayList getAllGoods(){ArrayList list = new ArrayList()。conn = ()。try {statement = ()。String sql = select * from goods a,seller b where = and =39。+()+39。resultSet = (sql)。while(()){Seller seller = new Seller()。((seller_name))。((address))。Goods goods = new Goods()。(seller)。((goods_id))。((goods_name))。((seller_id))。((discount))。((num))。((price))。// (())。(goods)。}} catch (SQLException e) {// TODO Autogenerated catch block()。}finally{try {()。()。()。} catch (SQLException e) {// TODO Autogenerated catch block()。}}return list。}//public ArrayList getAllSellerGoods(){ArrayList list = new ArrayList()。conn = ()。try {statement = ()。String sql = select * from goods a,seller b where =。resultSet = (sql)。while(()){Seller seller = new Seller()。((seller_name))。((address))。Goods goods = new Goods()。(seller)。((goods_id))。((goods_name))。((seller_id))。((discount))。((num))。((price))。// (())。(goods)。}} catch (SQLException e) {// TODO Autogenerated catch block()。}finally{try {()。()。()。} catch (SQLException e) {// TODO Autogenerated catch block()。}}return list。}//根據(jù)商品號查詢商品信息public Goods getOneGoods(int id){Goods goods = new Goods()。conn = ()。try {statement = ()。String sql = select * from goods where goods_id = +id。resultSet = (sql)。while(()){(id)。((goods_name))。((price))。((num))。((discount))。((seller_id))。((num))。}} catch (SQLException e) {// TODO Autogenerated catch block()。}finally{try {()。()。()。} catch (SQLException e) {// TODO Autogenerated catch block()。}}return goods。}//修改商品信息public int updateGoods(Goods goods){int flag = 0。conn = ()。try {statement = ()。String sql = update goods set goods_name=39。+()+39。,price =+()+,discount =+()+,num=+()+ where goods_id=+()。flag = (sql)。} catch (SQLException e) {// TODO Autogenerated catch block()。}finally{try {()。()。} catch (SQLException e) {// TODO Autogenerated catch block()。}}return flag。}//通過 id 刪除商品public int deleteById(int id){int flag = 0。conn = ()。try {statement = ()。String sql = delete goods where goods_id = +id。flag = (sql)。} catch (SQLException e) {// TODO Autogenerated catch block()。}finally{try {()。()。} catch (SQLException e) {// TODO Autogenerated catch block()。}}return flag。}//添加public int insertGoods(Goods goods){int flag = 0。conn = ()。try {statement = ()。String sql = insert into goods values((select max(goods_id+1) from goods),39。+()+39。,39。+()+39。,+e()+,+()+,+()+)。flag = (sql)。} catch (SQLException e) {// TODO Autogenerated catch block()。}finally{try {()。()。} catch (SQLException e) {// TODO Autogenerated catch block()。}}return flag。}public static void main(String[] args) {GoodsDao dao = new GoodsDao()。// Goods goods = new Goods()。// (c++)。// (50)。// (niclascage)。// (8)。// (10)。// (main)。// (ii+(goods))。// ((4))。// Goods goods = new Goods()。// (1)。// (oracle)。// (50)。// (8)。// (5)。// ((goods))。()。// ((1))。}}package 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。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 = ()。try {statement = ()。String sql = insert into orders values((select max(order_id+1) from orders),+()+,39。+()+39。,39。+ame()+39。,+num+)。flag = (sql)。} catch (SQLException e) {// TODO Autogenerated catch block()。}finally{try {()。()。} catch (SQLException e) {// TODO Autogenerated catch block()。}}return