public static CartItem fromResultSet(ResultSet resultSet) throws SQLException {
   CartItem cartItem = new CartItem();
   cartItem.setProductId(resultSet.getInt(resultSet.findColumn(COLUMN_ID_PRODUCT)));
   cartItem.setCartId(resultSet.getInt(resultSet.findColumn(COLUMN_ID_CART)));
   cartItem.setAmount(resultSet.getInt(resultSet.findColumn(COLUMN_AMOUNT)));
   return cartItem;
 }
Esempio n. 2
1
  public HashMap<String, Object> xoa() {
    if (id <= 0) return error("Bản ghi không tồn tại.");

    String sql = "SELECT * FROM sanpham WHERE id = '" + id + "';";
    try {
      ResultSet rs = statement.executeQuery(sql);
      if (rs.next()) {
        if (anh != null) {
          for (int i = 0; i < anh.size(); i++) {
            FileUploadUtil.deleteFile(anh.get(i).getAddUrl());
          }
        }
        sql = "DELETE FROM sanpham_anh WHERE sanpham_id = '" + rs.getInt(rs.findColumn("id")) + "'";
        preparedStatement = connection.prepareStatement(sql);
        preparedStatement.executeUpdate();

        sql = "DELETE FROM sanpham WHERE id = '" + rs.getInt(rs.findColumn("id")) + "';";
        preparedStatement = connection.prepareStatement(sql);
        int affectedRows = preparedStatement.executeUpdate();
        if (affectedRows != 0) {
          HashMap<String, Object> success = new HashMap<>();
          success.put("success", 1);
          success.put("error", 0);
          return success;
        } else {
          return error("Sảy ra lỗi.");
        }
      } else {
        return error("Bản ghi không tồn tại.");
      }
    } catch (SQLException ex) {
      Logger.getLogger(SanPham.class.getName()).log(Level.SEVERE, null, ex);
    }
    return error("Lỗi hệ thống.");
  }
Esempio n. 3
1
 private List getSegmentServices(Statement stmt, String instance) throws SQLException {
   List rtn = new ArrayList();
   ResultSet rs = null;
   try {
     // Discover tables
     rs = stmt.executeQuery(SEGMENT_QUERY);
     int segment_col = rs.findColumn("SEGMENT_NAME");
     int ts_col = rs.findColumn("TABLESPACE_NAME");
     while (rs.next()) {
       String segment = rs.getString(segment_col);
       String tablespace = rs.getString(ts_col);
       ServiceResource service = new ServiceResource();
       service.setType(this, SEGMENT);
       service.setServiceName(segment);
       service.setDescription("Segment in the " + instance + " database instance");
       ConfigResponse productConfig = new ConfigResponse();
       ConfigResponse metricConfig = new ConfigResponse();
       productConfig.setValue(OracleMeasurementPlugin.PROP_SEGMENT, segment);
       productConfig.setValue(OracleMeasurementPlugin.PROP_TABLESPACE, tablespace);
       service.setProductConfig(productConfig);
       service.setMeasurementConfig(metricConfig);
       service.setControlConfig();
       rtn.add(service);
     }
   } finally {
     DBUtil.closeResultSet(log, rs);
   }
   return rtn;
 }
Esempio n. 4
0
 public static User fromResultSet(ResultSet resultSet) throws SQLException {
   User user = new User();
   if (resultSet.next()) {
     user.setId(resultSet.getInt(resultSet.findColumn(COLUMN_ID)));
     user.setName(resultSet.getString(resultSet.findColumn(COLUMN_NAME)));
     user.setPassword(resultSet.getString(resultSet.findColumn(COLUMN_PASSWORD)));
     return user;
   } else {
     return null;
   }
 }
