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());
}
}
}

What are the ddl statements?

904

---

How does jdbc driver work?

1030

---

How can you use preparedstatement in jdbc?

1041

---

What are 4 drivers available in JDBC? At what situation are four of the drivers used?

1006

---

What is a rollback in jdbc?

993

---

How can I instantiate and load a new CachedRowSet object from a non-JDBC source?

1028

---

How java can be connected to a database?

1156

---

How does jdbc work?

920

---

What is a java driver?

1066

---

What are the new features available in jdbc 4.0?

1013

---

What is a jdbc connection pool?

996

---

Does jpa use jdbc?

979

---

What is meant by jdbc and odbc?

941

---

What is the benefit of having jdbcrowset implementation?

984

---

Which type of JDBC driver is the fastest one?

1135

---