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 "> <input type="reset" value=" Reset " onclick="location.reload()"></center>
</html>
LOGIN.JAVA (SERVLET):-
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 {
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();
}
}
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
@Override
public String getServletInfo() {
return "Short description";
}
}
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...