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 a JDBC 2.0 DataSource?

975

---

Explain the locking system in jdbc & its types?

982

---

Explain the necessary steps to connect to the database in java?

1048

---

What is type 4 jdbc driver?

849

---

Explain the difference between rowset vs. Resultset in jdbc?

1001

---

What is jdbc explain?

921

---

How to use JDBC to connect Microsoft Access?

1185

---

java based application for hospital management

3833

---

What is two-phase commit in the database?

1051

---

Define preparedstatement.

988

---

How can I know when I reach the last record in a table, since JDBC doesn't provide an EOF method?

988

---

What is the difference between jdbc and odbc?

989

---

How to get the Database server details in java program?

1072

---

How do I insert an image file (or other raw data) into a database?

969

---

Explain the process of creating tables using NetBeans IDE?

976

---