java商品管理系統(tǒng)

//代表各的主頁面packagecom.gui;importjava.awt.*;javax.swing.*;importjava.io.*;importjava.sql.*;publicclassMainextendsJFrameimplementsActionListener,AdjustmentListener{/***@paramargs*///主窗體組件menuBar;MenuItemitem_up_password,item_reLanding,item_exit;MenuItemitem_input,item_find,item_delete;MenuItemitem_jisuanqi,item_jishiben,item_beijing;MenuItemitem_LookHelp,item_About;//錄入界面要用的組件JPaneljp_btn,jp_main,jp_table,jp_text;JLabellbl_id,lbl_name,lbl_address,lbl_in_price,lbl_out_price,lbl_kucun,lbl_jinhuo,lbl_chuhuo;JButtonsubmit,reset,delete;jsp;JTabletable;DefaultTableModelmodel;CardLayoutc=newCardLayout();JPanelcard;//查找頁面要用的組件JPaneljp2_main;JTextFieldtext_find;jsp_find;JTabletable_find;DefaultTableModelmodel_find;//背景更改要用的組件intr=255,g=255,b=255;TextFieldtfr,tfg,tfb;sbr,sbg,sbb;Paneldisplay;jp3_main;publicMain(){super("主窗口");menuBar=newMenuBar();menu_gongju=newMenu("工具");menu_guanli=newMenu("管理");menu_Help=new Menu("協(xié)助");menu_xitong=newMenu("系統(tǒng)");item_About=newMenuItem("關(guān)于");item_beijing=newMenuItem("背景設(shè)置");item_LookHelp=newMenuItem("查看協(xié)助");item_up_password=newMenuItem("修改密碼");item_reLanding=newMenuItem("重新登錄");item_exit=newMenuItem("退出系統(tǒng)");item_jishiben=newMenuItem("記事本");item_jisuanqi=newMenuItem("計算器");item_find=new MenuItem("查找");item_input=newMenuItem("錄入");item_delete=newMenuItem("刪除");//注冊監(jiān)聽item_About.addActionListener(this);item_beijing.addActionListener(this);item_LookHelp.addActionListener(this);item_up_password.addActionListener(this);item_reLanding.addActionListener(this);item_exit.addActionListener(this);item_jishiben.addActionListener(this);item_jisuanqi.addActionListener(this);item_find.addActionListener(this);item_input.addActionListener(this);item_delete.addActionListener(this);menu_xitong.add(item_up_password);menu_xitong.add(item_reLanding);menu_xitong.add(item_exit);menu_guanli.add(item_input);menu_guanli.add(item_find);//menu_guanli.add(item_delete);menu_gongju.add(item_jisuanqi);menu_gongju.add(item_jishiben);menu_gongju.add(item_beijing);menu_Help.add(item_About);menu_Help.add(item_LookHelp);menuBar.add(menu_xitong);menuBar.add(menu_guanli);menuBar.add(menu_gongju);menuBar.add(menu_Help);setMenuBar(menuBar);setResizable(false);initComponents();//調(diào)用方式初始化界面Find();change_color();//查找功能的布局以及組建CardLayout());card=newJPanel();card.setLayout(c);card.add("1",jp_main);card.add("2",jp2_main);card.add("3",jp3_main);jp_main);this.add(card);this.setSize(1000,500);this.setLocationRelativeTo(null);this.setVisible(true);this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);}//錄入界面初始化privatevoidinitComponents(){//構(gòu)造面板JLabel("商品編號",JLabel.CENTER);lbl_name=newJLabel("商品名稱",JLabel.CENTER);lbl_address=newJLabel("商品產(chǎn)地",JLabel.CENTER);lbl_in_price=newJLabel("進(jìn)價",JLabel.CENTER);lbl_out_price=newJLabel("售價",JLabel.CENTER);lbl_jinhuo=newJLabel("進(jìn)貨量",JLabel.CENTER);lbl_chuhuo=newJLabel("銷售量",JLabel.CENTER);lbl_kucun=newJLabel("庫存量",JLabel.CENTER);text_id=newTextField();text_name=newTextField();text_address=new TextField();text_in_price=newTextField();text_out_price=newTextField();text_jinhuo=newTextField();text_chuhuo=newTextField();text_kucun=new TextField();jp_table=newJPanel(newBorderLayout());jp_text=newJPanel(newGridLayout(2,8));jp_text.add(lbl_id);jp_text.add(lbl_name);jp_text.add(lbl_address);jp_text.add(lbl_in_price);jp_text.add(lbl_out_price);jp_text.add(lbl_jinhuo);jp_text.add(lbl_chuhuo);jp_text.add(lbl_kucun);jp_text.add(text_id);jp_text.add(text_name);jp_text.add(text_address);"});}

