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 is jdbc in dbms?

961

---

what happen if we set JDBC string to NULL?

3344

---

What do you understand by jdbc statements?

976

---

What is metadata in jdbc?

933

---

What is the function of drivermanager class?

1048

---

If you are given a choice to implement the code to either insert a record or update if already exist, which approach will you follow ?

945

---

What does it mean to "materialize" data?

934

---

How do you determine the sensitivity of the ResultSet object?

929

---

What is jdbc? Describe the steps needed to execute a sql query using jdbc.

858

---

What is the function of setautocommit?

1162

---

What are the types of jdbc drivers that exist?

957

---

What is jdbc odbc driver?

991

---

How does a custom RowSetReader get called from a CachedRowSet?

1030

---

What are the considerations for deciding on transaction boundaries?

960

---

What are devices?

906

---