Aplikasi Netbeans Menggunakan Database MySql
Adapun Source Code pertama untuk Form Log In
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
new formlogin().setVisible(true);
this.dispose();
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
String admin=txtadmin.getText();
String password=txtpass.getText();
if (admin.equalsIgnoreCase("adminremaja")&&password.equals("librarian")){
} else {
JOptionPane.showMessageDialog(null,"Maaf, Username atau Password SALAH,Silahkan ulangi Login!");
txtadmin.setText("");
txtpass.setText("");
}
}
Dan dibawah ini adalah source code aplikasi yang menggunakan mysql:
package koneksidatabase;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import javax.swing.JOptionPane;
import javax.swing.SwingUtilities;
import javax.swing.UIManager;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.table.DefaultTableModel;
public class databuku extends javax.swing.JFrame {
public class Koneksi extends javax.swing.JFrame{
private Connection Koneksi;
private Statement Pernyataan;
private ResultSet Hasil;
/**
* Creates new form databuku
*/
public Koneksi() throws SQLException {
initComponents();
}
private void initComponents() throws SQLException {
koneksi_database();//memanggil void koneksi database
isi_table();//memanggil void isi table
kosong();//memanngil void kosong
tidak_bisa_isi();//memanggil void tidak bisa isi
tombol_mati();//memanggil void tombol mati
}
private void isi_table() throws SQLException{
DefaultTableModel tbl=new DefaultTableModel();
///judul kolom\\\\
tbl.addColumn("No Buku");
tbl.addColumn("Jenis Buku");
tbl.addColumn("Judul");
tbl.addColumn("Pengarang");
tbl.addColumn("Penerbit");
tabel.setModel(tbl);
try {
Hasil = Pernyataan.executeQuery("Select * from dataperus.inputbuku");
} catch (SQLException ex) {
Logger.getLogger(databuku.class.getName()).log(Level.SEVERE, null, ex);
}
while (Hasil.next()){
tbl.addRow(new Object[]
{// isi dari database harus sama dgn field database mysql\\\
Hasil.getString("No Buku"),
Hasil.getString("Jenis Buku"),
Hasil.getString("Judul"),
Hasil.getString("Pengarang"),
Hasil.getString("Penerbit"),
});
tabel.setModel(tbl);
}
}
private void kosong (){
txtno.setText("");
txtjdl.setText("");
txtpeng.setText("");
txtpen.setText("");
txtjenis.setText("");
}
private void bisa_isi(){
txtno.setEnabled(true);
txtjdl.setEnabled(true);
txtpeng.setEnabled(true);
txtpen.setEnabled(true);
txtjenis.setEnabled(true)
}
private void tidak_bisa_isi(){
txtno.setEnabled(false);
txtjdl.setEnabled(false);
txtpeng.setEnabled(false);
txtpen.setEnabled(false);
txtJenis.setEnable(false);
}
private void tombol_mati(){
newbt.setVisible(false);
savebt.setText("simpan");
savebt.setEnabled(false);
deletebt.setEnabled(false);
}
private void tombol_hidup(){
newbt.setVisible(true);
savebt.setText("simpan");
savebt.setEnabled(true);
deletebt.setEnabled(true);
}
private void koneksi_database(){
try{
Class.forName("com.mysql.jdbc.Driver");
Koneksi = DriverManager.getConnection("jdbc:msyql://localhost/dataperpus","root","");
Pernyataan = Koneksi.createStatement();
}
catch (Exception e){
JOptionPane.showMessageDialog(null, e);
}}
private void savebtActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
if (savebt.getText()=="Simpan")
Simpan();
else{
tidak_bisa_isi ();
tombol_hidup ();
txtno.setEnabled(true);
}
}
private void deletebtActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
int dialogButton = JOptionPane.YES_NO_OPTION;
int dialogResult = JOptionPane.showConfirmDialog(null, "Data akan di hapus", "Hapus Data", dialogButton);
if (dialogResult==0)
hapus ();
else{
JOptionPane.showMessageDialog(null, "Batal Menghapus");
}
}
private void exitbtActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
System.exit(0);
}
private void newbtActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
kosong ();
bisa_isi();
deletebt.setEnabled(false);
txtno.requestFocus();
if (txtno.getText()=="")
savebt.setEnabled(false);
else {
savebt.setEnabled(true);
}
}
private void txtnoActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try {
Hasil = Pernyataan.executeQuery("Select * from inputbuku where"+
"No Buku='"+txtno.getText()+"'");
} catch (SQLException ex) {
Logger.getLogger(databuku.class.getName()).log(Level.SEVERE, null, ex);
try {
while (Hasil.next()){
txtjdl.setText(Hasil.getString("Judul"));
txtpeng.setText(Hasil.getString("Pengarang"));
txtpen.setText(Hasil.getString("Penerbit"));
txtjenis.setText(Hasil.getString("Penerbit"));
tombol_hidup();
} } catch (SQLException ex1) {
Logger.getLogger(databuku.class.getName()).log(Level.SEVERE, null, ex1);
}
JOptionPane.showMessageDialog(null, "Keterangan eror");
bisa_isi();
}
}
private void tblMouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
int tableBuku = tbl.getSelectedRow();
txtno.setText(tbl.getValueAt(tableBuku, 0).toString());
txtjdl.setText(tbl.getValueAt(tableBuku, 1).toString());
txtpeng.setText(tbl.getValueAt(tableBuku, 2).toString());
txtpen.setText(tbl.getValueAt(tableBuku, 3).toString())
txtpen.setText(tbl.getValueAt(tableBuku, 3).toString())
tombol_hidup();
ok
BalasHapus