Database - Statement

Steps

1. Create a project database.
2. Then create a JavaScript service named database-basic.js.
3. Within the service code, enter the following content:

var database = require("db/v4/database");
var response = require("http/v4/response");

var connection = database.getConnection();
try {
  var statement = connection.prepareStatement(
    "select * from DIRIGIBLE_EXTENSIONS where EXTENSION_EXTENSIONPOINT_NAME = ?"
  );
  var i = 0;
  statement.setString(++i, "ide-view");
  var resultSet = statement.executeQuery();
  while (resultSet.next()) {
    response.println(
      "[location]: " + resultSet.getString("EXTENSION_LOCATION")
    );
  }
  resultSet.close();
  statement.close();
} catch (e) {
  console.trace(e);
  response.println(e.message);
} finally {
  connection.close();
}

response.flush();
response.close();

---

For more information, see the API documentation.