Sunday, November 2, 2008

lecture 6

Assume that there is a large software company developing an application that retrieves data from five different database systems such as Oracle, and SQL Server. Each of these databases have their own API to store and retrieve data. Currently the application has five separate modules dealing with connections to these databases. This has resulted in maintenance problems (such as upgrading the connection code whenever a database API changed). You are a consultant who can offer a solution to this problem. What would you recommend? Justify your answer.

JDBC provides a standard API for programmers and makes it possible to write database applications using a pure java API.you can write a single program using the JDBC API, and the
program will be able to send SQL statements to any database system for which an appropriate JDBC driver has been written.

No comments: