Creating PreparedStatements
Lines 31–32 invoke Connection
method prepareStatement to create the PreparedStatement
named selectAllPeople
that selects all the rows in the Addresses
table. Lines 35–36 create the PreparedStatement
named selectPeopleByLastName
with a parameter. This statement selects all the rows in the Addresses
table that match a particular last name. Notice the ?
character that’s used to specify the last-name parameter. Lines 39–42 create the PreparedStatement
named insertNewPerson
with four parameters that represent the first name, last name, email address and phone number for a new entry. Again, notice the ?
characters used to represent these parameters.
Get Java™ How To Program (Early Objects), Tenth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.