Common-beanutils,common-collection, commons-digester,common- logging,groovy-all,iText,jasperreports
public class DatabaseConnection {
public static Connection getKoneksi(String host,
String port, String username, String password,
String db){
String konString = "jdbc:mysql://" + host
+ ":" + port + "/" + db;
Connection koneksi = null;
try {
[Link]("[Link]");
koneksi =
[Link](konString,
username, password);
[Link]("Koneksi Berhasil");
} catch (Exception ex) {
[Link]();
[Link](null,
"Koneksi Database Error");
koneksi = null;
}
DefaultTableModel dtm;
public void showData() {
String[] kolom = {"NO","Nama Pasien","Jenis
Kelamin","Alamat","Tgl Lahir", "No Telp"};
dtm = new DefaultTableModel (null, kolom);
try{
Statement stmt = [Link]();
String query = "SELECT * FROM pasien";
ResultSet rs = [Link](query);
int no = 1;
while ([Link]()){
String nopasien = [Link]("no_pasien");
String nama = [Link]("nm_pasien");
String jkel = [Link]("j_kel");
String alamat = [Link]("alamat");
String tgl = [Link] ("tgl_lahir");
String telepon = [Link] ("no_tlp");
[Link](new String []
{nopasien,nama,jkel,alamat,tgl,telepon});
no++;
}
} catch (SQLException ex) {
[Link]();
}
tbl_daftar.setModel(dtm);
}
Login Method
private boolean validate_login(String
username,String password) {
try{
[Link]("[Link]"); //
MySQL database connection
Connection conn =
[Link]("jdbc:mysql://
localhost/db_rekmed?" +
"user=root&password=");
PreparedStatement pst =
[Link]("Select * from login
where username=? and password=?");
[Link](1, username);
[Link](2, password);
ResultSet rs = [Link]();
if([Link]()){
return true;
}else{
return false;
}
}catch(Exception e){
[Link]();
private void
btnMasukActionLOGINPerformed([Link].
ActionEvent evt) {
if([Link]().length()==0)
[Link](null, "Field
Username Kosong");
else if([Link]().length==0)
[Link](null, "Field
Password Kosong");
else{
String user = [Link]();
char[] pass = [Link]();
String pwd = [Link](pass);
if(validate_login(user,pwd)){
[Link](null,
"Berhasil Login");
[Link](false);
FrmMainMenu_17 fm = new
FrmMainMenu_17();
[Link](true);
} else{
[Link](null,
"Username Atau Password Salah");}}}
private void
btnHapusActionPerformed([Link]
Event evt) {
String idWhoWantToBeDelete =
tbl_daftar.getValueAt(baris, 0).toString();
try {
Statement stmt =
[Link]();
String query = "DELETE FROM pasien
WHERE no_pasien =
'"+idWhoWantToBeDelete+"';";
int berhasil =
[Link](query);
if (berhasil == 1){
[Link](null,
"Data Berhasil Di Hapus");
[Link]().removeAllElements();
showData();
}else {
[Link](null,
"Data Gagal Di Hapus");
}
} catch(SQLException ex){
int baris;
private void
tbl_daftarMouseClicked([Link]
ent evt) {
// TODO add your handling code here:
baris = tbl_daftar.getSelectedRow();
}