Esempio n. 5
0
  public HashMap<String, Object> sua() {
    if (id <= 0) return error("Bản ghi không tồn tại.");
    if (ten == null || mota == null || diaChi == null || trangThai == null)
      return error("Không thể gửi lên 1 giá trị \"null\", vui lòng kiểm tra lại.");
    if (ten.isEmpty() || mota.isEmpty() || diaChi.isEmpty() || trangThai.isEmpty())
      return error("Có vẻ như bạn chưa điền đầy đủ thông tin.");
    if (tinhThanh <= 0) return error("Bạn chưa chọn tỉnh thành.");
    if (gia <= 0) return error("Giá sản phẩm phải lớn hơn 0.");

    String sql = "SELECT * FROM sanpham WHERE id = '" + id + "';";
    try {
      ResultSet rs = statement.executeQuery(sql);
      if (rs.next()) {
        sql =
            "UPDATE sanpham SET ten=?, gia=?, mota=?, ngaycapnhat=GETDATE(), diachi=?, tinhthanh_id=?, trangthai=? WHERE id = '"
                + rs.getInt(rs.findColumn("id"))
                + "';";
        preparedStatement = connection.prepareStatement(sql);
        preparedStatement.setString(1, ten);
        preparedStatement.setLong(2, gia);
        preparedStatement.setString(3, mota);
        preparedStatement.setString(4, diaChi);
        preparedStatement.setInt(5, tinhThanh);
        preparedStatement.setString(6, trangThai);
        int affectedRows = preparedStatement.executeUpdate();
        if (affectedRows != 0) {
          sql =
              "SELECT a.*, b.ten as 'tentinhthanh', (SELECT ten FROM tinhthanh WHERE id = b.parent_id) as 'tenvungmien' FROM sanpham a INNER JOIN tinhthanh b ON a.tinhthanh_id = b.id WHERE a.id='"
                  + id
                  + "'";
          rs = statement.executeQuery(sql);
          if (rs.next()) {
            HashMap<String, Object> success = new HashMap<>();
            success.put("success", 1);
            success.put("error", 0);
            success.put("ngay_cap_nhat", rs.getString(rs.findColumn("ngaycapnhat")));
            success.put("ten_tinh_thanh", rs.getString(rs.findColumn("tentinhthanh")));
            success.put("ten_vung_mien", rs.getString(rs.findColumn("tenvungmien")));
            return success;
          }
        } else {
          return error("Sảy ra lỗi.");
        }
      } else {
        return error("Bản ghi không tồn tại.");
      }
    } catch (SQLException ex) {
      Logger.getLogger(SanPham.class.getName()).log(Level.SEVERE, null, ex);
    }

    return error("Lỗi hệ thống.");
  }
