public ArrayList<LopMonHocEntity> getAllLopMonHoc() throws Exception {
ArrayList<LopMonHocEntity> arrLopMonHoc = new ArrayList<LopMonHocEntity>();
Statement stmt = null;
ResultSet rs = null;
Connection cn = null;
SimpleDateFormat format = new SimpleDateFormat("dd/MM/yyyy");
try {
cn = DBPool.getConnection();
stmt = cn.createStatement();
String SQL =
"SELECT LOPMONHOC.*, MONHOC.TenMonHoc, MONHOC.SoGio, LOPHOC.TenLop, GIOHOC.ThoiGian, PHONGHOC.TenPhongHoc FROM LOPMONHOC"
+ " INNER JOIN MONHOC ON LOPMONHOC.MaMonHoc = MONHOC.MaMonHoc"
+ " INNER JOIN LOPHOC ON LOPMONHOC.MaLop = LOPHOC.MaLop"
+ " INNER JOIN GIOHOC ON LOPMONHOC.MaGioHoc = GIOHOC.MaGioHoc"
+ " INNER JOIN PHONGHOC ON LOPMONHOC.MaPhong = PHONGHOC.MaPhongHoc";
rs = stmt.executeQuery(SQL);
while (rs.next()) {
LopMonHocEntity lopMonHoc = new LopMonHocEntity();
lopMonHoc.setIdLopMonHoc(Integer.parseInt(rs.getString(1)));
lopMonHoc.setMaMonHoc(rs.getString(2));
lopMonHoc.setMaLop(rs.getString(3));
lopMonHoc.setMaGioHoc(rs.getString(4));
lopMonHoc.setMaPhong(rs.getString(5));
lopMonHoc.setNgayBatDauHoc(rs.getDate(6));
lopMonHoc.setNgayBatDauHocView(format.format(rs.getDate(6)));
lopMonHoc.setNgayNghiDKBatDau(rs.getDate(7));
lopMonHoc.setNgayNghiDKBatDauView(format.format(rs.getDate(7)));
lopMonHoc.setNgayNghiDKKetThuc(rs.getDate(8));
lopMonHoc.setNgayNghiDKKetThucView(format.format(rs.getDate(8)));
lopMonHoc.setNgayHoc(rs.getString(9));
lopMonHoc.setGiangVien(rs.getString(10));
lopMonHoc.setNgayThiDuKienView(format.format(rs.getDate(11)));
lopMonHoc.setTenMonHoc(rs.getString(12));
lopMonHoc.setSoGio(Integer.parseInt(rs.getString(13)));
lopMonHoc.setTenLop(rs.getString(14));
lopMonHoc.setThoiGian(rs.getString(15));
lopMonHoc.setTenPhongHoc(rs.getString(16));
arrLopMonHoc.add(lopMonHoc);
}
} catch (Exception ex) {
throw ex;
} finally {
try {
DBPool.releaseConnection(cn, stmt, rs);
} catch (Exception e) {
throw e;
}
}
return arrLopMonHoc;
}
