STIKOM EL RAHMA
INFORMATIKA
MODUL PERKULIAHAN
BASIS DATA II
MEMBUAT FORM LOGIN, REGISTER DAN MENU
DENGAN JAVA NETBEANS – MYSQL / MARIADB
Ilham Aristanto, [Link]., [Link].
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 [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
public class Login extends [Link] {
public Statement st;
public ResultSet rs;
public DefaultTableModel tabModel;
Connection cn = [Link]();
public Login() {
initComponents();
}
3
Klik kanan button_EXIT -> Event -> Action -> actionPerformed
private void button_EXITActionPerformed([Link] evt) {
[Link](0);
Klik kanan button_LOGIN -> Event -> Action -> actionPerformed
private void button_LOGINActionPerformed([Link] evt) {
try {
st = [Link]();
rs = [Link]("SELECT * FROM user WHERE
username='"+[Link]()+"' AND
password='"+[Link]()+"'");
if([Link]()){
if([Link]().equals([Link]("username")) &&
inputPASSWORD. getPassword ().equals([Link]("password"))){
[Link]();
[Link](null, "Login Berhasil");
new Menu().setVisible(true);
}
} else {
[Link](null, "Username atau Password Salah");
}
} catch (Exception e) {
[Link](this, [Link]());
}
}
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 [Link];
import [Link];
import [Link];
import [Link];
import [Link];
public class Register extends [Link] {
public Statement st;
public ResultSet rs;
public DefaultTableModel tabModel;
Connection cn = [Link]();
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 = [Link]();
[Link]().removeAllElements();
[Link]();
rs = [Link]("SELECT * FROM user " + where);
while ([Link]()) {
Object[] data = {
[Link]("id"),
[Link]("nama"),
[Link]("username"),
[Link]("password"),
};
[Link](data);
}
} catch(Exception e) {
[Link]();
}
}
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([Link] evt) {
try {
st = [Link]();
[Link]("INSERT INTO user VALUES('" + input_ID.getText() + "','"
+ input_NAMA.getText() + "','"
+ input_USERNAME.getText() + "','"
+ input_PASSWORD.getText() + "')");
tampilData("");
[Link](null, "Data Berhasil di Simpan");
input_ID.setText("");
input_NAMA.setText("");
input_USERNAME.setText("");
input_PASSWORD.setText("");
} catch (Exception e) {
[Link]();
}
9
Klik kanan button_UPDATE -> Event -> Action -> actionPerformed
private void button_UPDATEActionPerformed([Link] evt) {
try {
st = [Link]();
[Link]("UPDATE user set "
+ "nama ='"+input_NAMA.getText()+"',"
+ "username ='"+input_USERNAME.getText()+"',"
+ "password ='"+input_PASSWORD.getText() + "'"
+ "where id ='"+input_ID.getText()+"'");
tampilData("");
[Link](null, "Update Berhasil");
reset();
} catch (Exception e) {
[Link]();
}
10
Klik kanan button_DELETE -> Event -> Action -> actionPerformed
private void button_DELETEActionPerformed([Link] evt) {
try {
int jawab;
if ((jawab = [Link](null, "Ingin menghapus data?",
"konfirmasi", JOptionPane.YES_NO_OPTION)) == 0) {
st = [Link]();
[Link]("DELETE FROM user WHERE id='"
+ [Link](tabel_REGISTER.getSelectedRow(), 0) + "'");
tampilData("");
reset();
}
} catch (Exception e) {
[Link]();
}
11
Klik kanan button_RESET -> Event -> Action -> actionPerformed
private void button_RESETActionPerformed([Link] evt) {
reset();
button_SAVE.setEnabled(true);
Klik kanan button_CLOSE -> Event -> Action -> actionPerformed
private void button_CLOSEActionPerformed([Link] evt) {
[Link]();
12
Klik kanan tabel_Register -> Event -> Mouse -> MouseClicked
private void tabel_REGISTERMouseClicked([Link] 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 [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
public class Menu extends [Link] {
public Menu() {
initComponents();
[Link](null);
}
16
Klik kanan menuLOGOUT -> Event -> Action -> actionPerformed
private void menuLOGOUTActionPerformed([Link] evt) {
[Link]();
new Login().setVisible(true);
Klik kanan menuEXIT -> Event -> Action -> actionPerformed
private void menuEXITActionPerformed([Link] evt) {
[Link](0);
Klik kanan menuFORMMAHASISWA -> Event -> Action -> actionPerformed
private void menuFORMMAHASISWAActionPerformed([Link] evt) {
FormMahasiswa mhs = new FormMahasiswa();
[Link](mhs);
[Link](true);
17
Klik kanan menuREGISTER -> Event -> Action -> actionPerformed
Private void menuREGISTERActionPerformed([Link] evt) {
Register login = new Register();
[Link](login);
[Link](true);
Klik kanan menuTENTANG -> Event -> Action -> actionPerformed
private void menuTENTANGMouseClicked([Link] evt) {
[Link](
"[Link]",
new FontUIResource(new Font("Tahoma", [Link], 12)));
[Link](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