Java Reference
In-Depth Information
The java.sql.DriverManager class can be used to obtain a connection to
a database. The java.sql.Connection interface represents the database
connection.
■■
The javax.sql.DataSource class can also be used to obtain a connection
to a database. This is the preferred technique when connecting to a
database from within a J2EE application or environment that provides
JNDI.
■■
SQL stands for Structured Query Language and is the language used by
most databases for accessing and updating data.
■■
There are three types of statements: simple statements, prepared state-
ments, and callable statements, which are used for stored procedures.
■■
The java.sql.Statement interface represents simple statements, the
java.sql.PreparedStatement interface represents prepared statements,
and the java.sql.CallableStatement interface represents callable state-
ments. Each of these is obtained using the Connection object.
■■
The java.sql.ResultSet interface represents a result set, the data returned
from an SQL query.
■■
