Sams Teach Yourself EJB in 21 Days

Data Manipulation

After a connection is made to the data source, the JDBC API is furnished with comprehensive operations. Both DDL (Data Definition Language) and DML (Data Manipulation Language) operations are available. Metadata (information about the database itself) or the result set can also be queried.

Note

We assume that the reader is familiar with SQL fundamentals. For more coverage of SQL, we recommend you to refer to the book, Sams Teach Yourself SQL in 10 Minutes (ISBN: 0672321289).

A Statement object represents a SQL statement, and must be created from the Connection object. A Statement sends simple SQL statements to the database:

// Create a Statement object
java.sql.Statement stmt = conn.createStatement();

One of the powerful methods ...