Membuat Login dengan Java Netbeans dan MySQL

Membuat program login dengan netbeans dimana user yang dapat mengakses aplikasi adalah user yang sudah terdaftar dalam databse, pada latihan kali ini kita akan buat dua buah form( login dan menu) dan ketika user mengentrikan user name dan password jika user dan password sudah ada dalam database maka akan memanggil form menu...
Latihan selanjutnya . . .

1. Buatlah database dan tabel terlebih dahulu : 
=> Disini Nama database nya adalah "user07".

2. Buka aplikasi Netbeans dan buat project baru dengan nama pustaka_keliling017, tambahkan class baru (jframe form) dengan nama login017 dan awal(Menu Utama).

3. Menambahkan library,
Pada project pustaka_keliling017, klik kanan pada libraries, add library, pilih MySQL JDBC Driver dan klik tombol Add Library...

Ketikan koding berikut pada class login...

package pustaka_keliling017;
import java.sql.*;
import javax.swing.*;
/**
 *
 * @author ANDESKB
 */
public class LOGIN017 extends javax.swing.JFrame {
public Connection conn;
public Statement cn;
String hakakses;
    /**
     * Creates new form LOGIN017
     */
    public LOGIN017() {
        initComponents();
        bersih();
        
    }
public void koneksi(){
try{
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/aplikasi_rental","root","");
cn = conn.createStatement();
}catch (Exception e){
JOptionPane.showMessageDialog(null,"koneksi gagal..");
System.out.println(e.getMessage());
}
}

public void cariuser(){
try{
koneksi();
String sql = "Select * from user017 where namauser='"+jTextField2.getText()+"' and password='" + jTextField3.getText() + "'";
ResultSet rs = cn.executeQuery(sql);
if (rs.next())
{
JOptionPane.showMessageDialog(null, "Sukses Bro.....!");
new AWAL().show();
this.dispose();
}
}catch (Exception e){
JOptionPane.showMessageDialog(null, "Ada Kesalahan");
}

}

public  void bersih(){

    jTextField2.setText("");

    jTextField3.setText("");

}

private void jTextField2ActionPerformed(java.awt.event.ActionEvent evt) {                                            

        // TODO add your handling code here:

       jTextField3.requestFocus();

    } 

 private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                         

        // TODO add your handling code here:

        dispose();

    }

private void jTextField3ActionPerformed(java.awt.event.ActionEvent evt) {                                            

        // TODO add your handling code here:

           jButton1.requestFocus();

    } 

 private void jButton1KeyPressed(java.awt.event.KeyEvent evt) {                                    

        // TODO add your handling code here:

        cariuser();

    }

 private void jLabel7MouseClicked(java.awt.event.MouseEvent evt) {                                     

        // TODO add your handling code here:

        new user017().show();

    } 

Jalankan program, isikan user dan password berdasarkan yang sudah kita isi tadi pada tabel user017, contoh (user : danny, password : java)..
Selamat mencoba kawan ....

Program Simpan, Edit, Hapus dan Cari dengan Java Netbeans dan MySQL

Pada latihan sebelumnya di project pustaka_keliling017, cara membuat login kita tambahkan tabel buku :

tambahkan sebuat class dengan nama mahasiswa, disain form seperti tampilan berikut :

Berikut Koding nya :

package pustaka_keliling017;
import java.sql.*;
import javax.swing.*;
import javax.swing.table.*;
/**
 *
 * @author ANDESKB
 */
