In this chapter you will learn: Relational database concepts, to use Structured Query Language (SQL) to retrieve data from and manipulate data in a database, to use the JDBC™ API of package to access databases, to use the RowSet interface from package to manipulate databases, to use JDBC ’s automatic JDBC driver discovery,. | 25 Accessing Databases with JDBC It is a capital mistake to theorize before one has data. Arthur Conan Doyle Now go, write it before them in a table, and note it in a book, that it may be for the time to come for ever and ever. The Holy Bible, Isaiah 30:8 Get your facts first, and then you can distort them as much as you please. Mark Twain I like two kinds of men: domestic and foreign. Mae West OBJECTIVES In this chapter you will learn: Relational database concepts. To use Structured Query Language (SQL) to retrieve data from and manipulate data in a database. To use the JDBC™ API of package to access databases. To use the RowSet interface from package to manipulate databases. To use JDBC ’s automatic JDBC driver discovery. To use PreparedStatements to create precompiled SQL statements with parameters. How transaction processing makes database applications more robust. Introduction Relational Databases Relational Database Overview: | 25 Accessing Databases with JDBC It is a capital mistake to theorize before one has data. Arthur Conan Doyle Now go, write it before them in a table, and note it in a book, that it may be for the time to come for ever and ever. The Holy Bible, Isaiah 30:8 Get your facts first, and then you can distort them as much as you please. Mark Twain I like two kinds of men: domestic and foreign. Mae West OBJECTIVES In this chapter you will learn: Relational database concepts. To use Structured Query Language (SQL) to retrieve data from and manipulate data in a database. To use the JDBC™ API of package to access databases. To use the RowSet interface from package to manipulate databases. To use JDBC ’s automatic JDBC driver discovery. To use PreparedStatements to create precompiled SQL statements with parameters. How transaction processing makes database applications more robust. Introduction Relational Databases Relational Database Overview: The books Database SQL Basic SELECT Query WHERE Claus ORDER BY Claus Merging Data from Multiple Tables: INNER JOIN INSERT Statement UPDATE Statement DELETE Statement Instructions for installing MySQL and MySQL Connector/J Instructions for Setting Up a MySQL User Account Creating Database book in MySQL Manipulating Databases with JDBC Connecting to and Querying a Database Querying the books Database RowSet Interface Java DB/Apache Derby PreparedStatements Stored Procedures Transaction Processing Wrap-Up Web Resources and Recommended Readings Introduction Database Collection of data DBMS Database management system Storing and organizing data SQL Relational database Structured Query Language Introduction (Cont.) RDBMS Relational database management system MySQL Open source Available for both Windows and Linux .
