Đang chuẩn bị liên kết để tải về tài liệu:
Lecture Object Oriented Programing - Chapter 25: Accessing databases with JDBC

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 java.sql to access databases, to use the RowSet interface from package javax.sql to manipulate databases, to use JDBC 4.0’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 java.sql to access databases. To use the RowSet interface from package javax.sql to manipulate databases. To use JDBC 4.0’s automatic JDBC driver discovery. To use PreparedStatements to create precompiled SQL statements with parameters. How transaction processing makes database applications more robust. 25.1 Introduction 25.2 Relational Databases 25.3 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 java.sql to access databases. To use the RowSet interface from package javax.sql to manipulate databases. To use JDBC 4.0’s automatic JDBC driver discovery. To use PreparedStatements to create precompiled SQL statements with parameters. How transaction processing makes database applications more robust. 25.1 Introduction 25.2 Relational Databases 25.3 Relational Database Overview: The books Database 25.4 SQL 25.4.1 Basic SELECT Query 25.4.2 WHERE Claus 25.4.3 ORDER BY Claus 25.4.4 Merging Data from Multiple Tables: INNER JOIN 25.4.5 INSERT Statement 25.4.6 UPDATE Statement 25.4.7 DELETE Statement 25.5 Instructions for installing MySQL and MySQL Connector/J 25.6 Instructions for Setting Up a MySQL User Account 25.7 Creating Database book in MySQL 25.8 Manipulating Databases with JDBC 25.8.1 Connecting to and Querying a Database 25.8.2 Querying the books Database 25.9 RowSet Interface 25.10 Java DB/Apache Derby 25.11 PreparedStatements 25.12 Stored Procedures 25.13 Transaction Processing 25.14 Wrap-Up 25.15 Web Resources and Recommended Readings 25.1 Introduction Database Collection of data DBMS Database management system Storing and organizing data SQL Relational database Structured Query Language 25.1 Introduction (Cont.) RDBMS Relational database management system MySQL Open source Available for both Windows and Linux .