Java Insert JTable Rows Data Into MySQL - Hallo sahabat Dev-Create, Pada Artikel yang anda baca kali ini dengan judul Java Insert JTable Rows Data Into MySQL, kami telah mempersiapkan artikel ini dengan baik untuk anda baca dan ambil informasi didalamnya. mudah-mudahan isi postingan Artikel insert, Artikel Insert All JTable Rows Data To MySQL DataBase Using Java, Artikel Insert JTable Data Into MySQL, Artikel Java, Artikel java jtable, Artikel jtable, Artikel jtable row, yang kami tulis ini dapat anda pahami. baiklah, selamat membaca.

Judul : Java Insert JTable Rows Data Into MySQL
link : Java Insert JTable Rows Data Into MySQL

Baca juga


Java Insert JTable Rows Data Into MySQL

How To Insert All JTable Rows Data To MySQL DataBase Using Java NetBeans

Insert JTable Values Into DataBase Using Java



In this Java Tutorial we will see How To INSERT All JTable Rows Values Into DataBase Using For Loop And addBatch Function On Button Click In Java NetBeans .




▶ Download All JAVA Projects Source Code


Project Source Code:


// function to get the connection
    public Connection getConnection()
    {
         try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException ex) {
             System.out.println(ex.getMessage());
        }
        
        Connection con = null;
        
        try {
            con = DriverManager.getConnection("jdbc:mysql://localhost/s_t_d", "root", "");
        } catch (SQLException ex) {
            System.out.println(ex.getMessage());
        }
        return con;
    } 


// insert button
    private void jButtonInsertActionPerformed(java.awt.event.ActionEvent evt) {                                              
        
        Connection con = getConnection();
        Statement st;
        
        DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
        
        try {
            st = con.createStatement();
            
            for(int i = 0; i < model.getRowCount(); i++){
                
                int id = Integer.valueOf(model.getValueAt(i, 0).toString());
                String fn = model.getValueAt(i, 1).toString();
                String adr = model.getValueAt(i, 2).toString();
                String bdate = model.getValueAt(i, 3).toString();
                
                String sqlQuery = "INSERT INTO `student`(`Id`, `FullName`, `Address`, `BirthDate`) VALUES ("+id+",'"+fn+"','"+adr+"','"+bdate+"')";
                
                st.addBatch(sqlQuery);
            }
            
            int[] rowsInserted = st.executeBatch();
            System.out.println("Data Inserted");
            System.out.println("rowsInserted Count = " + rowsInserted.length);
            
        } catch (SQLException ex) {
            Logger.getLogger(Insert_All_JTable_Row_Into_MySQL.class.getName()).log(Level.SEVERE, null, ex);
        }
        
    }

OutPut:

java add jtable data to mysql





Demikianlah Artikel Java Insert JTable Rows Data Into MySQL

Sekianlah artikel Java Insert JTable Rows Data Into MySQL kali ini, mudah-mudahan bisa memberi manfaat untuk anda semua. baiklah, sampai jumpa di postingan artikel lainnya.

Anda sekarang membaca artikel Java Insert JTable Rows Data Into MySQL dengan alamat link https://dev-create.blogspot.com/2021/05/java-insert-jtable-rows-data-into-mysql.html