JSP and Servlets

Question

1.00/5 (1 vote)

See more:

INDEX.JSP:-

XML

<%--
    Document   : index
    Created on : Aug 28, 2010, 8:04:10 AM
    Author     : Prateek
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title> Login Form </title>
    </head>
    <form action="Login" method="post"/>
    <body>
        <br>
        <br>
   <center><h3> Please fill in the following information in order to continue with your registration</h3></center>
   <br>
   <br>
   <table border="2" bordercolor="black"  align="center"  cellpadding="5" cellspacing="2" width="450" height="300">
        <tr>
            <td ><center><font color="black"><b>FirstName </b></font></center></td>
            <td><center><input type="text" name="fn"></center></td>
        </tr>

        <tr>
           <td><center><font color="black"><b>Last Name</b></font></center></td>
           <td><center><input type="text" name="ln"></center></td>
        </tr>

        <tr>
           <td><center><font color="black"><b>Address</b></font></center></td>
           <td><center><input type="text" name="address"></center></td>
        </tr>

        <tr>
           <td><center><font color="black"><b>Contact Number</b></font></center></td>
           <td><center><input type="text" name="cno"></center></td>
        </tr>

        <tr>
           <td><center><font color="black"><b>E-Mail ID</b></font></center></td>
           <td><center><input type="text" name="EMail"></center></td>
        </tr>

        <tr>
           <td><center><font color="black"><b>Registration Date</b></font></center></td>
           <td><center><input type="text" name="Rd"/></center></td>
        </tr>


    </table>
</body>
<br>
<br>
<center><input type="submit" value="     Save       ">&nbsp;&nbsp;&nbsp;<input type="reset" value="     Reset        " onclick="location.reload()"></center>
</html>

LOGIN.JAVA (SERVLET):-

Java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
import javax.servlet.*;
public class Login extends HttpServlet {
   
   
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        //doPost(request, response);
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
       
         String fn =request.getParameter("fn");
         String ln =request.getParameter("ln");
         String address=request.getParameter("address");
         String cno=request.getParameter("cno");
         String EMail=request.getParameter("EMail");
         String Rd=request.getParameter("Rd");
        
          try 
        {
             if(fn.length()==0 && ln.length()==0 && address.length()==0 && cno.length()==0 && EMail.length()==0 && Rd.length()==0)
                {
                    response.sendRedirect("error.html");
                }
             else
                {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                Connection c = DriverManager.getConnection("jdbc:odbc:Family","","");
                PreparedStatement ps = c.prepareStatement("insert into Friends values (First_Name,Last_Name,Address,ContactNo,EMailID,RegistrationDate) values(?,?,?,?,?,?)");
                ps.setString(1, fn);
                ps.setString(2, ln);
                ps.setString(3, address);
                ps.setString(4, cno);
                ps.setString(5, EMail);
                ps.setString(6, Rd);
                
                ps.executeUpdate();
                response.sendRedirect("success.html");
                }
        } 
        
        catch(Exception ec)
        {
            out.print(ec);
        }
         
         finally {
            out.close();
        }
    } 
    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** 
     * Handles the HTTP <code>GET</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        doPost(request, response);
    } 
    /** 
     * Handles the HTTP <code>POST</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }
    /** 
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>
}

Thanx for the last answer guys..
Now i am having a different problem. When i build and run my project...all is good...but the problem is...when i enter the information in my LOGIN FORM and click on the SAVE button...i get the following Exception---->

java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]The name "First_Name" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

So, if anyone can please help me regarding this problem? I will be really grateful.

Thanx...

Posted 22-Nov-10 22:24pm

prateek2607

Updated 22-Nov-10 22:30pm

Sandeep Mewara

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manfred Rudolf Bihy · Answer 1 · 2010-11-23T03:31:00

Hello Prateek,

your problem is with the SQL insert statement:

insert into Friends values (First_Name,Last_Name,Address,ContactNo,EMailID,RegistrationDate) values(?,?,?,?,?,?)"

The first "values" is wrong. The list of fields is seperated by comma and enclosed in parehthesis. It's the list of values that starts with the string "values".

If you remove the string "values" in front of the field list it'll work as expected.

Cheers

Manfred