>> Friday, April 8, 2011
Query Statement: This code segment creates a Statement object and calls the Statement.executeQuery method to select text from the dba database. The results of the query are returned in a ResultSet object. How to retrieve results from a ResultSet object is explained in Result Sets below.
Statement stmt = con.createStatement(); ResultSet results = stmt.executeQuery("SELECT TEXT FROM dba ");
Update Statement: This code segment creates a Statement object and calls the Statement.executeUpdate method to add an email address to a table in the dba database.
String updateString = "INSERT INTO dba VALUES (some text)"; int count = stmt.executeUpdate(updateString);