![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]()
![]()
(chat, newsreader, calendar)
|
![]() |
|
Course Notes Table of Contents | Exercises JDBC Short Course Index | Online Training Index
|
Using MetaData |
Working Applet | Help Solution
|
PrerequisitesSkeleton CodeThe administration at MageLang University maintains a database of information about the course activities of the university's professors. This exercise results in an application that examines the different information kept for the university's instructors through the use of the ResultSetMetaData interface. This exercise uses the instructors table in the database.
Perform the following tasks:
Load the driver and connect to database. Create a Statement to perform a query. Execute the "select * from instructors" query. Get the metadata for the ResultSet. Examine the metadata to find out the number and datatype of columns, number of nullable columns, and number of numeric columns. You can discover more if you want to.
|
Copyright © 1997 MageLang Institute. All Rights Reserved May-97 Copyright © 1996, 1997 Sun Microsystems Inc. All Rights Reserved |