api db - SAP-archive/xsk GitHub Wiki

var db = $.db;

var response = $.response;

  

var tableName =  "USERS";

  

try  {

	var connection = db.getConnection();

	// Make sure to create the table only once
	connection.prepareStatement("CREATE TABLE "  + tableName +  " (NAME varchar(255), AGE int)").execute();

  

	var insertStatement = connection.prepareStatement("INSERT INTO "  + tableName +
		" (NAME, AGE) VALUES ('Bob', 20), ('Alice', 21);");

	insertStatement.executeUpdate();
	insertStatement.close();
	
	var selectStatement = connection.prepareStatement("SELECT * FROM "  + tableName);
	selectStatement.execute();

	var resultSet = selectStatement.getResultSet();

	var names =  [];

	while  (resultSet.next())  {
		names.push(resultSet.getString(1));
	}

	response.setBody(names.toString());

	selectStatement.close();

	resultSet.close();

}  catch(e)  {

	connection.rollback();

	response.setBody("Transaction was rolled back: "  + e.message);

}  finally  {

	connection.close();

}