this is my register.jsp code
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>New User Register page</title>
<script language="Javascript">
function Validate() {
var fname = document.regform.fname
var mname = document.regform.mname
var lname = document.regform.lname
var uname = document.regform.uname
var pass = document.regform.pass
var confpass = document.regform.confpass
if ((fname.value==null) || (fname.value=="")) {
alert("Please Enter First Name")
fname.focus()
return false
}
if ((mname.value==null) || (mname.value=="")) {
alert("Please Enter Middle Name")
mname.focus()
return false
}
if ((lname.value==null) || (lname.value=="")) {
alert("Please Enter Last Name")
lname.focus()
return false
}
if ((uname.value==null) || (uname.value=="")) {
alert("Please Enter Username")
uname.focus()
return false
}
if ((pass.value==null) || (pass.value=="")) {
alert("Please Enter user Password")
pass.focus()
return false
}
if ((confpass.value==null) || (confpass.value=="")) {
alert("Please Enter Confirm Password")
confpass.focus()
return false
}
return true
}
</script>
</head>
<body>
<form name="regform" action="RegisterServlet" method="Post"
onSubmit="return Validate()">
<table align="center" style="background-color: ffeeff;">
<tr>
<td colspan=2 style="font-weight: bold; font-size: 20pt;"
align="center">New User Registeration</td>
</tr>
<tr>
<td colspan=2> </td>
</tr>
<tr>
<td>First Name</td>
<td><input type="text" name="fname" value=""></td>
</tr>
<tr>
<td>Middle Name</td>
<td><input type="text" name="mname" value=""></td>
</tr>
<tr>
<td>Last Name</td>
<td><input type="text" name="lname" value=""></td>
</tr>
<tr>
<td>Login Name</td>
<td><input type="text" name="uname" value=""></td>
</tr>
<tr>
<td>Password</td>
<td><input type="password" name="pass" value=""></td>
</tr>
<tr>
<td>Confirm Password</td>
<td><input type="password" name="confpass" value=""></td>
</tr>
<tr align="center">
<td><input type="submit" name="Submit" value="Save User"></td>
<td><input type="Reset" name="Reset" value=" Reset"></td>
</tr>
</table>
</form>
</body>
</html>
This is my RegisterServlet code.
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class RegisterServlet extends HttpServlet{
private static final long serialVersionUID = 1L;
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException,IOException{
PrintWriter out = response.getWriter();
Connection connection=null;
String firstname=request.getParameter("fname");
String middlename=request.getParameter("mname");
String lastname=request.getParameter("lname");
String username=request.getParameter("uname");
String password=request.getParameter("pass");
try {
Class.forName("com.mysql.jdbc.Driver");
String URL = "jdbc:mysql://localhost:3306/webapplication";
connection = DriverManager.getConnection(URL, "root", "admin");
out.println(username);
out.println(password);
String sql = "insert into login_detail set name='"+username+"'+ password='"+password+"'";
// String sql1 = "insert into user_info set FNAME='"+firstname+"'+ MNAME='"+middlename+"' + LNAME='"+lastname+"'+ name='"+username+"'";
Statement s = connection.createStatement();
out.println(sql);
// out.println(sql1);
int i = s.executeUpdate(sql);
// int j = s.executeUpdate(sql1);
if(i>0)
{
response.sendRedirect("Record Updated sucessfully");
}
s.close();
}
catch(Exception e){
System.out.println("Exception is ;"+e);
}
}
}
Exception is ;com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: 'rocker'