Esempio n. 6
0
 private List getTablespaceServices(Statement stmt, String instance) throws SQLException {
   List rtn = new ArrayList();
   ResultSet rs = null;
   try {
     // Discover tablespaces
     rs = stmt.executeQuery(TABLESPACE_QUERY);
     int ts_col = rs.findColumn("TABLESPACE_NAME");
     while (rs.next()) {
       String tablespace = rs.getString(ts_col);
       ServiceResource service = new ServiceResource();
       service.setType(this, TABLESPACE);
       service.setServiceName(tablespace);
       service.setDescription("Tablespace on the " + instance + " database instance");
       ConfigResponse productConfig = new ConfigResponse();
       ConfigResponse metricConfig = new ConfigResponse();
       productConfig.setValue(OracleMeasurementPlugin.PROP_TABLESPACE, tablespace);
       service.setProductConfig(productConfig);
       service.setMeasurementConfig(metricConfig);
       ConfigResponse svcProps = new ConfigResponse();
       // 9i and 10g only
       if (!getTypeInfo().getVersion().equals(VERSION_8i)) {
         svcProps.setValue("block_size", rs.getString("BLOCK_SIZE"));
         svcProps.setValue("allocation_type", rs.getString("ALLOCATION_TYPE"));
         svcProps.setValue("space_management", rs.getString("SEGMENT_SPACE_MANAGEMENT"));
       }
       svcProps.setValue("contents", rs.getString("CONTENTS"));
       svcProps.setValue("logging", rs.getString("LOGGING"));
       service.setCustomProperties(svcProps);
       rtn.add(service);
     }
   } finally {
     DBUtil.closeResultSet(log, rs);
   }
   return rtn;
 }
  // fetch all values from a table and a column
  // fill the ZaurusChoice zc with the row values for the Choice
  // and the column values as values
  private void fillZChoice(ZaurusChoice zc, String tab, String col) {

    try {
      if (cConn == null) {
        return;
      }

      Statement stmt = cConn.createStatement();
      ResultSet rs = stmt.executeQuery("SELECT * FROM " + tab + " ORDER BY " + col);
      ResultSetMetaData rsmd = rs.getMetaData();
      int numberOfColumns = rsmd.getColumnCount();
      int colIndex = rs.findColumn(col);

      while (rs.next()) {
        String tmp = "";

        for (int i = 1; i <= numberOfColumns; i++) {
          if (i > 1) {
            tmp += "; ";
          }

          tmp += rs.getString(i);
        } // end of for (int i=1; i<=numberOfColumns; i++)

        zc.add(tmp, rs.getString(colIndex));
      }

      rs.close();
    } catch (SQLException e) {
      System.out.println("SQL Exception: " + e.getMessage());
    } // end of try-catch
  }
  public static void main(String args[]) {
    try {
      String urlBD = "jdbc:odbc:FOSA";
      String usuarioBD = "SYSDBA";
      String passwordBD = "masterkey";
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection conexion = DriverManager.getConnection(urlBD, usuarioBD, passwordBD);
      Statement select = conexion.createStatement();
      ResultSet resultadoSelect = select.executeQuery("SELECT MAX(NUM_REG) AS numreg FROM FACT01");
      System.out.println("COMANDO EXITOSO");
      System.out.println("numreg");
      System.out.println("------");
      int col = resultadoSelect.findColumn("numreg");
      for (boolean seguir = resultadoSelect.next(); seguir; seguir = resultadoSelect.next())
        System.out.println(resultadoSelect.getInt(col));

      resultadoSelect.close();
      select.close();
      conexion.close();
    } catch (SQLException ex) {
      System.out.println("Error: SQLException");
      while (ex != null) {
        System.out.println(
            (new StringBuilder()).append("SQLState: ").append(ex.getSQLState()).toString());
        System.out.println(
            (new StringBuilder()).append("Mensaje: ").append(ex.getMessage()).toString());
        System.out.println(
            (new StringBuilder()).append("Vendedor: ").append(ex.getErrorCode()).toString());
        ex = ex.getNextException();
        System.out.println("");
      }
    } catch (Exception ex) {
      System.out.println("Se produjo un error inesperado");
    }
  }
Esempio n. 9
0
 public int resolveColumnPosition(String columnName) throws HibernateException {
   try {
     return resultSet.findColumn(columnName);
   } catch (SQLException e) {
     throw new HibernateException(
         "Could not resolve column name in result set [" + columnName + "]", e);
   }
 }
Esempio n. 10
0
 @Override
 public Date getDateOrNull(String columnName) {
   try {
     column = rs.findColumn(columnName) + 1;
     return toDate(rs, columnName);
   } catch (SQLException e) {
     throw new DatabaseException(e);
   }
 }
Esempio n. 11
0
 /**
  * 向聚合列的补列填充索引值.
  *
  * @param resultSet 结果集对象
  * @param aggregationColumns 聚合列集合
  * @throws SQLException SQL异常
  */
 public static void fillIndexesForDerivedAggregationColumns(
     final ResultSet resultSet, final Collection<AggregationColumn> aggregationColumns)
     throws SQLException {
   for (AggregationColumn aggregationColumn : aggregationColumns) {
     for (AggregationColumn derivedColumn : aggregationColumn.getDerivedColumns()) {
       derivedColumn.setIndex(resultSet.findColumn(derivedColumn.getAlias().get()));
     }
   }
 }
 @Override
 public int findColumn(String columnName) throws SQLException {
   try {
     return _res.findColumn(columnName);
   } catch (SQLException e) {
     handleException(e);
     return 0;
   }
 }
