JDBC Oracle program

use this code

import java.sql.Connection;

import java.sql.Statement;

import java.sql.ResultSet;

import java.sql.DriverManager;

public class DemoForYou

{

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

{

//Establish the connection between java application and 
database software

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

//Register Driver with DriverManager service

Connection con=DriverManager.getConnection("jdbc:odbc:give your dsn","username","password");

//Send and execute query in database s/w

Statement st=con.createStatement();

//process the result

ResultSet rs=st.executeQuery("select * from stduent");

while(rs.next())

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

//close the jdbc objects

rs.close();

st.close();

con.close();

}//main

}//class

query of the application

SQL>create table student(sid number,sname varchar2(20),sadd varchar2(20));

table created

SQL> insert into student values(101,jack,hyderabad);
1 row updated


here 101=getInt(1)

     jack=getString(2)

     hyderabad=getString(2)