jp_text.add(text_in_price);jp_text.add(text_out_price);jp_text.add(text_jinhuo);jp_text.add(text_chuhuo);jp_text.add(text_kucun);model=newDefaultTableModel(newObject[][]{},newString[]{"商品編號","商品名稱","商品產(chǎn)地","進(jìn)價","售價","庫存量","進(jìn)貨量","出貨量table=newJTable(model);jsp=newJScrollPane(table);submit=newJButton("錄入商品");reset=newJButton("重置信息");delete=newJButton("刪除所選商品");submit.addActionListener(this);reset.addActionListener(this);delete.addActionListener(this);jp_btn=newJPanel(newGridLayout(1,3));jp_btn.add(submit);jp_btn.add(delete);jp_btn.add(reset);jp_table.add("Center",jp_text);jp_table.add("South",jp_btn);jp_main=newJPanel(newBorderLayout(10,10));jp_main.add("Center",jsp);jp_main.add("North",jp_table);privatevoidFind()jp1=newJPanel(newGridLayout(1,1));jp2=newJPanel(newGridLayout(1,4));jp3=newJPanel(newBorderLayout());find_id=newJButton("依據(jù)商品編號查詢");find_name=newJButton("依據(jù)商品名稱查詢");find_all=newJButton("查詢所有信息");find_delete=newJButton("刪除所選信息");text_find=newJTextField();jsp_find=newJScrollPane();table_find=newJTable();DefaultTableModel();model_find=newDefaultTableModel(newObject[][]{newString[]商品編號商品名稱商品產(chǎn)地進(jìn)價","售價","庫存量","進(jìn)貨量","出貨量"});table_find=newJTable(model_find);find_id.addActionListener(this);find_name.addActionListener(this);find_all.addActionListener(this);find_delete.addActionListener(this);jp1.add(text_find);jp2.add(find_id);jp2.add(find_name);jp2.add(find_all);jp2.add(find_delete);jp3.add("North",jp1);jp3.add("Center",jp2);jp2_main=newJPanel(newBorderLayout(10,10));jp2_main.add("Center",jsp_find);jp2_main.add("North",jp3);}//背景更改privatevoidchange_color(){jp3_main=new display=new Panel();display.setBackground(Color.WHITE);Panelpcolor=newPanel();pcolor.setLayout(newBorderLayout());Panelpw=newPanel();GridLayout(3,2,0,0));jp3_main.setLayout(new tfr=newTextField("255");tfr.setEditable(false);tfg.setEditable(false);tfb.setEditable(false);sbr=newScrollbar(Scrollbar.HORIZONTAL,255,0,0,255);sbr.setName("SBR");sbg.setName("SBG");sbb.setName("SBB");sbr.setBackground(Color.red);sbg.setBackground(Color.green);sbb.setBackground(Color.blue);sbr.addAdjustmentListener(this);sbg.addAdjustmentListener(this);sbb.addAdjustmentListener(this);pw.add(newLabel("紅色"));pw.add(tfr);pw.add(newLabel("綠色"));pw.add(tfg);pw.add(newLabel("藍(lán)色"));pw.add(tfb);Panelpc=newPanel();pc.setLayout(newGridLayout(3,1,0,0));pc.add(sbr);pc.add(sbg);pc.add(sbb);pcolor.add(pw,BorderLayout.WEST);pcolor.add(pc,BorderLayout.CENTER);jp3_main.add(display,BorderLayout.CENTER);jp3_main.add(pcolor,BorderLayout.SOUTH);}//查看協(xié)助文檔,調(diào)用本地的程序，查看協(xié)助文檔public voiduseCMDCommand()throwsIOException{Runtime.getRuntime().exec(newString[]{"cmd.exe","/c","..\\BaoDing_Shoop\\保定商場商品管理系統(tǒng)項目協(xié)助.doc"});}//主函數(shù)publicstaticvoidmain(String[]args){//TODOAuto-generatedmethodstubpublicvoidrun(){newMain().setVisible(true);}});}//監(jiān)聽方式publicvoidactionPerformed(ActionEvente){//得到事件源StringbtString=e.getActionCommand();//錄入功能if(btString.equals("錄入商品{//追加到最后一行if(!text_id.getText().equals("")

