myserv.java

Web based Distributed Database Access Tool

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;

public class MyServ extends HttpServlet
{
Enumeration en;
Vector DSN;
Connection con;

public void init(){
en=getInitParameterNames();
DSN=new Vector();
while(en.hasMoreElements())
	{
	String para=(String)en.nextElement();
	DSN.addElement(getInitParameter(para));
	}
}
public void doGet(HttpServletRequest req,HttpServletResponse res)
{
try{
String usr=req.getParameter("user");
res.setContentType("text/html");
PrintWriter pw=res.getWriter();
pw.println("<h2>GET Request from "+usr+"</h2>");
pw.println("<hr color='red'>");
HttpSession ses=req.getSession();
pw.println("Session ID is: "+ses.getId());

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:"+(String)DSN.elementAt(0),"","");
pw.println("Connection OK :"+con);
Statement st=con.createStatement();
int rows=st.executeUpdate("use pod");
pw.println("Using POD: "+rows);
rows=st.executeUpdate("insert into login values('a1','a1','A1')");
pw.println("Using INSERT: "+rows);

}catch(Exception e){e.printStackTrace();}
finally{
try{if(con!=null)
	con.close();
}catch(SQLException sql){sql.printStackTrace();}
}

}


}