Cara Membuat Aplikasi Form Input Nilai Mahasiswa Yg Menampilkan Grafik Menggunakan Netbeans

Halo Guys kali ini saya akan menjelaskan cara membuat aplikasi form input nilai mahasiswa yg menampilkan grafik menggunakan Netbeans.

1. Buka Xampp, kemudian hidupkan Apache dan MySql

2.) Bukalah halaman : localhost/phpmyadmin Pada browser, tidak perlu menggunakan koneksi internet.

3.) Buat Database baru dengan nama "ProjectUAS" dan klik create, kemudian buat tabel "nilai_mhs" didalam database grafik dengan 3 columns, klik go.

4.) Sebelumnya, input isi columns sesuai kebutuhan dan NIM indexnya menjadi primary dan klik save.

5.) kemudian buat lagi tabel "data_mhs" didalam database grafik dengan 3 columns, klik go , Lalu input kembali isi columns sesuai kebutuhan dan NIM indexnya menjadi primary dan klik save.

6.) Buka NetBeans, dan buat projek baru dengan nama "RIVALDHAJI", dan finish.

7.) Buatlah JFrameFrom dengan nama classnya "Nilai_MAHASISWA" seperti dibawah ini, dan finish.

8.) Desain sebagai berikut.

9.) Masukan Source Code pada masing fungsi (Button)

