Introduction

The JSE_Database class allows you to run queries on different databases by connecting using an ODBC connection string. This class can be instantiated or used in static mode

Manufacturers

JSE_Database(String connectionString, int databaseType)

• databaseType:
  • 0 = ODBC
  • 1 = OLEDB

var database = new JSE_Database("DSN=SQLODBC32", 1);

JSE_Database(String connectionString)

• databaseType: 0 by default = ODBC

var database = new JSE_Database("DSN=SQLODBC32");

Duties

Instanced Mode

executeRequest(String request): Array

This function allows you to execute the request request using the connection string passed as a parameter in the class’s constructor

var database = new JSE_Database("DSN=SQLODBC32");
var res = database.executeRequest("SELECT * FROM obp_document;");
var date = new Date(res[0]["creation_date"]);