Java

Display records from database using JDBC

Introduction 

 
In this blog we will know how to display records from database using JDBC (Java Database Connectivity) in the console window.
Here we use Type-1 driver (JDBC-ODBC bridge)
 

Creation of dsn(database source name) for Oracle

 
Start-Control panel- Administrative Tools- Data Sources (ODBC)-go to system DSN tab-click add button-select a driver for which you want to set up a data source (for Oracle- Oracle in XE)-select it and click finish-give any name in the data source name textbox-then click ok button.
Note: - Here Username=system, Password=pintu and DSN name=dsn1
 

Table Creation

 
Create table employee (empno int,empname varchar(50),sal int)
 

Example:- To select a record from a table 

  1. /*To select record from a table by using Statement*/    
  2. import java.sql.*;    
  3. public class select    
  4. {    
  5.  public static void main(String args[]) throws Exception {    
  6.   //Step-1      
  7.   //load the class for driver      
  8.   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");    
  9.   //Step -2      
  10.   Connection con = DriverManager.getConnection("jdbc:odbc:dsn1", "system", "pintu");    
  11.   //Step -3      
  12.   System.out.println("Connected to database");    
  13.   Statement stmt = con.createStatement();    
  14.   //Step-4      
  15.   ResultSet rs = stmt.executeQuery("select * from employee");    
  16.   //Fetching data from ResultSet and display      
  17.   while (rs.next())    
  18.   {    
  19.    //to fetch value from a column having number type of value      
  20.    int x = rs.getInt("empno");    
  21.    //to fetch value from a column having varchar/text type of value      
  22.    String y = rs.getString("empname");    
  23.    //to fetch value from a column having number type of value      
  24.    int z = rs.getInt("sal");    
  25.    System.out.println(x + "   " + y + " " + z);    
  26.   }    
  27.   //Step-5      
  28.   con.close();    
  29.  }    
  30. }     

Compile

 
Javac select.java
Java select
Membership not found