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);
}
}
}

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

915

---

How can we set null value in jdbc preparedstatement?

916

---

How can I get information about foreign keys used in a table?

912

---

Explain the process of creating tables using NetBeans IDE?

919

---

Is jdbc database independent?

908

---

What is a jdbc connection pool?

875

---

If you are truncated using JDBC, how can you that how much data is truncated?

1003

---

What are the differences between resultset and rowset?

1027

---

What is jdbc thin client?

923

---

What is drivermanager in java?

880

---

What are four types of JDBC driver?

1051

---

What is drivermanager in jdbc?

915

---

What is sqlwarning and discuss the procedure of retrieving warnings?

953

---

How can I create a custom RowSetMetaData object from scratch?

933

---

Can I use JDBC to execute non-standard features that my DBMS provides?

929

---