Aplikasi Pemerintah pada Java Netbeans dengan Database MySql
Aplikasi Pemerintah pada Java Netbeans dengan Database MySql
Adapun form yang sudah saya buat seperti berikut:
1) Form Menu Utama
2) Form Login
3) Form Data Penduduk
4) Form Kritik & Saran
Mari kita lihat Source Code untuk Form Menu Utama :
private void btloginActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
new loginuas_1().show();
this.dispose();
}
private void btagendaActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
new agendaevent().show();
this.dispose();
}
private void btkritiksaranActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
new kritiksaran().show();
this.dispose();
}
Source code Form Log in :
private void btloginActionPerformed(java.awt.event.ActionEvent evt) {
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/loginuas", "root", "");
Statement stt = conn.createStatement();
ResultSet Result = stt.executeQuery("select * from isilogin where username='"+txtuser.getText()+"'");
if (Result.next()){
if (txtpass.getText().equals(Result.getString("Password"))){
new datapenduduk().show();
this.dispose();
}else {
JOptionPane.showMessageDialog(rootPane, "Password Salah");
txtpass.setText("");
txtuser.requestFocus();
}
}else{
JOptionPane.showMessageDialog(rootPane, "Username tidak ditemukan");
txtuser.setText("");
txtpass.setText("");
txtuser.requestFocus();
}
} catch (Exception e){
JOptionPane.showMessageDialog(rootPane, "Gagal");
}
}
private void btcancelActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
this.dispose();
}
Source Code Form Data Penduduk :
private void btsaveActionPerformed(java.awt.event.ActionEvent evt) {
try {
Class.forName("com.mysql.jdbc.Driver");
Connection connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/loginuas", "root", "");
Statement state = connect.createStatement();
String sql = "INSERT INTO inputdata VALUES('"+nama.getText()+ "','"+noktp.getText()+ "','"
+ttl.getText()+ "','"+jk.getSelectedItem()+"','"+almt.getText()+ "','"
+agama.getSelectedItem()+ "','"+status.getSelectedItem()+"','"+pk.getText()+ "','"+kw.getText()+ "')";
state.executeUpdate(sql);
JOptionPane.showMessageDialog(null, "Data berhasil disimpan di Database");
}catch (Exception e) {
JOptionPane.showMessageDialog(null, "Data gagal disimpan di Database" +e);
}
}
private void btrefreshActionPerformed(java.awt.event.ActionEvent evt) {
nama.setText("");
noktp.setText("");
jk.setSelectedItem("");
ttl.setText("");
almt.setText("");
agama.setSelectedItem("");
status.setSelectedItem("");
pk.setText("");
kw.setText("");
}
private void btexitActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
if(JOptionPane.showConfirmDialog(null, "Apakah anda yakin ingin keluar?", "Konfirmasi", JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE)==
JOptionPane.YES_OPTION){
System.exit(0);
}
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/loginuas", "root", "");
Statement stt = con.createStatement();
String cari = "select * from inputdata";
ResultSet rs = stt.executeQuery(cari);
if (rs.next()){
System.out.print(rs.getString(1));
nama.setText(rs.getString(1));
noktp.setText(rs.getString(2));
jk.setSelectedItem(rs.getString(3));
ttl.setText(rs.getString(4));
almt.setText(rs.getString(5));
agama.setSelectedItem(6);
status.setSelectedItem(7);
pk.setText(rs.getString(8));
kw.setText(rs.getString(9));
JOptionPane.showMessageDialog(null, "Data Ditemukan"+ rs.getString(1)+"");
}else{
JOptionPane.showMessageDialog(null, "Data Ditemukan");
}
}catch (Exception e){
JOptionPane.showMessageDialog(null, "Tidak Ditemukan"+e);
}
}
private void btupdateActionPerformed(java.awt.event.ActionEvent evt) {
try{
Class.forName("com.mysql.jdbc.Driver");
Connection connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/loginuas", "root", "");
Statement stat = connect.createStatement();
String sqlnya = "update inputdata set NamaLengkap='"+nama.getText()+
"',NoKTP='"+noktp.getText()+"',TempatTglLahir='"+ttl.getText()+
"',JenisKelamin='"+jk.getSelectedItem()+"',Alamat='"+almt.getText()+
"',Agama='"+agama.getSelectedItem()+"',StatusPerkawinan='"+status.getSelectedItem()+
"',Pekerjaan='"+pk.getText()+"',Kewarganegaraan='"+kw.getText()+"'";
stat.executeUpdate(sqlnya);
JOptionPane.showMessageDialog(null, "Data berhasil di update");
}catch (Exception e){
JOptionPane.showMessageDialog(null, "Data tidak berhasil di update");
}
}
Source Code Kritik & Saran :
private void btokActionPerformed(java.awt.event.ActionEvent evt) {
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/loginuas", "root", "");
Statement stt = con.createStatement();
String sqll = "insert into kritiksaran values('"+txtkritik.getText()+ "','"+txtsaran.getText()+"')";
stt.executeUpdate(sqll);
JOptionPane.showMessageDialog(null, "Terimakasih telah memberikan Kritik & Saran ");
} catch (Exception e){
JOptionPane.showMessageDialog(null, "Belum bisa memberikan Kritik & Saran "+e);
}
this.dispose();
}
Dan terakhir saya akan memberikan Screenshoot hasil running program Aplikasi Pemerintah ini, sebagai berikut :
isi Login sesuai database MySql yang sudah saya buat,
gambar running setelah klik tombol save
gambar running setelah klik tombol ok
Itulah hasil program Aplikasi Pemerintah yang berhasil saya buat, semoga bermanfaat....
Komentar
Posting Komentar