Ejemplo n.º 1
0
  public int selectInt(String query) {

    try {

      if (log != null) log.wl(query);

      Statement stmt = con.createStatement();
      ResultSet rs = stmt.executeQuery(query);

      if (rs.next() == false)
        throw new RuntimeException(
            "WConnection.selectInt() - No rows found for this query: " + query);

      int result = rs.getInt(1);

      rs.close();
      stmt.close();

      return result;

    } catch (SQLException e) {
      String message = "This query failed: " + query + "\n";
      throw new RuntimeException(message, e);
    }
  }
Ejemplo n.º 2
0
  public int executeUpdate(String query) {

    try {

      if (log != null) log.wl(query);

      Statement stmt = con.createStatement();
      int result = stmt.executeUpdate(query);

      stmt.close();

      return result;

    } catch (SQLException e) {
      String message = "This query failed: " + query + "\n";
      throw new RuntimeException(message, e);
    }
  }
Ejemplo n.º 3
0
  /** Execute a query on the database */
  public ResultSet executeQuery(String query) {

    try {

      if (log != null) log.wl(query);

      Statement stmt = con.createStatement();
      ResultSet result = stmt.executeQuery(query);

      // BUG
      // cannot be closed here, because RS becomes useless.
      // stmt.close();

      return result;

    } catch (SQLException e) {
      throw new RuntimeException("This query failed: " + query + "\n", e);
    }
  }