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 to move the cursor in scrollable resultset ?

1028

---

How do I insert/update records with some of the columns having NULL value?

932

---

Is jpa faster than jdbc?

882

---

What are the differences between setmaxrows(int) and setfetchsize(int)?

1063

---

What is a jdbc connection?

891

---

How many locking systems are there in jdbc?

1020

---

What is jdbc and why is it required?

922

---

Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?

1119

---

Explain the steps in writing a java program using jdbc?

932

---

What are the benefits of PreparedStatement over Statement?

1002

---

What do you mean by batch processing in jdbc?

1007

---

How can I get information about foreign keys used in a table?

965

---

Which package is used for jdbc application?

973

---

What is the JDBC?

1076

---

What is namedparameterjdbctemplate?

979

---