JSP和Servlet

扫码查看
本文介绍了JSP和Servlet的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

INDEX.JSP:-

<%--
    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):-



LOGIN.JAVA (SERVLET):-

/*
 * 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.


那么,是否有人可以帮助我解决这个问题?我会很感激.

Thanx ...


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

Thanx...

推荐答案


这篇关于JSP和Servlet的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-04 20:20
查看更多