Answer Posted / r.salimulla baba

import java.util.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Connect extends HttpServlet
{
public void service(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException
{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
Connection con=null;
Statement st=null;
PreparedStatement pst=null;
ResultSet rs;
try
{
Class.forName
("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection
("jdbc:odbc:Std","","");
st=con.createStatement();
rs=st.executeQuery("select * from
[ExcelSheetName$]");
while(rs.next())
{
out.println(rs.getString
(1));
out.println(rs.getString
(2));
out.println(rs.getString
(3));
}
}
catch(Exception e)
{
System.out.println("Errr :"+e);
}
}
}

Explain the role of driver in jdbc.

751

---

What is the difference between client and server database cursors?

784

---

What are the differences between statement and preparedstatement interface?

708

---

How can we execute stored procedures using callablestatement?

666

---

Define preparedstatement.

711

---

What causes no suitable driver error?

717

---

What are the common JDBC problems that you got and how do you solved them?

2135

---

What is metadata in jdbc?

643

---

How can I connect mysql or oracle with java?

695

---

Which interface handles transaction management in jdbc?

783

---

What is the use of getGeneratedKeys() method in Statement?

739

---

Does the JDBC-ODBC Bridge work with Microsoft J++?

2040

---

What are the different types of locking in JDBC?

737

---

What is sqlwarning?

726

---

What does the jdbc driver interface do?

708

---