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 steps to connect to the database in java?

978

---

What is a statement?

1016

---

How we store procedure in oralce for callable statements in jdbc

2335

---

Expalin the method of calling a stored procedure from jdbc.

973

---

What is sqlwarning?

1015

---

What is the advantage of namedparameterjdbctemplate?

964

---

When do we use execute method in java jdbc?

989

---

What is the return type of class.forname() method?

946

---

Explain how data flows from view to db and reverse

2050

---

What is jdbc vs odbc?

953

---

What is use of connection pooling?

963

---

Explain creation of statement object with connection method create method with help of an example.

977

---

What are the differences between resultset and rowset?

1131

---

Which jdbc drivers will run your program?

941

---

How can I determine where a given table is referenced via foreign keys?

1004

---