Database.PreparedStatement

Description

A class for execution and manipulation of a database SQL statement.

The Database.PreparedStatement class is returned from the Database.Connection.prepareStatement() method. Calling this method creates a new PreparedStatement object. This object can be executed multiple times, and different values can be bound to named or numbered parameters in the statement.

Database.Connection con = Database.Connection("DBConnector1");
con.connect();
Database.PreparedStatement statement = con.prepareStatement("INSERT INTO customers (ID, FirstName, LastName) VALUES (:id, :firstName, :lastName)");
Table customers = Table("Customers");
for (int i = 1; i <= customers.numRows; i++) {
	statement.bindParam("id", customers[i]["ID"], Database.DataType.Int);
	statement.bindParam("firstName", customers[i]["FirstName"], Database.DataType.VarChar);
	statement.bindParam("lastName", customers[i]["LastName"], Database.DataType.VarChar);
	statement.execute();
}
con.disconnect();

Properties

Methods