Transfer Excel data to oracle

Steps to Transfer excel sheet data to oracle database

1. create table in oracle database

    ex:

create table student

(

stdno int,

stdname varchar2(10),

stdadd varchar2(10)

)

2. Write This Program

import java.sql.*;

class class2

{

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

{

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

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection xcon=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","system123");

PreparedStatement ps=xcon.prepareStatement("insert into std1 values (?,?,?)");

System.out.println("Drivers are loaded");

Connection con=DriverManager.getConnection("jdbc:odbc:exe");

System.out.println("Connection is established");

Statement st=con.createStatement();

ResultSet rs=st.executeQuery("select * from [student$]");

while(rs.next())

{

int sno=rs.getInt(1);

String s2=rs.getString(2);

String s3=rs.getString(3);

ps.setInt(1,sno);

ps.setString(2,s2);

ps.setString(3,s3);

ps.executeUpdate();

}

con.close();

System.out.println("Data is Transfored");

}

}