TAILIEUCHUNG - 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 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:

• Kỹ thuật lập trình
• Object Oriented Programing
• Lecture Object Oriented Programing
• Programming languages
• Manipulating databases
• Database management system
• Structured Query Language
• Direct superclass
• Indirect superclass
• Software engineering
• Effect polymorphism
• Demonstrating polymorphic behavior
• Abstract classes
• Data hierarchy
• Class file
• Object serialization
• Class string
• Class character
• Concatenating strings
• Computer organization
• Early operating systems
• World Wide Web
• Java applications
• Displaying text
• Java application programming
• Instance variables
• Initializing Objects
• Primitive types
• Control statements
• Control structures
• Formulating algorithms
• Counter controlled repetition
• Program modules in Java
• Declaring methods
• Method overloading
• Declaring arrays
• Creating arrays
• Passing arrays to methods
• Controlling access
• Overloaded constructors
• Graphical user interfaces
• Look and feel observation
• Java coordinate system
• Graphics contexts
• Drawing Arcs
• Exception handling
• Java exception hierarchy
• Infinite recursion
• Recursive backtracking
• Searching algorithms
• Sorting algorithms
• Linear search
• Data structures
• Type wrapper classes
• Dynamic memory allocation
• Class arrays
• Collections algorithms
• Synchronized collections
• Loading images
• Displaying images
• Scaling images
• Pluggable look and feel
• Manipulate sliders
• Thread states
• Executing threads
• Thread synchronization