Java Reference
In-Depth Information
What You Should Know
Having completed this chapter, you now should be able to perform the tasks
shown in Table 11-9.
Table 11-9
Chapter 11 What You Should Know
TASK NUMBER
TASK
PAGE
1
Open an Existing Java Program in TextPad
700
2
Implement the Serializable Interface
702
3
Register an ODBC Data Source Name
703
4
Open a New Java Program in TextPad
713
5
Load a JDBC™ Database Driver
714
6
Establish a JDBC™ Connection
716
7
Drop Indexes and Tables in a Database
718
8
Create Tables with Primary Keys
720
9
Create Tables with Foreign Keys
722
10
Create a Primary Key Index on an Existing Table
723
11
Create a PreparedStatement Object
724
12
Execute a PreparedStatement
725
13
Execute an SQL Query Statement
726
14
Process the ResultSet of a Query
728
15
Serialize an Object
730
16
Deserialize an Object
731
17
Create the StockTracker Database Tables
732
18
Open a New Java Program in TextPad
739
19
Create a Data Access Class Constructor
740
20
Close a Connection
741
21
Serialize and Deserialize Objects
742
22
Add Records to Database Tables
743
23
Update a Record in the Users Table
745
24
Delete a Record in the Stocks Table
746
25
Commit a Transaction to Delete Related Records
748
26
Delete a User Stock Holding
751
27
Obtain a Database Field Value
752
28
Obtain All Database Field Values
752
29
Obtain a List of Fields from Multiple Database
753
Records
30
Compile Related Classes
755
31
Test the StockTrackerDB Data Access Class
756
32
Print Source Code
765
33
Quit TextPad
765
Search WWH ::
Custom Search