Esempio n. 13
0
 @Override
 public InputStream getBlobInputStreamOrNull(String columnName) {
   try {
     column = rs.findColumn(columnName) + 1;
     return rs.getBinaryStream(columnName);
   } catch (SQLException e) {
     throw new DatabaseException(e);
   }
 }
Esempio n. 14
0
 @Override
 public byte[] getBlobBytesOrNull(String columnName) {
   try {
     column = rs.findColumn(columnName) + 1;
     return rs.getBytes(columnName);
   } catch (SQLException e) {
     throw new DatabaseException(e);
   }
 }
Esempio n. 15
0
 @Override
 public BigDecimal getBigDecimalOrNull(String columnName) {
   try {
     column = rs.findColumn(columnName) + 1;
     return toBigDecimal(rs, columnName);
   } catch (SQLException e) {
     throw new DatabaseException(e);
   }
 }
Esempio n. 16
0
 @Override
 public Reader getClobReaderOrNull(String columnName) {
   try {
     column = rs.findColumn(columnName) + 1;
     return rs.getCharacterStream(columnName);
   } catch (SQLException e) {
     throw new DatabaseException(e);
   }
 }
Esempio n. 17
0
 @Nullable
 @Override
 public Boolean getBooleanOrNull(String columnName) {
   try {
     column = rs.findColumn(columnName) + 1;
     return toBoolean(rs, columnName);
   } catch (SQLException e) {
     throw new DatabaseException(e);
   }
 }
Esempio n. 18
0
 public ColumnInfo(ResultSet rs, int i, Calendar calendar, Format dateFormat, Format aorFormat)
     throws SQLException {
   m_fieldIndex = i;
   m_calendar = calendar;
   m_rsIndex = rs.findColumn(FIELDS[m_fieldIndex]);
   m_timestamp = TIME_FIELDS[m_fieldIndex];
   if (AOR_FIELDS[m_fieldIndex]) {
     m_format = aorFormat;
   } else if (TIME_FIELDS[m_fieldIndex]) {
     m_format = dateFormat;
   }
 }
Esempio n. 19
0
 @Override
 public String getClobStringOrNull(String columnName) {
   try {
     column = rs.findColumn(columnName) + 1;
     String result = rs.getString(columnName);
     if (result != null && result.length() == 0) {
       result = null;
     }
     return result;
   } catch (SQLException e) {
     throw new DatabaseException(e);
   }
 }
Esempio n. 20
0
 /** {@inheritDoc} */
 @Override
 public Object nullSafeGet(
     final ResultSet rs,
     final String[] names,
     final SessionImplementor session,
     final Object owner)
     throws SQLException {
   // Cf io.vertigo.dynamo.impl.database.vendor.core.SQLMappingImpl
   final String columnName = names[0];
   final int index = rs.findColumn(columnName);
   final DataStream value = SqlDataStreamMappingUtil.getDataStream(rs, index);
   return value;
 }
Esempio n. 21
0
 private ArrayList<Anh> getArrAnh(int sanPhamId) {
   ArrayList<Anh> data = new ArrayList<>();
   try {
     statement = connection.createStatement();
     String sql = "SELECT * FROM sanpham_anh WHERE sanpham_id = '" + sanPhamId + "';";
     ResultSet rs = statement.executeQuery(sql);
     while (rs.next()) {
       Anh anh =
           new Anh(
               rs.getInt(rs.findColumn("id")),
               rs.getString(rs.findColumn("url")),
               rs.getInt(rs.findColumn("sanpham_id")));
       // if(data.size()==0)
       // data.add(new Anh(-1, "default", sanPhamId));
       data.add(anh);
     }
     return data;
   } catch (SQLException ex) {
     Logger.getLogger(SanPham.class.getName()).log(Level.SEVERE, null, ex);
   }
   return data;
 }
