This is the Registration Page. All the Details given in the Fields are to be Retrieved. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" ``"http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>Register</title> <meta charset="utf-8" /> <link href="style.css" rel="stylesheet" type="text/css" /> </head> <body> <p> </p> <div id="login"> <center> <h1><font color="black"> Welcome! Please Register</font></h1> </center> <form action="register1.jsp" method="get"> <fieldset> <p><input name="fn" onblur="if(this.value=='')this.value='Firstname'" onfocus="if(this.value=='Firstname')this.value='' " required="" type="text" value="Firstname" /></p> <p><input name="ln" onblur="if(this.value=='')this.value='Lastname'" onfocus="if(this.value=='Lastname')this.value='' " required="" type="text" value="Lastname" /></p> <p><input name="un" onblur="if(this.value=='')this.value='Username'" onfocus="if(this.value=='Username')this.value='' " required="" type="text" value="Username" /></p> <p><input name="pwd" onblur="if(this.value=='')this.value='Password'" onfocus="if(this.value=='Password')this.value='' " required="" type="password" /></p> <p><input name="email" onblur="if(this.value=='')this.value='Email'" onfocus="if(this.value=='Email')this.value='' " required="" type="text" value="Email" /></p> <p><input name="phno" onblur="if(this.value=='')this.value='PhoneNo'" onfocus="if(this.value=='PhoneNo')this.value='' " required="" type="text" value="PhoneNo" /></p> <p><input type="submit" value="Register" /></p> </fieldset> </form> </div> <p> </p> <div id="background"><img alt="" class="stretch" src="bg.jpg" /></div> </body> </html> This is the Action Jsp Page <%@ page import = "java.sql.*" %> <%@ include file="DbConnection.jsp"%> <% String first = request.getParameter("fn"); String last = request.getParameter("ln"); String user = request.getParameter("un"); String password = request.getParameter("pwd"); String email = request.getParameter("email"); String phone = request.getParameter("phno"); pst = con.prepareStatement("insert into Registration_Services values(?,?,?,?,?,?)"); pst.setString(1,first); pst.setString(2,last); pst.setString(3,user); pst.setString(4,password); pst.setString(5,email); pst.setString(6,phone); int result = pst.executeUpdate();(error is here) RequestDispatcher rd = request.getRequestDispatcher("login.jsp"); rd.include(request,response); %> The Error that i am getting is http error 500 What I have tried: I have tried to use all the execute kind of commands like executeQuery, eececute and also executeUpdate but i couldnt find the solution
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)