Submitted by
coderz

on
Wed, 06/17/2009 - 08:16

Type 4 drivers or Native protocol driver is known to be the one with the best features and functions. Type 4 driver does not have any native methods and is a complete Java driver. You need not to install it on the client before use and the can be easily downloaded or configured on a system very easily. One of the best features of Type 4 driver is that it interacts directly with the DBMS server.

Firstly, you need to register the type of driver that you are using by using the string,

Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);

And then connect to the database by use of the connection string:

Connection con = DriverManager.getConnection(url, uid, password);

Here, url is the JDBC url, uid is the username for the database and its password.

Example for Database connection:

1. import
   
   java.sql.Connection
   
   ;
   
2. import
   
   java.sql.DriverManager
   
   ;
   
3. import
   
   java.sql.SQLException
   
   ;
   
4. 
   
5. 
   
6. public
   
   class
   
   Hello {
   
7. static
   
   public
   
   void
   
   main(
   
   String
   
   args[
   
   ]
   
   )
   
   {
   
8. Connection
   
   connection =
   
   null
   
   ;
   
9. if
   
   (
   
   args.length
   
   !=
   
   4
   
   )
   
   {
   
10. System
    
    .out
    
    .println
    
    (
    
    "Incorrect Syntax!"
    
    )
    
    ;
    
11. return
    
    ;
    
12. }
    
13. try
    
    {
    
    // Loading driver
    
14. Class
    
    .forName
    
    (
    
    args[
    
    0
    
    ]
    
    )
    
    ;
    
15. }
    
16. catch
    
    (
    
    Exception
    
    e )
    
    {
    
    //Print error message if problem with driver loading
    
17. e.printStackTrace
    
    (
    
    )
    
    ;
    
18. return
    
    ;
    
19. }
    
20. try
    
    {
    
21. connection =
    
    DriverManager
    
    .getConnection
    
    (
    
    args[
    
    1
    
    ]
    
    , args[
    
    2
    
    ]
    
    , args[
    
    3
    
    ]
    
    )
    
    ;
    
22. System
    
    .out
    
    .println
    
    (
    
    "You have connected to the database successfully!"
    
    )
    
    ;
    
23. 
    
24. }
    
25. catch
    
    (
    
    SQLException
    
    e )
    
    {
    
26. e.printStackTrace
    
    (
    
    )
    
    ;
    
27. }
    
28. finally
    
    {
    
29. try
    
    {
    
30. connection.close
    
    (
    
    )
    
    ;
    
31. }
    
32. catch
    
    (
    
    SQLException
    
    e )
    
    {
    
33. e.printStackTrace
    
    (
    
    )
    
    ;
    
34. }
    
35. }
    
36. }
    

So, next time when you are planning for database programming then use JDBC in your application to make it simple and easy to use.