Example #1
0
 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
               + "'");
 }
Example #2
0
 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')");
 }
Example #3
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;
    }
  }
Example #4
0
  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;
  }
Example #5
0
 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;
 }
Example #6
0
 public void closeConnection() {
   db.closeConnection();
 }
Example #7
0
 // Cài đặt menu
 public void setMenu(int nBangghi, int ntrang) {
   db.setMenu(nBangghi, ntrang);
 }
Example #8
0
 public String getMenuPhanTrang() {
   return db.getMenuPhanTrang();
 }