Friday, March 13, 2009

What is the normal procedure followed by a java client to access the

Question :What is the normal procedure followed by a java client to access the
db.? (JDBC)

Answer :The database connection is created in 3 steps:
1.Find a proper database URL (see FAQ on JDBC URL)
2.Load the database driver
3.Ask the Java DriverManager class to open a connection to your database
In java code, the steps are realized in code as follows:
1.Create a properly formatted JDBR URL for your database. (See FAQ on
JDBC URL for more information). A JDBC URL has the form
jdbc:someSubProtocol://myDatabaseServer/theDatabaseName 2.
Class.forName("my.database.driver");
3 . Connection conn = DriverManager.getConnection("a.JDBC.URL",
"databaseLogin","databasePassword");

No comments: