Answer Posted / vijay

import java.io.*;
import java.net.*;
import java.sql.*;
import java.util.*;

public class EmployeeReader1 {
public static void main(String[] args) {
Connection connection = null;
try {
Class.forName
("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager
.getConnection
("jdbc:odbc:friends_exl");
Statement st = con.createStatement
();
ResultSet rs = st.executeQuery
("Select * from [Sheet1$]");

ResultSetMetaData rsmd =
rs.getMetaData();
int numberOfColumns =
rsmd.getColumnCount();

System.out.println("No of cols " +
numberOfColumns);

while (rs.next()) {
for (int i = 1; i <=
numberOfColumns; i++) {
if (i > 1)

System.out.print(", ");
String columnValue
= rs.getString(i);
System.out.print
(columnValue);
}
System.out.println("");
}
rs.close();
st.close();
} catch (Exception ex) {
System.err.print("Exception: ");
System.err.println(ex.getMessage());
}
}
}

How does jdbc driver work?

924

---

If you are truncated using JDBC, how can you that how much data is truncated?

1003

---

How can I create a custom RowSetMetaData object from scratch?

933

---

What is odbc. how is it related to sql cli?

979

---

what happen if we set JDBC string to NULL?

3335

---

How to set NULL values in JDBC PreparedStatement?

927

---

What do you mean by two phase commits?

987

---

Why do I get UnsatisfiedLinkError when I try to use my JDBC driver?

965

---

Is jpa faster than jdbc?

839

---

How do I write Greek ( or other non-ASCII/8859-1 ) characters to a database?

940

---

DB2 Universal claims to support JDBC 2.0, But I can only get JDBC 1.0 functionality. What can I do?

913

---

What is the JDBC syntax for using a literal or variable in a standard Statement?

937

---

Why is jdbc needed?

857

---

What is the role of the jdbc drivermanager class?

881

---

How do you determine the sensitivity of the ResultSet object?

920

---