1
Now i am facing the problem..as to how to store the information provided by the user...in the SQL server 2005..which is acting as a database in my project.
So plz help me regarding this.
Thanx.
For ue reference..i am providing u with the coding of my project.
Expand|Select|Wrap|Line Numbers
- 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 "> <input type="reset" value=" Reset " onclick="location.reload()"></center>
- </html>
- Login.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 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>
- }
