Answer Posted / n.gowtham raj

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:gowtham");
Statement st = con.createStatement
();
ResultSet rs = st.executeQuery
("select * from [Sheet1$]");

while(rs.next())
{
System.out.println
("USER ID:"+rs.getString("ID"));
}

rs.close();
st.close();
} catch (Exception ex) {
System.err.print("Exception: ");
System.err.println(ex.getMessage());
}
}
}

Step 1: goto control panel and select the Administrative
Tools and click the odbc driver.
Step 2: Then click the add button and select the microsoft
excel driver (".xls")
Step 3: then give the dsn name. (gowtham).
Step 4: then click the select workbook button and choose
the excel file then it work well.

What is jdbc driver in java?

970

---

Which jdbc driver type s is are the jdbc odbc bridge?

922

---

Explain how to make updates to the updatable resultsets.

969

---

When do we use execute method in java jdbc?

1024

---

Which type of driver is unique in jdbc?

1023

---

What is a datasource in java?

1008

---

How to connect multiple database in jdbc?

1147

---

How do we call a stored procedure from jdbc?

1022

---

Is jpa faster than jdbc?

925

---

How can I determine the isolation levels supported by my DBMS?

1036

---

How many types of statements are there in jdbc?

973

---

Why do you use a data source object for a connection?

1072

---

What is statement and resultset in jdbc?

1013

---

What does the jdbc resultsetmetadata interface?

994

---

What does the jdbc connection interface?

1033

---