24.11 Wrap-Up
In this chapter, you learned basic database concepts, how to query and manipulate data in a database using SQL and how to use JDBC to allow Java applications to interact with Java DB databases. You learned about the SQL commands SELECT, INSERT, UPDATE and DELETE, as well as clauses such as WHERE, ORDER BY and INNER JOIN. You created and configured databases in Java DB by using predefined SQL scripts. You learned the steps for obtaining a Connection to the database, creating a Statement to interact with the database’s data, executing the statement and processing the results. Then you used a RowSet to simplify the process of connecting to a database and creating statements. You used PreparedStatements to create precompiled SQL statements. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access