Sunday, October 21st, 2007
create these kinds of object-oriented/relational bridges. Moreover, there are several solutions being developed to work specifically with Java. I ve given you an idea of what ORM is all about. If you would like to investigate this topic further, check out The Coriolis Group Web site (http://www.coriolis.com/jdbc- book) for links to ORM vendors and some really informative ORM documents. The ODMG (Object Database Management Group) is a consortium that is working on a revised standard for object database technology and the incorporation of this concept into programming languages such as Java. A link to the consortium s Web site can be found on The Coriolis Group Web site as well. Summary As you can see from this brief chapter, mapping SQL data types to Java is truly a snap. We covered a few of the more important methods you will use to retrieve data from a database. For a complete reference, see Chapter 12 and have a look at the Date, Time, TimeStamp, Types, and Numeric classes. The next chapter steps back from the JDBC to look at ways of presenting your data in Java. Using Java packages available on the Net, we ll cover graphs, tables, and more. We ll also discuss some nifty methods in the JDBC that will help streamline your code for retrieving data from your database. Chapter 7 Working With Query Results So far, we ve been concentrating on how to use the classes in the JDBC to perform SQL queries. That s great, but now we have to do something with the data we ve retrieved. The end user of your JDBC applets or applications will want to see more than just rows and rows of data. In this chapter, we ll learn how to package the raw table data that is returned after a successful SQL query into a Java object, and then how to use this packaged data to produce easy-to-read graphs. The first issue we ll look at is creating a Java object to store the results of a query. This object will provide a usable interface to the actual query results so they can be plugged into a Java graphics library. We ll create a simple data structure to hold the column results in a formatted way so that we can easily parse them and prepare them for display. Second, we ll look at taking these results in the Java object and setting up the necessary code to plug the data into a pie chart and bar graph Java package. In the next chapter, we ll go one step further and work with BLOB data types (like images). Between these chapters, I will be providing plenty of examples, complete with code, to help you work up your own JDBC programs. At the very least, these chapters will give you some ideas for dealing with raw table data and displaying it in an effective manner.
Our Colorado hosting facilities are located in Little Rock, Colorado. Colorado web hosting datacenter which we have is linked on five major US backbones which gives you assurance that your site will be online 24/7 a day. More details you can find out in Web Hosting Colorado part.