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 a jdbc connection?

943

---

What is jdbc url for mysql?

1083

---

What are the packages are used in jdbc?

1097

---

What are the main components of JDBC ?

1109

---

What are jdbc?

1013

---

How many types of jdbc drivers are available?

984

---

password, is stored in as plain text. What can I do to protect my passwords?

1017

---

What is JDBC Transaction Management and why do we need it?

1237

---

Is jdbc a framework?

959

---

Under what circumstances, that all four drivers are used?

2465

---

What are types of resultset?

1024

---

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

1029

---

Why is jdbc needed?

970

---

Can resultset be null in java?

978

---

What is database connection pooling? Advantages of using a connection pool?

1094

---