Mysql 實作 DBMS (使用JDBC)

Main Systems :

1. 
   
2. import java.awt.Color;  
3. import java.awt.Graphics;  
4. import java.awt.Graphics2D;  
5. import java.awt.Image;  
6. import java.io.BufferedReader;  
7. import java.io.BufferedWriter;  
8. import java.io.File;  
9. import java.io.FileInputStream;  
10. import java.io.FileNotFoundException;  
11. import java.io.FileReader;  
12. import java.io.FileWriter;  
13. import java.io.IOException;  
14. import java.io.InputStream;  
15. import java.sql.Connection;  
16. import java.sql.DriverManager;  
17. import java.sql.PreparedStatement;  
18. import java.sql.ResultSet;  
19. import java.sql.SQLException;  
20. import java.sql.Statement;  
21. import java.util.*;  
22. import java.util.logging.Level;  
23. import java.util.logging.Logger;  
24.   
25. import javax.swing.*;  
26. import javax.swing.table.DefaultTableModel;  
27. import javax.swing.table.TableModel;  
28.   
29. /* 
30.  * To change this license header, choose License Headers in Project Properties. 
31.  * To change this template file, choose Tools | Templates 
32.  * and open the template in the editor. 
33.  */  
34.   
35. /** 
36.  * 
37.  * @author ping xin 
38.  */  
39. public class Date2 extends javax.swing.JFrame {  
40.  String com = "com.mysql.jdbc.Driver";  
41.  String URL = "jdbc:mysql://127.0.0.1/xin_data?user=koer3740&password=er3p5eak97&useUnicode=true&characterEncoding=utf-8";  
42.  String SetInterface = "null" , SetInter2 = "China";  
43.  Deta4 obj = new Deta4();  
44.  String ImagePath ;  
45.    
46.     /** 
47.      * Creates new form Date2 
48.      */  
49.     public Date2() {  
50.         initComponents();  
51.         ReadSET();//讀取設定  
52.         Read();//事先讀取資料 DB > 管理器  
53.        //事件按鈕端  
54.         obj.jButton4.addActionListener(new java.awt.event.ActionListener() {  
55.             public void actionPerformed(java.awt.event.ActionEvent evt) {  
56.                 SALE();  
57.             }  
58.         });  
59.         obj.jButton3.addActionListener(new java.awt.event.ActionListener() {  
60.             public void actionPerformed(java.awt.event.ActionEvent evt) {  
61.                 Date4OK();  
62.             }  
63.         });  
64.          obj.jButton1.addActionListener(new java.awt.event.ActionListener() {  
65.             public void actionPerformed(java.awt.event.ActionEvent evt) {  
66.                 Date4Canel();  
67.             }  
68.   
69.             private void Date4Canel() {  
70.                 obj.dispose();  
71.             }  
72.         });       
73.     }  
74.     public String CheckInput(boolean is) throws Exception{  
75.         String id  = jTextField3.getText();  
76.         if(is == true){  
77.         for(User u : users){  
78.         if(id.equals(u.id)||jTextField1.getText().isEmpty()||jTextField2.getText().isEmpty()||jTextField3.getText().isEmpty()||jTextField4.getText().isEmpty()||jTextField5.getText().isEmpty()||jTextField6.getText().isEmpty()||jTextField7.getText().isEmpty()){    
79.                  JOptionPane.showMessageDialog(null, "欄位不可以為空" + "和ID不能相同");   
80.                  throw new Exception();  
81.         }  
82.         }  
83.         }else{  
84.         if(jTextField1.getText().isEmpty()||jTextField2.getText().isEmpty()||jTextField3.getText().isEmpty()||jTextField4.getText().isEmpty()||jTextField5.getText().isEmpty()||jTextField6.getText().isEmpty()||jTextField7.getText().isEmpty()){    
85.                  JOptionPane.showMessageDialog(null, "欄位不可以為空");   
86.                  throw new Exception();  
87.         }  
88.         }  
89.         return id ;  
90.     }  
91.     public void FieldEmpty(){  
92.         jLabel1.setText(null);  
93.         jTextField1.setText(null);jTextField2.setText(null);jTextField3.setText(null);  
94.         jTextField4.setText(null);jTextField5.setText(null);jTextField6.setText(null);  
95.         jTextField7.setText(null);  
96.     }  
97.     public void ReadSET(){  
98.         File n = new File("SET");  
99.         String Str = null;  
100.      try {   
101.            
102.          if(n.exists()){  
103.              FileReader fis = new FileReader("SET/設定.txt");  
104.              BufferedReader fis2 = new  BufferedReader(fis);   
105.              while((Str = fis2.readLine()) != null){  
106.              Scanner sc = new Scanner(Str).useDelimiter("\t");  
107.              String ssc = sc.next();  
108.              if(ssc.equals("SETBLUE")) SetBlue();  
109.              else if(ssc.equals("SETNULL")) SetNull();  
110.              else SetGreen();  
111.              String ssc2 = sc.next();  
112.              if(ssc2.equals("China"))  SetChina();   
113.              else SetEnglish();   
114.                }  
115.              fis.close();  
116.              fis2.close();  
117.          }else  n.mkdirs();          
118.      } catch (Exception ex) {  
119.          Logger.getLogger(Date2.class.getName()).log(Level.SEVERE, null, ex);  
120.      }  
121.     }  
122.   
123.     /** 
124.      * This method is called from within the constructor to initialize the form. 
125.      * WARNING: Do NOT modify this code. The content of this method is always 
126.      * regenerated by the Form Editor. 
127.      */  
128.     @SuppressWarnings("unchecked")  
129.     // <editor-fold defaultstate="collapsed" desc="Generated Code">                            
130.     private void initComponents() {  
131.   
132.         jMenuItem6 = new javax.swing.JMenuItem();  
133.         jScrollPane1 = new javax.swing.JScrollPane();  
134.         jTable1 = new javax.swing.JTable();  
135.         jPanel1 = new javax.swing.JPanel();  
136.         jLabel1 = new javax.swing.JLabel();  
137.         Brow = new javax.swing.JButton();  
138.         jLabel2 = new javax.swing.JLabel();  
139.         jTextField1 = new javax.swing.JTextField();  
140.         jLabel3 = new javax.swing.JLabel();  
141.         jTextField2 = new javax.swing.JTextField();  
142.         jLabel4 = new javax.swing.JLabel();  
143.         jTextField3 = new javax.swing.JTextField();  
144.         jLabel5 = new javax.swing.JLabel();  
145.         jTextField4 = new javax.swing.JTextField();  
146.         jLabel6 = new javax.swing.JLabel();  
147.         jTextField5 = new javax.swing.JTextField();  
148.         jLabel7 = new javax.swing.JLabel();  
149.         jTextField6 = new javax.swing.JTextField();  
150.         jButton2 = new javax.swing.JButton();  
151.         jButton3 = new javax.swing.JButton();  
152.         jLabel8 = new javax.swing.JLabel();  
153.         jButton8 = new javax.swing.JButton();  
154.         Sale = new javax.swing.JButton();  
155.         jTextField7 = new javax.swing.JTextField();  
156.         jLabel9 = new javax.swing.JLabel();  
157.         jPanel2 = new javax.swing.JPanel();  
158.         jButton4 = new javax.swing.JButton();  
159.         jButton5 = new javax.swing.JButton();  
160.         DELETEALL = new javax.swing.JButton();  
161.         jButton6 = new javax.swing.JButton();  
162.         jMenuBar1 = new javax.swing.JMenuBar();  
163.         jMenu1 = new javax.swing.JMenu();  
164.         jMenuItem7 = new javax.swing.JMenuItem();  
165.         jMenu2 = new javax.swing.JMenu();  
166.         jMenu3 = new javax.swing.JMenu();  
167.         jMenuItem1 = new javax.swing.JMenuItem();  
168.         jMenuItem2 = new javax.swing.JMenuItem();  
169.         jMenu4 = new javax.swing.JMenu();  
170.         jMenuItem3 = new javax.swing.JMenuItem();  
171.         jMenuItem4 = new javax.swing.JMenuItem();  
172.         jMenuItem5 = new javax.swing.JMenuItem();  
173.         jMenu5 = new javax.swing.JMenu();  
174.   
175.         jMenuItem6.setText("jMenuItem6");  
176.   
177.         setDefaultCloseOperation(javax.swing.WindowConstants.DO_NOTHING_ON_CLOSE);  
178.         setBounds(new java.awt.Rectangle(160, 0, 0, 0));  
179.         setMaximumSize(new java.awt.Dimension(935, 608));  
180.         setMinimumSize(new java.awt.Dimension(935, 608));  
181.         setPreferredSize(new java.awt.Dimension(935, 608));  
182.         setResizable(false);  
183.         addWindowListener(new java.awt.event.WindowAdapter() {  
184.             public void windowClosing(java.awt.event.WindowEvent evt) {  
185.                 formWindowClosing(evt);  
186.             }  
187.         });  
188.         getContentPane().setLayout(null);  
189.   
190.         jTable1.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(153, 0, 0), 2));  
191.         jTable1.setModel(new javax.swing.table.DefaultTableModel(  
192.             new Object [][] {  
193.   
194.             },  
195.             new String [] {  
196.                 "商品名 ", "ID", "電話", "價格", "地址", "發行商", "e-mail"  
197.             }  
198.         ));  
199.         jTable1.addMouseListener(new java.awt.event.MouseAdapter() {  
200.             public void mouseClicked(java.awt.event.MouseEvent evt) {  
201.                 jTable1MouseClicked(evt);  
202.             }  
203.         });  
204.         jScrollPane1.setViewportView(jTable1);  
205.   
206.         getContentPane().add(jScrollPane1);  
207.         jScrollPane1.setBounds(0, 0, 450, 450);  
208.   
209.         jPanel1.setBackground(new java.awt.Color(153, 255, 51));  
210.         jPanel1.setForeground(new java.awt.Color(255, 255, 255));  
211.         jPanel1.setMaximumSize(new java.awt.Dimension(430, 520));  
212.         jPanel1.setLayout(null);  
213.   
214.         jLabel1.setBackground(new java.awt.Color(255, 255, 255));  
215.         jLabel1.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(153, 153, 0), 5));  
216.         jLabel1.setOpaque(true);  
217.         jPanel1.add(jLabel1);  
218.         jLabel1.setBounds(80, 10, 310, 223);  
219.   
220.         Brow.setText("上傳圖片");  
221.         Brow.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED));  
222.         Brow.addActionListener(new java.awt.event.ActionListener() {  
223.             public void actionPerformed(java.awt.event.ActionEvent evt) {  
224.                 BrowActionPerformed(evt);  
225.             }  
226.         });  
227.         jPanel1.add(Brow);  
228.         Brow.setBounds(360, 240, 90, 21);  
229.   
230.         jLabel2.setForeground(new java.awt.Color(51, 51, 0));  
231.         jLabel2.setText("商品名 :");  
232.         jPanel1.add(jLabel2);  
233.         jLabel2.setBounds(70, 250, 90, 20);  
234.         jPanel1.add(jTextField1);  
235.         jTextField1.setBounds(140, 240, 120, 30);  
236.   
237.         jLabel3.setForeground(new java.awt.Color(51, 51, 0));  
238.         jLabel3.setText("電話 :");  
239.         jPanel1.add(jLabel3);  
240.         jLabel3.setBounds(80, 300, 60, 15);  
241.         jPanel1.add(jTextField2);  
242.         jTextField2.setBounds(140, 288, 150, 30);  
243.   
244.         jLabel4.setForeground(new java.awt.Color(51, 51, 0));  
245.         jLabel4.setText("ID :");  
246.         jPanel1.add(jLabel4);  
247.         jLabel4.setBounds(90, 340, 18, 15);  
248.         jPanel1.add(jTextField3);  
249.         jTextField3.setBounds(140, 328, 40, 30);  
250.   
251.         jLabel5.setForeground(new java.awt.Color(51, 51, 0));  
252.         jLabel5.setText("地址 :");  
253.         jPanel1.add(jLabel5);  
254.         jLabel5.setBounds(80, 380, 60, 15);  
255.         jPanel1.add(jTextField4);  
256.         jTextField4.setBounds(140, 368, 250, 30);  
257.   
258.         jLabel6.setForeground(new java.awt.Color(51, 51, 0));  
259.         jLabel6.setText("發行商 :");  
260.         jPanel1.add(jLabel6);  
261.         jLabel6.setBounds(190, 340, 60, 21);  
262.         jPanel1.add(jTextField5);  
263.         jTextField5.setBounds(250, 328, 140, 30);  
264.   
265.         jLabel7.setForeground(new java.awt.Color(51, 51, 0));  
266.         jLabel7.setText("e-mail :");  
267.         jPanel1.add(jLabel7);  
268.         jLabel7.setBounds(85, 420, 60, 15);  
269.         jPanel1.add(jTextField6);  
270.         jTextField6.setBounds(140, 408, 250, 30);  
271.   
272.         jButton2.setIcon(new javax.swing.ImageIcon(getClass().getResource("/delete.png"))); // NOI18N  
273.         jButton2.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED));  
274.         jButton2.addActionListener(new java.awt.event.ActionListener() {  
275.             public void actionPerformed(java.awt.event.ActionEvent evt) {  
276.                 jButton2ActionPerformed(evt);  
277.             }  
278.         });  
279.         jPanel1.add(jButton2);  
280.         jButton2.setBounds(130, 470, 70, 30);  
281.   
282.         jButton3.setIcon(new javax.swing.ImageIcon(getClass().getResource("/edit-icon.png"))); // NOI18N  
283.         jButton3.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED));  
284.         jButton3.addActionListener(new java.awt.event.ActionListener() {  
285.             public void actionPerformed(java.awt.event.ActionEvent evt) {  
286.                 jButton3ActionPerformed(evt);  
287.             }  
288.         });  
289.         jPanel1.add(jButton3);  
290.         jButton3.setBounds(40, 470, 70, 30);  
291.         jPanel1.add(jLabel8);  
292.         jLabel8.setBounds(300, 500, 150, 30);  
293.   
294.         jButton8.setText("最近銷售");  
295.         jButton8.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED));  
296.         jButton8.addActionListener(new java.awt.event.ActionListener() {  
297.             public void actionPerformed(java.awt.event.ActionEvent evt) {  
298.                 jButton8ActionPerformed(evt);  
299.             }  
300.         });  
301.         jPanel1.add(jButton8);  
302.         jButton8.setBounds(360, 300, 90, 21);  
303.   
304.         Sale.setText("售出");  
305.         Sale.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED));  
306.         Sale.addActionListener(new java.awt.event.ActionListener() {  
307.             public void actionPerformed(java.awt.event.ActionEvent evt) {  
308.                 SaleActionPerformed(evt);  
309.             }  
310.         });  
311.         jPanel1.add(Sale);  
312.         Sale.setBounds(360, 270, 90, 21);  
313.   
314.         jTextField7.setFont(new java.awt.Font("新細明體", 0, 14)); // NOI18N  
315.         jPanel1.add(jTextField7);  
316.         jTextField7.setBounds(320, 448, 59, 30);  
317.   
318.         jLabel9.setText("價格 :");  
319.         jPanel1.add(jLabel9);  
320.         jLabel9.setBounds(270, 460, 50, 18);  
321.   
322.         getContentPane().add(jPanel1);  
323.         jPanel1.setBounds(450, 0, 490, 540);  
324.   
325.         jPanel2.setBackground(new java.awt.Color(153, 255, 51));  
326.         jPanel2.setForeground(new java.awt.Color(255, 255, 255));  
327.         jPanel2.setMaximumSize(new java.awt.Dimension(450, 70));  
328.         jPanel2.setLayout(null);  
329.   
330.         jButton4.setIcon(new javax.swing.ImageIcon(getClass().getResource("/ADD.png"))); // NOI18N  
331.         jButton4.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED));  
332.         jButton4.addActionListener(new java.awt.event.ActionListener() {  
333.             public void actionPerformed(java.awt.event.ActionEvent evt) {  
334.                 jButton4ActionPerformed(evt);  
335.             }  
336.         });  
337.         jPanel2.add(jButton4);  
338.         jButton4.setBounds(370, 20, 73, 30);  
339.   
340.         jButton5.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Help-Support-icon.png"))); // NOI18N  
341.         jButton5.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED));  
342.         jButton5.addActionListener(new java.awt.event.ActionListener() {  
343.             public void actionPerformed(java.awt.event.ActionEvent evt) {  
344.                 jButton5ActionPerformed(evt);  
345.             }  
346.         });  
347.         jPanel2.add(jButton5);  
348.         jButton5.setBounds(260, 20, 70, 30);  
349.   
350.         DELETEALL.setIcon(new javax.swing.ImageIcon(getClass().getResource("/database-delete-icon.png"))); // NOI18N  
351.         DELETEALL.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED));  
352.         DELETEALL.addActionListener(new java.awt.event.ActionListener() {  
353.             public void actionPerformed(java.awt.event.ActionEvent evt) {  
354.                 DELETEALLActionPerformed(evt);  
355.             }  
356.         });  
357.         jPanel2.add(DELETEALL);  
358.         DELETEALL.setBounds(130, 20, 80, 30);  
359.   
360.         jButton6.setIcon(new javax.swing.ImageIcon(getClass().getResource("/排行.png"))); // NOI18N  
361.         jButton6.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED));  
362.         jButton6.addActionListener(new java.awt.event.ActionListener() {  
363.             public void actionPerformed(java.awt.event.ActionEvent evt) {  
364.                 jButton6ActionPerformed(evt);  
365.             }  
366.         });  
367.         jPanel2.add(jButton6);  
368.         jButton6.setBounds(20, 20, 80, 30);  
369.   
370.         getContentPane().add(jPanel2);  
371.         jPanel2.setBounds(0, 450, 460, 90);  
372.   
373.         jMenuBar1.setBackground(new java.awt.Color(204, 153, 0));  
374.         jMenuBar1.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(153, 204, 0), 4));  
375.   
376.         jMenu1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Save-as-icon.png"))); // NOI18N  
377.   
378.         jMenuItem7.setText("印出");  
379.         jMenuItem7.addActionListener(new java.awt.event.ActionListener() {  
380.             public void actionPerformed(java.awt.event.ActionEvent evt) {  
381.                 jMenuItem7ActionPerformed(evt);  
382.             }  
383.         });  
384.         jMenu1.add(jMenuItem7);  
385.   
386.         jMenuBar1.add(jMenu1);  
387.   
388.         jMenu2.setIcon(new javax.swing.ImageIcon(getClass().getResource("/捨定.png"))); // NOI18N  
389.   
390.         jMenu3.setText("語言");  
391.   
392.         jMenuItem1.setText("繁體");  
393.         jMenuItem1.addActionListener(new java.awt.event.ActionListener() {  
394.             public void actionPerformed(java.awt.event.ActionEvent evt) {  
395.                 jMenuItem1ActionPerformed(evt);  
396.             }  
397.         });  
398.         jMenu3.add(jMenuItem1);  
399.   
400.         jMenuItem2.setText("英文");  
401.         jMenuItem2.addActionListener(new java.awt.event.ActionListener() {  
402.             public void actionPerformed(java.awt.event.ActionEvent evt) {  
403.                 jMenuItem2ActionPerformed(evt);  
404.             }  
405.         });  
406.         jMenu3.add(jMenuItem2);  
407.   
408.         jMenu2.add(jMenu3);  
409.   
410.         jMenu4.setText("版面顏色");  
411.   
412.         jMenuItem3.setText("白色");  
413.         jMenuItem3.addActionListener(new java.awt.event.ActionListener() {  
414.             public void actionPerformed(java.awt.event.ActionEvent evt) {  
415.                 jMenuItem3ActionPerformed(evt);  
416.             }  
417.         });  
418.         jMenu4.add(jMenuItem3);  
419.   
420.         jMenuItem4.setBackground(new java.awt.Color(255, 255, 255));  
421.         jMenuItem4.setForeground(new java.awt.Color(51, 204, 0));  
422.         jMenuItem4.setText("綠色");  
423.         jMenuItem4.addActionListener(new java.awt.event.ActionListener() {  
424.             public void actionPerformed(java.awt.event.ActionEvent evt) {  
425.                 jMenuItem4ActionPerformed(evt);  
426.             }  
427.         });  
428.         jMenu4.add(jMenuItem4);  
429.   
430.         jMenuItem5.setForeground(new java.awt.Color(51, 51, 255));  
431.         jMenuItem5.setText("藍色");  
432.         jMenuItem5.addActionListener(new java.awt.event.ActionListener() {  
433.             public void actionPerformed(java.awt.event.ActionEvent evt) {  
434.                 jMenuItem5ActionPerformed(evt);  
435.             }  
436.         });  
437.         jMenu4.add(jMenuItem5);  
438.   
439.         jMenu2.add(jMenu4);  
440.   
441.         jMenuBar1.add(jMenu2);  
442.   
443.         jMenu5.setIcon(new javax.swing.ImageIcon(getClass().getResource("/User-Interface-Exit-icon.png"))); // NOI18N  
444.         jMenu5.addMouseListener(new java.awt.event.MouseAdapter() {  
445.             public void mouseClicked(java.awt.event.MouseEvent evt) {  
446.                 jMenu5MouseClicked(evt);  
447.             }  
448.         });  
449.         jMenuBar1.add(jMenu5);  
450.   
451.         setJMenuBar(jMenuBar1);  
452.   
453.         pack();  
454.     }// </editor-fold>                          
455.     public void Sale(){        
456.         obj.setVisible(true);         
457.     }  
458.     Double Sales_volume ;  
459.     Double Settlement_costs;  
460.     Double profit ;  
461.     public void SALE(){ //售出功能   
462.       try{  
463.        Sales_volume  = Double.parseDouble( obj.jTextField1.getText())*Double.parseDouble( obj.jTextField2.getText());  
464.        obj.jLabel12.setText(Sales_volume.toString());   
465.        Settlement_costs  = (Double.parseDouble( obj.jTextField1.getText())*Double.parseDouble( obj.jTextField3.getText()))+Double.parseDouble( obj.jTextField5.getText())+Double.parseDouble( obj.jTextField6.getText());  
466.        obj.jLabel7.setText(Settlement_costs.toString());   
467.        Double Unit_profit = Double.parseDouble( obj.jTextField2.getText()) - Double.parseDouble( obj.jTextField3.getText()) ;  
468.        obj.jLabel13.setText(Unit_profit.toString());      
469.        profit = (Sales_volume)-(Settlement_costs);  
470.        obj.jLabel8.setText(profit.toString());  
471.          
472.     }catch(Exception e){  
473.            JOptionPane.showMessageDialog(null, "欄位不得有特殊字元與空白", "錯誤",  JOptionPane.ERROR_MESSAGE);  
474.    }  
475.     }  
476.     public void Date4OK(){//執行確認後  
477.       PreparedStatement ps = null ;  
478.       PreparedStatement ps2 = null ;  
479.       Connection conn = null ;  
480.       String qriey = "UPDATE `mydatabase` SET `SUMP`= ?,`SUMC`= ? ,`SUMPR`= ? WHERE `id` = ?";  
481.       String Addqriey = "INSERT INTO `mydatabaaseTimeList`(`Name`, `count`, `SUMP`, `SUMC`, `SUMPR`, `Unit Price`, `Unit cost`, `Unit profit`, `Freight`, `other`, `TIME`) VALUES (?,?,?,?,?,?,?,?,?,?,?)";  
482.        try{  
483.        if(jTextField3.getText().isEmpty()) throw new Exception();     
484.        conn = getConnection();  
485.        ps = conn.prepareStatement(qriey);    
486.        ps2 = conn.prepareStatement(Addqriey);  
487.        for(User u : users){  
488.        if(jTextField3.getText().equals(u.id)){  
489.        ps.setDouble(1, u.SUMP+Sales_volume);  
490.        ps.setDouble(2, u.SUMC+Settlement_costs);  
491.        ps.setDouble(3, u.SUMPR+profit);  
492.        ps.setString(4, u.id);  
493.         //************************************  
494.       Date date = new Date();   
495.       ps2.setString(1, jTextField1.getText()); ps2.setInt(2, Integer.parseInt(obj.jTextField1.getText()));  
496.       ps2.setDouble(3, Double.parseDouble(obj.jLabel12.getText()));ps2.setDouble(4, Double.parseDouble(obj.jLabel7.getText()));ps2.setDouble(5, Double.parseDouble(obj.jLabel8.getText()));  
497.       ps2.setDouble(6, Double.parseDouble(obj.jTextField2.getText()));ps2.setDouble(7, Double.parseDouble(obj.jTextField3.getText()));  
498.       ps2.setDouble(8, Double.parseDouble(obj.jLabel13.getText())); ps2.setDouble(9, Double.parseDouble(obj.jTextField5.getText())); ps2.setDouble(10, Double.parseDouble(obj.jTextField6.getText()));  
499.       ps2.setString(11, String.format("%tF %<tT", date));       
500.       if(ps.executeUpdate() == 1 ){  
501.            JOptionPane.showMessageDialog(null, "賣出 !","消息",  JOptionPane.QUESTION_MESSAGE);  
502.            ps2.executeUpdate() ;  
503.       }  
504.        break;  
505.       }  
506.       }  
507.     } catch(Exception e){  
508.          JOptionPane.showMessageDialog(null, "ERROR","消息",  JOptionPane.ERROR_MESSAGE);  
509.      }  
510.     }  
511.       
512.     public void Top(){  
513.          
514.         NO1 nod = new NO1();  
515.         try{     
516.         nod.setVisible(true);  
517.         Read();//得到更新  
518.         DefaultTableModel n = (DefaultTableModel) nod.jTable1.getModel();  
519.         n.setRowCount(0);  
520.         Object[] o = new Object[4];   
521.           
522.         for(User u : users){  
523.             o[0] = u.name ;  
524.             o[1] = u.SUMPR ;  
525.             o[2] = u.SUMP ;   
526.             o[3] = u.SUMC ;  
527.             n.addRow(o);  
528.         }  
529.         }catch(Exception e){  
530.             e.printStackTrace();  
531.         }  
532.         }  
533.     Deta3 date3 = new Deta3();  
534.     public void NowSale(){       //最近銷售  
535.         Statement st = null ;  
536.         Connection conn = null ;  
537.         try{  
538.          date3.setVisible(true);  
539.         conn =  getConnection();  
540.         DefaultTableModel mod = (DefaultTableModel) date3.jTable1.getModel();  
541.         mod.setRowCount(0);  
542.         st = conn.createStatement();  
543.         ResultSet rs = st.executeQuery("SELECT * FROM `mydatabaasetimelist`");  
544.         Object[] o = new Object[11];  
545.         while(rs.next()){  
546.             o[0] = rs.getString("Name");  
547.             o[1] = rs.getInt("count") ;  
548.             o[2] = rs.getDouble("SUMP");  
549.             o[3] = rs.getDouble("SUMC");  
550.             o[4] = rs.getDouble("SUMPR");  
551.             o[5] = rs.getDouble("Unit Price");  
552.             o[6] = rs.getDouble("Unit cost");  
553.             o[7] = rs.getDouble("Unit profit");  
554.             o[8] = rs.getDouble("Freight") ;  
555.             o[9] = rs.getDouble("Other") ;  
556.             o[10] = rs.getString("TIME") ;  
557.             mod.addRow(o);    
558.         }  
559.         }catch(Exception e ){  
560.             e.printStackTrace();   
561.         }  
562.     }  
563.     /////////////////////////////////////////////////////////////////////////  
564.    public ImageIcon ReImage(String imagepath , byte[] p){  
565.        ImageIcon myprc = null ;  
566.         
567.        if(imagepath != null){  
568.            myprc = new ImageIcon(imagepath);  
569.        }else{//假設有圖片就NEW 沒有就直接回NULL  
570.            if(p != null)  
571.            {myprc = new ImageIcon(p);}  
572.            else  
573.            {return null;}  
574.        }  
575.        Image img = myprc.getImage();  
576.        img.getScaledInstance(jLabel1.getWidth(), jLabel1.HEIGHT, Image.SCALE_AREA_AVERAGING);  
577.        ImageIcon Image =  new ImageIcon(img);  
578.        return Image;  
579.          
580.    }  
581.     public  Connection getConnection() throws ClassNotFoundException, SQLException{  
582.         Connection conn = null ;  
583.         Class.forName(com);  
584.         conn = DriverManager.getConnection(URL);  
585.         return conn ;  
586.     }  
587.     public void Update(){ //更新資料     
588.         String SQL = "UPDATE `mydatabase` SET `name`= ? ,`price`= ? ,`adress`= ? ,`number`= ? ,`Company`= ? ,`E-MAIL`= ? ,`Image`= ? WHERE `id` = ?";  
589.         String SQLNotImage = "UPDATE `mydatabase` SET `name`=?,`price`=?,`adress`=?,`number`=?,`Company`=?,`E-MAIL`=? WHERE `id` = ?";  
590.         PreparedStatement ps = null ;  
591.         Connection conn = null ;  
592.         try{  
593.            conn = getConnection();  
594.            CheckInput(false);  
595.             if(ImagePath != null ){  
596.         ps = conn.prepareStatement(SQL);  
597.         InputStream Ip = new FileInputStream(new File(ImagePath));   
598.         ps.setString(1, jTextField1.getText());   
599.         ps.setDouble(2, Double.parseDouble(jTextField7.getText())); ps.setString(3, jTextField4.getText());  
600.         ps.setString(4, jTextField2.getText()); ps.setString(5, jTextField5.getText());  
601.         ps.setString(6, jTextField6.getText());   
602.         ps.setBlob(7, Ip); ps.setString(8, jTextField3.getText());  
603.             }else{  
604.         ps = conn.prepareStatement(SQLNotImage);  
605.         ps.setString(1, jTextField1.getText());   
606.         ps.setDouble(2, Double.parseDouble(jTextField7.getText())); ps.setString(3, jTextField4.getText());  
607.         ps.setString(4, jTextField2.getText()); ps.setString(5, jTextField5.getText());  
608.         ps.setString(6, jTextField6.getText()); ps.setString(7, jTextField3.getText());  
609.             }  
610.         if(ps.executeUpdate() == 1){      
611.             JOptionPane.showMessageDialog(rootPane,"ID :"+jTextField3.getText()+" 更新成功 ");  
612.         }else{  
613.             JOptionPane.showMessageDialog(rootPane,"ID :"+jTextField3.getText()+" 未找到 ! ");}  
614.         Read();     
615.         }catch(Exception e ){  
616.             JOptionPane.showMessageDialog(null, "MySql 更新錯誤", "錯誤",  JOptionPane.ERROR_MESSAGE);  
617.             e.printStackTrace();  
618.         }  
619.     }  
620.       
621.     public void Delete(){//刪除商品資料  
622.         Connection conn = null ;  
623.         PreparedStatement ps = null ;  
624.         try{  
625.            conn = getConnection();  
626.            ps = conn.prepareStatement("DELETE FROM `mydatabase` WHERE `id` = ?");  
627.            ps.setString(1, jTextField3.getText());  
628.              
629.            if(ps.executeUpdate() != 0){//使否刪除成功  
630.                Read();  
631.                JOptionPane.showMessageDialog(rootPane,"ID :"+jTextField3.getText()+" 刪除成功 ");  
632.            }else{//失敗顯示未找到視窗提醒  
633.                JOptionPane.showMessageDialog(rootPane,"ID :"+jTextField3.getText()+" 未找到 ! ");}  
634.              
635.         }catch(Exception e){  
636.             JOptionPane.showMessageDialog(null, "MySql 刪除錯誤", "錯誤",  JOptionPane.ERROR_MESSAGE);  
637.             e.printStackTrace();  
638.         }  
639.     }   
640.     public void Insert(){//添加商品  
641.         //SQL語法  
642.         String quiry = "INSERT INTO `mydatabase`(`name`, `id`, `price`, `adress`, `number`, `Company`, `E-MAIL`, `Time`, `Image`, `SUMP`, `SUMC`, `SUMPR`) VALUES (?,?,?,?,?,?,?,?,?,0,0,0)";  
643.         String quiryNotImage = "INSERT INTO `mydatabase`(`name`, `id`, `price`, `adress`, `number`, `Company`, `E-MAIL`, `Time`, `SUMP`, `SUMC`, `SUMPR`) VALUES (?,?,?,?,?,?,?,?,0,0,0)";  
644.         PreparedStatement ps = null ;  
645.         Connection conn = null ;  
646.         try{  
647.         CheckInput(true);     
648.         Date date = new Date();    
649.         conn = getConnection();  
650.         if(ImagePath != null ){//使否有照片路徑存在  
651.         InputStream Ip = new FileInputStream(new File(ImagePath));  
652.         ps = conn.prepareStatement(quiry);//準備聲明  
653.         ps.setString(1, jTextField1.getText()); ps.setString(2, jTextField3.getText());  
654.         ps.setDouble(3, Double.parseDouble(jTextField7.getText())); ps.setString(4, jTextField4.getText());  
655.         ps.setString(5, jTextField2.getText()); ps.setString(6, jTextField5.getText());  
656.         ps.setString(7, jTextField6.getText()); ps.setString(8, String.format("%tF %<tT",date));  
657.         ps.setBlob(9, Ip);  
658.         }else{        
659.         ps = conn.prepareStatement(quiryNotImage);  
660.         ps.setString(1, jTextField1.getText()); ps.setString(2, jTextField3.getText());  
661.         ps.setDouble(3, Double.parseDouble(jTextField7.getText())); ps.setString(4, jTextField4.getText());  
662.         ps.setString(5, jTextField2.getText()); ps.setString(6, jTextField5.getText());  
663.         ps.setString(7, jTextField6.getText()); ps.setString(8, String.format("%tF %<tT",date));        
664.         }  
665.         ps.executeUpdate() ; //執行  
666.         Read(); //重新閱讀  
667.         JOptionPane.showMessageDialog(null, "MYSQL : Insert 成功");   
668.         }catch(Exception e){  
669.             JOptionPane.showMessageDialog(null, "MySql 新增錯誤", "錯誤",  JOptionPane.ERROR_MESSAGE);  
670.             e.printStackTrace();  
671.         }  
672.     }  
673.     LinkedList<User> users ;  
674.     public void Read() {//讀取  
675.         DefaultTableModel mod = (DefaultTableModel) jTable1.getModel();  
676.         mod.setRowCount(0);  
677.         users = new    LinkedList<User>();  
678.         Connection conn = null ;  
679.         Statement st = null;  
680.         try{  
681.             conn =  getConnection() ;  
682.             st = conn.createStatement();  
683.             ResultSet rs = st.executeQuery("SELECT * FROM `mydatabase`");  
684.             while(rs.next()){  
685.                 users.add(new User(rs.getString("name") ,rs.getString("id"),rs.getDouble("price") , rs.getString("adress") , rs.getInt("number"),rs.getString("Company"),rs.getString("E-MAIL"),ReImage(null,rs.getBytes("Image")), rs.getString("Time") , rs.getDouble("SUMP") ,rs.getDouble("SUMC") ,rs.getDouble("SUMPR")));  
686.             }  
687.             JTableRead();  
688.         }catch(Exception e){           
689.             JOptionPane.showMessageDialog(null, "MySql連接錯誤", "錯誤",  JOptionPane.ERROR_MESSAGE);  
690.             e.printStackTrace();  
691.         }finally{//清空    
692.             ImagePath = null ;  
693.             FieldEmpty();  
694.             }  
695.     }  
696.     public void JTableRead(){//Table讀取與顯示  
697.         DefaultTableModel Mod = (DefaultTableModel) jTable1.getModel();  
698.         Object[] Tableobj = new Object[7];  
699.         for(User user : users){  
700.             Tableobj[0] = user.name ;  
701.             Tableobj[1] = user.id ;  
702.             Tableobj[2] = user.number ;  
703.             Tableobj[3] = user.price ;  
704.             Tableobj[4] = user.address ;  
705.             Tableobj[5] = user.Company ;  
706.             Tableobj[6] = user.MAIL ;  
707.             Mod.addRow(Tableobj);    
708.         }  
709.           
710.     }  
711.      
712.       
713.       
714.     private void jMenuItem4ActionPerformed(java.awt.event.ActionEvent evt) {                                             
715.         // TODO add your handling code here:  
716.        SetGreen();  
717.     }                                            
718.   
719.     private void jMenuItem3ActionPerformed(java.awt.event.ActionEvent evt) {                                             
720.         SetNull();  
721.     }                                            
722.   
723.     private void jMenuItem5ActionPerformed(java.awt.event.ActionEvent evt) {                                             
724.         SetBlue();  
725.     }                                            
726.   
727.     private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {                                             
728.         // TODO add your handling code here:  
729.          SetChina();  
730.     }                                            
731.   
732.     private void jMenuItem2ActionPerformed(java.awt.event.ActionEvent evt) {                                             
733.         // TODO add your handling code here  
734.          SetEnglish();  
735.     }                                            
736.   
737.     private void SaleActionPerformed(java.awt.event.ActionEvent evt) {                                       
738.         Sale();  
739.     }                                      
740.   
741.     private void formWindowClosing(java.awt.event.WindowEvent evt) {                                     
742.        WinClose();  
743.     }                                    
744.     public void WinClose(){  
745.        int close = JOptionPane.showConfirmDialog(null, "離開??", "關閉", JOptionPane.YES_NO_OPTION,JOptionPane.ERROR_MESSAGE,new ImageIcon(this.getClass().getResource("User-Interface-Exit-icon.png")));  
746.        if(close == JOptionPane.YES_OPTION){  
747.            try {  
748.                FileWriter fis = new FileWriter("SET/設定.txt");  
749.                fis.write(SetInterface+"\t");  
750.                fis.write(SetInter2);  
751.                fis.close();  
752.                System.exit(0);  
753.            } catch (Exception ex) {  
754.               ex.printStackTrace();  
755.            }  
756.        }  
757.     }  
758.     private void BrowActionPerformed(java.awt.event.ActionEvent evt) {                                       
759.         JFileChooser chooser2 = new JFileChooser();  
760.         chooser2.setDialogTitle("圖片開啟: ");  
761.         //  
762.          chooser2.setFileFilter(new FileTypeFilter(".gif","GIF File"));  
763.          chooser2.setFileFilter(new FileTypeFilter(".png","PNG File"));//設置文件過濾器   
764.          chooser2.setFileFilter(new FileTypeFilter(".jpg","JPEG File"));//設置文件過濾器  
765.         //  
766.         int openresult = chooser2.showOpenDialog(null);  
767.         if(openresult == JFileChooser.APPROVE_OPTION){  
768.             File file =  chooser2.getSelectedFile();  
769.             ImagePath = file.getAbsolutePath();//透過file絕對路徑  
770.             jLabel1.setIcon(ReImage(ImagePath, null));  
771.         }  
772.     }                                      
773.   
774.     private void jMenu5MouseClicked(java.awt.event.MouseEvent evt) {                                      
775.        WinClose();  
776.     }                                     
777.   
778.     private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {                                           
779.       Insert();//添加商品  
780.     }                                          
781.   
782.     private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {                                       
783.          //滑鼠點擊觸發事件  
784.          TableModel mod = jTable1.getModel();  
785.          int index = jTable1.getSelectedRow();  
786.          jTextField1.setText((String) mod.getValueAt(index, 0));  
787.          jTextField3.setText((String) mod.getValueAt(index, 1));  
788.          jTextField2.setText(mod.getValueAt(index, 2).toString());  
789.          jTextField7.setText(mod.getValueAt(index, 3).toString());  
790.          jTextField4.setText((String) mod.getValueAt(index, 4));  
791.          jTextField5.setText((String) mod.getValueAt(index, 5));  
792.          jTextField6.setText((String) mod.getValueAt(index, 6));  
793.          jLabel1.setIcon(users.get(index).Image);  
794.          jLabel8.setText(users.get(index).Time);  
795.     }                                      
796.   
797.     private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                           
798.         Delete();  
799.     }                                          
800.   
801.     private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {                                           
802.         Update();  
803.     }                                          
804.   
805.     private void DELETEALLActionPerformed(java.awt.event.ActionEvent evt) {                                            
806.          Connection conn = null ;  
807.          PreparedStatement ps = null ;  
808.         try{  
809.            conn = getConnection();       
810.            ps = conn.prepareStatement("DELETE FROM `mydatabase` WHERE `id` = ?");  
811.            for(User u : users){  
812.            ps.setString(1, u.id);   
813.            ps.executeUpdate();  
814.            }   
815.            Read();  
816.            JOptionPane.showMessageDialog(rootPane," 全部刪除成功 ");  
817.         }catch(Exception e){  
818.             JOptionPane.showMessageDialog(null, "MySql 刪除錯誤", "錯誤",  JOptionPane.ERROR_MESSAGE);  
819.             e.printStackTrace();  
820.         }  
821.     }                                           
822.   
823.     private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {                                           
824.              Top();//紀錄  
825.                
826.     }                                          
827.   
828.     private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {                                           
829.          NowSale();  
830.     }                                          
831.   
832.     private void jMenuItem7ActionPerformed(java.awt.event.ActionEvent evt) {                                             
833.          JFileChooser chooser = new JFileChooser();  
834.          chooser.setDialogTitle("匯出");  
835.           chooser.setFileFilter(new FileTypeFilter("txt" , "文件"));  
836.          int is = chooser.showSaveDialog(null) ;  
837.          if(is == JFileChooser.APPROVE_OPTION){       
838.              try {  
839.                  BufferedWriter fos = new  BufferedWriter(new FileWriter(chooser.getSelectedFile()));      
840.                  for(User u : users){  
841.                  fos.write(u.name+" "+u.price+" "+u.id+" "+u.number+" "+u.Company+" "+u.MAIL+" "+u.address+" "+u.SUMP+" "+u.SUMC+" "+u.SUMPR+"\r\n");  
842.                  }  
843.                  fos.close();  
844.              } catch (IOException ex) {  
845.                  Logger.getLogger(Date2.class.getName()).log(Level.SEVERE, null, ex);  
846.              }  
847.          }  
848.     }                                            
849.   
850.     private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {                                           
851.        help he = new help();  
852.        he.setVisible(true);  
853.          
854.     }                                          
855.    public void SetBlue(){  
856.         jPanel1.setBackground(new Color(153, 153, 255));  
857.         jPanel2.setBackground(new Color(153, 153, 255));  
858.         jLabel1.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(51, 0, 102), 5));  
859.         jMenuBar1.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 153), 4));  
860.         SetInterface = "SETBLUE";  
861.    }  
862.    public void SetGreen(){  
863.         jPanel1.setBackground(new Color(153, 255, 51));  
864.         jPanel2.setBackground(new Color(153, 255, 51));  
865.         jLabel1.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(153, 153, 0), 5));  
866.         jMenuBar1.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(153, 204, 0), 4));  
867.         SetInterface = "SETGREEN";  
868.    }  
869.    public void SetNull(){  
870.         jPanel1.setBackground(null);  
871.         jPanel2.setBackground(null);  
872.         jLabel1.setBorder(null);  
873.         jMenuBar1.setBorder(null);  
874.         SetInterface = "SETNULL";  
875.    }  
876.    public void SetChina()  
877.    {  
878.        jLabel2.setText("商品名 :");  
879.        jLabel3.setText("電話 :");  
880.        jLabel4.setText("ID :");  
881.        jLabel5.setText("地址 :");  
882.        jLabel6.setText("發行商 :");jLabel9.setText("價格 :");  
883.        Brow.setText("上傳圖片");  
884.        Sale.setText("售出");  
885.        jButton8.setText("銷售量");     
886.         jTable1.setModel(new DefaultTableModel(  
887.             new Object [][] {},  
888.             new String [] {  
889.                 "商品名 ", "ID", "電話", "價格", "地址", "發行商", "e-mail"  
890.             }  
891.         ));    
892.         obj.jLabel1.setText("銷售數量 :");  
893.         obj.jLabel2.setText("單價成本 :");  
894.         obj.jLabel5.setText("單價定價 :");  
895.         obj.jLabel6.setText("單價利潤 :");  
896.         obj.jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("總結 :"));  
897.         obj.jLabel3.setText("結算成本 :");  
898.         obj.jLabel4.setText("利潤 :");  
899.         obj.jLabel11.setText("銷售值 :");  
900.         obj.jButton1.setText("取消");      
901.         obj.jButton3.setText("確定");    
902.         obj.jLabel9.setText("運費 :");    
903.         obj.jLabel10.setText("額外成本 :");  
904.         SetInter2 = "China";  
905.    }  
906.      public void SetEnglish()  
907.    {  
908.        jLabel2.setText("Name :");  
909.        jLabel3.setText("Number :");  
910.        jLabel4.setText("ID :");  
911.        jLabel5.setText("Address :");  
912.        jLabel6.setText("Company :");jLabel9.setText("Price :");  
913.        Brow.setText("Upload image");  
914.        Sale.setText("Sold out");  
915.        jButton8.setText("Sales");     
916.         jTable1.setModel(new DefaultTableModel(  
917.             new Object [][] {},  
918.             new String [] {  
919.                 "Name ", "ID", "Number", "Price", "Address", "Company", "e-mail"  
920.             }  
921.         ));  
922.         obj.jLabel1.setText("Sales volume :");  
923.         obj.jLabel2.setText("Unit cost :");  
924.         obj.jLabel5.setText("Unit Price :");  
925.         obj.jLabel6.setText("Unit profit :");  
926.         obj.jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("Sum up :"));  
927.         obj.jLabel3.setText("Settlement costs :");  
928.         obj.jLabel4.setText("Profit :");  
929.         obj.jLabel11.setText("Sales :");  
930.         obj.jButton1.setText("Cancel");      
931.         obj.jButton3.setText("Yes");    
932.         obj.jLabel9.setText("Freight  :");   
933.         obj.jLabel10.setText("Other :");  
934.         SetInter2 = "ENG";  
935.    }  
936.      
937.       
938.       
939.       
940.       
941.       
942.     /**  
943.      * @param args the command line arguments  
944.      */  
945.     public static void main(String args[]) {  
946.         /* Set the Nimbus look and feel */  
947.         //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">  
948.         /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. 
949.          * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html  
950.          */  
951.         try {  
952.             for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {  
953.                 if ("Nimbus".equals(info.getName())) {  
954.                     javax.swing.UIManager.setLookAndFeel(info.getClassName());  
955.                     break;  
956.                 }  
957.             }  
958.         } catch (ClassNotFoundException ex) {  
959.             java.util.logging.Logger.getLogger(Date2.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);  
960.         } catch (InstantiationException ex) {  
961.             java.util.logging.Logger.getLogger(Date2.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);  
962.         } catch (IllegalAccessException ex) {  
963.             java.util.logging.Logger.getLogger(Date2.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);  
964.         } catch (javax.swing.UnsupportedLookAndFeelException ex) {  
965.             java.util.logging.Logger.getLogger(Date2.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);  
966.         }  
967.         //</editor-fold>  
968.   
969.         /* Create and display the form */  
970.         java.awt.EventQueue.invokeLater(new Runnable() {  
971.             public void run() {  
972.                 new Date2().setVisible(true);  
973.             }  
974.         });  
975.     }  
976.   
977.     // Variables declaration - do not modify                       
978.     private javax.swing.JButton Brow;  
979.     private javax.swing.JButton DELETEALL;  
980.     private javax.swing.JButton Sale;  
981.     private javax.swing.JButton jButton2;  
982.     private javax.swing.JButton jButton3;  
983.     private javax.swing.JButton jButton4;  
984.     private javax.swing.JButton jButton5;  
985.     private javax.swing.JButton jButton6;  
986.     private javax.swing.JButton jButton8;  
987.     private javax.swing.JLabel jLabel1;  
988.     private javax.swing.JLabel jLabel2;  
989.     private javax.swing.JLabel jLabel3;  
990.     private javax.swing.JLabel jLabel4;  
991.     private javax.swing.JLabel jLabel5;  
992.     private javax.swing.JLabel jLabel6;  
993.     private javax.swing.JLabel jLabel7;  
994.     private javax.swing.JLabel jLabel8;  
995.     private javax.swing.JLabel jLabel9;  
996.     private javax.swing.JMenu jMenu1;  
997.     private javax.swing.JMenu jMenu2;  
998.     private javax.swing.JMenu jMenu3;  
999.     private javax.swing.JMenu jMenu4;  
1000.     private javax.swing.JMenu jMenu5;  
1001.     private javax.swing.JMenuBar jMenuBar1;  
1002.     private javax.swing.JMenuItem jMenuItem1;  
1003.     private javax.swing.JMenuItem jMenuItem2;  
1004.     private javax.swing.JMenuItem jMenuItem3;  
1005.     private javax.swing.JMenuItem jMenuItem4;  
1006.     private javax.swing.JMenuItem jMenuItem5;  
1007.     private javax.swing.JMenuItem jMenuItem6;  
1008.     private javax.swing.JMenuItem jMenuItem7;  
1009.     private javax.swing.JPanel jPanel1;  
1010.     private javax.swing.JPanel jPanel2;  
1011.     private javax.swing.JScrollPane jScrollPane1;  
1012.     public javax.swing.JTable jTable1;  
1013.     private javax.swing.JTextField jTextField1;  
1014.     private javax.swing.JTextField jTextField2;  
1015.     private javax.swing.JTextField jTextField3;  
1016.     private javax.swing.JTextField jTextField4;  
1017.     private javax.swing.JTextField jTextField5;  
1018.     private javax.swing.JTextField jTextField6;  
1019.     private javax.swing.JTextField jTextField7;  
1020.     // End of variables declaration                     
1021.   
1022.     private help help() {  
1023.         throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.  
1024.     }  
1025. }  
1026. class User {  
1027.     String name ;  
1028.     String  id  ;  
1029.     double price ;    
1030.     String address;   
1031.     int number ;      
1032.     String Company ;      
1033.     String MAIL ;     
1034.     ImageIcon Image ;  
1035.     String Time;  
1036.     double SUMP , SUMC , SUMPR ;  
1037. public User(String name ,String  id,double price , String address , int number,String Company,String MAIL,ImageIcon Image  
1038. , String Time , double SUMP ,double SUMC ,double SUMPR){  
1039.     this.name = name ;this.id = id ;    
1040.     this.price = price ;this.address = address ;  
1041.     this.number = number ;this.Company = Company ;  
1042.     this.MAIL = MAIL ;  this.Time = Time ;  
1043.     this.Image = Image ;this. SUMP = SUMP ;  
1044.     this. SUMC = SUMC ;this. SUMPR = SUMPR ;  
1045. }  
1046.   
1047.       
1048. } 

  FileTypeFilter.class

1. public class FileTypeFilter extends FileFilter{  
2.  private final String extension ;//延期  
3.  private final String description;//描述  
4.  public  FileTypeFilter( String extension,String description){  
5.      this.extension = extension ;  
6.      this.description= description ;  
7.  }  
8.     @Override  
9.     public boolean accept(File f) {  
10.        if(f.isDirectory()){  
11.            return true;  
12.        }  
13.        return f.getName().endsWith(extension);  
14.     }  
15.   
16.     @Override  
17.     public String getDescription() {  
18.         return description+String.format(" (*%s)", extension);  
19.     }  
20. 
    
21. 
    
23.