JDBC basic example For Select Query

JDBC basic example For Select Query 

For explanation watch video: 

For Creating Table::

SQL> create table emp60(srno int,fname varchar2(10));

Table created.

SQL> desc emp60;

 Name                                      Null?    Type

 ----------------------------------------- -------- ----------------------------

 SRNO                                               NUMBER(38)

 FNAME                                              VARCHAR2(10)

SQL> insert into emp60 values(1,'allu');

1 row created.

SQL> insert into emp60 values(2,'vijay');

1 row created.

SQL> insert into emp60 values(3,'rajni');

1 row created.

SQL> select * from emp60;

      SRNO FNAME

---------- ----------

         1 allu

         2 vijay

         3 rajni

TO check Service Id:

SQL> commit;

Commit complete.

SQL> select * from global_name;

GLOBAL_NAME

--------------------------------------------------------------------------------

ORCL

JDBC Program::

===========

import java.sql.*;

import java.util.*;

import java.lang.*;

// Example 1: SQL SELECT

class Test

{

//classpath jar file set up

public static void main(String[] args)throws Exception{

//load the JDBC Driver

//11 

//Connection Obj

Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","system","tiger");

//JDBC Obj fro Statement

Statement st = con.createStatement();

//write the query

String query = "select * from emp60";

//create JDBC ResultSet obj

ResultSet rs = st.executeQuery(query);

while(rs.next()){

System.out.println(rs.getInt(1)+" "+rs.getString(2));

}

rs.close();

st.close();

con.close();

}

}