Cara Membuat CRUD Pada Pemrograman Java | Tahap 1 Insert Data

Berikut merupakan langkah yang harus diperhatikan sampai tahapan INSERT DATA 1. MEMBUAT FORM 2. MEMBUAT DATABASE DAN TABEL DB : aplikasi_pbo TB : mahasiswa, kolom : 5 npm : primary key 3. MEMBUAT CLASS CONFIG import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class config { private static Connection mysqlconfig; public static Connection configDB()throws SQLException{ try { String url="jdbc:mysql://localhost:3306/aplikasi_pbo"; //url database String user="root"; //user database String pass=""; //password database DriverManager.registerDriver(new com.mysql.jdbc.Driver()); mysqlconfig=DriverManager.getConnection(url, user, pass); } catch (Exception e) { System.err.println("koneksi gagal "+e.getMessage()); //perintah menampilkan error pada koneksi } return mysqlconfig; } } 4. MENERAPKAN INSERT DATA KODING 1 ======================== import java.sql.Connection; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; KODING 2 ================================ //insert try { String sql = "INSERT INTO mahasiswa VALUES ('"+txt_npm.getText()+"','"+txt_nama.getText()+"','"+txt_prodi.getSelectedItem()+"','"+txt_semester.getText()+"','"+txt_angkatan.getText()+"')"; java.sql.Connection conn=(Connection)config.configDB(); java.sql.PreparedStatement pst=conn.prepareStatement(sql); pst.execute(); JOptionPane.showMessageDialog(null, "Penyimpanan Data Berhasil"); } catch (Exception e) { JOptionPane.showMessageDialog(this, e.getMessage()); } // load_tabel(); // kosong(); //insert