database_gui_openfileview.java

JAVA 資料庫讀寫測試 簡單的對 MYSQL資料庫讀寫測試

                    .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 19, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 21, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(mainPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel6)
                    .addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel5)
                    .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel4)
                    .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel3)
                    .addComponent(jTextField5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 134, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(mainPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(mainPanelLayout.createSequentialGroup()
                        .addGroup(mainPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(jButton1)
                            .addComponent(jButton4)
                            .addComponent(jButton5)
                            .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addGap(29, 29, 29)
                        .addGroup(mainPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                            .addComponent(jLabel7)
                            .addComponent(jLabel8, javax.swing.GroupLayout.PREFERRED_SIZE, 15, javax.swing.GroupLayout.PREFERRED_SIZE)))
                    .addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(23, 23, 23))
        );

        menuBar.setName("menuBar"); // NOI18N

        fileMenu.setText(resourceMap.getString("fileMenu.text")); // NOI18N
        fileMenu.setName("fileMenu"); // NOI18N

        exitMenuItem.setAction(actionMap.get("quit")); // NOI18N
        exitMenuItem.setName("exitMenuItem"); // NOI18N
        fileMenu.add(exitMenuItem);

        jMenuItem1.setText(resourceMap.getString("jMenuItem1.text")); // NOI18N
        jMenuItem1.setName("jMenuItem1"); // NOI18N
        jMenuItem1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem1ActionPerformed(evt);
            }
        });
        fileMenu.add(jMenuItem1);

        menuBar.add(fileMenu);

        helpMenu.setText(resourceMap.getString("helpMenu.text")); // NOI18N
        helpMenu.setName("helpMenu"); // NOI18N

        aboutMenuItem.setAction(actionMap.get("showAboutBox")); // NOI18N
        aboutMenuItem.setName("aboutMenuItem"); // NOI18N
        helpMenu.add(aboutMenuItem);

        menuBar.add(helpMenu);

        statusPanel.setName("statusPanel"); // NOI18N

        statusPanelSeparator.setName("statusPanelSeparator"); // NOI18N

        statusMessageLabel.setName("statusMessageLabel"); // NOI18N

        statusAnimationLabel.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
        statusAnimationLabel.setName("statusAnimationLabel"); // NOI18N

        progressBar.setName("progressBar"); // NOI18N

        javax.swing.GroupLayout statusPanelLayout = new javax.swing.GroupLayout(statusPanel);
        statusPanel.setLayout(statusPanelLayout);
        statusPanelLayout.setHorizontalGroup(
            statusPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(statusPanelSeparator, javax.swing.GroupLayout.DEFAULT_SIZE, 578, Short.MAX_VALUE)
            .addGroup(statusPanelLayout.createSequentialGroup()
                .addContainerGap()
                .addComponent(statusMessageLabel)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 277, Short.MAX_VALUE)
                .addComponent(progressBar, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(135, 135, 135)
                .addComponent(statusAnimationLabel)
                .addContainerGap())
        );
        statusPanelLayout.setVerticalGroup(
            statusPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(statusPanelLayout.createSequentialGroup()
                .addComponent(statusPanelSeparator, javax.swing.GroupLayout.PREFERRED_SIZE, 2, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addGroup(statusPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                    .addGroup(statusPanelLayout.createSequentialGroup()
                        .addGroup(statusPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(statusMessageLabel)
                            .addComponent(statusAnimationLabel))
                        .addGap(3, 3, 3))
                    .addComponent(progressBar, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
        );

        jSeparator1.setName("jSeparator1"); // NOI18N

        setComponent(mainPanel);
        setMenuBar(menuBar);
        setStatusBar(statusPanel);
    }// </editor-fold>//GEN-END:initComponents

     /*
     定義資料庫變數
     */
    private static Connection dbCon = null; 
    private static Statement stmt = null; 
    private static ResultSet rs = null; 
    private static ResultSetMetaData md = null; 
    
 Vector   vec=new   Vector();
 Vector   vec_record=new Vector();
    
    
private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem1ActionPerformed
   // TODO add your handling code here:
       try { 
	             Class.forName("com.mysql.jdbc.Driver").newInstance(); 
	             //System.out.println("載入驅動程式成功"); 
                     jLabel1.setText("載入驅動程式成功");
	           } 
        catch (Exception e) { 
	             jLabel1.setText("無法載入驅動程式"); 
	            }
        try { 
	            dbCon = DriverManager.getConnection("jdbc:mysql://localhost:3306/patient?user=root&password="); 
	            stmt = dbCon.createStatement(); 
	            if(stmt==null){ 
	                jLabel2.setText("stmt==null : 無法連結MYSQL資料庫1"); 
	            }
                    else 
                    {
	                jLabel2.setText("連結MYSQL資料庫成功"); 
                    }
	        }
        catch (SQLException e) { 
	            jLabel2.setText("SQLException : 無法連結MYSQL資料庫"); 
	            }
    
    
 
}//GEN-LAST:event_jMenuItem1ActionPerformed



/*
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed
 TODO add your handling code here:
String sqlstring ,IDtemp,NAMEtemp,PHOMEtemp,ADDRESStemp;//GEN-LAST:event_jButton3ActionPerformed
*/

private void select_item(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_select_item
// TODO add your handling code here:
    
    
    
    
}//GEN-LAST:event_select_item


    @Action
    public void connect_database() {
      
    }
int i=0;
    String lisetdata[];
    @Action
    public void search() {
        String search_temp="";
        search_temp=jTextField1.getText();
        try { 
            vec.clear();
            //vec_record.clear();
                    rs = stmt.executeQuery("select * from patient");
	            //rs = stmt.executeQuery("SELECT patient.* , record.* FROM record LEFT JOIN patient ON record.ID = patient.ID "); 
	            while (rs.next()) 
	            { 
                        System.out.println(rs.getString("ID")+" " + rs.getString("NAME")+" "+ rs.getString("PHONE")+" "+ rs.getString("ADDRESS")); 
                       vec.add(rs.getString("ID")+" " + rs.getString("NAME")+" "+ rs.getString("PHONE")+" "+ rs.getString("ADDRESS"));
                      // vec_record.add( rs.getString("SET_UP_DATA")+" "+ rs.getString("FILE_PATH")+" "+ rs.getString("FILE_NAME")+" "+ rs.getString("FILE_TYPE"));
                       
                         
	            } 
                      
               jList1.removeAll();     
               jList1.setListData(vec);
               //jList2.removeAll();     
               //jList2.setListData(vec_record);
               
	        } catch (SQLException e) { 
	            // TODO Auto-generated catch block 
	            e.printStackTrace(); 
	        }
        
    }

    @Action
    public void delete() {
        
        String sqlstring ,select_temp;

               select_temp=jTextField1.getText();
               sqlstring = " DELETE FROM patient ";
               sqlstring += " WHERE ID = '"+ select_temp.toString() +"' ";
               /*新增資料*/
                try{
                    int num = stmt.executeUpdate(sqlstring);
                    System.out.println("delete OK");
                    System.out.println(" 刪除了"+num+"筆資料");
                    jLabel8.setText("delete OK  刪除了"+num+"筆資料");
                }
                catch (SQLException e){
                    e.printStackTrace();
                    System.out.println(" 刪除失敗 ");
                    jLabel8.setText(" 刪除失敗 ");
                }
        
    }

    @Action
    public void open_file() {
    }

    @Action
    public void insert_data() {
        String sqlstring ,IDtemp,NAMEtemp,PHOMEtemp,ADDRESStemp;                                        

               IDtemp=jTextField2.getText();
               NAMEtemp=jTextField3.getText();
               PHOMEtemp=jTextField4.getText();
               ADDRESStemp=jTextField5.getText();
               sqlstring = "INSERT INTO patient (ID,NAME,PHONE,ADDRESS) ";
               sqlstring += "VALUES ('"+IDtemp.toString()+"','"+NAMEtemp.toString()+"','"+PHOMEtemp.toString()+"','"+ADDRESStemp.toString()+"') ";
               
                try{
                    int num = stmt.executeUpdate(sqlstring);
                    System.out.println("insert OK");
                    jLabel8.setText("insert OK");
                }
                catch (SQLException e){
                    e.printStackTrace();
                    System.out.println(" insert is not OK");
                    jLabel8.setText(" insert is not OK");
                    
                }
                                        

        
    }
    

    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JButton jButton3;
    private javax.swing.JButton jButton4;
    private javax.swing.JButton jButton5;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JList jList1;
    private javax.swing.JList jList2;
    private javax.swing.JMenuItem jMenuItem1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JSeparator jSeparator1;
    private javax.swing.JTextField jTextField1;
    private javax.swing.JTextField jTextField2;
    private javax.swing.JTextField jTextField3;
    private javax.swing.JTextField jTextField4;
    private javax.swing.JTextField jTextField5;
    private javax.swing.JPanel mainPanel;
    private javax.swing.JMenuBar menuBar;
    private javax.swing.JProgressBar progressBar;
    private javax.swing.JLabel statusAnimationLabel;
    private javax.swing.JLabel statusMessageLabel;
    private javax.swing.JPanel statusPanel;
    // End of variables declaration//GEN-END:variables

    private final Timer messageTimer;
    private final Timer busyIconTimer;
    private final Icon idleIcon;
    private final Icon[] busyIcons = new Icon[15];
    private int busyIconIndex = 0;

    private JDialog aboutBox;
}