Esempio n. 22
0
 /**
  * Suprime un répértoire dans la base de données.
  *
  * @param url
  */
 public static void deleteRepository(String url) {
   bd = new BDHelper();
   user.getRepos().remove(url);
   if (user.getPseudo() != null) {
     ResultSet result = bd.query("SELECT * FROM user WHERE login='******'");
     try {
       result.first();
       result =
           bd.query(
               "SELECT * FROM repository where id_user="******"id"))
                   + " AND repo_url='"
                   + url
                   + "'");
       result.first();
       bd.queryUpdate("DELETE FROM repository WHERE id=" + result.getInt(result.findColumn("id")));
     } catch (SQLException e) {
       e.printStackTrace();
     }
   }
   bd.close();
 }
Esempio n. 23
0
  /**
   * @param user_id
   * @return La liste des répértoire Git pour un utilisateur donné.
   */
  private static List<String> getRepository(int user_id) {
    List<String> rep = new ArrayList<String>();
    ResultSet result = bd.query("SELECT * FROM repository WHERE id_user="******"repo_url")));

      } while (result.next());
    } catch (SQLException e) {
      e.printStackTrace();
    }
    return rep;
  }
Esempio n. 24
0
  public static String getIPContainer(Connection con, String mail) {
    String recherche = "";
    try {
      Statement smt = con.createStatement();
      ResultSet resultset = smt.executeQuery("SELECT * FROM container WHERE email='" + mail + "' ");
      int nbr = 0;
      while (resultset.next()) {
        recherche = resultset.getString(resultset.findColumn("ip"));
      }

    } catch (SQLException ex) {
      Logger.getLogger(DatabaseManager.class.getName()).log(Level.SEVERE, null, ex);
    }
    return recherche;
  }
Esempio n. 25
0
 public AllTypeAttrs(ResultSet rs) throws SQLException {
   super();
   if (!m_indexed) {
     m_indexed = true;
     iATTR_NAME = rs.findColumn("ATTR_NAME");
     iATTR_NO = rs.findColumn("ATTR_NO");
     iATTR_TYPE_MOD = rs.findColumn("ATTR_TYPE_MOD");
     iATTR_TYPE_OWNER = rs.findColumn("ATTR_TYPE_OWNER");
     iATTR_TYPE_NAME = rs.findColumn("ATTR_TYPE_NAME");
     iLENGTH = rs.findColumn("LENGTH");
     iPRECISION = rs.findColumn("PRECISION");
     iSCALE = rs.findColumn("SCALE");
     iCHARACTER_SET_NAME = rs.findColumn("CHARACTER_SET_NAME");
   }
   attrName = rs.getString(iATTR_NAME);
   attrNo = rs.getInt(iATTR_NO);
   attrTypeMod = rs.getString(iATTR_TYPE_MOD);
   attrTypeOwner = rs.getString(iATTR_TYPE_OWNER);
   attrTypeName = rs.getString(iATTR_TYPE_NAME);
   attrLength = rs.getInt(iLENGTH);
   attrPrecision = rs.getInt(iPRECISION);
   attrScale = rs.getInt(iSCALE);
   characterSetName = rs.getString(iCHARACTER_SET_NAME);
 }
Esempio n. 26
0
 /**
  * Sauvegarde un nouveau répértoire dans la base de données.
  *
  * @param url
  */
 public static void saveRepository(String url) {
   bd = new BDHelper();
   user.getRepos().add(url);
   if (user.getPseudo() != null) {
     ResultSet result = bd.query("SELECT * FROM user WHERE login='******'");
     try {
       result.first();
       bd.queryUpdate(
           "INSERT INTO repository (id_user,repo_url) VALUES ("
               + result.getInt(result.findColumn("id"))
               + ",'"
               + url
               + "')");
     } catch (SQLException e) {
       e.printStackTrace();
     }
   }
   bd.close();
 }
