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