Dear Stephen,
This cannot work.
The protocol you are using is GET. There should be statements in your program to
get the values from URL string. Once you get the values then you can pass them
to the insert statement.
You will have to use the methods getParameter, getParameterNames and
getParameterValues of the request object in order to access the values of
theQ1, theQ2, theComment1, thecomment2, fname, lname. Once you get these values
you will have to create a SQL string with these values in place and then pass
this string as a parameter to prepareStatement().
Hope this suffices.
Regards,
Pradeep Shekade
"Lambert, Stephen : CO IR" wrote:
> I have a working servlet that can query my Oracle database and display the
> results to an HTML page(Hooray!).
>
> The second phase of this servlet is to insert data into the Oracle database
> from an HTML form using the POST METHOD.
> The HTML FORM names are:(theQ1, theQ2, theComment1, thecomment2, fname,
> lname).
>
> Can someone please correct my java/sql syntax or point me to an actual
> working sample code that shows how to insert HTML data into an Oracle
> database.
>
> My servlet "JdbcServlet3" is listed below and will compile without errors.
> However, when I try to POST the HTML FORM, I recieve the following error:
> Bad Request
> Your browser sent a request that this server could not understand.
>
> ****************************************************************************
> import javax.servlet.*;
> import javax.servlet.http.*;
> import java.io.*;
> import java.sql.*;
>
> /**
> * JdbcServlet writes Legacy's Web Survey information to a JDBC database
> * from a HTML form.
> *
> * @author Stephen B. Lambert
> * @version 0.1a, 02/21/2000
> */
> public class JdbcServlet3 extends HttpServlet
> implements SingleThreadModel {
>
> private Connection conn;
> private void dbConnect() throws SQLException {
>
> DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
> conn = DriverManager.getConnection
> ("jdbc:oracle:thin:@w121c20.legacyhs:1521:FIRST",
> "slambert", "password");
> }
>
> /**
> * doGet method is called in response to a GET request
> */
> public void doGet(HttpServletRequest request,
> HttpServletResponse response) throws ServletException,
> IOException
> {
> PrintWriter out = response.getWriter();
> try
>
> {
> response.setContentType("text/html"); //returns HTML
>
> //get handle to output stream
> // PrintWriter out = response.getWriter();
>
> //create statement
> dbConnect();
> PreparedStatement stat = conn.prepareStatement( "INSERT INTO
> LHS_WEB_Survey Q1, Q2, DO_BEST, NEEDS_IMPROVE, F_NAME, L_NAME FROM " +
> "LHS_WEB_Survey" +
> "VALUES ( theQ1, theQ2, theQ3, theComment1, theComment2, fname,
> lname");
>
> //query database for result set
> ResultSet survey = stat.executeQuery();
> //generate HTML document to return to client
> out.println("<HTML>");
> out.println("<HEAD><TITLE>Survey List</TITLE></HEAD>");
> out.println("<BODY>");
> out.println("<H2>Survey List</H2>");
> out.println("<TABLE BORDER=1>"); //create an HTML table
> out.println("<TH>Satisfaction</TH>");
> out.println("<TH>Parking</TH>");
> out.println("<TH>Did Best?</TH>");
> out.println("<TH>Needed Improvement</TH>");
> out.println("<TH>First Name</TH>");
> out.println("<TH>Last Name</TH></TR>");
>
> while (survey.next()) //iterate through all records
> {
> //add a table row for each record
> out.println("<TR><TD>" +
> survey.getString("q1")+ "</TD><TD>" +
> survey.getString("q2") + "</TD><TD>" +
> survey.getString("DO_BEST") + "</TD><TD>" +
> survey.getString("NEEDS_IMPROVE") + "</TD><TD>" +
> survey.getString("F_NAME") + "</TD><TD>" +
> survey.getString("L_NAME") + "</TD></TR>");
> }
>
> out.println("</TABLE>");
> out.println("</BODY></HTML>");
> }
> catch (Exception e)
> {
> out.println(e.toString());
>
> }
> out.close();
> }
>
> /**
> * Tells the server about this servlet
> */
> public String getServletInfo()
> {
> return "Sample JDBC servlet";
> }
> }
>
> ***************************************************************************
> Thank you!
> Stephen.
>
> ___________________________________________________________________________
> 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
