Write a jdbc program to retrieve the data from excel?
import java.sql.*;
class XSelect {
public static void main(String[] args) {
try {
DriverManager.registerDriver(new
Sun.jdbc.odbc.JdbcOdbcDriver());
System.out.println("DRIVERS LOADED...");
Connection con = DriverManager.getConnection("jdbc:odbc:xldsn");
System.out.println("CONNECTION ESTABLISHED...");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from [student$]");
while (rs.next()) {
System.out.println(rs.getString(1) + " " + rs.getString(2) + " " + rs.getString(3));
}
con.close();
} catch (SQLException sqle) {
sqle.printStackTrace();
}
} // main
} // XSelect
import java.sql.*;
class XSelect {
public static void main(String[] args) {
try {
DriverManager.registerDriver(new
Sun.jdbc.odbc.JdbcOdbcDriver());
System.out.println("DRIVERS LOADED...");
Connection con = DriverManager.getConnection("jdbc:odbc:xldsn");
System.out.println("CONNECTION ESTABLISHED...");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from [student$]");
while (rs.next()) {
System.out.println(rs.getString(1) + " " + rs.getString(2) + " " + rs.getString(3));
}
con.close();
} catch (SQLException sqle) {
sqle.printStackTrace();
}
} // main
} // XSelect
No comments:
Post a Comment