Hi Biren,
Are you getting any displays on the server console ?. The
System.out.println, as you know, will be displayed on the server
console.
Regards
vishwa
Biren Patnaik wrote:
>
> Hi all,
> I have written a simple program,whose work is to add and delete a record
> from a database.After executing the html file,it is not showing any error
> message,infact it is showing "Done" in the status bar,but records are
> neither inserted nor deleted from the database.I m sending the full
> codes.Please check it and send me reply .I m waiting for reply.I m using
> JSWDK1.0.1. AND ORACLE.
>
> srvtimp.html
>
> <html>
>
> <head>
> <meta http-equiv="Content-Type"
> content="text/html; charset=iso-8859-1">
> <meta name="GENERATOR" content="Microsoft FrontPage Express 2.0">
> <title></title>
> </head>
>
> <body background="http://net/srvt/vnet.jpg" text="#FF0000">
> <script language="javascript">
> function check()
> {
> // alert("ok");
> }
>
> </script>
>
> <form name="form1" method="post"
> action="http://147.0.1.41:8080/servlet/srvtimp">
> <input type="text" size="10" name="T1" value="">
> <input type="text" size="10" name="T2" value="">
> <input type="hidden" name="ad" value="">
> <input type="submit" name="insert"
> onclick="document.form1.ad.value='add';">
> <input type="submit" name="delete"
> onclick="document.form1.ad.value='del';">
> </form>
> </body>
> </html>
>
> srvtimp.java
>
> import javax.servlet.*;
> import javax.servlet.http.*;
> import java.io.*;
> import java.sql.*;
>
> public class srvtimp extends HttpServlet
> {
> Connection conn = null;
> Statement stmt = null;
> ResultSet rst = null;
> PrintWriter out=null;
> ResultSetMetaData rdata=null;
>
> public void init() throws ServletException {
>
> try {
>
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
>
> conn=DriverManager.getConnection("jdbc:odbc:prjct1","scott","tiger");
> } catch(ClassNotFoundException e) {
> System.out.println("CustSvc: Database driver could not be
> found.");
> System.out.println(e.toString());
> throw new UnavailableException(this, "Database driver class not
> found");
> } catch(SQLException e) {
> System.out.println("CustSvc: Error connecting to the database.");
> System.out.println(e.toString());
> throw new UnavailableException(this, "Cannot connect to the
> database");
> }
> }
>
> /*public void doGet(HttpServletRequest rqst, HttpServletResponse rsp)
> {
> try
> {
> doPost(rqst,rsp);
> }catch(Exception e){}
> }*/
>
> public void doPost(HttpServletRequest rqst, HttpServletResponse rsp)
> throws
>
> ServletException,IOException
> {
> try
> {
> String bT = rqst.getParameter("ad");
> String mT1 = rqst.getParameter("T1");
> String mT2 = rqst.getParameter("T2");
>
> if(bT == "add")
> {
> stmt = conn.createStatement();
> rsp.setContentType("text/html");
> stmt.executeUpdate("INSERT INTO EMP1 VALUES('" + mT1 +
> "','" + mT2 + "')");
> }
> if(bT == "del")
> {
> stmt = conn.createStatement();
> rsp.setContentType("text/html");
> stmt.executeUpdate("DELETE FROM EMP1 WHERE NAME = '" +mT1+ "'");
> }
> out.close();
> }
> catch (SQLException e) {
> rsp.sendError(rsp.SC_ACCEPTED, "The request has been accepted, but
> it failed to complete
>
> due to an error updating the database.");
> System.out.println(e.toString());
> return;
> }
> catch (NumberFormatException e) {
> rsp.sendError(rsp.SC_BAD_REQUEST, "At least one of the input fields
> is non-numeric. Please
>
> correct and try again.");
> System.out.println(e.toString());
> return;
> }
>
> catch(Exception e)
> {
> //out.println("<script
> language='javascript'>defaultStatus='Error';</script>");
> }
> }
> public void destroy()
> {
> try
> {
> conn.close();
> }
> catch(Exception e)
> {
> System.out.println("Emp: Database close Failed");
> System.out.println(e.toString());
> }
> }
> }
> Thanx in advance
> Biren
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
