public void loadDataKehadiran(DefaultTableModel namatabel) throws SQLException {
namatabel.getDataVector().removeAllElements();
namatabel.fireTableDataChanged();
sql =
"SELECT * tblkehadiran.tanggal, tbl_pegawai.nama, tbl_jabatan.jabatan, tblkehadiran.jmasuk, tblkehadiran.jkeluar "
+ "FROM tbl_pegawai "
+ "INNER JOIN tbl_jabatan ON tbl_pegawai.jabatan=tbl_jabatan.idjabatan "
+ "INNER JOIN tblkehadiran ON tbl_pegawai.idpegawai=tblkehadiran.idpegawai "
+ "GROUP BY tbl_pegawai.idpegawai "
+ "ORDER BY tblkehadiran.tanggal desc;";
pst = KoneksiDB.getConnect().prepareStatement(sql);
rs = pst.executeQuery(sql);
while (rs.next()) {
// lakukan penelusuran baris
Object[] o = new Object[5];
o[0] = rs.getDate("tanggal");
o[1] = rs.getString("nama");
o[2] = rs.getString("jabatan");
o[3] = rs.getTime("jmasuk");
o[4] = rs.getTime("jkeluar");
namatabel.addRow(o);
}
rs.close();
pst.close();
}
public int getTotalHari() throws SQLException {
sql = "SELECT * tanggal as tanggal_kerja " + "from tblkehadiran " + "group by tanggal;";
pst = KoneksiDB.getConnect().prepareStatement(sql);
rs = pst.executeQuery(sql);
int jumlah_hari = 0;
while (rs.next()) {
jumlah_hari += 1;
}
return jumlah_hari;
}
public int getTotalHadir() throws SQLException {
sql = "SELECT count(*) as total_hadir " + "from tblkehadiran;";
pst = KoneksiDB.getConnect().prepareStatement(sql);
rs = pst.executeQuery(sql);
int jumlah_hadir;
while (rs.next()) {
jumlah_hadir = rs.getInt("total_hadir");
return jumlah_hadir;
}
return 0;
}
public int getJumlahPegawai() throws SQLException {
sql = "SELECT Count(*) as jumlah_pegawai " + "from tbl_pegawai;";
pst = KoneksiDB.getConnect().prepareStatement(sql);
rs = pst.executeQuery(sql);
int jumlah;
while (rs.next()) {
jumlah = rs.getInt("jumlah_pegawai");
return jumlah;
}
return 0;
}
