Click here to Skip to main content
14,735,210 members
Please Sign up or sign in to vote.
2.00/5 (1 vote)
See more:
Hey guys...thank you for the previous code related to JSP...but NOW i am in a new situation. Now i am having a problem with the sql connectivity of the JSP page...where the information entered in the JSP page..i need that information to be stored in the database...that is SQl server 2005.

So guys plz help me regarding this problem.

Thanx
Posted
Comments
Sandeep Mewara 25-Sep-10 6:00am
   
What help? What have you tried so far?

1 solution

I have created a JSP page(index.jsp),success page(success.html),error page(error.html) and a servlet page(Login.java).

Now i want that whatever information the user enters in the login for(that is index.jsp)..that information should be stored in the SQL.

I have tried the following code:-
[CODE]
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>
    <body

    <form action="success.html" method="get"/>

        <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>First Name </b></font></center></td>
            <td><center><input type="text" name="name"></center></td>
        </tr>

        <tr>
           <td><center><font color="black"><b>Last Name</b></font></center></td>
           <td><center><input type="text" name="name"></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="E-Mail"></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

/*
* 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 java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.*;
public class Login extends HttpServlet
{


protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException, ClassNotFoundException, SQLException
{

response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();

String fn =request.getParameter("First Name");
String ln =request.getParameter("Last Name");
String address=request.getParameter("Address");
String cno=request.getParameter("cno");
String EMail=request.getParameter("E-Maild ID");
String Rd=request.getParameter("Registration Date");

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 (FirstName,LastName,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
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException, SQLException {
processRequest(request, response);
}
/**
* Handles the HTTP <code>POST</code> method.
* @param request servlet request
* @param response servlet response
*/
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Returns a short description of the servlet.
*/
@Override
public String getServletInfo() {
return "Short description";
}
// </editor-fold>
}




[/CODE]

now i have provided with the coding of my projct. So plz help me...in creating the coonection to the SQL.
   

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




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900