Sample Servlet to test DB2 Connectivity

import java.net.URL; import java.sql.*; import java.io.*; import java.util.*; import java.text.*; import javax.servlet.*; import javax.servlet.http.*; public class Con_Servlet6 extends HttpServlet { public void init(ServletConfig config) throws ServletException {super.init (config);} public void destroy(){} public void service(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException{ try{ String retstr="OK"; Vector headers=new Vector(); //Vector rows =new Vector(); //getting input from applet /*ObjectInputStream input_app=new ObjectInputStream(req.getInputStream()); String []conarr=(String[])input_app.readObject(); String driver=conarr[0]; String url=conarr[1]; String sqlcmd=conarr[2];*/ try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:Log"); stmt=con.createStatement(); rst=stmt.executeQuery("select * from tbllogin"); rmeta=rst.getMetaData(); int numcol=rmeta.getColumnCount(); //String text=""; for(int i=0;i" ); sout.println( "Sample Servlet to test DB2 Connectivity" ); sout.println( "" ); sout.println("testing stuff"); sout.println("they are" + headers.elementAt(1)); sout.println( "" ); sout.println( "" ); sout.flush(); sout.close();*/ output_app.close(); }catch(Exception e){e.printStackTrace();} } // :declare variables here Connection con=null; Statement stmt=null; ResultSet rst=null; ResultSetMetaData rmeta=null; } _______________________________________________________________________________________________ Applet goes here://///////////////////////////////////////// _______________________________________________________________________________________________ import java.applet.*; import java.net.*; import java.awt.*; import java.io.*; import java.util.*; public class testapplet extends Applet{ TextArea OutputField; Button button1; public void init() { OutputField = new TextArea("",20,80); add(OutputField); button1 = new Button("OK"); add(button1); } public void execSQL() { try{ /*String host = getDocumentBase().getHost(); int port = getDocumentBase().getPort(); if (port != -1) host += ":" + port;*/ //OutputField.setText("Rashid"); URL servletURL=new URL("http://pc37.cressoft.com.pk/servlet/Con_Servlet9"); //log("servlet invoked:" + servletURL); URLConnection uc=servletURL.openConnection(); uc.setDoOutput(true); uc.setDoInput(true); uc.setUseCaches(false); uc.setRequestProperty("Content-type","application/octet-stream"); //OutputField.setText("Amin"); ObjectOutputStream outtoservlet=new ObjectOutputStream(uc.getOutputStream()); String arr="RASHID";//new String[3]; /*arr[0] =txtDriver.getText(); arr[1] =txtURL.getText(); arr[2] =txtSQL.getText();*/ outtoservlet.writeObject(arr); outtoservlet.flush(); outtoservlet.close(); //ObjectInputStream outputfromservlet=new ObjectInputStream(uc.getInputStream()); //String retstr=(String)outputfromservlet.readObject(); //showStatus("Returned :"+retstr); //Vector header=(Vector)(outputfromservlet.readObject()); //StringBuffer sb=new StringBuffer(); //for(int i=0;i