Hi,
So what is the solution for that.I think there is not any problem with the
statements but with the parameters which r passed in java program.
Biren
On Mon, 8 May 2000, [iso-8859-1] sampathkumar rangarajan wrote:
> hi,
>
>
> You can you stmt.executeUpdate() for insert,delete and
>
> update.
>
> The executeQuery() is only for executing the Select
> statments.
>
> If you want to use both update and select statements
> you can use execute().
>
> you better check the return status of the
> executeUpdate() statements.It is a integer value
> specifies number of
> records affected.
>
> Regards
> ranga
>
>
> --- Jiger Patel <[EMAIL PROTECTED]> wrote:
> > Hi Biren,
> > You r probably doing two mistakes one u
> > have to use
> > stmt.executeQuery() instead of stmt.executeUpdate()
> > which is generally only
> > for update statements. Secondly since u r using
> > Oracle u must explicitly
> > commit the transactions by using conn.commit().
> >
> > bye,
> > Jiger
> >
> >
> > >From: Biren Patnaik <[EMAIL PROTECTED]>
> > >Reply-To: "A mailing list for discussion about Sun
> > Microsystem's Java
> > > Servlet API Technology."
> > <[EMAIL PROTECTED]>
> > >To: [EMAIL PROTECTED]
> > >Subject: Help on a simple program
> > >Date: Mon, 8 May 2000 12:25:57 +0100
> > >
> > >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
> >
> === message truncated ===
>
> ____________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
> or your free @yahoo.ie address at http://mail.yahoo.ie
>
___________________________________________________________________________
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
