public boolean updateQuanTri( String idQuanTri, String chinhanh, String tenTaiKhoan, String matKhau, String hoTen, String diaChi, String dienThoai, String email) { // TODO Auto-generated method stub return db.updateData( "update TAIKHOAN set MatKhau=N'" + matKhau + "',HoTen=N'" + hoTen + "',DiaChi=N'" + diaChi + "',DienThoai=N'" + dienThoai + "',Email='" + email + "' where TenTaiKhoan=N'" + tenTaiKhoan + "'") && db.updateData( "update QUANTRI set IdChiNhanh=N'" + chinhanh + "' where IdQuanTri=N'" + idQuanTri + "'"); }
public boolean addQuanTRi( String idQuanTri, String chinhanh, String tenTaiKhoan, String matKhau, String hoTen, String diaChi, String dienThoai, String email) { String sql = "insert into TAIKHOAN values(N'" + tenTaiKhoan + "', N'" + matKhau + "', N'" + hoTen + "', N'" + diaChi + "', N'" + dienThoai + "', N'" + email + "')"; String sql2 = "insert into QUANTRI values(N'" + idQuanTri + "', N'" + tenTaiKhoan + "', N'Quản lý', N'" + chinhanh + "')"; System.out.println(sql); System.out.println(sql2); return db.updateData( "insert into TAIKHOAN values(N'" + tenTaiKhoan + "', N'" + matKhau + "', N'" + hoTen + "', N'" + diaChi + "', N'" + dienThoai + "', N'" + email + "')") && db.updateData( "insert into QUANTRI values(N'" + idQuanTri + "', N'" + tenTaiKhoan + "', N'Quản lý', N'" + chinhanh + "')") && db.updateData("insert into KHACHHANG values (N'" + tenTaiKhoan + "','0')"); }
// 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; } }
public QUANTRI getQuanTri(String id) { // TODO Auto-generated method stub ResultSet rs = db.getResultSet( "select IdQuanTri,QuyenQuanTri,TAIKHOAN.TenTaiKhoan,MatKhau,HoTen,TAIKHOAN.DiaChi,DienThoai,Email,CHINHANH.IdChiNhanh,TenChiNhanh,CHINHANH.DiaChi" + " from QUANTRI join TAIKHOAN on QUANTRI.TenTaiKhoan=TAIKHOAN.TenTaiKhoan" + " join CHINHANH on QUANTRI.IdChiNhanh=CHINHANH.IdChiNhanh where IdQuanTri=N'" + id + "'"); QUANTRI quantri = new QUANTRI(); try { if (rs.next()) { quantri.setIdQuanTri(rs.getString(1)); quantri.setQuyenQuanTri(rs.getString(2)); quantri.setTaiKhoan( new TAIKHOAN( rs.getString(3), rs.getString(4), rs.getString(5), rs.getString(6), rs.getString(7), rs.getString(8))); quantri.setChiNhanh(new CHINHANH(rs.getString(9), rs.getString(10), rs.getString(11))); } } catch (SQLException e) { System.out.println(e.toString()); } return quantri; }
public String getIdQuanTri() { // TODO Auto-generated method stub ResultSet rs = db.getResultSet("select top 1 IdQuanTri from QUANTRI order by IdQuanTri desc"); String id = ""; int so = 0; try { if (rs.next()) { so = Integer.parseInt(rs.getString(1).substring(2)) + 1; id = "QT000".substring(0, 5 - ("" + so).length()) + so; } } catch (SQLException e) { System.out.println(e.toString()); } return id; }
public void closeConnection() { db.closeConnection(); }
// Cài đặt menu public void setMenu(int nBangghi, int ntrang) { db.setMenu(nBangghi, ntrang); }
public String getMenuPhanTrang() { return db.getMenuPhanTrang(); }