insertion of values through jsp into database


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: insertion of values through jsp into database

  1. #1
    Join Date
    Nov 2004
    Posts
    29

    insertion of values through jsp into database

    i want a query which i have to be used in jsp page, that the values of html page, which display in jsp page get stored in oracle database.my coonnection is working, but the value is not stored in database.


    the values is get from the html page, by using request.getParameter("code") method.

    i have used the following query, but it is not working:


    <%@ page import="javax.servlet.*" %>
    <%@ page import="javax.servlet.http.*" %>


    <%@ page language="java" import="java.sql.*" %>


    <html>
    <head>
    <title></title>
    <body>

    <%

    try {
    //Load the jdbc driver

    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

    //Create a connection object

    Connection con=DriverManager.getConnection("jdbcdbcf","scott","ttlscott");

    System.out.println("got connection");

    // Create a statement object and call its executeUpdate method to insert a record

    Statement s=con.createStatement();

    String sql = "insert into gl_mast values(\"" + request.getParameter("code") + "\",\"" + request.getParameter("Description") + "\",\"" + request.getParameter("DrAmount") + "\",\"" + request.getParameter("CrAmount") + "\",\"" + request.getParameter("type") + "\",\"" + request.getParameter("pct") + "\"")";


    s.executeUpdate(sql);

    Step 4. Use the same Statement object to obtain a ResultSet object
    ";

    ResultSet rs = s.executeQuery(sql);

    rs.close();
    s.close();
    con.close();
    }
    catch (ClassNotFoundException e1) {
    // JDBC driver class not found, print error message to the console
    System.out.println(e1.toString());
    }
    catch (SQLException e2) {
    // Exception when executing java.sql related commands, print error message to the console
    System.out.println(e2.toString());
    }
    catch (Exception e3) {
    // other unexpected exception, print error message to the console
    System.out.println(e3.toString());
    }
    %>

  2. #2
    Join Date
    Oct 2004
    Posts
    311
    Try keeping your messages in a single forum next time. This way is highly anoying and won't get you answers sooner. All it will get you is a ban because people will report you to the moderators.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center