1、/代表各的主頁面package com.gui;import java.awt.*;import javax.swing.*;import java.awt.event.*;import java.io.*;import java.nio.channels.ClosedSelectorException;import java.sql.*;import javax.swing.JFileChooser;import javax.swing.plaf.ScrollBarUI;import javax.swing.table.DefaultTableColumnModel;import javax

2、.swing.table.DefaultTableModel;import com.DateSystem.Good_data;import com.DateSystem.Goods;import com.DateSystem.Userdate;import java.util.List;public class Main extends JFrame implements ActionListener,AdjustmentListener/* * param args */主窗體組件MenuBar menuBar; Menu menu_xitong,menu_guanli,menu_gongj

3、u,menu_Help;MenuItem item_up_password, item_reLanding, item_exit;MenuItem item_input, item_find, item_delete;MenuItem item_jisuanqi, item_jishiben, item_beijing;MenuItem item_LookHelp, item_About;/錄入界面要用的組件JPanel jp_btn,jp_main,jp_table,jp_text;JLabel lbl_id, lbl_name, lbl_address, lbl_in_price, lbl

4、_out_price, lbl_kucun, lbl_jinhuo, lbl_chuhuo;TextField text_id,text_name,text_address,text_in_price,text_out_price,text_kucun,text_jinhuo,text_chuhuo;JButton submit,reset,delete;JScrollPane jsp;JTable table;DefaultTableModel model;CardLayout c=new CardLayout();JPanel card;/查找頁面要用的組件JPanel jp1,jp2,j

5、p3;JPanel jp2_main;JButton find_id,find_name,find_delete,find_all;JTextField text_find;JScrollPane jsp_find;JTable table_find;DefaultTableModel model_find;/背景更改要用的組件int r =255,g=255,b=255;TextField tfr,tfg,tfb;Scrollbar sbr,sbg,sbb;Panel display;JPanel jp3_main;public Main()super(主窗口);menuBar=new Me

6、nuBar();menu_gongju=new Menu(工具);menu_guanli=new Menu(管理);menu_Help=new Menu(幫助);menu_xitong=new Menu(系統(tǒng));item_About=new MenuItem(關(guān)于);item_beijing=new MenuItem(背景設(shè)置);item_LookHelp=new MenuItem(查看幫助);item_up_password=new MenuItem(修改密碼);item_reLanding=new MenuItem(重新登錄);item_exit=new MenuItem(退出系統(tǒng));it

7、em_jishiben=new MenuItem(記事本);item_jisuanqi=new MenuItem(計(jì)算器);item_find=new MenuItem(查找);item_input=new MenuItem(錄入);item_delete=new MenuItem(刪除);/注冊監(jiān)聽item_About.addActionListener(this);item_beijing.addActionListener(this);item_LookHelp.addActionListener(this);item_up_password.addActionListener(this

8、);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_xiton

9、g.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_xi

10、tong);menuBar.add(menu_guanli);menuBar.add(menu_gongju);menuBar.add(menu_Help);setMenuBar(menuBar);setResizable(false);initComponents();/調(diào)用方法初始化界面Find();change_color();/查找功能的布局以及組建/this.setLayout(new CardLayout();card=new JPanel();card.setLayout(c);card.add(1, jp_main);card.add(2, jp2_main);card.add

11、(3, jp3_main);/this.getContentPane().add(Center, jp_main);this.add(card);this.setSize(1000, 500);this.setLocationRelativeTo(null);this.setVisible(true);this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);/錄入界面初始化private void initComponents() /構(gòu)造面板System.out.println(pass);lbl_id=new JLabel(商品編號,JLabe

12、l.CENTER);lbl_name=new JLabel(商品名稱,JLabel.CENTER);lbl_address=new JLabel(商品產(chǎn)地,JLabel.CENTER);lbl_in_price=new JLabel(進(jìn)價(jià),JLabel.CENTER);lbl_out_price=new JLabel(售價(jià),JLabel.CENTER);lbl_jinhuo=new JLabel(進(jìn)貨量,JLabel.CENTER);lbl_chuhuo=new JLabel(銷售量,JLabel.CENTER);lbl_kucun=new JLabel(庫存量,JLabel.CENTER);

