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

What are the common jdbc exceptions?

902

---

How can I retrieve a String or other object type without creating a new object each time?

1135

---

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

943

---

What is resultset in jdbc with example?

870

---

How does jdbc driver work?

925

---

What is meant by dao?

884

---

What is metadata in jdbc?

914

---

Is jdbc part of j2ee?

932

---

Is jdbc a framework?

843

---

What is a java driver?

931

---

How do java applications access the database using jdbc?

965

---

What is the difference between jdbc and jndi?

940

---

Can I enable requests to a jdbc connection pool for a database connection to wait until a connection is available?

840

---

What are the steps to connect to the database in java?

910

---

What is a statement?

960

---