This section provides an overview of PreparedStatement.
If you have a SQL statement that needs to be executed multiple times, it is more efficient to use a JDBC PreparedStatement object to run it.
JDBC PreparedStatement class supports the following main features:
SQL statements PreparedStatement objects are pre-compiled on the database server side.
IN parameters are supported in SQL statements in PreparedStatement objects.
Batch execution mode is supported to run the run SQL statement multiple times in a single transaction.
A PreparedStatement object should be created from a Connection object with the prepareStatement() method and executed
like a regular Statement object as shown in the following program:
/**
* SqlServerPreparedSelect.java
* Copyright (c) 2007 by Dr. Herong Yang. All rights reserved.
*/
import java.sql.*;
public class SqlServerPreparedSelect {
public static void main(String [] args) {
Connection con = null;
try {
com.microsoft.sqlserver.jdbc.SQLServerDataSource ds
= new com.microsoft.sqlserver.jdbc.SQLServerDataSource();
ds.setServerName("localhost");
ds.setPortNumber(1269);
ds.setDatabaseName("AdventureWorksLT");
ds.setUser("Herong");
ds.setPassword("TopSecret");
con = ds.getConnection();
// PreparedStatement for SELECT statement
PreparedStatement sta = con.prepareStatement(
"SELECT * FROM Profile WHERE ID = 2");
// Execute the PreparedStatement as a query
ResultSet res = sta.executeQuery();
// Get values out of the ResultSet
res.next();
String firstName = res.getString("FirstName");
String lastName = res.getString("LastName");
System.out.println("User ID 2: "+firstName+' '+lastName);
// Close ResultSet and PreparedStatement
res.close();
sta.close();
con.close();
} catch (Exception e) {
System.err.println("Exception: "+e.getMessage());
e.printStackTrace();
}
}
}
The output looks correct:
C:\>javac -cp .;\local\lib\sqljdbc.jar SqlServerPreparedSelect.java
C:\>java -cp .;\local\lib\sqljdbc.jar SqlServerPreparedSelect
User ID 2: Janet Gates