Esempio n. 27
0
  /**
   * Vefifie que le login et le mot de passe est bien dans la base de données. Et met à jour la
   * liste des répértoires git.
   *
   * @param login
   * @param mdp
   * @return estConnecter
   */
  public static boolean connect(String login, String mdp) {

    bd = new BDHelper();
    ResultSet result =
        bd.query("SELECT * FROM User WHERE login = '******' AND mdp = '" + mdp + "'");

    try {
      if (result.next()) {
        List<String> rep = new ArrayList<String>();
        rep = getRepository(result.getInt(result.findColumn("id")));
        user = new User(login, rep);
        bd.close();
        return true;
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
    bd.close();
    return false;
  }
Esempio n. 28
0
  /** @throws Exception If failed. */
  public void testFindColumn() throws Exception {
    final ResultSet rs = stmt.executeQuery(SQL);

    assertNotNull(rs);
    assertTrue(rs.next());

    assert rs.findColumn("id") == 1;

    GridTestUtils.assertThrows(
        log,
        new Callable<Object>() {
          @Override
          public Object call() throws Exception {
            rs.findColumn("wrong");

            return null;
          }
        },
        SQLException.class,
        "Column not found: wrong");
  }
 public AllMethodResults(ResultSet rs) throws SQLException {
   super();
   if (!m_indexed) {
     m_indexed = true;
     iRESULT_TYPE_MOD = rs.findColumn("RESULT_TYPE_MOD");
     iRESULT_TYPE_OWNER = rs.findColumn("RESULT_TYPE_OWNER");
     iRESULT_TYPE_NAME = rs.findColumn("RESULT_TYPE_NAME");
     iCHARACTER_SET_NAME = rs.findColumn("CHARACTER_SET_NAME");
     iMETHOD_NAME = rs.findColumn("METHOD_NAME");
     iMETHOD_NO = rs.findColumn("METHOD_NO");
   }
   resultTypeMod = rs.getString(iRESULT_TYPE_MOD);
   resultTypeOwner = rs.getString(iRESULT_TYPE_OWNER);
   resultTypeName = rs.getString(iRESULT_TYPE_NAME);
   characterSetName = rs.getString(iCHARACTER_SET_NAME);
   methodName = rs.getString(iMETHOD_NAME);
   methodNo = rs.getString(iMETHOD_NO);
 }
Esempio n. 30
0
  public static String getBDD(Connection con, String mail) {
    String recherche = "";
    try {
      Statement smt = con.createStatement();
      ResultSet resultset = smt.executeQuery("SELECT * FROM members WHERE email='" + mail + "' ");
      int nbr = 0;
      recherche =
          "<div class=\"form-group\" align=\"center\">\n"
              + "                            <div><SELECT name=\"Bdd\" id=\"required\" align=\"center\">";
      recherche += "<option value=\"123456test**123456\" >Your databases</option>\n";
      while (resultset.next()) {
        String nom = resultset.getString(resultset.findColumn("bdd"));
        String s = "_";
        String s2 = "-";
        String s1 = "" + nom;
        if (s.equals(s1)) {
          // nothing rest = ".";
        } else if (s2.equals(s1)) {
          // nothing  rest = ".";
        } else {
          recherche += "<option VALUE=\"" + nom + "\">" + nom + "</option>\n";
        }
        nbr++;
      }
      if (nbr > 0) {
        recherche +=
            "</SELECT>\n"
                + "                            </div>\n"
                + "                        </div>";
      }

    } catch (SQLException ex) {
      Logger.getLogger(DatabaseManager.class.getName()).log(Level.SEVERE, null, ex);
    }
    return recherche;
  }