/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package rivaldhaji; import java.awt.Dimension; import java.awt.Toolkit; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; /** * * @author hp */ public class Nilai_Mahasiswa extends javax.swing.JFrame { private Connection con_RIVALDHAJI; private Statement stat_RIVALDHAJI; private ResultSet res_RIVALDHAJI; private String t_RIVALDHAJI; private DefaultTableModel dtm_RIVALDHAJI; ResultSet rs_RIVALDHAJI; String sql_RIVALDHAJI; /** * Creates new form Nilai_Mahasiswa */ public Nilai_Mahasiswa() { initComponents(); koneksi_RIVALDHAJI(); kosongkan_RIVALDHAJI(); tabel_RIVALDHAJI(); kosongkan1_RIVALDHAJI(); tabel1_RIVALDHAJI(); //membuat layout tampil di tengah pada saat ditampilkan Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize(); Dimension frameSize = getSize(); setLocation( (screenSize.width - frameSize.width) / 2, (screenSize.height - frameSize.height) / 2); } private void koneksi_RIVALDHAJI(){ try { Class.forName("com.mysql.jdbc.Driver"); con_RIVALDHAJI=DriverManager.getConnection("jdbc:mysql://localhost/projectuas", "root", ""); stat_RIVALDHAJI=con_RIVALDHAJI.createStatement(); } catch (Exception e) { JOptionPane.showMessageDialog(null,"koneksi gagal" +e); } } private void kosongkan_RIVALDHAJI(){ jTextField1_RIVALDHAJI.setText(""); jTextField2_RIVALDHAJI.setText(""); jTextField3_RIVALDHAJI.setText(""); } private void kosongkan1_RIVALDHAJI(){ nim_RIVALDHAJI.setText(""); nama_RIVALDHAJI.setText(""); jComboBox1.setSelectedIndex(0); } private void tabel1_RIVALDHAJI(){ DefaultTableModel t_RIVALDHAJI= new DefaultTableModel(); t_RIVALDHAJI.addColumn("NIM"); t_RIVALDHAJI.addColumn("Nilai Semester Ganjil"); t_RIVALDHAJI.addColumn("Nilai Semester Genap"); jTable1_RIVALDHAJI.setModel(t_RIVALDHAJI); try{ res_RIVALDHAJI=stat_RIVALDHAJI.executeQuery("select * from data_mhs"); while (res_RIVALDHAJI.next()) { t_RIVALDHAJI.addRow(new Object[]{ res_RIVALDHAJI.getString("NIM"), res_RIVALDHAJI.getString("Nilai Semester Ganjil"), res_RIVALDHAJI.getString("Nilai Semester Genap"), }); } }catch (Exception e) { JOptionPane.showMessageDialog(rootPane, e); } } private void tabel_RIVALDHAJI(){ DefaultTableModel t_RIVALDHAJI= new DefaultTableModel(); t_RIVALDHAJI.addColumn("NIM"); t_RIVALDHAJI.addColumn("Nama"); t_RIVALDHAJI.addColumn("Jurusan"); tabel_RIVALDHAJI.setModel(t_RIVALDHAJI); try{ res_RIVALDHAJI=stat_RIVALDHAJI.executeQuery("select * from nilai_mhs"); while (res_RIVALDHAJI.next()) { t_RIVALDHAJI.addRow(new Object[]{ res_RIVALDHAJI.getString("NIM"), res_RIVALDHAJI.getString("Nama"), res_RIVALDHAJI.getString("Jurusan"), }); } }catch (Exception e) { JOptionPane.showMessageDialog(rootPane, e); } } /** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() { jLabel1 = new javax.swing.JLabel(); jLabel2 = new javax.swing.JLabel(); jLabel3 = new javax.swing.JLabel(); jLabel4 = new javax.swing.JLabel(); jComboBox1 = new javax.swing.JComboBox<>(); nim_RIVALDHAJI = new javax.swing.JTextField(); nama_RIVALDHAJI = new javax.swing.JTextField(); save_RIVALDHAJI = new javax.swing.JButton(); clear_RIVALDHAJI = new javax.swing.JButton(); jScrollPane1 = new javax.swing.JScrollPane(); tabel_RIVALDHAJI = new javax.swing.JTable(); tampil_RIVALDHAJI = new javax.swing.JButton(); hapus_RIVALDHAJI = new javax.swing.JButton(); jTextField1_RIVALDHAJI = new javax.swing.JTextField(); jTextField2_RIVALDHAJI = new javax.swing.JTextField(); jButton1_RIVALDHAJI = new javax.swing.JButton(); jButton5_RIVALDHAJI = new javax.swing.JButton(); jScrollPane2 = new javax.swing.JScrollPane(); jTable1_RIVALDHAJI = new javax.swing.JTable(); jButton2_RIVALDHAJI = new javax.swing.JButton(); jLabel5 = new javax.swing.JLabel(); jButton4_RIVALDHAJI = new javax.swing.JButton(); jLabel6 = new javax.swing.JLabel(); jLabel7 = new javax.swing.JLabel(); jTextField3_RIVALDHAJI = new javax.swing.JTextField(); jButton3_RIVALDHAJI = new javax.swing.JButton(); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); setBackground(new java.awt.Color(51, 204, 255)); jLabel1.setFont(new java.awt.Font("Times New Roman", 1, 24)); // NOI18N jLabel1.setText("NILAI MAHASISWA"); jLabel2.setText("NIM"); jLabel3.setText("Nama"); jLabel4.setText("Jurusan"); jComboBox1.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "Teknik Informatika", "Teknik Kimia", "Teknik Industri", "Sastra Indonesia", "Sastra Jepang", "Sastra Inggris", " " })); nim_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { nim_RIVALDHAJIActionPerformed(evt); } }); save_RIVALDHAJI.setText("Save"); save_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { save_RIVALDHAJIActionPerformed(evt); } }); clear_RIVALDHAJI.setText("Clear"); clear_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { clear_RIVALDHAJIActionPerformed(evt); } }); tabel_RIVALDHAJI.setModel(new javax.swing.table.DefaultTableModel( new Object [][] { {null, null, null}, {null, null, null}, {null, null, null}, {null, null, null} }, new String [] { "Title 1", "Title 2", "Title 3" } )); tabel_RIVALDHAJI.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { tabel_RIVALDHAJIMouseClicked(evt); } }); jScrollPane1.setViewportView(tabel_RIVALDHAJI); tampil_RIVALDHAJI.setText("View"); tampil_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { tampil_RIVALDHAJIActionPerformed(evt); } }); hapus_RIVALDHAJI.setText("Delete"); hapus_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { hapus_RIVALDHAJIActionPerformed(evt); } }); jButton1_RIVALDHAJI.setText("Save"); jButton1_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1_RIVALDHAJIActionPerformed(evt); } }); jButton5_RIVALDHAJI.setText("Clear"); jButton5_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton5_RIVALDHAJIActionPerformed(evt); } }); jTable1_RIVALDHAJI.setModel(new javax.swing.table.DefaultTableModel( new Object [][] { {null, null, null}, {null, null, null}, {null, null, null}, {null, null, null} }, new String [] { "Title 1", "Title 2", "Title 3" } )); jTable1_RIVALDHAJI.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { jTable1_RIVALDHAJIMouseClicked(evt); } }); jScrollPane2.setViewportView(jTable1_RIVALDHAJI); jButton2_RIVALDHAJI.setText("View"); jButton2_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton2_RIVALDHAJIActionPerformed(evt); } }); jLabel5.setText("NIM"); jButton4_RIVALDHAJI.setText("Delete"); jButton4_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton4_RIVALDHAJIActionPerformed(evt); } }); jLabel6.setText("Nilai Semester Ganjil"); jLabel7.setText("Nilai Semester Genap"); jButton3_RIVALDHAJI.setText("Grafik"); jButton3_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton3_RIVALDHAJIActionPerformed(evt); } }); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(425, 425, 425) .addComponent(jLabel1) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addGroup(layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(28, 28, 28) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addGroup(layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel4) .addComponent(jLabel2) .addComponent(jLabel3)) .addGap(69, 69, 69) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(nim_RIVALDHAJI) .addComponent(nama_RIVALDHAJI, javax.swing.GroupLayout.DEFAULT_SIZE, 130, Short.MAX_VALUE))) .addGroup(layout.createSequentialGroup() .addComponent(save_RIVALDHAJI) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(clear_RIVALDHAJI)))) .addGroup(layout.createSequentialGroup() .addContainerGap() .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(layout.createSequentialGroup() .addGap(29, 29, 29) .addComponent(tampil_RIVALDHAJI) .addGap(72, 72, 72) .addComponent(hapus_RIVALDHAJI))) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 144, Short.MAX_VALUE) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(layout.createSequentialGroup() .addGap(25, 25, 25) .addComponent(jButton2_RIVALDHAJI) .addGap(72, 72, 72) .addComponent(jButton4_RIVALDHAJI)) .addGroup(layout.createSequentialGroup() .addGap(24, 24, 24) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel7) .addComponent(jLabel5) .addComponent(jLabel6) .addGroup(layout.createSequentialGroup() .addComponent(jButton1_RIVALDHAJI) .addGap(26, 26, 26) .addComponent(jButton5_RIVALDHAJI))) .addGap(23, 23, 23) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(7, 7, 7) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jTextField1_RIVALDHAJI) .addComponent(jTextField2_RIVALDHAJI) .addComponent(jTextField3_RIVALDHAJI, javax.swing.GroupLayout.DEFAULT_SIZE, 110, Short.MAX_VALUE))) .addComponent(jButton3_RIVALDHAJI)))) .addGap(58, 58, 58)) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addContainerGap() .addComponent(jLabel1) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(18, 18, 18) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel2) .addComponent(nim_RIVALDHAJI, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(20, 20, 20) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel3) .addComponent(nama_RIVALDHAJI, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(27, 27, 27) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel4) .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(37, 37, 37) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(save_RIVALDHAJI) .addComponent(clear_RIVALDHAJI)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 140, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(tampil_RIVALDHAJI) .addComponent(hapus_RIVALDHAJI))) .addGroup(layout.createSequentialGroup() .addGap(26, 26, 26) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jTextField1_RIVALDHAJI, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel5)) .addGap(20, 20, 20) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jTextField2_RIVALDHAJI, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel6)) .addGap(27, 27, 27) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel7) .addComponent(jTextField3_RIVALDHAJI, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(37, 37, 37) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jButton1_RIVALDHAJI) .addComponent(jButton5_RIVALDHAJI) .addComponent(jButton3_RIVALDHAJI)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 140, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jButton2_RIVALDHAJI) .addComponent(jButton4_RIVALDHAJI)))) .addContainerGap(41, Short.MAX_VALUE)) ); pack(); }// </editor-fold> private void hapus_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: try { stat_RIVALDHAJI.executeUpdate("delete from data_mhs where " + "NIM='"+nim_RIVALDHAJI.getText() +"'" ); kosongkan1_RIVALDHAJI(); JOptionPane.showMessageDialog(null, "Berhasil"); } catch (Exception e) { JOptionPane.showMessageDialog(null, "pesan salah : "+e); } } private void jButton4_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: try { stat_RIVALDHAJI.executeUpdate("delete from nilai_mhs where " + "NIM='"+jTextField1_RIVALDHAJI.getText() +"'" ); kosongkan_RIVALDHAJI(); JOptionPane.showMessageDialog(null, "Berhasil"); } catch (Exception e) { JOptionPane.showMessageDialog(null, "pesan salah : "+e); } } private void clear_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: kosongkan1_RIVALDHAJI(); } private void nim_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: } private void save_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: try { String a; a = nim_RIVALDHAJI.getText(); jTextField1_RIVALDHAJI.setText(a); int s=0; koneksi_RIVALDHAJI(); String cs=""; s=jComboBox1.getSelectedIndex(); if(s==0) { cs="Teknik Informatika"; } else if(s==1) { cs="Teknik Kimia"; } else if(s==2) { cs="Teknik Industri"; } else if(s==3) { cs="Sastra Indonesia"; } else if(s==4) { cs="Sastra Jepang"; } else { cs="Sastra Inggris"; } stat_RIVALDHAJI.executeUpdate("insert into data_mhs values (" + "'" + nim_RIVALDHAJI.getText()+"'," + "'" + nama_RIVALDHAJI.getText()+ "',"+"'"+cs+"')"); kosongkan1_RIVALDHAJI(); JOptionPane.showMessageDialog(null, "Berhasil Menyimpan Data"); } catch (Exception e) { JOptionPane.showMessageDialog(null, "Perintah Salah : "+e); } } private void jButton5_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: kosongkan1_RIVALDHAJI(); } private void jButton1_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: try { stat_RIVALDHAJI.executeUpdate("insert into nilai_mhs values (" + "'" + jTextField1_RIVALDHAJI.getText()+"'," + "'" + jTextField2_RIVALDHAJI.getText()+ "'," + "'" + jTextField3_RIVALDHAJI.getText()+ "')"); kosongkan_RIVALDHAJI(); JOptionPane.showMessageDialog(null, "Berhasil Menyimpan Data"); } catch (Exception e) { JOptionPane.showMessageDialog(null, "Perintah Salah : "+e); } } private void jButton3_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: RIVALDHAJI obj1_RIVALDHAJI = new RIVALDHAJI(); obj1_RIVALDHAJI.setNilai(jTextField2_RIVALDHAJI.getText(),jTextField3_RIVALDHAJI.getText()); obj1_RIVALDHAJI.setVisible(true); dispose(); } private void tampil_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: try{ Object [] rows={"NIM","Nama","Jurusan"}; dtm_RIVALDHAJI=new DefaultTableModel(null,rows); tabel_RIVALDHAJI.setModel(dtm_RIVALDHAJI); tabel_RIVALDHAJI.setBorder(null); jScrollPane2.setVisible(true); jScrollPane2.setViewportView(tabel_RIVALDHAJI); int no = 1; String nim="",nama="",jrs="";try{String sql="select * from data_mhs";Statement st=con_RIVALDHAJI.createStatement();ResultSet rs=st.executeQuery(sql); while(rs.next()){nim=rs.getString("NIM");nama=rs.getString("Nama");jrs=rs.getString("Jurusan"); String [] tampil={""+nim,nama,jrs};dtm_RIVALDHAJI.addRow(tampil); } }catch(SQLException e){e.printStackTrace(); JOptionPane.showMessageDialog(null,"Query Salah "+e); } }catch(Exception e){e.printStackTrace(); } } private void jButton2_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: try{ Object [] rows={"NIM","Nilai Semester Ganjil","Nilai Semester Genap"}; dtm_RIVALDHAJI=new DefaultTableModel(null,rows); jTable1_RIVALDHAJI.setModel(dtm_RIVALDHAJI); jTable1_RIVALDHAJI.setBorder(null); jScrollPane1.setVisible(true); jScrollPane1.setViewportView(jTable1_RIVALDHAJI); int no = 1; String nim="",gnp="",gjl="";try{String sql="select * from nilai_mhs";Statement st=con_RIVALDHAJI.createStatement();ResultSet rs=st.executeQuery(sql); while(rs.next()){nim=rs.getString("NIM");gjl=rs.getString("Nilai Semester Ganjil");gnp=rs.getString("Nilai Semester Genap"); String [] tampil={""+nim,gjl,gnp};dtm_RIVALDHAJI.addRow(tampil); } }catch(SQLException e){e.printStackTrace(); JOptionPane.showMessageDialog(null,"Query Salah "+e); } }catch(Exception e){e.printStackTrace(); } } private void tabel_RIVALDHAJIMouseClicked(java.awt.event.MouseEvent evt) { // TODO add your handling code here: int i = tabel_RIVALDHAJI.getSelectedRow(); if(i==-1){ return; } String code = (String)tabel_RIVALDHAJI.getValueAt(i,0); String code1 = (String)tabel_RIVALDHAJI.getValueAt(i,1); String code2 = (String)tabel_RIVALDHAJI.getValueAt(i, 2); String code3 = (String)tabel_RIVALDHAJI.getValueAt(i, 0); nim_RIVALDHAJI.setText(code); nama_RIVALDHAJI.setText(code1); jComboBox1.setSelectedItem(code2); jTextField1_RIVALDHAJI.setText(code3); } private void jTable1_RIVALDHAJIMouseClicked(java.awt.event.MouseEvent evt) { // TODO add your handling code here: int i_RIVALDHAJI = jTable1_RIVALDHAJI.getSelectedRow(); if(i_RIVALDHAJI==-1){ return; } String code_RIVALDHAJI = (String)jTable1_RIVALDHAJI.getValueAt(i_RIVALDHAJI,0); String code1_RIVALDHAJI = (String)jTable1_RIVALDHAJI.getValueAt(i_RIVALDHAJI,1); String code2_RIVALDHAJI = (String)jTable1_RIVALDHAJI.getValueAt(i_RIVALDHAJI,2); jTextField1_RIVALDHAJI.setText(code_RIVALDHAJI); jTextField2_RIVALDHAJI.setText(code1_RIVALDHAJI); jTextField3_RIVALDHAJI.setText(code2_RIVALDHAJI); } /** * @param args the command line arguments */ public static void main(String args[]) { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) { if ("Nimbus".equals(info.getName())) { javax.swing.UIManager.setLookAndFeel(info.getClassName()); break; } } } catch (ClassNotFoundException ex) { java.util.logging.Logger.getLogger(Nilai_Mahasiswa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(Nilai_Mahasiswa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(Nilai_Mahasiswa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(Nilai_Mahasiswa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold> /* Create and display the form */ java.awt.EventQueue.invokeLater(new Runnable() { public void run() { new Nilai_Mahasiswa().setVisible(true); } }); } // Variables declaration - do not modify private javax.swing.JButton clear_RIVALDHAJI; private javax.swing.JButton hapus_RIVALDHAJI; private javax.swing.JButton jButton1_RIVALDHAJI; private javax.swing.JButton jButton2_RIVALDHAJI; private javax.swing.JButton jButton3_RIVALDHAJI; private javax.swing.JButton jButton4_RIVALDHAJI; private javax.swing.JButton jButton5_RIVALDHAJI; private javax.swing.JComboBox<string> jComboBox1; 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.JScrollPane jScrollPane1; private javax.swing.JScrollPane jScrollPane2; private javax.swing.JTable jTable1_RIVALDHAJI; private javax.swing.JTextField jTextField1_RIVALDHAJI; private javax.swing.JTextField jTextField2_RIVALDHAJI; private javax.swing.JTextField jTextField3_RIVALDHAJI; private javax.swing.JTextField nama_RIVALDHAJI; private javax.swing.JTextField nim_RIVALDHAJI; private javax.swing.JButton save_RIVALDHAJI; private javax.swing.JTable tabel_RIVALDHAJI; private javax.swing.JButton tampil_RIVALDHAJI; // End of variables declaration }

110. Masukan Source Code pada RIVALDHAJI.class

/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package rivaldhaji; import java.awt.Dimension; import java.awt.Toolkit; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; /** * * @author hp */ public class Nilai_Mahasiswa extends javax.swing.JFrame { private Connection con_RIVALDHAJI; private Statement stat_RIVALDHAJI; private ResultSet res_RIVALDHAJI; private String t_RIVALDHAJI; private DefaultTableModel dtm_RIVALDHAJI; ResultSet rs_RIVALDHAJI; String sql_RIVALDHAJI; /** * Creates new form Nilai_Mahasiswa */ public Nilai_Mahasiswa() { initComponents(); koneksi_RIVALDHAJI(); kosongkan_RIVALDHAJI(); tabel_RIVALDHAJI(); kosongkan1_RIVALDHAJI(); tabel1_RIVALDHAJI(); //membuat layout tampil di tengah pada saat ditampilkan Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize(); Dimension frameSize = getSize(); setLocation( (screenSize.width - frameSize.width) / 2, (screenSize.height - frameSize.height) / 2); } private void koneksi_RIVALDHAJI(){ try { Class.forName("com.mysql.jdbc.Driver"); con_RIVALDHAJI=DriverManager.getConnection("jdbc:mysql://localhost/projectuas", "root", ""); stat_RIVALDHAJI=con_RIVALDHAJI.createStatement(); } catch (Exception e) { JOptionPane.showMessageDialog(null,"koneksi gagal" +e); } } private void kosongkan_RIVALDHAJI(){ jTextField1_RIVALDHAJI.setText(""); jTextField2_RIVALDHAJI.setText(""); jTextField3_RIVALDHAJI.setText(""); } private void kosongkan1_RIVALDHAJI(){ nim_RIVALDHAJI.setText(""); nama_RIVALDHAJI.setText(""); jComboBox1.setSelectedIndex(0); } private void tabel1_RIVALDHAJI(){ DefaultTableModel t_RIVALDHAJI= new DefaultTableModel(); t_RIVALDHAJI.addColumn("NIM"); t_RIVALDHAJI.addColumn("Nilai Semester Ganjil"); t_RIVALDHAJI.addColumn("Nilai Semester Genap"); jTable1_RIVALDHAJI.setModel(t_RIVALDHAJI); try{ res_RIVALDHAJI=stat_RIVALDHAJI.executeQuery("select * from data_mhs"); while (res_RIVALDHAJI.next()) { t_RIVALDHAJI.addRow(new Object[]{ res_RIVALDHAJI.getString("NIM"), res_RIVALDHAJI.getString("Nilai Semester Ganjil"), res_RIVALDHAJI.getString("Nilai Semester Genap"), }); } }catch (Exception e) { JOptionPane.showMessageDialog(rootPane, e); } } private void tabel_RIVALDHAJI(){ DefaultTableModel t_RIVALDHAJI= new DefaultTableModel(); t_RIVALDHAJI.addColumn("NIM"); t_RIVALDHAJI.addColumn("Nama"); t_RIVALDHAJI.addColumn("Jurusan"); tabel_RIVALDHAJI.setModel(t_RIVALDHAJI); try{ res_RIVALDHAJI=stat_RIVALDHAJI.executeQuery("select * from nilai_mhs"); while (res_RIVALDHAJI.next()) { t_RIVALDHAJI.addRow(new Object[]{ res_RIVALDHAJI.getString("NIM"), res_RIVALDHAJI.getString("Nama"), res_RIVALDHAJI.getString("Jurusan"), }); } }catch (Exception e) { JOptionPane.showMessageDialog(rootPane, e); } } /** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() { jLabel1 = new javax.swing.JLabel(); jLabel2 = new javax.swing.JLabel(); jLabel3 = new javax.swing.JLabel(); jLabel4 = new javax.swing.JLabel(); jComboBox1 = new javax.swing.JComboBox<>(); nim_RIVALDHAJI = new javax.swing.JTextField(); nama_RIVALDHAJI = new javax.swing.JTextField(); save_RIVALDHAJI = new javax.swing.JButton(); clear_RIVALDHAJI = new javax.swing.JButton(); jScrollPane1 = new javax.swing.JScrollPane(); tabel_RIVALDHAJI = new javax.swing.JTable(); tampil_RIVALDHAJI = new javax.swing.JButton(); hapus_RIVALDHAJI = new javax.swing.JButton(); jTextField1_RIVALDHAJI = new javax.swing.JTextField(); jTextField2_RIVALDHAJI = new javax.swing.JTextField(); jButton1_RIVALDHAJI = new javax.swing.JButton(); jButton5_RIVALDHAJI = new javax.swing.JButton(); jScrollPane2 = new javax.swing.JScrollPane(); jTable1_RIVALDHAJI = new javax.swing.JTable(); jButton2_RIVALDHAJI = new javax.swing.JButton(); jLabel5 = new javax.swing.JLabel(); jButton4_RIVALDHAJI = new javax.swing.JButton(); jLabel6 = new javax.swing.JLabel(); jLabel7 = new javax.swing.JLabel(); jTextField3_RIVALDHAJI = new javax.swing.JTextField(); jButton3_RIVALDHAJI = new javax.swing.JButton(); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); setBackground(new java.awt.Color(51, 204, 255)); jLabel1.setFont(new java.awt.Font("Times New Roman", 1, 24)); // NOI18N jLabel1.setText("NILAI MAHASISWA"); jLabel2.setText("NIM"); jLabel3.setText("Nama"); jLabel4.setText("Jurusan"); jComboBox1.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "Teknik Informatika", "Teknik Kimia", "Teknik Industri", "Sastra Indonesia", "Sastra Jepang", "Sastra Inggris", " " })); nim_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { nim_RIVALDHAJIActionPerformed(evt); } }); save_RIVALDHAJI.setText("Save"); save_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { save_RIVALDHAJIActionPerformed(evt); } }); clear_RIVALDHAJI.setText("Clear"); clear_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { clear_RIVALDHAJIActionPerformed(evt); } }); tabel_RIVALDHAJI.setModel(new javax.swing.table.DefaultTableModel( new Object [][] { {null, null, null}, {null, null, null}, {null, null, null}, {null, null, null} }, new String [] { "Title 1", "Title 2", "Title 3" } )); tabel_RIVALDHAJI.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { tabel_RIVALDHAJIMouseClicked(evt); } }); jScrollPane1.setViewportView(tabel_RIVALDHAJI); tampil_RIVALDHAJI.setText("View"); tampil_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { tampil_RIVALDHAJIActionPerformed(evt); } }); hapus_RIVALDHAJI.setText("Delete"); hapus_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { hapus_RIVALDHAJIActionPerformed(evt); } }); jButton1_RIVALDHAJI.setText("Save"); jButton1_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1_RIVALDHAJIActionPerformed(evt); } }); jButton5_RIVALDHAJI.setText("Clear"); jButton5_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton5_RIVALDHAJIActionPerformed(evt); } }); jTable1_RIVALDHAJI.setModel(new javax.swing.table.DefaultTableModel( new Object [][] { {null, null, null}, {null, null, null}, {null, null, null}, {null, null, null} }, new String [] { "Title 1", "Title 2", "Title 3" } )); jTable1_RIVALDHAJI.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { jTable1_RIVALDHAJIMouseClicked(evt); } }); jScrollPane2.setViewportView(jTable1_RIVALDHAJI); jButton2_RIVALDHAJI.setText("View"); jButton2_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton2_RIVALDHAJIActionPerformed(evt); } }); jLabel5.setText("NIM"); jButton4_RIVALDHAJI.setText("Delete"); jButton4_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton4_RIVALDHAJIActionPerformed(evt); } }); jLabel6.setText("Nilai Semester Ganjil"); jLabel7.setText("Nilai Semester Genap"); jButton3_RIVALDHAJI.setText("Grafik"); jButton3_RIVALDHAJI.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton3_RIVALDHAJIActionPerformed(evt); } }); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(425, 425, 425) .addComponent(jLabel1) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addGroup(layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(28, 28, 28) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addGroup(layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel4) .addComponent(jLabel2) .addComponent(jLabel3)) .addGap(69, 69, 69) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(nim_RIVALDHAJI) .addComponent(nama_RIVALDHAJI, javax.swing.GroupLayout.DEFAULT_SIZE, 130, Short.MAX_VALUE))) .addGroup(layout.createSequentialGroup() .addComponent(save_RIVALDHAJI) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(clear_RIVALDHAJI)))) .addGroup(layout.createSequentialGroup() .addContainerGap() .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(layout.createSequentialGroup() .addGap(29, 29, 29) .addComponent(tampil_RIVALDHAJI) .addGap(72, 72, 72) .addComponent(hapus_RIVALDHAJI))) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 144, Short.MAX_VALUE) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(layout.createSequentialGroup() .addGap(25, 25, 25) .addComponent(jButton2_RIVALDHAJI) .addGap(72, 72, 72) .addComponent(jButton4_RIVALDHAJI)) .addGroup(layout.createSequentialGroup() .addGap(24, 24, 24) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel7) .addComponent(jLabel5) .addComponent(jLabel6) .addGroup(layout.createSequentialGroup() .addComponent(jButton1_RIVALDHAJI) .addGap(26, 26, 26) .addComponent(jButton5_RIVALDHAJI))) .addGap(23, 23, 23) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(7, 7, 7) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jTextField1_RIVALDHAJI) .addComponent(jTextField2_RIVALDHAJI) .addComponent(jTextField3_RIVALDHAJI, javax.swing.GroupLayout.DEFAULT_SIZE, 110, Short.MAX_VALUE))) .addComponent(jButton3_RIVALDHAJI)))) .addGap(58, 58, 58)) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addContainerGap() .addComponent(jLabel1) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(18, 18, 18) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel2) .addComponent(nim_RIVALDHAJI, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(20, 20, 20) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel3) .addComponent(nama_RIVALDHAJI, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(27, 27, 27) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel4) .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(37, 37, 37) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(save_RIVALDHAJI) .addComponent(clear_RIVALDHAJI)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 140, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(tampil_RIVALDHAJI) .addComponent(hapus_RIVALDHAJI))) .addGroup(layout.createSequentialGroup() .addGap(26, 26, 26) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jTextField1_RIVALDHAJI, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel5)) .addGap(20, 20, 20) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jTextField2_RIVALDHAJI, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel6)) .addGap(27, 27, 27) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel7) .addComponent(jTextField3_RIVALDHAJI, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(37, 37, 37) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jButton1_RIVALDHAJI) .addComponent(jButton5_RIVALDHAJI) .addComponent(jButton3_RIVALDHAJI)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 140, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jButton2_RIVALDHAJI) .addComponent(jButton4_RIVALDHAJI)))) .addContainerGap(41, Short.MAX_VALUE)) ); pack(); }// </editor-fold> private void hapus_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: try { stat_RIVALDHAJI.executeUpdate("delete from data_mhs where " + "NIM='"+nim_RIVALDHAJI.getText() +"'" ); kosongkan1_RIVALDHAJI(); JOptionPane.showMessageDialog(null, "Berhasil"); } catch (Exception e) { JOptionPane.showMessageDialog(null, "pesan salah : "+e); } } private void jButton4_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: try { stat_RIVALDHAJI.executeUpdate("delete from nilai_mhs where " + "NIM='"+jTextField1_RIVALDHAJI.getText() +"'" ); kosongkan_RIVALDHAJI(); JOptionPane.showMessageDialog(null, "Berhasil"); } catch (Exception e) { JOptionPane.showMessageDialog(null, "pesan salah : "+e); } } private void clear_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: kosongkan1_RIVALDHAJI(); } private void nim_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: } private void save_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: try { String a; a = nim_RIVALDHAJI.getText(); jTextField1_RIVALDHAJI.setText(a); int s=0; koneksi_RIVALDHAJI(); String cs=""; s=jComboBox1.getSelectedIndex(); if(s==0) { cs="Teknik Informatika"; } else if(s==1) { cs="Teknik Kimia"; } else if(s==2) { cs="Teknik Industri"; } else if(s==3) { cs="Sastra Indonesia"; } else if(s==4) { cs="Sastra Jepang"; } else { cs="Sastra Inggris"; } stat_RIVALDHAJI.executeUpdate("insert into data_mhs values (" + "'" + nim_RIVALDHAJI.getText()+"'," + "'" + nama_RIVALDHAJI.getText()+ "',"+"'"+cs+"')"); kosongkan1_RIVALDHAJI(); JOptionPane.showMessageDialog(null, "Berhasil Menyimpan Data"); } catch (Exception e) { JOptionPane.showMessageDialog(null, "Perintah Salah : "+e); } } private void jButton5_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: kosongkan1_RIVALDHAJI(); } private void jButton1_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: try { stat_RIVALDHAJI.executeUpdate("insert into nilai_mhs values (" + "'" + jTextField1_RIVALDHAJI.getText()+"'," + "'" + jTextField2_RIVALDHAJI.getText()+ "'," + "'" + jTextField3_RIVALDHAJI.getText()+ "')"); kosongkan_RIVALDHAJI(); JOptionPane.showMessageDialog(null, "Berhasil Menyimpan Data"); } catch (Exception e) { JOptionPane.showMessageDialog(null, "Perintah Salah : "+e); } } private void jButton3_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: RIVALDHAJI obj1_RIVALDHAJI = new RIVALDHAJI(); obj1_RIVALDHAJI.setNilai(jTextField2_RIVALDHAJI.getText(),jTextField3_RIVALDHAJI.getText()); obj1_RIVALDHAJI.setVisible(true); dispose(); } private void tampil_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: try{ Object [] rows={"NIM","Nama","Jurusan"}; dtm_RIVALDHAJI=new DefaultTableModel(null,rows); tabel_RIVALDHAJI.setModel(dtm_RIVALDHAJI); tabel_RIVALDHAJI.setBorder(null); jScrollPane2.setVisible(true); jScrollPane2.setViewportView(tabel_RIVALDHAJI); int no = 1; String nim="",nama="",jrs="";try{String sql="select * from data_mhs";Statement st=con_RIVALDHAJI.createStatement();ResultSet rs=st.executeQuery(sql); while(rs.next()){nim=rs.getString("NIM");nama=rs.getString("Nama");jrs=rs.getString("Jurusan"); String [] tampil={""+nim,nama,jrs};dtm_RIVALDHAJI.addRow(tampil); } }catch(SQLException e){e.printStackTrace(); JOptionPane.showMessageDialog(null,"Query Salah "+e); } }catch(Exception e){e.printStackTrace(); } } private void jButton2_RIVALDHAJIActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: try{ Object [] rows={"NIM","Nilai Semester Ganjil","Nilai Semester Genap"}; dtm_RIVALDHAJI=new DefaultTableModel(null,rows); jTable1_RIVALDHAJI.setModel(dtm_RIVALDHAJI); jTable1_RIVALDHAJI.setBorder(null); jScrollPane1.setVisible(true); jScrollPane1.setViewportView(jTable1_RIVALDHAJI); int no = 1; String nim="",gnp="",gjl="";try{String sql="select * from nilai_mhs";Statement st=con_RIVALDHAJI.createStatement();ResultSet rs=st.executeQuery(sql); while(rs.next()){nim=rs.getString("NIM");gjl=rs.getString("Nilai Semester Ganjil");gnp=rs.getString("Nilai Semester Genap"); String [] tampil={""+nim,gjl,gnp};dtm_RIVALDHAJI.addRow(tampil); } }catch(SQLException e){e.printStackTrace(); JOptionPane.showMessageDialog(null,"Query Salah "+e); } }catch(Exception e){e.printStackTrace(); } } private void tabel_RIVALDHAJIMouseClicked(java.awt.event.MouseEvent evt) { // TODO add your handling code here: int i = tabel_RIVALDHAJI.getSelectedRow(); if(i==-1){ return; } String code = (String)tabel_RIVALDHAJI.getValueAt(i,0); String code1 = (String)tabel_RIVALDHAJI.getValueAt(i,1); String code2 = (String)tabel_RIVALDHAJI.getValueAt(i, 2); String code3 = (String)tabel_RIVALDHAJI.getValueAt(i, 0); nim_RIVALDHAJI.setText(code); nama_RIVALDHAJI.setText(code1); jComboBox1.setSelectedItem(code2); jTextField1_RIVALDHAJI.setText(code3); } private void jTable1_RIVALDHAJIMouseClicked(java.awt.event.MouseEvent evt) { // TODO add your handling code here: int i_RIVALDHAJI = jTable1_RIVALDHAJI.getSelectedRow(); if(i_RIVALDHAJI==-1){ return; } String code_RIVALDHAJI = (String)jTable1_RIVALDHAJI.getValueAt(i_RIVALDHAJI,0); String code1_RIVALDHAJI = (String)jTable1_RIVALDHAJI.getValueAt(i_RIVALDHAJI,1); String code2_RIVALDHAJI = (String)jTable1_RIVALDHAJI.getValueAt(i_RIVALDHAJI,2); jTextField1_RIVALDHAJI.setText(code_RIVALDHAJI); jTextField2_RIVALDHAJI.setText(code1_RIVALDHAJI); jTextField3_RIVALDHAJI.setText(code2_RIVALDHAJI); } /** * @param args the command line arguments */ public static void main(String args[]) { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) { if ("Nimbus".equals(info.getName())) { javax.swing.UIManager.setLookAndFeel(info.getClassName()); break; } } } catch (ClassNotFoundException ex) { java.util.logging.Logger.getLogger(Nilai_Mahasiswa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(Nilai_Mahasiswa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(Nilai_Mahasiswa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(Nilai_Mahasiswa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold> /* Create and display the form */ java.awt.EventQueue.invokeLater(new Runnable() { public void run() { new Nilai_Mahasiswa().setVisible(true); } }); } // Variables declaration - do not modify private javax.swing.JButton clear_RIVALDHAJI; private javax.swing.JButton hapus_RIVALDHAJI; private javax.swing.JButton jButton1_RIVALDHAJI; private javax.swing.JButton jButton2_RIVALDHAJI; private javax.swing.JButton jButton3_RIVALDHAJI; private javax.swing.JButton jButton4_RIVALDHAJI; private javax.swing.JButton jButton5_RIVALDHAJI; private javax.swing.JComboBox<string> jComboBox1; 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.JScrollPane jScrollPane1; private javax.swing.JScrollPane jScrollPane2; private javax.swing.JTable jTable1_RIVALDHAJI; private javax.swing.JTextField jTextField1_RIVALDHAJI; private javax.swing.JTextField jTextField2_RIVALDHAJI; private javax.swing.JTextField jTextField3_RIVALDHAJI; private javax.swing.JTextField nama_RIVALDHAJI; private javax.swing.JTextField nim_RIVALDHAJI; private javax.swing.JButton save_RIVALDHAJI; private javax.swing.JTable tabel_RIVALDHAJI; private javax.swing.JButton tampil_RIVALDHAJI; // End of variables declaration }

s
11. Jalankan / Run program dengan cara klik kanan pada JFrame DataInput > Run Program atau dengan menekan Shift+F6

Selesai sampai sini ya guyss semoga bermanfaat ya :D