June 2017
Beginner
1296 pages
69h 23m
English
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. You incorporated a Swing JTable component into a JavaFX GUI via a SwingNode and used a TableModel to bind ResultSet data to the JTable.
Next, you used a RowSet ...