Akses Database Menggunakan Java

import javax.swing.*; import java.awt.GridLayout; import java.awt.BorderLayout; import java.awt.event.*; import java.sql.*; import javax.swing.table.DefaultTableModel; public class sisip implements ActionListener { JLabel labelNama = new JLabel(“nama:”); JTextField fieldNama = new JTextField(10); JLabel labelNim = new JLabel(“nim:”); JTextField fieldNim = new JTextField(10); JLabel labelProdi = new JLabel(“prodi:”); JTextField fieldProdi = new JTextField(10); JLabel labelAlamat = new JLabel(“alamat:”); JTextField fieldAlamat = new JTextField(10); JLabel labelKota = new JLabel(“kota:”); JTextField fieldKota = new JTextField(10); JButton tombolSimpan = new JButton(“simpan”); JButton tombolBatal = new JButton(“batal”); JPanel panelSemua = new JPanel(); JPanel panelAtas = new JPanel(); JPanel panelCenter = new JPanel(); JScrollPane scrollPane = new JScrollPane(); JTable tabel = new JTable(); DefaultTableModel tabMode; Connection koneksi; sisip(){ BorderLayout bl = new BorderLayout(); panelSemua.setLayout(bl); GridLayout gl1 = new GridLayout(6,2); panelAtas.setLayout(gl1); panelAtas.add(labelNim); panelAtas.add(fieldNim); panelAtas.add(labelNama); panelAtas.add(fieldNama); panelAtas.add(labelProdi); panelAtas.add(fieldProdi); panelAtas.add(labelAlamat); panelAtas.add(fieldAlamat); panelAtas.add(labelKota); panelAtas.add(fieldKota); panelAtas.add(tombolSimpan); panelAtas.add(tombolBatal); panelSemua.add(“North”, panelAtas); Object[] row = {“NIM”, “Nama”, “Prodi”, “Alamat”, “Kota”}; tabMode = new DefaultTableModel(null, row); tabel.setModel(tabMode); scrollPane.getViewport().add(tabel, null); panelSemua.add(“Center”, scrollPane); koneksiDatabase(); tampilDataKeTabel(); tombolSimpan.addActionListener(this); tombolBatal.addActionListener(this); JFrame frame = new JFrame(“input data”); frame.setContentPane(panelSemua); frame.setSize(400,250); frame.setVisible(true); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); frame.setResizable(true); } public void actionPerformed(ActionEvent kejadian) { try { if(kejadian.getSource()==tombolSimpan) { String nama = fieldNama.getText(); String nim = fieldNim.getText(); String prodi = fieldProdi.getText(); String alamat = fieldAlamat.getText(); String kota = fieldKota.getText(); //Class.forName(“com.mysql.jdbc.Driver”); //System.out.println(“driver JDBC ditemukan…”); //String url = “jdbc:mysql://localhost:3306/dbmahasiswa?user=root&password=t3l0g0dh0g”; //Connection koneksi = DriverManager.getConnection(“jdbc:mysql://localhost:3306/dbmahasiswa”, //                                                 “root”,”t3l0g0dh0g”); //System.out.println(“koneksi sukses…”); koneksiDatabase(); Statement perintah = koneksi.createStatement(); String sql = “INSERT INTO mahasiswa VALUES (‘”+nim+”‘,’”+nama+”‘,’”+prodi+”‘,’”+alamat+”‘,’”+kota+”‘);”; perintah.executeUpdate(sql); fieldNama.setText(“”); fieldNim.setText(“”); fieldProdi.setText(“”); fieldAlamat.setText(“”); fieldKota.setText(“”); //perintah.close(); //koneksi.close(); JOptionPane.showMessageDialog(panelSemua, “data sukses tersimpan…”); //hapusTabel(); tampilDataKeTabel(); } } catch(Exception e) { System.out.println(“terjadi error…”); } if(kejadian.getSource()==tombolBatal){ fieldNama.setText(“”); fieldNim.setText(“”); fieldProdi.setText(“”); fieldAlamat.setText(“”); fieldKota.setText(“”); } } public void koneksiDatabase() { try { Class.forName(“com.mysql.jdbc.Driver”); System.out.println(“JDBC ditemukan…”); try { String url = “jdbc:mysql://localhost:3306/dbmahasiswa?user=root&password=t3l0g0dh0g”; koneksi = DriverManager.getConnection(url); System.out.println(“koneksi sukses…”); } catch (SQLException se) { System.out.println(“koneksi gagal = ” + se); System.exit(0); } } catch (ClassNotFoundException cnfe) { System.out.println(“class tidak ditemukan… error: ” + cnfe); System.exit(0); } } public void tampilDataKeTabel() { hapusTabel(); try { String sql = “SELECT * FROM mahasiswa”; Statement stat = koneksi.createStatement(); ResultSet set = stat.executeQuery(sql); while(set.next()) { String nim = set.getString(“nim”); String nama = set.getString(“nama”); String prodi = set.getString(“prodi”); String alamat = set.getString(“alamat”); String kota = set.getString(“kota”); String[] data = {nim, nama, prodi, alamat, kota}; tabMode.addRow(data); } } catch (Exception e) { } } public void hapusTabel() { int row = tabMode.getRowCount(); for(int i=0; i<row; i++) { tabMode.removeRow(0); } } public static void main(String[] args) { sisip insertRecord = new sisip(); } }

 

Output Program :

Setelah Disisipkan record baru

Artikel Terkait: