JDBC-Odbc Connectivity

The code illustrates an example from JDBC-ODBC Connectivity.

JDBC-Odbc Connectivity

JDBC-ODBC Connectivity

     

The code illustrates an example from JDBC-ODBC Connectivity. The code helps you in retrieve the name and size of the column. To understand this example we have  a class JdbcOdbcConnectivity ,the class include a main method ( ) follows a list of step in it -

   Importing a package java.sql,provides you a network interface for the interaction between front-end application in java and database in the backend.

   The first step inside the main method ( ) is to load a driver by calling class.forName ( ) by accepting driver class as argument.

   DriverManager.getConnection ( ) :The Driver Manager call getConnection ( ) returns you an object of connection class. This method is used to built a connection between url and database. The Connection object call createStatement ( ),this return you a sql object to send and execute SQL Statements in database. 

  

 executeQuery ( ) : This method return you a record set from a table using select query in sql.The obtained record set is stored in result set.

  get Metadata ( ) : This method return you the property of the column's data type, size, the methods, properties, and parameters of a component associated with object in an application.

  get ColumnCount ( ):  This method return you the number of column in a result set.

Finally the println print the column name

  get Column Display Size ( ): This method return you the designated column's normal maximum width in characters.

In case there exists an exception in try block, the catch block check and handle. the exception. JdbcOdbcConnectivity.java

import java.sql.*;



public class JdbcOdbcConnectivity {



  static private final String driver = "sun.jdbc.odbc.JdbcOdbcDriver";

  static private final String connection = "jdbc:odbc:emp";



  public static void main(String args[]) {



  Connection con = null;

  Statement st = null;

  ResultSet rs = null;

  ResultSetMetaData metaData = null;



  try {

  Class.forName(driver);

  con = DriverManager.getConnection(connection);



  st = con.createStatement();



  String sql = "select * from Employees";

  rs = st.executeQuery(sql);

  metaData = rs.getMetaData();



  int rowCount = metaData.getColumnCount();



  System.out.println("Table Name : " +

    metaData.getTableName(rowCount));



  System.out.println("Field\t\t" +"Type");

    System.out.println("--------------------");

  for (int i = 0; i < rowCount; i++) {

  System.out.print( metaData.getColumnName(i+1)+"\t");

 System.out.println(" "+metaData.getColumnDisplaySize(i+1));



  }



  con.close();

  } catch (Exception e) {

  System.out.println(e);

  }

  }

}
  

Output

rno	libno
1   	101
2   	102
3   	103
4   	104
5   	105
6   	106
7   	107
8   	108

Download code

Tutorials

  1. First Step towards JDBC
  2. Accessing the Database from Servlet
  3. Accessing Databases Using Java and JDBC
  4. First Step towards JDBC!
  5. First Step towards JDBC!
  6. Accessing Database from servlets through JDBC!
  7. JDBC, JDBC Tutorial, JDBC Tutorials
  8. What is JDBC?
  9. Product Components of JDBC
  10. Understanding the JDBC Architecture
  11. JDBC Driver and Its Types
  12. JDBC Versions
  13. Features of JDBC 3.0 API
  14. Features of JDBC 4.0
  15. Difference between JDBC 3.0 & JDBC 4.0
  16. Relational Database Concepts
  17. Understanding Common SQL statements
  18. Important JDBC Concepts
  19. Introduction to java.sql package
  20. Driver Manager Class
  21. Understanding Data Source
  22. Understanding Connection Object
  23. Mapping MySQL Data Types in Java
  24. Connecting to a MySQL Database in Java
  25. Creating a Database in MySQL
  26. Creating a Database Table
  27. Creating a MySQL Database Table to store Java Types
  28. Description of Database Table
  29. Deleting a Table from Database
  30. Retrieving Tables from a Database
  31. Inserting values in MySQL database table
  32. Retrieving All Rows from a Database Table
  33. Adding a New Column Name in Database Table
  34. Change Column Name of a Table
  35. Make Unique Column in Database Table
  36. Remove Unique Column in Database Table
  37. Arrange a Column of Database Table
  38. Arrange a Column of Database Table
  39. Sum of Column in a Database Table
  40. Deleting All Rows from a Database Table