Answer Posted / sushant

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String myDB = "jdbc:odbc:Driver={Microsoft Excel Driver
(*.xls)};DBQ=c:/java/scratch/jdbc_test.xls;"
+ "DriverID=22;READONLY=false";
Connection conn = DriverManager.getConnection(myDB, "", "");

Write a program JDBCcode forfetching student database with SQL.

1066

---

What is jdbc type?

846

---

Is it possible to connect to multiple databases? Using single statement can we update or extract data from two or three or many databases?

1026

---

How can I use the JDBC API to access a desktop database like Microsoft Access over the network?

962

---

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

939

---

What is the use of jdbc?

940

---

What are the standard isolation levels defined by JDBC?

1027

---

What are database warnings in jdbc and how can we handle database warnings in jdbc?

943

---

What are different parts of a url?

895

---

How can we execute stored procedures using callablestatement?

884

---

What is the role of class.forname while loading drivers?

940

---

What are the different types of locking in JDBC?

949

---

What is the use of callablestatement? Name the method, which is used to prepare a callablestatement.

835

---

What is com mysql jdbc driver?

874

---

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

1003

---