&& !text_name.getText().equals("")&&!text_address.getText().equals("")&&!text_in_price.getText().equals("")&&!text_out_price.getText().equals("")&&!text_jinhuo.getText().equals("")&&!text_chuhuo.getText().equals("")&&!text_kucun.getText().equals("")){//取得文本框信息int Stringids=text_id.getText();StringnameString=text_name.getText();doublein_priceString=Double.parseDouble(text_in_price.getText());int jinhuoString=Integer.parseInt(text_jinhuo.getText());int int kucun=Integer.parseInt(text_kucun.getText());if(in_priceString<=0){JOptionPane.showMessageDialog(this,"親~，進(jìn)價要大于零哦！");}else{if(in_priceString>=out_priceString){");

JOptionPane.showMessageDialog(this,"親~，要有盈利的，銷售價格要大于進(jìn)價！}else{if (idString!=0 && !nameString.equals("") && !addresString.equals("") &&in_priceString!=0&&out_priceString!=0&&jinhuoString!=0&&chuhuoString!=0&&kucun!=0){//對數(shù)據(jù)庫的操作Stringsql="insertintoresultvalues('"+ids+"','"+nameString+"','"+addresString+"',"+in_priceString+","+out_priceString+","+jinhuoString+","+chuhuoString+","+kucun+")";Userdateuserdate=newUserdate();if(flag){//對表格的操作model.insertRow(model.getRowCount(),newObject[]{nameString,addresString,in_priceString,out_priceString,jinhuoString,chuhuoString,kucun});

ids,}else{JOptionPane.showMessageDialog(this,"商品編號重復(fù)！");}}else{JOptionPane.showMessageDialog(this,"請輸入商品詳細(xì)信息！");}}}}else{JOptionPane.showMessageDialog(this,"請輸入商品的詳細(xì)信息！");}}//刪除功能elseif(btString.equals("刪除所選商品")){//取得要刪除的行,沒有選擇是-1introw=table.getSelectedRow();if(row==-1)JOptionPane.showMessageDialog(this,"請選擇要刪除商品的商品名！");}else{//數(shù)據(jù)庫刪除商品操作//int shangpin_id=Integer.parseInt((String)model.getValueAt(row,0));Stringshangpin_id=(String)model.getValueAt(row,0);Stringsql="deletefromresultwhereid='"+shangpin_id+"'";Userdateuserdate=newUserdate();if(flag){model.removeRow(row);}}}//重置功能elseif(btString.equals("重置信息")){text_id.setText("");text_name.setText("");text_address.setText("");text_in_price.setText("");text_out_price.setText("");text_jinhuo.setText("");text_chuhuo.setText("");text_kucun.setText("");}elseif(btString.equals("修改密碼")){UpDatadata=newUpData();data.setVisible(true);}elseif(btString.equals("計算器")){Calculatorcalculator=newCalculator();calculator.setSize(250,350);calculator.setLocationRelativeTo(null);calculator.setVisible(true);calculator.setResizable(false);}elseif(btString.equals("退出系統(tǒng)")){System.exit(0);}elseif(btString.equals("記事本")){NotePadnotePad=newNotePad();notePad.setVisible(true);}elseif(btString.equals("查看協(xié)助")){tryuseCMDCommand();}catch(IOExceptione1){//TODOAuto-generatedcatchblocke1.printStackTrace();}}elseif(btString.equals("關(guān)于")){Aboutabout=newAbout();about.setVisible(true);}elseif(btString.equals("重新登錄")){LandinglandingnewLanding();landing.setVisible(true);this.dispose();}elseif(btString.equals("查找")){c.show(card,"2");}elseif(btString.equals("錄入")){c.show(card,"1");}elseif(btString.equals("刪除")){c.show(card,"2");JOptionPane.showMessageDialog(this,"請先查找所要刪除的商品信息！");}elseif(btString.equals("背景設(shè)置")){c.show(card,"3");}//查找功能elseif(btString.equals("依據(jù)商品編號查詢")){if(text_find.getText().equals(""))JOptionPane.showMessageDialog(this,"查詢信息為空！");}else{//int Stringid=text_find.getText().trim();Good_datadata=newGood_data();Goodsgoods=data.findStudentById(id);//Stringid_s=Integer.toString(id);//取得文本框信息//int idString=goods.getId();String idString=goods.getId();StringnameString=goods.getName();double in_priceString=goods.getIn_price();double int jinhuoString=goods.getJinhuo();int int kucun=goods.getKucun();//推斷用戶所輸入的商品編號數(shù)據(jù)庫中是否有if(idString==null){JOptionPane.showMessageDialog(this,"對不起，小編沒有從數(shù)據(jù)庫中找到商品編號為："+id+"的信息！");

}else{//對表格的操作newObject[]{

idString,nameString,addresString,in_priceString,out_priceString,jinhuoString,chuhuoString,kucun});}}}elseif(btString.equals("依據(jù)商品名稱查詢")){Stringname=text_find.getText().trim();Good_datadata=newGood_data();Stringsql="selec*tfromresultwherenamlike'%"+name+"%'";List<Goods>datalist=data.findGoods(sql);/取得文本框信息if(name.equals("")){}else{if(datalist.size()<=0){JOptionPane.showMessageDialog(this"+name+"}//intidString=d.getId();

據(jù)，將查詢所得到的數(shù)據(jù)逐一賦值到表中StringidString=d.getId();StringnameString=d.getName();StringaddresString=d.getAddress();doublein_priceString=d.getIn_price();doubleout_priceString=d.getOut_price();intjinhuoString=d.getJinhuo();intchuhuoString=d.getChuhuo();intkucun=d.getKucun();/對表格的操作model_find.insertRow(model_find.getRowCount(),newObject[]{nameString,addresString,in_priceString,out_priceString,jinhuoString,chuhuoString,kucun});

idString,}}}elseif(btString.eqas/-1introw=table_find.getSelectedRow();if(row==-1){JOptionPane.showMessageDialog(this}else{/數(shù)據(jù)庫刪除商品操作//intshangpin_id=(Integer)model_find.getValueAt(row,0);Stringshangpin_id=(String)