13、text_id=new TextField();text_name = new TextField();text_address=new TextField();text_in_price=new TextField();text_out_price=new TextField();text_jinhuo=new TextField();text_chuhuo=new TextField();text_kucun=new TextField();jp_table=new JPanel(new BorderLayout();jp_text =new JPanel(new GridLayout(2

14、,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.

15、add(text_out_price);jp_text.add(text_jinhuo);jp_text.add(text_chuhuo);jp_text.add(text_kucun);model = new DefaultTableModel(new Object , new String 商品編號, 商品名稱, 商品產(chǎn)地 ,進(jìn)價(jià),售價(jià),庫存量,進(jìn)貨量,出貨量 );table =new JTable(model);jsp=new JScrollPane(table);submit=new JButton(錄入商品);reset=new JButton(重置信息);delete=new JB

16、utton(刪除所選商品);submit.addActionListener(this);reset.addActionListener(this);delete.addActionListener(this);jp_btn=new JPanel(new GridLayout(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=new JPanel(new BorderLayout(10,10);j

17、p_main.add(Center,jsp);jp_main.add(North,jp_table);System.out.println(pass);/查找面板初始化面板private void Find() jp1=new JPanel(new GridLayout(1,1);jp2=new JPanel(new GridLayout(1,4);jp3=new JPanel(new BorderLayout();find_id =new JButton(根據(jù)商品編號查詢);find_name=new JButton(根據(jù)商品名稱查詢);find_all=new JButton(查詢所有信息

18、);find_delete=new JButton(刪除所選信息);text_find=new JTextField();jsp_find=new JScrollPane();table_find=new JTable();model_find=new DefaultTableModel();model_find = new DefaultTableModel(new Object , new String 商品編號, 商品名稱, 商品產(chǎn)地 ,進(jìn)價(jià),售價(jià),庫存量,進(jìn)貨量,出貨量 );table_find =new JTable(model_find);jsp_find=new JScrollP

19、ane(table_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=new JPa

20、nel(new BorderLayout(10,10);jp2_main.add(Center,jsp_find);jp2_main.add(North,jp3);/背景更改private void change_color() jp3_main=new JPanel();display =new Panel();display.setBackground(Color.WHITE);Panel pcolor =new Panel();pcolor.setLayout(new BorderLayout();Panel pw=new Panel();pw.setLayout(new GridLay

21、out(3,2,0,0);jp3_main.setLayout(new BorderLayout();tfr= new TextField(255);tfg=new TextField(255);tfb=new TextField(255);tfr.setEditable(false);tfg.setEditable(false);tfb.setEditable(false);sbr=new Scrollbar(Scrollbar.HORIZONTAL,255,0,0,255);sbg=new Scrollbar(Scrollbar.HORIZONTAL,255,0,0,255);sbb=ne

22、w Scrollbar(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(new Label(

23、紅色);pw.add(tfr);pw.add(new Label(綠色);pw.add(tfg);pw.add(new Label(藍(lán)色);pw.add(tfb);Panel pc= new Panel();pc.setLayout(new GridLayout(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.a

24、dd(pcolor,BorderLayout.SOUTH);/查看幫助文檔,調(diào)用本地的程序，查看幫助文檔public void useCMDCommand() throws IOException Runtime.getRuntime().exec(new Stringcmd.exe, /c, .BaoDing_Shoop保定商場商品管理系統(tǒng)項(xiàng)目幫助.doc); /主函數(shù)public static void main(String args) / TODO Auto-generated method stubjava.awt.EventQueue.invokeLater(new Runnabl

25、e() public void run() new Main().setVisible(true); );/監(jiān)聽方法public void actionPerformed(ActionEvent e) /得到事件源String btString=e.getActionCommand();/錄入功能if (btString.equals(錄入商品) /追加到最后一行if(!text_id.getText().equals() & !text_name.getText().equals() & !text_address.getText().equals() & !text_in_price.ge

26、tText().equals() & !text_out_price.getText().equals() & !text_jinhuo.getText().equals() & !text_chuhuo.getText().equals() & !text_kucun.getText().equals() /獲取文本框信息int idString=Integer.parseInt(text_id.getText();String ids=text_id.getText();String nameString=text_name.getText();String addresString=te

27、xt_address.getText();double in_priceString=Double.parseDouble(text_in_price.getText();double out_priceString=Double.parseDouble(text_out_price.getText();int jinhuoString=Integer.parseInt(text_jinhuo.getText();int chuhuoString=Integer.parseInt(text_chuhuo.getText();int kucun=Integer.parseInt(text_kuc

28、un.getText();if (in_priceString=out_priceString) JOptionPane.showMessageDialog(this, 親，要有盈利的，銷售價(jià)格要大于進(jìn)價(jià)！);else System.out.print(錄入商品);if (idString!=0 & !nameString.equals() & !addresString.equals() & in_priceString!=0 & out_priceString!=0 & jinhuoString!=0 & chuhuoString!=0 & kucun!=0) /對數(shù)據(jù)庫的操作 Strin

29、g sql=insert into result values(+ ids +, + nameString+,+ addresString+,+ in_priceString+,+ out_priceString+,+ jinhuoString+,+ chuhuoString+,+ kucun+ );Userdate userdate=new Userdate();boolean flag=userdate.add_goods(sql);if (flag) /對表格的操作model.insertRow(model.getRowCount(), new Object ids, nameStrin

30、g,addresString,in_priceString,out_priceString,jinhuoString,chuhuoString,kucun );else JOptionPane.showMessageDialog(this, 商品編號重復(fù)！); else JOptionPane.showMessageDialog(this, 請輸入商品詳細(xì)信息！);else JOptionPane.showMessageDialog(this, 請輸入商品的詳細(xì)信息！);/刪除功能else if(btString.equals(刪除所選商品)/獲取要刪除的行,沒有選擇是-1int row=ta

31、ble.getSelectedRow();System.out.print(刪除商品操作);System.out.print(row);if (row=-1) JOptionPane.showMessageDialog(this,請選擇要刪除商品的商品名！);else /System.out.print(row);/數(shù)據(jù)庫刪除商品操作/int shangpin_id= Integer.parseInt(String) model.getValueAt(row, 0) ;String shangpin_id=(String) model.getValueAt(row, 0) ;System.ou

32、t.print(row);String sql=delete from result where id=+shangpin_id+;Userdate userdate=new Userdate();boolean flag=userdate.add_goods(sql);if (flag) model.removeRow(row);/重置功能else if(btString.equals(重置信息)text_id.setText();text_name.setText();text_address.setText();text_in_price.setText();text_out_price

33、.setText();text_jinhuo.setText();text_chuhuo.setText();text_kucun.setText();else if(btString.equals(修改密碼)UpData data=new UpData();data.setVisible(true);else if(btString.equals(計(jì)算器)Calculator calculator = new Calculator();calculator.setSize(250,350);calculator.setLocationRelativeTo(null);calculator.s

34、etVisible(true);calculator.setResizable(false);else if(btString.equals(退出系統(tǒng))System.exit(0);else if (btString.equals(記事本) NotePad notePad=new NotePad();notePad.setVisible(true);else if(btString.equals(查看幫助)/System.out.println(help_pss);try useCMDCommand();System.out.println(help_pss); catch (IOExcept

35、ion e1) / TODO Auto-generated catch blocke1.printStackTrace();else if(btString.equals(關(guān)于)About about =new About();about.setVisible(true);else if(btString.equals(重新登錄)System.out.print(重新登錄);Landing landing = new Landing();landing.setVisible(true);this.dispose();else if(btString.equals(查找)c.show(card,

36、2);else if(btString.equals(錄入)c.show(card,1);else if(btString.equals(刪除)c.show(card,2);JOptionPane.showMessageDialog(this, 請先查找所要刪除的商品信息！);else if(btString.equals(背景設(shè)置)c.show(card,3);/查找功能else if(btString.equals(根據(jù)商品編號查詢)if (text_find.getText().equals() JOptionPane.showMessageDialog(this, 查詢信息為空！);e

37、lse /int id =Integer.parseInt(text_find.getText().trim();String id =text_find.getText().trim();Good_data data=new Good_data();Goods goods =data.findStudentById(id);/String id_s=Integer.toString(id);/獲取文本框信息/int idString=goods.getId();/String ids=Integer.toString(goods.getId();String idString=goods.g

38、etId();String nameString=goods.getName();String addresString=goods.getAddress();double in_priceString=goods.getIn_price();double out_priceString=goods.getOut_price();int jinhuoString=goods.getJinhuo();int chuhuoString=goods.getChuhuo();int kucun=goods.getKucun();/判斷用戶所輸入的商品編號數(shù)據(jù)庫中是否有if (idString=null

39、) JOptionPane.showMessageDialog(this,對不起，小編沒有從數(shù)據(jù)庫中找到商品編號為：+id+的信息！);else /對表格的操作model_find.insertRow(model_find.getRowCount(), new Object idString, nameString,addresString,in_priceString,out_priceString,jinhuoString,chuhuoString,kucun );else if(btString.equals(根據(jù)商品名稱查詢)String name =text_find.getText

40、().trim();Good_data data=new Good_data();String sql=select * from result where nam like %+name+%; List datalist=data.findGoods(sql);/獲取文本框信息 if (name.equals() JOptionPane.showMessageDialog(this, 查詢信息為空！);else if (datalist.size()=0) JOptionPane.showMessageDialog(this,對不起，小編沒有從數(shù)據(jù)庫中找到商品名為：+name+的信息！);

41、for(Goods d:datalist)/遍歷數(shù)據(jù)，將查詢所得到的數(shù)據(jù)逐一賦值到表中/int idString=d.getId();String idString=d.getId();String nameString=d.getName();String addresString=d.getAddress();double in_priceString=d.getIn_price();double out_priceString=d.getOut_price();int jinhuoString=d.getJinhuo();int chuhuoString=d.getChuhuo();in

42、t kucun=d.getKucun();/對表格的操作model_find.insertRow(model_find.getRowCount(), new Object idString, nameString,addresString,in_priceString,out_priceString,jinhuoString,chuhuoString,kucun ); else if(btString.equals(刪除所選信息)/獲取要刪除的行,沒有選擇是-1int row=table_find.getSelectedRow();System.out.print(刪除商品操作);System.out.print(row);if (row=-1) JOptionPane.showMessageDialog(this,請選擇要刪除商品！);else /System.out.print(row);/數(shù)據(jù)庫刪除商品操作/int shangpin_id=(Integer) model_find.g