public class buku017 extends javax.swing.JFrame {
public Connection conn;
public Statement cn;
    /**
     * Creates new form buku017
     */
    public buku017() {
        initComponents();
        bersih();
        tampil();
        pertama();
        jButton6.requestFocus();
    }

//prosedur koneksi
    public  void koneksi(){
    try{
        Class.forName("com.mysql.jdbc.Driver");
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/aplikasi_rental","root","");
        cn = conn.createStatement();
    }catch (Exception e){
        JOptionPane.showMessageDialog(null,"koneksi gagal..");
        System.out.println(e.getMessage());
        }
}
//prosedure bersih    
public  void bersih(){
    jTextField2.setText("");
    jTextField3.setText("");
    jTextField4.setText("");
    jTextField5.setText("");
    jTextField6.setText("");
}

//prosedur pertama tampil atau load
public void pertama(){
    jTextField2.setEditable(false);
    jTextField3.setEditable(false);
    jTextField4.setEditable(false);
    jTextField5.setEditable(false);
    jTextField6.setEditable(false);
    jButton1.setEnabled(false);
    jButton2.setEnabled(false);
    jButton4.setEnabled(false);
}

//prosedur no otomatis
public void noauto(){
    try{
koneksi();
String sql = "Select id as no from buku ORDER by id desc";
ResultSet rs = cn.executeQuery(sql);

if (rs.next())
{
int no_t = Integer.parseInt(rs.getString("no")) + 1;
jTextField2.setText(Integer.toString(no_t));
}
else{
int no_t = 001;
jTextField2.setText(Integer.toString(no_t));
}
rs.close();
}catch (Exception e){

}
}
//prosedur tambah baru
public void baru(){
    noauto();
    jTextField2.setEditable(false);
    jTextField3.setEditable(true);
    jTextField4.setEditable(true);
    jTextField5.setEditable(true);
    jTextField6.setEditable(true);
    jButton1.setEnabled(true);
    jButton2.setEnabled(false);
    jButton4.setEnabled(false);
}

//prosedur tampil
public  void tampil(){
    DefaultTableModel tabelModel=new DefaultTableModel();
    tabelModel.addColumn("ID Buku");
    tabelModel.addColumn("Judul Buku");
    tabelModel.addColumn("Penerbit");
    tabelModel.addColumn("Pengarang");
    
    try{
koneksi();
String sql = "Select * from buku order by id asc";
ResultSet rs = cn.executeQuery(sql);
while (rs.next())
{
tabelModel.addRow(new Object[]{
rs.getString(1),
rs.getString(2),
rs.getString(3),
rs.getString(4),
});
}
jTable2.setModel(tabelModel);

}catch (Exception e){
JOptionPane.showMessageDialog(null, "Ada Kesalahan");
}
}
//prosedur pencarian buku
public void caribuku(){
 DefaultTableModel tabelnyo = new DefaultTableModel();
tabelnyo.addColumn("id");
tabelnyo.addColumn("judul");
tabelnyo.addColumn("penerbit");
tabelnyo.addColumn("pengarang");
try{
koneksi();
String sql = "Select * from buku where id like '%" + jTextField6.getText() + "%'" +
"or judul like '%" + jTextField6.getText() +  "%'";
ResultSet rs = cn.executeQuery(sql);
while (rs.next()) {
tabelnyo.addRow(new Object[]{
rs.getString(1),
rs.getString(2),
rs.getString(3),
rs.getString(4)
});
}
jTable2.setModel(tabelnyo);

}catch (Exception e){
}

}

**koding simpan
    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        try{

koneksi();
String sql = "insert into buku values ('"+ jTextField2.getText()+"', '" + jTextField3.getText() + "' , '" + jTextField4.getText() + "' , '" + jTextField5.getText() + "')";
cn.executeUpdate(sql);
conn.close();

tampil();
bersih();
JOptionPane.showMessageDialog(null,"Data Berhasil di Simpan");

}catch (Exception e){
JOptionPane.showMessageDialog(null,"Proses penyimpanan gagal/koneksi gagal..");
System.out.println(e.getMessage());
}

    } 

** koding ubah
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here
        try{
koneksi();
String sql =( "update buku set judul='"+ jTextField3.getText() +"' ,penerbit='" + 
jTextField4.getText()+ "',pengarang='" + 
jTextField5.getText()+ "' where id='" + jTextField2.getText() + "'");
cn.executeUpdate(sql);
conn.close();

tampil();
bersih();
JOptionPane.showMessageDialog(null,"Data Berhasil Diubah ");
jButton1.setEnabled(true);
jButton2.setEnabled(false);
jButton4.setEnabled(false);
jTextField2.setEnabled(true);
}catch (Exception e){
JOptionPane.showMessageDialog(null,"Proses update gagal/koneksi gagal..");
System.out.println(e.getMessage());
}

    }   

** Koding hapus
 private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        try{

koneksi();
String sql = "delete from buku where id='"+ jTextField2.getText() +"'";
cn.executeUpdate(sql);
conn.close();

tampil();
bersih();
JOptionPane.showMessageDialog(null,"Data berhasil di Hapus");
jButton1.setEnabled(true);
jButton2.setEnabled(false);
jButton4.setEnabled(false);
jTextField2.setEnabled(true);
}catch (Exception e){
JOptionPane.showMessageDialog(null,"Proses hapus gagal/koneksi gagal..");
System.out.println(e.getMessage());
}

    }

**koding klik tabel
 private void jTable2MouseClicked(java.awt.event.MouseEvent evt) {                                     
        // TODO add your handling code here:
        int table = jTable2.getSelectedRow();
//mengambil data dari table
String a = jTable2.getValueAt(table, 0).toString();
String b = jTable2.getValueAt(table, 1).toString();
String c = jTable2.getValueAt(table, 2).toString();
String d = jTable2.getValueAt(table, 3).toString();

jTextField2.setText(a);
jTextField3.setText(b);
jTextField4.setText(c);
jTextField5.setText(d);

jTextField2.setEnabled(false);
jTextField3.requestFocus();
jButton1.setEnabled(false);
jButton2.setEnabled(true);
jButton4.setEnabled(true);
    }                                    


**pemanggilan  pencarian
    private void jTextField6KeyPressed(java.awt.event.KeyEvent evt) {                                       
        // TODO add your handling code here:
     caribuku();

    }     
**button bersih
 private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        bersih();
        jButton1.setEnabled(true);
jButton2.setEnabled(false);
jButton4.setEnabled(false);
jTextField2.setEnabled(true);
    }                                                                         
                              

    private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        baru();
    }                                        

    private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        dispose();
    }