Accessing Databases Using JDBC - Java Programming: Comprehensive Concepts and Techniques - page 773

3. Crossword Puzzle Challenge Click the Crossword Puzzle Challenge link
below Chapter 11. Read the instructions, and then enter your first and last
name. Click the Play button. Complete the crossword puzzle. When you are
finished, click the Submit button. When the crossword puzzle is displayed,
click the Print button.
4. Tips and Tricks Click the Tips and Tricks link below Chapter 11. Click a
topic that pertains to Chapter 11. Right-click the information and then click
Print on the shortcut menu. Construct a brief example of what the informa-
tion relates to in Java to confirm you understand how to use the tip or trick.
Hand in the example and printed information.
5. Newsgroups Click the Newsgroups link below Chapter 11. Click a topic that
pertains to Chapter 11. Print three comments.
6. Expanding Your Horizons Click the Expanding Your Horizons link below
Chapter 11. Click a topic that pertains to Chapter 11. Print the information.
Construct a brief example of what the information relates to in Java to con-
firm you understand the contents of the article. Hand in the example and
printed information.
7. Search Sleuth Select three key terms from the Key Terms section of this
chapter and then use the Google search engine at google.com (or any major
search engine) to display and print two Web pages for each key term.
Debugging Assignment
Find and fix the error in each line of code. Each line contains only one error.
Indented lines continue the previous statement.
1. forName("sun.jdbc.odbc.JdbcOdbcDriver");
2. String dbn = " AutoParts";
3. Connection con = getConnection(dbn);
4. Statement stmt = DriverManager.createStatement();
5. stmt.executeUpdate("CREATE TABLE StockItems itemID INT "
6. +"CONSTRAINT PK_Item PRIMARY, "
7. + "CONSTRAINT FK1_Item REFERENCES PartDesc (partno) "
8. +"qtyOnHand INT, price SINGLE, cost SINGLE");