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 classes and methods used for sending sql statements to database?

1073

---

Describe how the jdbc application works.

1022

---

What is connection pooling and why it is used?

999

---

Is jdbctemplate thread safe?

901

---

What is jdbc url for mysql?

1026

---

How we can you use preparedstatement.

967

---

Does jdbctemplate close connection?

913

---

Is jdbc open source?

851

---

How can you know about drivers and database information ?

997

---

What is ODBC and JDBC? How do you connect the Database?

1038

---

Does jdbc require oracle client?

924

---

What is sqlwarning?

1003

---

What happens if connection is not closed in jdbc?

973

---

What does executequery return in java?

914

---

What is meant by dao?

931

---