Saturday, August 22, 2015

jdbc program for accesing data from Excel Sheet

// JDBC to EXCEL
// Excel data being printed in Java
import java.sql.*;
import java.io.*;

class ExcelTest
{
   public static void main(String a[])
   {
       try
       {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           Connection con;
           con = DriverManager.getConnection("jdbc:odbc:xlsdsn");
           Statement st;
           st = con.createStatement();
           ResultSet rs;
           rs = st.executeQuery("Select * from [student$]");
              
            while(rs.next())
            {
    System.out.print(rs.getInt(1) + "  ");
    System.out.print(rs.getString("sname") + "  ");
    System.out.println(rs.getString("sadd"));
             }
             rs.close();
             st.close();
             con.close();
         } // try
catch(ClassNotFoundException ce)
{
   ce.printStackTrace();
 }
catch(SQLException se)
{
    se.printStackTrace();
}
catch(Exception e)
       {
    e.printStackTrace();
       }
     } // main
 } // class

No comments:

Post a Comment