Answer Posted / amar

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 is odbc and jdbc?

998

---

Name the new features added in jdbc 4.0.

979

---

Compare jdbc and odbc and how is jdbc required in this context.

931

---

How to set the attribute concurrency in resultset?

926

---

What does the jdbc connection interface?

982

---

Why resultset is used in java?

929

---

Differentiate between type_scroll_insensitive and type_scroll_sensitive.

917

---

What is the role of the jdbc drivermanager class?

940

---

Result set’s index starts with 0 or 1?

1038

---

What is a jdbctemplate?

928

---

What protocol does jdbc use?

972

---

What do you mean by database connection pooling?

945

---

What does the jdbc resultsetmetadata interface?

945

---

Explain about DSN?

968

---

What is meant by jdbc and odbc?

896

---