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; }