import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class Catalog2 extends HttpServlet
{
PrintWriter out;
Connection cn;
String url;
Statement sql;
ResultSet rs;
public void init()
{
System.out.println("Ready to Show the Catalog..");
//trying to load the driver
//Below 'try' module is for Connection to a MS-Access Database on Windows-OS.
//Connection string differs from OS and Driver used.
//Below module is to present an example of an implementation
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("Driver found....");
System.out.println("Waiting for Connection...");
url="jdbc:odbc:ixiaon";
cn=DriverManager.getConnection(url,"username","password");
System.out.println("Connection is Established.");
}
catch (ClassNotFoundException ce)
{
System.out.println("1 :Exception : " + ce);
}
catch (SQLException sqle)
{
System.out.println("2: Exception : " + sqle);
}
}
public void doGet(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException
{
response.setContentType("text/html");
out=response.getWriter();
out.println("");
out.println("Presenting Information..
");
out.println("
");
System.out.println("Entered inside");
try
{
sql=cn.createStatement();
sql.executeUpdate("INSERT INTO DEPOSIT VALUES(100001,'02/30/2002',300,'N/A','D',4) ");
rs=sql.executeQuery("SELECT * FROM DEPOSIT");
while(rs.next())
{
out.println("