Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- * Click nbfs://nbhost/SystemFileSystem/Templates/Licenses/license-default.txt to change this license
- * Click nbfs://nbhost/SystemFileSystem/Templates/GUIForms/JFrame.java to edit this template
- */
- package akademik;
- /**
- *
- * @author ENAK
- */
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import javax.swing.JOptionPane;
- import javax.swing.table.DefaultTableModel;
- //import java.swing.table.DefaultTableModel
- public class FormMahasiswa extends javax.swing.JFrame {
- /**
- * Creates new form FormMahasiswa
- */
- Connection conn;
- DefaultTableModel model;
- String jk,ini_prodi;
- private void koneksi(){
- conn = null;
- try{
- Class.forName("com.mysql.cj.jdbc.Driver");
- conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/akademik?zeroDateTimeBehavior=CONVERT_TO_NULL","root","");
- } catch(Exception e){
- System.out.println("Gagal Melakukan Koneksi : "+e.getMessage());
- }
- }
- private void kosongkan_form(){
- txtNrp.setEditable(true);
- txtNrp.requestFocus();
- txtNrp.setText(null);
- txtNama.setText(null);
- buttonGroup1.clearSelection();
- prodi.setSelectedItem(this);
- txtAlamat.setText(null);
- }
- private void tampil_data(){
- model = new DefaultTableModel();
- model.addColumn("NRP");
- model.addColumn("Nama Mahasiswa");
- model.addColumn("Jenis Kelamin");
- model.addColumn("Program Studi");
- model.addColumn("Alamat");
- try{
- PreparedStatement pre= conn.prepareStatement("SELECT * FROM mahasiswa");
- ResultSet res = pre.executeQuery();
- while(res.next()){
- model.addRow(new Object[]{res.getString(1),res.getString(2),res.getString(3),res.getString(4),res.getString(5)});
- }
- tabelMahasiswa.setModel(model);
- } catch(SQLException e){
- System.out.println("Gagal Memanggil Database : "+e.getMessage());
- }
- }
- public FormMahasiswa() {
- initComponents();
- koneksi();
- kosongkan_form();
- tampil_data();
- }
- /**
- * 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() {
- buttonGroup1 = new javax.swing.ButtonGroup();
- jLabel1 = new javax.swing.JLabel();
- jLabel2 = new javax.swing.JLabel();
- jLabel3 = new javax.swing.JLabel();
- jLabel4 = new javax.swing.JLabel();
- jLabel5 = new javax.swing.JLabel();
- txtNrp = new javax.swing.JTextField();
- txtNama = new javax.swing.JTextField();
- txtAlamat = new javax.swing.JTextField();
- lakilaki = new javax.swing.JRadioButton();
- perempuan = new javax.swing.JRadioButton();
- prodi = new javax.swing.JComboBox<>();
- jScrollPane1 = new javax.swing.JScrollPane();
- tabelMahasiswa = new javax.swing.JTable();
- btnSimpan = new javax.swing.JButton();
- btnUbah = new javax.swing.JButton();
- btnHapus = new javax.swing.JButton();
- btnBatal = new javax.swing.JButton();
- btnTutup = new javax.swing.JButton();
- jLabel6 = new javax.swing.JLabel();
- setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
- jLabel1.setFont(new java.awt.Font("Times New Roman", 1, 12)); // NOI18N
- jLabel1.setText("NRP");
- jLabel2.setFont(new java.awt.Font("Times New Roman", 1, 12)); // NOI18N
- jLabel2.setText("Nama");
- jLabel3.setFont(new java.awt.Font("Times New Roman", 1, 12)); // NOI18N
- jLabel3.setText("Jenis Kelamin");
- jLabel4.setFont(new java.awt.Font("Times New Roman", 1, 12)); // NOI18N
- jLabel4.setText("Program Studi");
- jLabel5.setFont(new java.awt.Font("Times New Roman", 1, 12)); // NOI18N
- jLabel5.setText("Alamat");
- buttonGroup1.add(lakilaki);
- lakilaki.setText("Laki-laki");
- buttonGroup1.add(perempuan);
- perempuan.setText("Perempuan");
- prodi.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "Teknik Informatika", "Manajement Informatika", "Komputer Akutansi", "Sistem Informasi" }));
- tabelMahasiswa.setModel(new javax.swing.table.DefaultTableModel(
- new Object [][] {
- {null, null, null, null},
- {null, null, null, null},
- {null, null, null, null},
- {null, null, null, null}
- },
- new String [] {
- "Title 1", "Title 2", "Title 3", "Title 4"
- }
- ));
- tabelMahasiswa.addMouseListener(new java.awt.event.MouseAdapter() {
- public void mouseClicked(java.awt.event.MouseEvent evt) {
- tabelMahasiswaMouseClicked(evt);
- }
- });
- jScrollPane1.setViewportView(tabelMahasiswa);
- btnSimpan.setFont(new java.awt.Font("Times New Roman", 1, 12)); // NOI18N
- btnSimpan.setText("SIMPAN");
- btnSimpan.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- btnSimpanActionPerformed(evt);
- }
- });
- btnUbah.setFont(new java.awt.Font("Times New Roman", 1, 12)); // NOI18N
- btnUbah.setText("UBAH");
- btnUbah.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- btnUbahActionPerformed(evt);
- }
- });
- btnHapus.setFont(new java.awt.Font("Times New Roman", 1, 12)); // NOI18N
- btnHapus.setText("HAPUS");
- btnHapus.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- btnHapusActionPerformed(evt);
- }
- });
- btnBatal.setFont(new java.awt.Font("Times New Roman", 1, 12)); // NOI18N
- btnBatal.setText("BATAL");
- btnBatal.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- btnBatalActionPerformed(evt);
- }
- });
- btnTutup.setFont(new java.awt.Font("Times New Roman", 1, 12)); // NOI18N
- btnTutup.setText("TUTUP");
- btnTutup.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- btnTutupActionPerformed(evt);
- }
- });
- jLabel6.setFont(new java.awt.Font("Times New Roman", 1, 18)); // NOI18N
- jLabel6.setText("FORM DATA MAHASISWA");
- 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(51, 51, 51)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 557, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addGroup(layout.createSequentialGroup()
- .addComponent(btnSimpan, javax.swing.GroupLayout.PREFERRED_SIZE, 87, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addGap(18, 18, 18)
- .addComponent(btnUbah, javax.swing.GroupLayout.PREFERRED_SIZE, 87, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addGap(18, 18, 18)
- .addComponent(btnHapus, javax.swing.GroupLayout.PREFERRED_SIZE, 87, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addGap(18, 18, 18)
- .addComponent(btnBatal, javax.swing.GroupLayout.PREFERRED_SIZE, 87, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addGap(18, 18, 18)
- .addComponent(btnTutup, javax.swing.GroupLayout.PREFERRED_SIZE, 87, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addGroup(layout.createSequentialGroup()
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(jLabel1)
- .addComponent(jLabel2)
- .addComponent(jLabel3)
- .addComponent(jLabel4)
- .addComponent(jLabel5))
- .addGap(132, 132, 132)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(txtAlamat, javax.swing.GroupLayout.PREFERRED_SIZE, 220, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(txtNama, javax.swing.GroupLayout.PREFERRED_SIZE, 220, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(txtNrp, javax.swing.GroupLayout.PREFERRED_SIZE, 220, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addGroup(layout.createSequentialGroup()
- .addGap(4, 4, 4)
- .addComponent(lakilaki)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addComponent(perempuan))
- .addComponent(prodi, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
- .addGroup(layout.createSequentialGroup()
- .addGap(149, 149, 149)
- .addComponent(jLabel6)))
- .addContainerGap(47, Short.MAX_VALUE))
- );
- layout.setVerticalGroup(
- layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(layout.createSequentialGroup()
- .addContainerGap()
- .addComponent(jLabel6)
- .addGap(54, 54, 54)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
- .addGroup(layout.createSequentialGroup()
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(jLabel1)
- .addComponent(txtNrp, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addGap(21, 21, 21)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(jLabel2)
- .addComponent(txtNama, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addGap(22, 22, 22)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(jLabel3)
- .addComponent(lakilaki)))
- .addComponent(perempuan))
- .addGap(19, 19, 19)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(jLabel4)
- .addComponent(prodi, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addGap(31, 31, 31)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(jLabel5)
- .addComponent(txtAlamat, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 13, Short.MAX_VALUE)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(btnSimpan, javax.swing.GroupLayout.PREFERRED_SIZE, 36, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(btnUbah, javax.swing.GroupLayout.PREFERRED_SIZE, 36, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(btnHapus, javax.swing.GroupLayout.PREFERRED_SIZE, 36, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(btnBatal, javax.swing.GroupLayout.PREFERRED_SIZE, 36, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(btnTutup, javax.swing.GroupLayout.PREFERRED_SIZE, 36, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addGap(18, 18, 18)
- .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 375, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addContainerGap())
- );
- pack();
- }// </editor-fold>
- private void btnTutupActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- System.exit(0);
- }
- private void btnSimpanActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- try{
- PreparedStatement pre = conn.prepareStatement("INSERT INTO mahasiswa VALUE(?,?,?,?,?)");
- pre.setString(1, txtNrp.getText());
- pre.setString(2, txtNama.getText());
- if(lakilaki.isSelected()){
- jk = "L";
- }
- if(perempuan.isSelected()){
- jk = "P";
- }
- pre.setString(3,jk);
- ini_prodi = prodi.getSelectedItem().toString();
- pre.setString(4, ini_prodi);
- pre.setString(5, txtAlamat.getText());
- pre.executeUpdate();
- JOptionPane.showMessageDialog(null,"Data Berhasil Disimpan");
- tampil_data();
- kosongkan_form();
- }catch(Exception e){
- System.out.println("Data Gagal Disimpan : "+e.getMessage());
- }
- }
- private void tabelMahasiswaMouseClicked(java.awt.event.MouseEvent evt) {
- // TODO add your handling code here:
- txtNrp.setEditable(false);
- int i = tabelMahasiswa.getSelectedRow();
- txtNrp.setText(model.getValueAt(i, 0).toString());
- txtNama.setText(model.getValueAt(i, 1).toString());
- String pilihJK = model.getValueAt(i, 2).toString();
- if(pilihJK.equals("L")){
- lakilaki.setSelected(true);
- } else {
- perempuan.setSelected(true);
- }
- String pilihProdi = model.getValueAt(i, 3).toString();
- switch(pilihProdi){
- case "Teknik Informatika":
- prodi.setSelectedIndex(0);
- break;
- case "Manajemen Informatika":
- prodi.setSelectedIndex(1);
- break;
- case "Komputer Akutansi":
- prodi.setSelectedIndex(2);
- break;
- case "Sistem Informasi":
- prodi.setSelectedIndex(3);
- break;
- }
- txtAlamat.setText(model.getValueAt(i, 4).toString());
- }
- private void btnUbahActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- try{
- PreparedStatement pre = conn.prepareStatement("UPDATE mahasiswa SET nama=?, jk=?, prodi=?, alamat=? WHERE nrp=?");
- pre.setString(1, txtNama.getText());
- if(lakilaki.isSelected()){
- jk = "L";
- }
- if(perempuan.isSelected()){
- jk = "P";
- }
- pre.setString(2,jk);
- ini_prodi = prodi.getSelectedItem().toString();
- pre.setString(3, ini_prodi);
- pre.setString(4, txtAlamat.getText());
- pre.setString(5, txtNrp.getText());
- pre.executeUpdate();
- JOptionPane.showMessageDialog(null,"Data Berhasil Diubah");
- tampil_data();
- kosongkan_form();
- }catch(Exception e){
- System.out.println("Data Gagal Diubah : "+e.getMessage());
- }
- }
- private void btnHapusActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- try{
- PreparedStatement pre = conn.prepareStatement("DELETE from mahasiswa WHERE nrp=?");
- pre.setString(1, txtNrp.getText());
- pre.executeUpdate();
- JOptionPane.showMessageDialog(null,"Data Berhasil Dihapus");
- tampil_data();
- kosongkan_form();
- }catch(Exception e){
- System.out.println("Data Gagal Dihapus : "+e.getMessage());
- }
- }
- private void btnBatalActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- kosongkan_form();
- }
- /**
- * @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(FormMahasiswa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (InstantiationException ex) {
- java.util.logging.Logger.getLogger(FormMahasiswa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (IllegalAccessException ex) {
- java.util.logging.Logger.getLogger(FormMahasiswa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (javax.swing.UnsupportedLookAndFeelException ex) {
- java.util.logging.Logger.getLogger(FormMahasiswa.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 FormMahasiswa().setVisible(true);
- }
- });
- }
- // Variables declaration - do not modify
- private javax.swing.JButton btnBatal;
- private javax.swing.JButton btnHapus;
- private javax.swing.JButton btnSimpan;
- private javax.swing.JButton btnTutup;
- private javax.swing.JButton btnUbah;
- private javax.swing.ButtonGroup buttonGroup1;
- 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.JScrollPane jScrollPane1;
- private javax.swing.JRadioButton lakilaki;
- private javax.swing.JRadioButton perempuan;
- private javax.swing.JComboBox<String> prodi;
- private javax.swing.JTable tabelMahasiswa;
- private javax.swing.JTextField txtAlamat;
- private javax.swing.JTextField txtNama;
- private javax.swing.JTextField txtNrp;
- // End of variables declaration
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement