CARA MEMBUAT APLIKASI DATA MAHASISWA
Selamat malam dengan saya Safriadi Manalu ,Saya kuliah di STMIK ERESHA, Disini Saya Sharing Mengenai cara membuat aplikasi data mahasiswa untuk memenuhi tugas uas pemograman 2
1.Deskripsi program
dengan adanya program ini dapat memudahkan pendataan mahasiswa ,dan mencari data mahasiswa dengan cepat dan efisien
NETBEANS
Langkah pertama membuat project baru dengan database yang diberi nama data mahasiswa
di utama ada ada login untuk untuk mengakses data mahasiswa
di Tambah mahasiswa menginput data mahasiswa yang baru
di menu cari mahasiswa kita menginput data mahasiswa yang ingin dicari
di menu edit mahasiswa disini kita bisa merubah data mahasiswa jika terjadi kesalahan dalam proses input sebelumnya
di menu tambah jurusan ini kita dapat menambahkan jurusan yang baru yang telah tersedia
demikian programnya, jika ada kekurangan saya minta maaf,
berikut source codenya
/*
* 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 Manalu;
import java.sql.*;
import java.util.Calendar;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
/**
*
* @author Manalu
*/
public class utama extends javax.swing.JFrame {
static Connection konesi = null;
static Statement st = null;
static Statement st2 = null;
static DatabaseMetaData metadata = null;
static ResultSet hasil = null;
static ResultSet hasil2 = null;
static String jalur = "jdbc:mysql://localhost/Manalu";
static String user = "root";
static String password = "";
static Calendar sekarang = Calendar.getInstance();
static int tahun;
int hapus = 3;
/**
* Creates new form utama
*/
public utama() {
initComponents();
setTitle("Data Mahasiswa -Manalu");
}
/**
* 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() {
jenis = new javax.swing.ButtonGroup();
jenis2 = new javax.swing.ButtonGroup();
jenis3 = new javax.swing.ButtonGroup();
jLabel35 = new javax.swing.JLabel();
jTabbedPane1 = new javax.swing.JTabbedPane();
jPanel1 = new javax.swing.JPanel();
jLabel33 = new javax.swing.JLabel();
jLabel34 = new javax.swing.JLabel();
jLabel36 = new javax.swing.JLabel();
jLabel37 = new javax.swing.JLabel();
jLabel41 = new javax.swing.JLabel();
jTextField12 = new javax.swing.JTextField();
jTextField13 = new javax.swing.JTextField();
jButton11 = new javax.swing.JButton();
jPanel2 = new javax.swing.JPanel();
jLabel2 = new javax.swing.JLabel();
jTextField1 = new javax.swing.JTextField();
jLabel1 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jTextField2 = new javax.swing.JTextField();
jLabel5 = new javax.swing.JLabel();
jLabel6 = new javax.swing.JLabel();
jRadioButton1 = new javax.swing.JRadioButton();
jRadioButton2 = new javax.swing.JRadioButton();
jLabel7 = new javax.swing.JLabel();
jScrollPane1 = new javax.swing.JScrollPane();
jTextArea1 = new javax.swing.JTextArea();
jComboBox1 = new javax.swing.JComboBox();
jLabel4 = new javax.swing.JLabel();
jTextField3 = new javax.swing.JTextField();
jLabel8 = new javax.swing.JLabel();
jLabel27 = new javax.swing.JLabel();
jLabel28 = new javax.swing.JLabel();
jComboBox3 = new javax.swing.JComboBox();
jButton6 = new javax.swing.JButton();
jButton7 = new javax.swing.JButton();
jPanel3 = new javax.swing.JPanel();
jLabel9 = new javax.swing.JLabel();
jScrollPane2 = new javax.swing.JScrollPane();
jTextArea2 = new javax.swing.JTextArea();
jLabel10 = new javax.swing.JLabel();
jComboBox2 = new javax.swing.JComboBox();
jTextField4 = new javax.swing.JTextField();
jLabel11 = new javax.swing.JLabel();
jLabel13 = new javax.swing.JLabel();
jLabel14 = new javax.swing.JLabel();
jLabel15 = new javax.swing.JLabel();
jRadioButton3 = new javax.swing.JRadioButton();
jTextField5 = new javax.swing.JTextField();
jTextField6 = new javax.swing.JTextField();
jRadioButton4 = new javax.swing.JRadioButton();
jRadioButton5 = new javax.swing.JRadioButton();
jScrollPane3 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
jButton1 = new javax.swing.JButton();
jLabel12 = new javax.swing.JLabel();
jButton5 = new javax.swing.JButton();
jLabel29 = new javax.swing.JLabel();
jLabel30 = new javax.swing.JLabel();
jPanel4 = new javax.swing.JPanel();
jLabel16 = new javax.swing.JLabel();
jScrollPane4 = new javax.swing.JScrollPane();
jTextArea3 = new javax.swing.JTextArea();
jLabel17 = new javax.swing.JLabel();
jTextField7 = new javax.swing.JTextField();
jLabel18 = new javax.swing.JLabel();
jLabel19 = new javax.swing.JLabel();
jLabel21 = new javax.swing.JLabel();
jLabel22 = new javax.swing.JLabel();
jRadioButton6 = new javax.swing.JRadioButton();
jTextField8 = new javax.swing.JTextField();
jTextField9 = new javax.swing.JTextField();
jRadioButton7 = new javax.swing.JRadioButton();
jButton2 = new javax.swing.JButton();
jLabel31 = new javax.swing.JLabel();
jLabel32 = new javax.swing.JLabel();
jButton8 = new javax.swing.JButton();
jButton9 = new javax.swing.JButton();
jButton10 = new javax.swing.JButton();
jPanel5 = new javax.swing.JPanel();
jScrollPane5 = new javax.swing.JScrollPane();
jTable2 = new javax.swing.JTable();
jLabel23 = new javax.swing.JLabel();
jTextField10 = new javax.swing.JTextField();
jLabel24 = new javax.swing.JLabel();
jTextField11 = new javax.swing.JTextField();
jLabel25 = new javax.swing.JLabel();
jButton3 = new javax.swing.JButton();
jButton4 = new javax.swing.JButton();
jLabel20 = new javax.swing.JLabel();
jLabel26 = new javax.swing.JLabel();
jLabel35.setText("jLabel35");
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setTitle("Data Mahasiswa dan Tambah Jurusan - Rahmat Burhanudin");
setResizable(false);
jTabbedPane1.addChangeListener(new javax.swing.event.ChangeListener() {
public void stateChanged(javax.swing.event.ChangeEvent evt) {
jTabbedPane1StateChanged(evt);
}
});
jLabel33.setFont(new java.awt.Font("Tahoma", 0, 24)); // NOI18N
jLabel33.setText("Data Mahasiswa dan Tambah Jurusan");
jLabel34.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
jLabel36.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
jLabel36.setText("Username ");
jLabel37.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
jLabel37.setText("Password");
jTextField12.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jTextField12ActionPerformed(evt);
}
});
jButton11.setText("Login");
jButton11.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton11ActionPerformed(evt);
}
});
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap(200, Short.MAX_VALUE)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel33)
.addComponent(jLabel34)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel36, javax.swing.GroupLayout.PREFERRED_SIZE, 73, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel37, javax.swing.GroupLayout.PREFERRED_SIZE, 65, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(46, 46, 46)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jTextField12, javax.swing.GroupLayout.PREFERRED_SIZE, 95, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel41, javax.swing.GroupLayout.PREFERRED_SIZE, 145, javax.swing.GroupLayout.PREFERRED_SIZE))
.addComponent(jTextField13, javax.swing.GroupLayout.PREFERRED_SIZE, 103, javax.swing.GroupLayout.PREFERRED_SIZE))))
.addGap(126, 126, 126))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
.addComponent(jButton11)
.addGap(322, 322, 322))))
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(116, 116, 116)
.addComponent(jLabel33)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jLabel34)
.addGap(42, 42, 42)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel36, javax.swing.GroupLayout.PREFERRED_SIZE, 61, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel41, javax.swing.GroupLayout.PREFERRED_SIZE, 47, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jTextField12, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(50, 50, 50)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel37, javax.swing.GroupLayout.PREFERRED_SIZE, 61, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jTextField13, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(35, 35, 35)
.addComponent(jButton11)
.addContainerGap(164, Short.MAX_VALUE))
);
jTabbedPane1.addTab("Utama", jPanel1);
jLabel2.setText("Nama");
jTextField1.setToolTipText("");
jLabel1.setText("Tanggal Lahir");
jLabel3.setText("Jurusan");
jLabel5.setText("Contoh : 15/01/1996");
jLabel6.setText("Jenis Kelamin");
jenis.add(jRadioButton1);
jRadioButton1.setSelected(true);
jRadioButton1.setText("L");
jenis.add(jRadioButton2);
jRadioButton2.setText("P");
jLabel7.setText("Alamat");
jTextArea1.setColumns(20);
jTextArea1.setLineWrap(true);
jTextArea1.setRows(5);
jScrollPane1.setViewportView(jTextArea1);
jComboBox1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jComboBox1ActionPerformed(evt);
}
});
jLabel4.setText("NPM");
jTextField3.setEditable(false);
jLabel27.setText("Isi data, tidak boleh ada yang kosong");
jLabel28.setText("Status ");
jButton6.setText("Tambah");
jButton6.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton6ActionPerformed(evt);
}
});
jButton7.setText("Reset");
jButton7.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton7ActionPerformed(evt);
}
});
javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
jPanel2.setLayout(jPanel2Layout);
jPanel2Layout.setHorizontalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel1)
.addComponent(jLabel6)
.addComponent(jLabel7)
.addComponent(jLabel3)
.addComponent(jLabel2)
.addComponent(jLabel4))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addComponent(jRadioButton1)
.addGap(34, 34, 34)
.addComponent(jRadioButton2))
.addGroup(jPanel2Layout.createSequentialGroup()
.addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(223, 223, 223)
.addComponent(jComboBox3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel2Layout.createSequentialGroup()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addComponent(jTextField2)
.addComponent(jTextField1)
.addComponent(jScrollPane1)
.addComponent(jTextField3, javax.swing.GroupLayout.Alignment.LEADING))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel5)
.addComponent(jLabel8)))))
.addGroup(jPanel2Layout.createSequentialGroup()
.addComponent(jLabel28)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel27))
.addGroup(jPanel2Layout.createSequentialGroup()
.addComponent(jButton6)
.addGap(54, 54, 54)
.addComponent(jButton7)))
.addContainerGap(368, Short.MAX_VALUE))
);
jPanel2Layout.setVerticalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addGap(7, 7, 7)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel4)
.addComponent(jLabel8))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel2)
.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel1)
.addComponent(jLabel5))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel6)
.addComponent(jRadioButton1)
.addComponent(jRadioButton2))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel7)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(10, 10, 10)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel3)
.addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jComboBox3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton6)
.addComponent(jButton7))
.addGap(42, 42, 42)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel28)
.addComponent(jLabel27))
.addContainerGap(263, Short.MAX_VALUE))
);
jTabbedPane1.addTab("Tambah Mahasiswa", jPanel2);
jLabel9.setText("Alamat");
jTextArea2.setColumns(20);
jTextArea2.setLineWrap(true);
jTextArea2.setRows(5);
jScrollPane2.setViewportView(jTextArea2);
jLabel10.setText("Nama");
jComboBox2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Semua" }));
jTextField4.setToolTipText("");
jLabel11.setText("Tanggal Lahir");
jLabel13.setText("Jurusan");
jLabel14.setText("Jenis Kelamin");
jLabel15.setText("NPM");
jenis2.add(jRadioButton3);
jRadioButton3.setText("L");
jTextField6.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jTextField6ActionPerformed(evt);
}
});
jenis2.add(jRadioButton4);
jRadioButton4.setText("P");
jenis2.add(jRadioButton5);
jRadioButton5.setSelected(true);
jRadioButton5.setText("Semua");
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
},
new String [] {
"NPM", "Nama", "Tanggal Lahir", "Jenis Kelamin", "Alamat", "Jurusan"
}
));
jScrollPane3.setViewportView(jTable1);
jButton1.setText("Cari");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jLabel12.setText("*Kosongkan semua jika ingin mencari semua mahasiswa");
jButton5.setText("Reset");
jLabel29.setText("Status ");
jLabel30.setText("Isi kriteria yang ingin di cari");
javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
jPanel3.setLayout(jPanel3Layout);
jPanel3Layout.setHorizontalGroup(
jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel3Layout.createSequentialGroup()
.addGap(24, 24, 24)
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel3Layout.createSequentialGroup()
.addComponent(jLabel29)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel30))
.addComponent(jScrollPane3, javax.swing.GroupLayout.PREFERRED_SIZE, 681, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(jPanel3Layout.createSequentialGroup()
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel3Layout.createSequentialGroup()
.addComponent(jLabel11)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jTextField6, javax.swing.GroupLayout.PREFERRED_SIZE, 166, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel3Layout.createSequentialGroup()
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel14)
.addComponent(jLabel15)
.addComponent(jLabel13))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jComboBox2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(jPanel3Layout.createSequentialGroup()
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jTextField5, javax.swing.GroupLayout.PREFERRED_SIZE, 166, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(jPanel3Layout.createSequentialGroup()
.addComponent(jRadioButton3)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jRadioButton4)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jRadioButton5)))
.addGap(102, 102, 102)
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel9)
.addComponent(jLabel10)))))
.addComponent(jLabel12))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, 166, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(jPanel3Layout.createSequentialGroup()
.addComponent(jButton1)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jButton5)))))
.addContainerGap(26, Short.MAX_VALUE))
);
jPanel3Layout.setVerticalGroup(
jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel3Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel15)
.addComponent(jTextField5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel10))
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel3Layout.createSequentialGroup()
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel14)
.addComponent(jRadioButton3)
.addComponent(jRadioButton4)
.addComponent(jRadioButton5))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel11)
.addComponent(jTextField6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel13)
.addComponent(jComboBox2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel3Layout.createSequentialGroup()
.addGap(14, 14, 14)
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel9)
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 59, javax.swing.GroupLayout.PREFERRED_SIZE))))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton1)
.addComponent(jLabel12)
.addComponent(jButton5))
.addGap(18, 18, 18)
.addComponent(jScrollPane3, javax.swing.GroupLayout.DEFAULT_SIZE, 398, Short.MAX_VALUE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel29)
.addComponent(jLabel30))
.addGap(18, 18, 18))
);
jTabbedPane1.addTab("Cari Mahasiswa", jPanel3);
jLabel16.setText("Alamat");
jTextArea3.setColumns(20);
jTextArea3.setLineWrap(true);
jTextArea3.setRows(5);
jScrollPane4.setViewportView(jTextArea3);
jLabel17.setText("Nama");
jTextField7.setToolTipText("");
jLabel18.setText("Tanggal Lahir");
jLabel19.setText("Contoh : 15/01/1996");
jLabel21.setText("Jenis Kelamin");
jLabel22.setText("NPM");
jenis3.add(jRadioButton6);
jRadioButton6.setSelected(true);
jRadioButton6.setText("L");
jenis3.add(jRadioButton7);
jRadioButton7.setText("P");
jButton2.setText("Cari");
jButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton2ActionPerformed(evt);
}
});
jLabel31.setText("Masukan NPM, lalu klik edit");
jLabel32.setText("Status ");
jButton8.setText("Simpan");
jButton8.setEnabled(false);
jButton8.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton8ActionPerformed(evt);
}
});
jButton9.setText("Batal");
jButton9.setEnabled(false);
jButton9.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton9ActionPerformed(evt);
}
});
jButton10.setText("Hapus");
jButton10.setEnabled(false);
jButton10.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton10ActionPerformed(evt);
}
});
javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout(jPanel4);
jPanel4.setLayout(jPanel4Layout);
jPanel4Layout.setHorizontalGroup(
jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel4Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel4Layout.createSequentialGroup()
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel18)
.addComponent(jLabel21)
.addComponent(jLabel16)
.addComponent(jLabel17))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel4Layout.createSequentialGroup()
.addComponent(jRadioButton6)
.addGap(34, 34, 34)
.addComponent(jRadioButton7))
.addGroup(jPanel4Layout.createSequentialGroup()
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addGroup(jPanel4Layout.createSequentialGroup()
.addGap(11, 11, 11)
.addComponent(jButton10)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jButton9))
.addComponent(jTextField9)
.addComponent(jTextField7)
.addComponent(jScrollPane4))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel19))))
.addGroup(jPanel4Layout.createSequentialGroup()
.addComponent(jLabel22)
.addGap(53, 53, 53)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jButton2)
.addComponent(jTextField8, javax.swing.GroupLayout.PREFERRED_SIZE, 166, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(jPanel4Layout.createSequentialGroup()
.addComponent(jLabel32)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel31))
.addComponent(jButton8))
.addContainerGap(376, Short.MAX_VALUE))
);
jPanel4Layout.setVerticalGroup(
jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel4Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jTextField8, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel22))
.addGap(5, 5, 5)
.addComponent(jButton2)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel17)
.addComponent(jTextField7, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jTextField9, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel18)
.addComponent(jLabel19))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel21)
.addComponent(jRadioButton6)
.addComponent(jRadioButton7))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel16)
.addComponent(jScrollPane4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jButton8)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton9)
.addComponent(jButton10)))
.addGap(52, 52, 52)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel32)
.addComponent(jLabel31))
.addContainerGap(253, Short.MAX_VALUE))
);
jTabbedPane1.addTab("Edit Hapus Mahasiswa", jPanel4);
jTable2.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
},
new String [] {
"Jurusan", "Acuan"
}
));
jScrollPane5.setViewportView(jTable2);
jLabel23.setText("Nama Jurusan");
jLabel24.setText("Karakter acuan");
jLabel25.setText("Untuk acuan NPM, max 1 karakter, boleh angka atau huruf");
jButton3.setText("Tambah");
jButton3.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton3ActionPerformed(evt);
}
});
jButton4.setText("Reset");
jButton4.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton4ActionPerformed(evt);
}
});
jLabel20.setText("Status ");
jLabel26.setText("Isi nama dan karakter acuan, lalu klik tambah");
javax.swing.GroupLayout jPanel5Layout = new javax.swing.GroupLayout(jPanel5);
jPanel5.setLayout(jPanel5Layout);
jPanel5Layout.setHorizontalGroup(
jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel5Layout.createSequentialGroup()
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel5Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel23)
.addComponent(jLabel24))
.addGap(18, 18, 18)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jTextField10, javax.swing.GroupLayout.PREFERRED_SIZE, 165, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(jPanel5Layout.createSequentialGroup()
.addComponent(jTextField11, javax.swing.GroupLayout.PREFERRED_SIZE, 35, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel25))))
.addGroup(jPanel5Layout.createSequentialGroup()
.addGap(26, 26, 26)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jScrollPane5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(jPanel5Layout.createSequentialGroup()
.addComponent(jLabel20)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel26))
.addGroup(jPanel5Layout.createSequentialGroup()
.addComponent(jButton3)
.addGap(122, 122, 122)
.addComponent(jButton4)))))
.addContainerGap(253, Short.MAX_VALUE))
);
jPanel5Layout.setVerticalGroup(
jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel5Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel23)
.addComponent(jTextField10, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel24)
.addComponent(jTextField11, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel25))
.addGap(64, 64, 64)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton3)
.addComponent(jButton4))
.addGap(18, 18, 18)
.addComponent(jScrollPane5, javax.swing.GroupLayout.PREFERRED_SIZE, 222, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel20)
.addComponent(jLabel26))
.addContainerGap(176, Short.MAX_VALUE))
);
jTabbedPane1.addTab("Tambah Jurusan", jPanel5);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jTabbedPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 736, javax.swing.GroupLayout.PREFERRED_SIZE)
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jTabbedPane1))
);
pack();
}// </editor-fold>
private void jTextField6ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
char a =jTextField11.getText().charAt(0);
if (jTextField10.getText().equals("") || jTextField11.getText().equals("")) {
jLabel26.setText("Tidak boleh ada yang kosong");
}else if(jTextField11.getText().length() >1) {
jLabel26.setText("Acuan hanya 1 karakter");
}else if (!(Character.isDigit(a))) {
jLabel26.setText("Acuan hanya boleh angka");
}else {
try {
hasil = st.executeQuery("SELECT * FROM `jurusan` WHERE `jurusan` = '" + jTextField10.getText() + "' OR `acuan` = '" + jTextField11.getText() + "';");
if (!hasil.next()) {
System.out.print("ga ada");
st.executeUpdate("INSERT INTO `jurusan` (`jurusan`, `acuan`) VALUES ('" + jTextField10.getText() + "', '" + jTextField11.getText() + "');");
DefaultTableModel model1 = (DefaultTableModel) jTable2.getModel();
model1.setRowCount(0);
hasil = st.executeQuery("select * from `jurusan`");
while(hasil.next()) {
model1.addRow(new Object[] {hasil.getString(1),hasil.getString(2)});
}
jTextField10.setText("");
jTextField11.setText("");
jLabel26.setText("Jurusan berhasil di tambah");
}else
{
System.out.print("ada");
jLabel26.setText("Gagal, jurusan atau acuan sudah ada");
}
} catch (Exception e ) {
}
}
}
private void jTabbedPane1StateChanged(javax.swing.event.ChangeEvent evt) {
// TODO add your handling code here:
try {
jComboBox3.setVisible(false);
if (jTabbedPane1.getSelectedIndex() == 4) {
DefaultTableModel model1 = (DefaultTableModel) jTable2.getModel();
model1.setRowCount(0);
hasil = st.executeQuery("select * from `jurusan`");
while(hasil.next()) {
System.out.print(hasil.getString(1));
model1.addRow(new Object[] {hasil.getString(1),hasil.getString(2)});
}
}else if (jTabbedPane1.getSelectedIndex() == 1) {
hasil = st.executeQuery("select * from `jurusan`");
jComboBox3.removeAllItems();
jComboBox1.removeAllItems();
while(hasil.next()) {
jComboBox3.addItem(hasil.getString(2));
jComboBox1.addItem(hasil.getString(1));
}
} else if (jTabbedPane1.getSelectedIndex() == 2) {
hasil = st.executeQuery("select * from `jurusan`");
jComboBox2.removeAllItems();
jComboBox2.addItem("Semua");
while(hasil.next()) {
jComboBox2.addItem(hasil.getString(1));
}
}
} catch (Exception e) {
}
}
private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
jTextField10.setText("");
jTextField11.setText("");
}
private void jComboBox1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
System.out.print(jComboBox1.getSelectedIndex());
jComboBox3.setSelectedIndex(jComboBox1.getSelectedIndex());
try {
hasil2 = st2.executeQuery("SELECT `npm` FROM `mahasiswa` WHERE `npm` LIKE '" + jComboBox3.getSelectedItem()+ tahun +"%' ORDER BY `npm` DESC");
if (hasil2.next()) {
System.out.print(hasil2.getString(1));
System.out.println();
int a = Integer.valueOf(hasil2.getString(1));
System.out.print(a + 1);
jTextField3.setText(String.valueOf(a + 1));
}else {
jTextField3.setText(String.valueOf(jComboBox3.getSelectedItem()) + String.valueOf(tahun) + "001");
}
} catch (Exception e) {
}
}
private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
if (jTextField1.getText().equals("") || jTextField2.getText().equals("") ||jTextArea1.getText().equals("")){
jLabel27.setText("Gagal, tidak boleh ada yang kosong");
}else {
String jenis;
if (jRadioButton1.isSelected()) {
jenis = "L";
}else {
jenis = "P";
}
try {
st.executeUpdate("INSERT INTO `mahasiswa` (`npm`, `nama`, `lahir`, `jenis`, `alamat`, `jurusan`) VALUES ('"+ jTextField3.getText() +"', '"+ jTextField1.getText() +"', '"+ jTextField2.getText() +"', '"+ jenis +"', '"+ jTextArea1.getText() +"', '"+ jComboBox1.getSelectedItem() +"');");
jTextField1.setText("");
jTextField2.setText("");
jTextArea1.setText("");
jComboBox1.setSelectedIndex(0);
jLabel27.setText("Data berhasil di tambah");
}catch (Exception e) {
}
}
}
private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
jTextField1.setText("");
jTextField2.setText("");
jTextArea1.setText("");
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
DefaultTableModel model1 = (DefaultTableModel) jTable1.getModel();
model1.setRowCount(0);
String jurusan;
String jenis;
if (jComboBox2.getSelectedIndex() == 0) {
jurusan = "";
}else{
jurusan = String.valueOf(jComboBox2.getSelectedItem());
}
if (jRadioButton3.isSelected()) {
jenis = "L";
}else if (jRadioButton4.isSelected()) {
jenis = "P";
}else {
jenis = "";
}
try {
if(jTextField4.getText().equals("") && jTextField5.getText().equals("") &&jTextField6.getText().equals("") && jTextArea2.getText().equals("") && jRadioButton5.isSelected() && jComboBox2.getSelectedIndex() == 0) {
jLabel30.setText("Semua Mahasiswa");
hasil = st.executeQuery("select * from `mahasiswa`");
while (hasil.next()) {
model1.addRow(new Object[] {hasil.getString(1),hasil.getString(2),hasil.getString(3),hasil.getString(4),hasil.getString(5),hasil.getString(6)});
}
model1.addRow(new Object[] {hasil.getString(1),hasil.getString(2)});
}else {
jLabel30.setText("Data di temukan");
hasil = st.executeQuery("SELECT * FROM `mahasiswa` WHERE `npm` LIKE '%"+ jTextField5.getText()+"%' AND `nama` LIKE '%"+ jTextField4.getText()+"%' AND `lahir` LIKE '%"+ jTextField6.getText()+"%' AND `jenis` LIKE '%"+ jenis+"%' AND `alamat` LIKE '%"+ jTextArea2.getText()+"%' AND `jurusan` LIKE '%"+ jurusan+"%'");
while (hasil.next()) {
model1.addRow(new Object[] {hasil.getString(1),hasil.getString(2),hasil.getString(3),hasil.getString(4),hasil.getString(5),hasil.getString(6)});
}
}
if (model1.getRowCount()== 0) {
jLabel30.setText("Data tidak di temukan");
}
} catch (Exception e) {
}
}
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try {
hasil = st.executeQuery("SELECT * FROM `mahasiswa` WHERE `npm` = "+ jTextField8.getText());
if (hasil.next()) {
jLabel31.setText("NPM di temukan, silahkan rubah data lalu simpan, atau klik batal untuk membatalkan");
jTextField7.setText(hasil.getString(2));
jTextField9.setText(hasil.getString(3));
if (hasil.getString(4).equals("L")) {
jRadioButton6.setSelected(true);
} else {
jRadioButton7.setSelected(true);
}
jTextArea3.setText(hasil.getString(5));
jTextField8.setEditable(false);
jButton2.setEnabled(false);
jButton8.setEnabled(true);
jButton9.setEnabled(true);
jButton10.setEnabled(true);
}else {
System.out.print("tidak ada ko");
jLabel31.setText("NPM tidak di temukan");
}
} catch (Exception e) {
jLabel31.setText("NPM tidak di temukan");
e.printStackTrace();
}
}
private void jButton9ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
jLabel31.setText("Dibatalkan");
jTextField8.setEditable(true);
jButton2.setEnabled(true);
jButton8.setEnabled(false);
jButton9.setEnabled(false);
jButton10.setEnabled(false);
jTextField7.setText("");
jTextField8.setText("");
jTextField9.setText("");
jTextArea3.setText("");
}
private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
if (jTextField7.getText().equals("") || jTextField8.getText().equals("") || jTextField9.getText().equals("") ||jTextArea3.getText().equals("")) {
jLabel31.setText("Tidak boleh kosong");
}else {
try {
String jenis;
if (jRadioButton6.isSelected()) {
jenis = "L";
}else {
jenis = "P";
}
st.executeUpdate("UPDATE `mahasiswa` SET `nama` = '"+ jTextField7.getText()+"', `lahir` = '"+ jTextField9.getText()+"', `jenis` = '"+jenis+"', `alamat` = '"+ jTextArea3.getText()+"' WHERE `mahasiswa`.`npm` = "+ jTextField8.getText()+";");
jLabel31.setText("Berhasil di rubah");
jTextField8.setEditable(true);
jButton2.setEnabled(true);
jButton8.setEnabled(false);
jButton9.setEnabled(false);
jButton10.setEnabled(false);
jTextField7.setText("");
jTextField8.setText("");
jTextField9.setText("");
jTextArea3.setText("");
}catch (Exception e) {
}
}
}
private void jButton10ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
hapus--;
if (hapus > 0) {
jLabel31.setText("Jika anda yakin ingin hapus, klik button hapus "+hapus+" kali lagi");
}else {
jLabel31.setText("Mahasiwa berhasil di hapus");
try {
st.executeUpdate("DELETE FROM `mahasiswa` WHERE `mahasiswa`.`npm` = " + jTextField8.getText());
jTextField8.setEditable(true);
jButton2.setEnabled(true);
jButton8.setEnabled(false);
jButton9.setEnabled(false);
jButton10.setEnabled(false);
jTextField7.setText("");
jTextField8.setText("");
jTextField9.setText("");
jTextArea3.setText("");
} catch (Exception e) {
}
}
}
private void jTextField12ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void jButton11ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
/**
* @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(utama.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(utama.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(utama.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(utama.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
tahun = sekarang.get(Calendar.YEAR);
try {
konesi = DriverManager.getConnection(jalur, user, password);
metadata = konesi.getMetaData();
hasil = metadata.getTables(null, null, "mahasiswa", null);
st = konesi.createStatement();
st2 = konesi.createStatement();
if (hasil.next()) {
System.out.print("ada");
}else {
System.out.print("tidak");
st.executeUpdate("CREATE TABLE `mahasiswa` ( `npm` INT(8) NOT NULL , `nama` VARCHAR(26) NOT NULL , `lahir` VARCHAR(12) NOT NULL , `jenis` VARCHAR(1) NOT NULL , `alamat` TEXT NOT NULL , `jurusan` VARCHAR(32) NOT NULL , PRIMARY KEY (`npm`) );");
st.executeUpdate("CREATE TABLE `jurusan` ( `jurusan` VARCHAR(30) NOT NULL , `acuan` VARCHAR(2) NOT NULL, PRIMARY KEY (`acuan`) );");
st.executeUpdate("INSERT INTO `jurusan` (`jurusan`, `acuan`) VALUES\n" +
"('Teknik Informatika', '2'),\n" +
"('Sistem Informasi', '8');");
st.executeUpdate("INSERT INTO `mahasiswa` (`npm`, `nama`, `lahir`, `jenis`, `alamat`, `jurusan`) VALUES\n" +
"(22015001, 'Rahamat Burhanudin', '08/07/1996', 'L', 'Kramatwatu', 'Teknik Informatika'),\n" +
"(22015002, 'Orang 2', '01/05/1995', 'L', 'Banten Kramatwatu', 'Teknik Informatika'),\n" +
"(82015001, 'Orang 3', '07/09/1996', 'P', 'Kramatwatu serang banten', 'Sistem Informasi');");
}
}catch (Exception e) {
e.printStackTrace();
}
/* Create and display the form */
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new utama().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton jButton1;
private javax.swing.JButton jButton10;
private javax.swing.JButton jButton11;
private javax.swing.JButton jButton2;
private javax.swing.JButton jButton3;
private javax.swing.JButton jButton4;
private javax.swing.JButton jButton5;
private javax.swing.JButton jButton6;
private javax.swing.JButton jButton7;
private javax.swing.JButton jButton8;
private javax.swing.JButton jButton9;
private javax.swing.JComboBox jComboBox1;
private javax.swing.JComboBox jComboBox2;
private javax.swing.JComboBox jComboBox3;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel10;
private javax.swing.JLabel jLabel11;
private javax.swing.JLabel jLabel12;
private javax.swing.JLabel jLabel13;
private javax.swing.JLabel jLabel14;
private javax.swing.JLabel jLabel15;
private javax.swing.JLabel jLabel16;
private javax.swing.JLabel jLabel17;
private javax.swing.JLabel jLabel18;
private javax.swing.JLabel jLabel19;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel20;
private javax.swing.JLabel jLabel21;
private javax.swing.JLabel jLabel22;
private javax.swing.JLabel jLabel23;
private javax.swing.JLabel jLabel24;
private javax.swing.JLabel jLabel25;
private javax.swing.JLabel jLabel26;
private javax.swing.JLabel jLabel27;
private javax.swing.JLabel jLabel28;
private javax.swing.JLabel jLabel29;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel30;
private javax.swing.JLabel jLabel31;
private javax.swing.JLabel jLabel32;
private javax.swing.JLabel jLabel33;
private javax.swing.JLabel jLabel34;
private javax.swing.JLabel jLabel35;
private javax.swing.JLabel jLabel36;
private javax.swing.JLabel jLabel37;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel41;
private javax.swing.JLabel jLabel5;
private javax.swing.JLabel jLabel6;
private javax.swing.JLabel jLabel7;
private javax.swing.JLabel jLabel8;
private javax.swing.JLabel jLabel9;
private javax.swing.JPanel jPanel1;
private javax.swing.JPanel jPanel2;
private javax.swing.JPanel jPanel3;
private javax.swing.JPanel jPanel4;
private javax.swing.JPanel jPanel5;
private javax.swing.JRadioButton jRadioButton1;
private javax.swing.JRadioButton jRadioButton2;
private javax.swing.JRadioButton jRadioButton3;
private javax.swing.JRadioButton jRadioButton4;
private javax.swing.JRadioButton jRadioButton5;
private javax.swing.JRadioButton jRadioButton6;
private javax.swing.JRadioButton jRadioButton7;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JScrollPane jScrollPane2;
private javax.swing.JScrollPane jScrollPane3;
private javax.swing.JScrollPane jScrollPane4;
private javax.swing.JScrollPane jScrollPane5;
private javax.swing.JTabbedPane jTabbedPane1;
private javax.swing.JTable jTable1;
private javax.swing.JTable jTable2;
private javax.swing.JTextArea jTextArea1;
private javax.swing.JTextArea jTextArea2;
private javax.swing.JTextArea jTextArea3;
private javax.swing.JTextField jTextField1;
private javax.swing.JTextField jTextField10;
private javax.swing.JTextField jTextField11;
private javax.swing.JTextField jTextField12;
private javax.swing.JTextField jTextField13;
private javax.swing.JTextField jTextField2;
private javax.swing.JTextField jTextField3;
private javax.swing.JTextField jTextField4;
private javax.swing.JTextField jTextField5;
private javax.swing.JTextField jTextField6;
private javax.swing.JTextField jTextField7;
private javax.swing.JTextField jTextField8;
private javax.swing.JTextField jTextField9;
private javax.swing.ButtonGroup jenis;
private javax.swing.ButtonGroup jenis2;
private javax.swing.ButtonGroup jenis3;
// End of variables declaration
}
Komentar
Posting Komentar