Search Records using Jdbc

In this blog we will know how to find the related records from the table when we enter one field value in console.

Introduction 

 

In this blog, we will know how to find the related records from the table when we enter one field value in the console.

 

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 with valuesb

1. create table emp(empno int,empname varchar(50),sal int,job varchar(50))  
2. insert into emp values(1,'Raj',10000,'Manager')  
3. insert into emp values(2,'Ravi',20000,'Director')=  
4. insert into emp values(3,'Rahul',30000,'Producer')  

SearchRecords.java

import java.sql.*;
import java.util.*;
public class SearchRecords {
 public static void main(String args[]) throws Exception {
  int eno, esal;
  String ename, job;
  char ch = 'c';
  Scanner sc = new Scanner(System.in);
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection con = DriverManager.getConnection("jdbc:odbc:dsn1", "system", "pintu");
  ResultSet rs;
  Statement stmt = con.createStatement();
  do {
   System.out.print("\nEnter the Employee Number : ");
   eno = sc.nextInt();
   rs = stmt.executeQuery("select * from emp where empno like " + eno);
   rs.next();
   ename = rs.getString("empname");
   job = rs.getString("job");
   System.out.println("\nNAME: " + ename + " ENO: " + eno + " Job: " + job);
   System.out.println("\nPress any key to quit or c to continue :");
   ch = (char) System.in.read();
  }
  while (ch == 'c' || ch == 'C');
  con.close();
 }
}

Compile

 

Javac SearchRecords.java

 

Java SearchRecords