K. Karacakaya

Ranch Hand

+ Follow

news 53 Posts 2 Threads

since May 20, 2014

Merit badge: grant badges

For More

Cows and Likes

Cows

Total received

In last 30 days

Forums and Threads

Recent posts by K. Karacakaya

Simple login form project - all attributes are null and HTTP Status 404 error in some cases

SignUpPage.jsp:

<!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=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<h2> Sign Up </h2>
<hr>
<form name="frm1" action="Registration" method="post" onsubmit="return validateForm();">
Username: <input type = "text" name = "un"> <br>
Password: <input type = "password" name = "pass"> <br>
Retype Password: <input type = "password" name = "pass2"> <br>
Name: <input type = "text" name = "name"> <br>
Surname: <input type = "text" name = "surname"> <br>
E-mail: <input type = "text" name = "email"> <br>
University Degree: <select name="degree">
<option value="none" selected>-</option>
<option value="Associate Degree">Associate Degree</option>
<option value="Bachelor's Degree">Bachelor's Degree</option>
<option value="Master's Degree">Master's Degree</option>
<option value="Doctoral Degree">Doctoral Degree</option>
</select>
<br>
<input type = "button" value = "Back" name = "back1" onclick = "JavaScript:window.location='NewFile.jsp';">
<input type = "submit" value = "Submit" name = "submit1">
</form>
<script type="text/javascript">
function validateForm(){
var form_object = document.forms.frm1;
var email = document.forms.frm1.elements.email.value;
if(form_object.elements.un.value == ''){
alert('You must enter your username!');
return false;
} else if(form_object.elements.pass.value == ''){
alert('You must enter your password!');
return false;
} else if(form_object.elements.pass2.value == ''){
alert('You must enter your last name!');
return false;
} else if(form_object.elements.pass.value == ''){
alert('You must enter your last name!');
return false;
} else if(form_object.elements.name.value == ''){
alert('You must enter your first name!');
return false;
} else if(form_object.elements.surname.value == ''){
alert('You must enter your last name!');
return false;
} else if(form_object.elements.email.value == ''){
alert('You must enter your e-mail address!');
return false;
} else if(form_object.elements.degree.value == ''){
alert('You must enter your university degree!');
return false;
} else if(email.indexOf('@')<0){
alert('There must be an @ character in your e-mail address.');
return false;
} else if(email.indexOf('@') != email.lastIndexOf('@')){
alert('There cannot be more than one @ character in your e-mail address.');
return false;
} else if(email.indexOf('.')<0){
alert('There must be at least one period in your e-mail address.');
return false;
} else if(email.lastIndexOf('.')<email.indexOf('@')){
alert('There must be at least one period following your @ sign in your e-mail address.');
return false;
} else if(!(/^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$/.test(email))){
alert('Please enter a valid e-mail address.');
return false;
} else if (form_object.elements.pass.value != form_object.elements.pass2.value){
alert ('Your password and retyped password do not match!');
return false;
}
//return true;
}
</script>
</body>
</html>

Registration.java

package com.amzi.servlets;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
@WebServlet("/Registration")
public class Registration extends HttpServlet{
String un = "";
String pass = "";
String name = "";
String surname = "";
String email = "";
String degree = "";
/**
*
*/
private static final long serialVersionUID = 1L;
public void init(ServletConfig config) throws ServletException{
super.init(config);
}
public void doPost(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException{
String url = "jdbc:mysql://localhost:3306/";
String dbName = "loginpage";
String driver = "com.mysql.jdbc.Driver";
Connection connection=null;
ResultSet rs;
res.setContentType("text/html");
PrintWriter out = res.getWriter();
HttpSession session = req.getSession();
un = req.getParameter("un");
pass = req.getParameter("pass");
name = req.getParameter("name");
surname = req.getParameter("surname");
email = req.getParameter("email");
degree = req.getParameter("degree");
try {
Class.forName(driver);
connection = (Connection) DriverManager.getConnection(url + dbName, "root", "");
String sql = "insert into users values (?,?,?,?,?,?)";
PreparedStatement pst = (PreparedStatement) connection.prepareStatement(sql);
pst.setString(1, un);
pst.setString(2, pass);
pst.setString(3, name);
pst.setString(4, surname);
pst.setString(5, email);
pst.setString(6, degree);
int numRowsChanged = pst.executeUpdate();
out.println(" Welcome : ");
out.println(" '"+name+"'. Registration is completed. Please ");
out.println("<a href=\"NewFile.jsp\">click here</a> and login to the system.");
pst.close();
}
catch(ClassNotFoundException e){
out.println("Couldn't load database driver: " + e.getMessage());
}
catch(SQLException e){
out.println("SQLException caught: " + e.getMessage());
}
catch (Exception e){
out.println(e);
}
finally {
try {
if (connection != null) connection.close();
}
catch (SQLException ignored){
out.println(ignored);
}
}
}
}

10 years ago