* Copyright (c) 2011 Schneider Electric.
* DISCLAIMER: The sample code described herein is provided on an "as is" basis, without warranty of
* any kind, to the fullest extent permitted by law. Schneider Electric does not warrant or
* guarantee the individual success developers may have in implementing the sample code on their development
* platforms or in using their own Web server configurations.
* Schneider Electric does not warrant, guarantee or make any representations regarding the use,
* results of use, accuracy, timeliness or completeness of any data or information relating to the
* sample code. Schneider Electric disclaims all warranties, express or implied, and in particular,
* disclaims all warranties of merchantability, fitness for a particular purpose, and warranties related
* to the code, or any service or software related thereto.
* Schneider Electric shall not be liable for any direct, indirect or consequential damages or costs
* of any type arising out of any action taken by you or others related to the sample code.
* This script shows how to make a simple connection to an MS SQL database
* and read measurements using SQL
* The database drivers (JDBC drivers) should be loaded in the startup script. An example of this is available
* in the file databasedriver.js in the startup folder.
* This script assumes that the MS SQL database driver has been loaded.
// Make Java SQL classes available to the script
// Define connection properties
// The properties needed to connect to the database and the format of the connection URL differ
// between different database. Please consult the documentation of the JDBC driver for the database used
// for specific information on this matter
username = "user1";
password = "password1";
server = "220.127.116.11";
port = 1134;
databaseName = "sample";
connectionUrl = "jdbc:sqlserver://" + server + ":" + port + ";databaseName=" + databaseName + ";user=" + username + ";password=" + password + ";"// Create a connection to the database
connection = DriverManager.getConnection(connectionUrl);
// Create a statement to execute SQL
// The sample database contains the Measurements table with two columns: measurement_id and measurement_value
// We want to extract the value of the measurement with id 11111111
sql = "SELECT measurement_value FROM measurements WHERE measurement_id = '11111111'";
// Create and execute statement
statement = connection.createStatement();
result = statement.executeQuery(sql);
// Move cursor to first result and retrieve the value of measurement_value
value = result.getDouble("measurement_value");
// Return measurement
returnValue = value;