STIKOM EL RAHMA
INFORMATIKA
MODUL PERKULIAHAN
BASIS DATA II
MEMBUAT FORM LOGIN, REGISTER DAN MENU
DENGAN JAVA NETBEANS – MYSQL / MARIADB
Ilham Aristanto, S.Kom., M.Kom.
1
1. Membuat tabel user pada database akademik
Pada database akademik, buatlah tabel dengan nama user :
CREATE TABLE USER (
id INT(10) NOT NULL,
nama VARCHAR(50) NOT NULL,
username VARCHAR(50) NOT NULL,
password VARCHAR(50) NOT NULL,
PRIMARY KEY (id)
);
2. Membuat Form Login pada package akademik
Klik kanan pada package akademik -> New -> JFrame Form
dengan nama Login / FormLogin
Sesuaikan Edit Text nya :
Label = FORM LOGIN
Label = USERNAME
Label = PASSWORD
Sesuaikan nama Variable nya :
Text Field = inputUSERNAME
Password Field = inputPASSWORD
Button = button_LOGIN
Button = button_EXIT
2
Input Syntax dibawah pada tab Source
note : text dengan label berwarna HIJAU tidak perlu di ketik karena sudah ada.
package akademik;
import java.awt.FlowLayout;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
import javax.swing.UIManager;
import javax.swing.plaf.FontUIResource;
import java.awt.FlowLayout;
public class Login extends javax.swing.JFrame {
public Statement st;
public ResultSet rs;
public DefaultTableModel tabModel;
Connection cn = koneksi.conn.conn();
public Login() {
initComponents();
}
3
Klik kanan button_EXIT -> Event -> Action -> actionPerformed
private void button_EXITActionPerformed(java.awt.event.ActionEvent evt) {
System.exit(0);
Klik kanan button_LOGIN -> Event -> Action -> actionPerformed
private void button_LOGINActionPerformed(java.awt.event.ActionEvent evt) {
try {
st = cn.createStatement();
rs = st.executeQuery("SELECT * FROM user WHERE
username='"+inputUSERNAME.getText()+"' AND
password='"+inputPASSWORD.getPassword()+"'");
if(rs.next()){
if(inputUSERNAME.getText().equals(rs.getString("username")) &&
inputPASSWORD. getPassword ().equals(rs.getString("password"))){
this.dispose();
JOptionPane.showMessageDialog(null, "Login Berhasil");
new Menu().setVisible(true);
}
} else {
JOptionPane.showMessageDialog(null, "Username atau Password Salah");
}
} catch (Exception e) {
JOptionPane.showMessageDialog(this, e.getMessage());
}
}
4
3. Membuat Form Register pada package akademik
Klik kanan pada package akademik -> New -> JFrame Form
dengan nama Register / FormRegister
Sesuaikan Edit Text nya :
Label = FORM REGISTER
Label = ID
Label = NAMA
Label = USERNAME
Label = PASSWORD
Sesuaikan nama Variable nya :
Text Field = input_ID
Text Field = input_NAMA
Text Field = input_USERNAME
Password Field = input_PASSWORD
Button = button_SAVE
Button = button_UPDATE
Button = button_DELETE
Button = button_RESET
Button = button_CLOSE
Table = tabel_REGISTER
5
package akademik;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
public class Register extends javax.swing.JInternalFrame {
public Statement st;
public ResultSet rs;
public DefaultTableModel tabModel;
Connection cn = koneksi.conn.conn();
public Register() {
initComponents();
judul();
tampilData("");
button_DELETE.setEnabled(false);
button_UPDATE.setEnabled(false);
6
7
Input Syntax dibawah pada tab Source
private void judul() {
Object[] judul = {
"ID", "NAMA", "USERNAME", "PASSWORD"
};
tabModel = new DefaultTableModel(null, judul);
tabel_REGISTER.setModel(tabModel);
}
public void tampilData(String where) {
try {
st = cn.createStatement();
tabModel.getDataVector().removeAllElements();
tabModel.fireTableDataChanged();
rs = st.executeQuery("SELECT * FROM user " + where);
while (rs.next()) {
Object[] data = {
rs.getString("id"),
rs.getString("nama"),
rs.getString("username"),
rs.getString("password"),
};
tabModel.addRow(data);
}
} catch(Exception e) {
e.printStackTrace();
}
}
public void reset() {
input_ID.setText("");
input_NAMA.setText("");
input_USERNAME.setText("");
input_PASSWORD.setText("");
}
8
Klik kanan button_SAVE -> Event -> Action -> actionPerformed
private void button_SAVEActionPerformed(java.awt.event.ActionEvent evt) {
try {
st = cn.createStatement();
st.executeUpdate("INSERT INTO user VALUES('" + input_ID.getText() + "','"
+ input_NAMA.getText() + "','"
+ input_USERNAME.getText() + "','"
+ input_PASSWORD.getText() + "')");
tampilData("");
JOptionPane.showMessageDialog(null, "Data Berhasil di Simpan");
input_ID.setText("");
input_NAMA.setText("");
input_USERNAME.setText("");
input_PASSWORD.setText("");
} catch (Exception e) {
e.printStackTrace();
}
9
Klik kanan button_UPDATE -> Event -> Action -> actionPerformed
private void button_UPDATEActionPerformed(java.awt.event.ActionEvent evt) {
try {
st = cn.createStatement();
st.executeUpdate("UPDATE user set "
+ "nama ='"+input_NAMA.getText()+"',"
+ "username ='"+input_USERNAME.getText()+"',"
+ "password ='"+input_PASSWORD.getText() + "'"
+ "where id ='"+input_ID.getText()+"'");
tampilData("");
JOptionPane.showMessageDialog(null, "Update Berhasil");
reset();
} catch (Exception e) {
e.printStackTrace();
}
10
Klik kanan button_DELETE -> Event -> Action -> actionPerformed
private void button_DELETEActionPerformed(java.awt.event.ActionEvent evt) {
try {
int jawab;
if ((jawab = JOptionPane.showConfirmDialog(null, "Ingin menghapus data?",
"konfirmasi", JOptionPane.YES_NO_OPTION)) == 0) {
st = cn.createStatement();
st.executeUpdate("DELETE FROM user WHERE id='"
+ tabModel.getValueAt(tabel_REGISTER.getSelectedRow(), 0) + "'");
tampilData("");
reset();
}
} catch (Exception e) {
e.printStackTrace();
}
11
Klik kanan button_RESET -> Event -> Action -> actionPerformed
private void button_RESETActionPerformed(java.awt.event.ActionEvent evt) {
reset();
button_SAVE.setEnabled(true);
Klik kanan button_CLOSE -> Event -> Action -> actionPerformed
private void button_CLOSEActionPerformed(java.awt.event.ActionEvent evt) {
this.dispose();
12
Klik kanan tabel_Register -> Event -> Mouse -> MouseClicked
private void tabel_REGISTERMouseClicked(java.awt.event.MouseEvent evt) {
input_ID.setText(tabel_REGISTER.getValueAt(tabel_REGISTER.getSelectedRow(),
0).toString());
input_NAMA.setText(tabel_REGISTER.getValueAt(tabel_REGISTER.getSelectedRow(),
1).toString());
input_USERNAME.setText(tabel_REGISTER.getValueAt(tabel_REGISTER.getSelectedR
ow(), 2).toString());
input_PASSWORD.setText(tabel_REGISTER.getValueAt(tabel_REGISTER.getSelected
Row(), 3).toString());
button_SAVE.setEnabled(false);
button_UPDATE.setEnabled(true);
button_DELETE.setEnabled(true);
13
4. Membuat Form Menu pada package akademik
Klik kanan pada package akademik -> New -> JFrame Form
dengan nama Menu / FormMenu
14
Sesuaikan nama Variable nya :
Menu = menuFILE
Menu = menuMASTER
Menu = menuTRANSAKSI
Menu = menuLAPORAN
Menu = menuTENTANG
Menu Item = menuLOGOUT
Menu Item = menuEXIT
Menu Item = menuFORMMAHASISWA
Menu Item = menuREGISTER
Desktop Pane = mainDESKTOP
15
package akademik;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
import java.awt.Font;
import javax.swing.JOptionPane;
import javax.swing.UIManager;
import javax.swing.plaf.FontUIResource;
import java.awt.FlowLayout;
import javax.swing.JFrame;
import javax.swing.JLabel;
public class Menu extends javax.swing.JFrame {
public Menu() {
initComponents();
this.setLocationRelativeTo(null);
}
16
Klik kanan menuLOGOUT -> Event -> Action -> actionPerformed
private void menuLOGOUTActionPerformed(java.awt.event.ActionEvent evt) {
this.dispose();
new Login().setVisible(true);
Klik kanan menuEXIT -> Event -> Action -> actionPerformed
private void menuEXITActionPerformed(java.awt.event.ActionEvent evt) {
System.exit(0);
Klik kanan menuFORMMAHASISWA -> Event -> Action -> actionPerformed
private void menuFORMMAHASISWAActionPerformed(java.awt.event.ActionEvent evt) {
FormMahasiswa mhs = new FormMahasiswa();
mainDESKTOP.add(mhs);
mhs.setVisible(true);
17
Klik kanan menuREGISTER -> Event -> Action -> actionPerformed
Private void menuREGISTERActionPerformed(java.awt.event.ActionEvent evt) {
Register login = new Register();
mainDESKTOP.add(login);
login.setVisible(true);
Klik kanan menuTENTANG -> Event -> Action -> actionPerformed
private void menuTENTANGMouseClicked(java.awt.event.MouseEvent evt) {
UIManager.put(
"OptionPane.messageFont",
new FontUIResource(new Font("Tahoma", Font.PLAIN, 12)));
JOptionPane.showMessageDialog(null, "Aplikasi Java\n"
+ "Ilham Aristanto", "Aplikasi Netbeans",
JOptionPane.INFORMATION_MESSAGE);
18
5. Ubah JFrame menjadi JInternalFrame pada FormMahasiswa dan FormRegister
FormMahasiswa
FormRegister
19
6. Hasil
20
21
