// Lấy danh sách các quảng cáo
public ArrayList<QUANGCAO> listAdv(int page, boolean hthi) {
ArrayList<QUANGCAO> listAdvertise = new ArrayList<QUANGCAO>();
String sql_select_advertise = "";
if (hthi)
sql_select_advertise = "SELECT * FROM quangcao where HienThi='1' order by IdQuangCao desc ";
else
sql_select_advertise = "SELECT * FROM quangcao where HienThi='0' order by IdQuangCao desc ";
db.createMenu("ListAdvertiseServlet?", page, sql_select_advertise);
ResultSet result_select = null;
if (page != -1) {
result_select =
db.getResultSet(
sql_select_advertise
+ " limit "
+ (page - 1) * db.getNBangGhi()
+ ","
+ db.getNBangGhi());
} else {
result_select = db.getResultSet(sql_select_advertise);
}
Calendar cal = Calendar.getInstance();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Calendar c1 = Calendar.getInstance();
Calendar c2 = Calendar.getInstance();
// Định nghĩa 2 mốc thời gian ban đầu
Date date2 = Date.valueOf(sdf.format(cal.getTime()));
c2.setTime(date2);
try {
while (result_select.next()) {
QUANGCAO advertise = new QUANGCAO();
advertise.setIdQuangCao(result_select.getInt("IdQuangCao"));
advertise.setViTri(result_select.getInt("ViTri"));
advertise.setTrangHienThi(result_select.getInt("TrangHienThi"));
advertise.setHienThi(result_select.getInt("HienThi"));
advertise.setLienKet(DinhDangSQL.FomatSQL(result_select.getString("LienKet")));
advertise.setHinhAnh(DinhDangSQL.FomatSQL(result_select.getString("HinhAnh")));
advertise.setSoNgay(result_select.getInt("SoNgay"));
advertise.setNgayDang(result_select.getDate("NgayDang").toString());
Date date1 = Date.valueOf(advertise.getNgayDang());
c1.setTime(date1);
advertise.setSoNgay(
advertise.getSoNgay()
- (int) (c2.getTime().getTime() - c1.getTime().getTime()) / (24 * 3600 * 1000));
advertise.setDonViQuangCao(result_select.getString("DonViQuangCao"));
listAdvertise.add(advertise);
}
return listAdvertise;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
}
