// 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
// 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