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 about Join?

1016

---

What is jdbc odbc connection?

980

---

Is jdbc secure?

977

---

How can I get or redirect the log used by DriverManager and JDBC drivers?

935

---

What is getconnection method in java?

935

---

What is jdbc odbc bridge in java?

1077

---

What do you understand by DDL and DML statements?

921

---

What are the standard isolation levels defined by JDBC?

1132

---

Differentiate between a statement and a preparedstatement.

1023

---

Which jdbc driver type s is are the jdbc odbc bridge?

879

---

List the advantages of using datasource?

997

---

Why we use while rs next ())?

965

---

How can I determine the isolation levels supported by my DBMS?

991

---

What is JDBC PreparedStatement?

960

---

What are JDBC Best Practices?

1109

---