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 the meaning of connection?

1019

---

What is layer in communication?

937

---

Is jdbc a middleware?

998

---

What is the difference between jdbc and odbc?

1023

---

What is 2 phase commit?

1249

---

How many types of jdbc drivers are there?

1050

---

Is jdbc an api?

1118

---

What are the different types of JDBC drivers?

1102

---

What is jndi lookup?

983

---

DB2 Universal claims to support JDBC 2.0, But I can only get JDBC 1.0 functionality. What can I do?

1019

---

What are the different types of resultset?

1020

---

Explain how to make updates to the updatable resultsets.

969

---

What is a java driver?

1071

---

Why did my jdbc code throw a rollback sqlexception?

962

---

How many packages are available in jdbc api?

1005

---