Aplikasi ini merupakan Aplikasi sederhana saya setelah saya belajar data base. Saya menciptakan project ini sebagai hasil dari pembelajaran saya mengenai data base. Saya lampirkan juga dengan source kodenya lengkap dengan cara menampilkan dan menyimpan datanya.
Ini desainnya.
Bagi pembaca yang berminat silahkan mencobanya dan source kodenya bisa anda lihat di bawah
sebelum memberi koding pada masing2 tombolnya anda harus dan wajib menulis kode di bawah ini pada bagian atas. halaman source kodeimport javax.swing.JOptionPane;
import java.sql.*;
import javax.swing.table.DefaultTableModel;
import java.awt.Dimension;
import javax.swing.table.JTableHeader;
Langkah-langkah selengkapnya di bawwah ini.... (^_^)
sebaiknya dlm membuat project ini, anda akan lebih mudah menggunakan prosedur, karena pada tombol yang akan anda beri even, anda tinggal memanggil nama prosedur yang anda buat jadi anda tidak perlu mengetikkan program 2 kali atau lebih.
cara membuat prosedurnya, anda tinggal ketikkan saja "public void btn simpan () { lalu enter ketikkan kodenya di dalamnya"(btnsimpan itu mksdnya tombol yang anda beri even pada halaman desain,namanya adalah btnsimpan)
public void displaydata(){
try{
Class.forName("com.mysql.jdbc.Driver");
Connection kon = DriverManager.getConnection("jdbc:mysql://localhost/sistem_informasi?user=root&password=");
String nrp = jTable1.getValueAt(jTable1.getSelectedRow(), 0).toString();
ResultSet rs = kon.createStatement().executeQuery("select * from tblmahasiswa where nrp ='" + nrp +"'");
Object[] data = new Object[8];
if (rs.next()){
txtnrp.setText(rs.getString("nrp"));
txtnama.setText(rs.getString("nama"));
if (rs.getString("jeniskelamin").equals("Laki-laki")){
rblaki.setSelected(true);
}else{
rbperempuan.setSelected(true);
}
txttgl.setText(rs.getString("tgllahir"));
txtjurusan.setText(rs.getString("jurusan"));
if (rs.getString("agama").equals("Islam")){
rbislam.setSelected(true);
}else if(rs.getString("agama").equals("Kristen")){
rbkristen.setSelected(true);
}else if(rs.getString("agama").equals("Katolik")){
rbkatolik.setSelected(true);
}else if (rs.getString("agama").equals("Hindu")){
rbhindu.setSelected(true);
}else if (rs.getString("agama").equals("Budha")){
rbbudha.setSelected(true);
}
txtemail.setText(rs.getString("email"));
txtalamat.setText(rs.getString("alamat"));
}
}
catch (ClassNotFoundException e){
JOptionPane.showMessageDialog(rootPane, "jdbc.Driver tidak ditemukan");
}catch (SQLException e){
JOptionPane.showMessageDialog(rootPane, "Koneksi Gagal " + e.toString());
}
}
private void rblakiActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
rblaki.setSelected(true);
rbperempuan.setSelected(false);
}
private void rbperempuanActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
rblaki.setSelected(false);
rbperempuan.setSelected(true);
}
private void rbislamActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
rbislam.setSelected(true);
rbkristen.setSelected(false);
rbkatolik.setSelected(false);
rbhindu.setSelected(false);
rbbudha.setSelected(false);
}
private void rbkristenActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
rbislam.setSelected(false);
rbkristen.setSelected(true);
rbkatolik.setSelected(false);
rbhindu.setSelected(false);
rbbudha.setSelected(false);
}
private void rbkatolikActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
rbislam.setSelected(false);
rbkristen.setSelected(false);
rbkatolik.setSelected(true);
rbhindu.setSelected(false);
rbbudha.setSelected(false);
}
private void rbhinduActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
rbislam.setSelected(false);
rbkristen.setSelected(false);
rbkatolik.setSelected(false);
rbhindu.setSelected(true);
rbbudha.setSelected(false);
}
private void rbbudhaActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
rbislam.setSelected(false);
rbkristen.setSelected(false);
rbkatolik.setSelected(false);
rbhindu.setSelected(false);
rbbudha.setSelected(true);
}
private void btnsimpanActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
simpan();
tampil();
reset();
btnsimpan.setEnabled(false);
}
public void reset(){
txtnrp.setText("");
txtnama.setText("");
txttgl.setText("");
txtjurusan.setText("");
txtemail.setText("");
txtalamat.setText("");
txtnrp.requestFocus();
}
private void btnkeluarActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
int jawab = JOptionPane.showConfirmDialog(rootPane, "Anda Yakin Ingin Keluar?", "Konfirmasi", JOptionPane.YES_NO_CANCEL_OPTION);
if (jawab == JOptionPane.YES_OPTION){
System.exit(0);
}
}
private void formWindowOpened(java.awt.event.WindowEvent evt) {
tampil();
aktif(false);
btnsimpan.setEnabled(false);
}
public void delete(){
int jawa = JOptionPane.showConfirmDialog(rootPane, "Are You Sure You Want to Delete ?", "CONFIRMATION", JOptionPane.OK_CANCEL_OPTION);
if (jawa == 0){
try{
Class.forName("com.mysql.jdbc.Driver");
Connection kon = DriverManager.getConnection("jdbc:mysql://localhost/sistem_informasi?user=root&password=");
PreparedStatement sql = kon.prepareStatement("delete from tblmahasiswa where nrp=?");
String nrp = jTable1.getValueAt(jTable1.getSelectedRow(), 0).toString();
sql.setString(1, nrp);
int sukses = sql.executeUpdate();
if (sukses > 0){
JOptionPane.showMessageDialog(rootPane, "Delete Successfully", "Information", JOptionPane.INFORMATION_MESSAGE);
}
else {
JOptionPane.showMessageDialog(rootPane, "Deleted Failed!", "Information", JOptionPane.INFORMATION_MESSAGE);
}
sql.close();
kon.close();
}catch(ClassNotFoundException eror){
JOptionPane.showMessageDialog(null, "jdbc Driver not found");
}catch(SQLException eror){
JOptionPane.showMessageDialog(null, "Koneksi Gagal" + eror.toString());
}
}
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
delete(
);
tampil(
);
}
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
aktif(true);
jButton3.setEnabled(false);
txtnrp.requestFocus();
btnsimpan.setEnabled(true);
}
private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
displaydata();
}
public void aktif (boolean value){
txtnrp.setEditable(value);
txtnama.setEditable(value);
rblaki.setEnabled(value);
rbperempuan.setEnabled(value);
txttgl.setEditable(value);
txtjurusan.setEditable(value);
rbbudha.setEnabled(value);
rbhindu.setEnabled(value);
rbislam.setEnabled(value);
rbkatolik.setEnabled(value);
rbkristen.setEnabled(value);
txtemail.setEditable(value);
txtalamat.setEnabled(value);
}
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
aktif(true);
reset();
btnsimpan.setEnabled(true);
jButton3.setEnabled(false);
}
public void tampil(){
try{
Class.forName("com.mysql.jdbc.Driver");
Connection kon = DriverManager.getConnection("jdbc:mysql://localhost/sistem_informasi?user=root&password=");
ResultSet rs = kon.createStatement().executeQuery("SELECT * FROM tblmahasiswa");
DefaultTableModel model= new DefaultTableModel();
String[] kolom = {"NRP","Nama","Jenis Kelamin", "Tanggal Lahir", "Jurusan","Agama","Email","Alamat"};
model.setColumnIdentifiers(kolom);
Object[] data = new Object[8];
while(rs.next()){
data[0] = rs.getString("nrp");
data[1] = rs.getString("nama");
data[2] = rs.getString("jeniskelamin");
data[3] = rs.getString("tgllahir");
data[4] = rs.getString("jurusan");
data[5] = rs.getString("agama");
data[6] = rs.getString("email");
data[7] = rs.getString("alamat");
model.addRow(data);
}
JTableHeader header = jTable1.getTableHeader();
header.setPreferredSize(new Dimension(1,29));
jTable1.setModel(model);
jTable1.setRowHeight(23);
}catch(ClassNotFoundException eror){
JOptionPane.showMessageDialog(null, "jdbc Driver not found");
}catch(SQLException eror){
JOptionPane.showMessageDialog(null, "Koneksi Gagal" + eror.toString());
}
}
public void simpan(){
try{
Class.forName("com.mysql.jdbc.Driver");
Connection kon = DriverManager.getConnection("jdbc:mysql://localhost/sistem_informasi?user=root&password=");
PreparedStatement sql = kon.prepareStatement("INSERT INTO tblmahasiswa (nrp,nama,jeniskelamin,tgllahir,jurusan,agama,email,alamat)VALUES (?,?,?,?,?,?,?,?)");
sql.setString(1, txtnrp.getText());
sql.setString(2, txtnama.getText());
String jeniskelamin;
if (rblaki.isSelected()){
jeniskelamin = "Laki-laki";
}else{
jeniskelamin = "Perempuan";
}
sql.setString(3, jeniskelamin);
sql.setString(4, txttgl.getText());
sql.setString(5, txtjurusan.getText());
String agama = null;
if (rbislam.isSelected()){
agama = "Islam";
}else if (rbkristen.isSelected()){
agama = "Kristen";
}else if (rbkatolik.isSelected()){
agama = "Katolik";
}else if (rbhindu.isSelected()){
agama = "Hindu";
}else if (rbbudha.isSelected()){
agama = "Budha";
}
sql.setString(6, agama);
sql.setString(7, txtemail.getText());
sql.setString(8, txtalamat.getText());
int sukses = sql.executeUpdate();
if (sukses > 0){
JOptionPane.showMessageDialog(null, "Data Anda Sudah Tersimpan", "Informasi", JOptionPane.INFORMATION_MESSAGE);
}else{
JOptionPane.showMessageDialog(null, "Data Anda Gagal Tersimpan", "Informasi", JOptionPane.INFORMATION_MESSAGE);
}
sql.close();
kon.close();
}catch(ClassNotFoundException eror){
JOptionPane.showMessageDialog(null, "jdbc Driver not found");
}catch(SQLException eror){
JOptionPane.showMessageDialog(null, "Koneksi Gagal" + eror.toString());
}
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new mahasiswa().setVisible(true);
}
});
}
Tidak ada komentar:
Posting Komentar