JDBC Example in Struts 2

JDBC Simple Connectivity using Struts 2


Registration.jsp

<%@ page contentType="text/html;charset=UTF-8" %>
<%@ taglib prefix="s" uri="/struts-tags" %>
<html>

<body>
<h1>REGISTRATION!!!!!!!!</h1>

<s:form action="registration">

<s:textfield label="FirstName" name="firstName" />
<s:textfield label="LastName" name="lastName" />
<s:textfield label="Email" name="email" />
<s:textfield label="Username" name="username" />
<s:password label="Password" name="password" />
<s:password label="confirm_password" name="confirmPassword" />
<s:textfield label="PhoneNumber" name="phoneNumber" />
<s:textfield label="dob" name="dob" />
<s:textfield label="gender" name="gender" />
<s:submit name="submit"/>

</s:form>


</body>
</html>
--------------------------------------------------------------------------------------------------
RegistrationAction.java

package egstruts;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

import com.opensymphony.xwork2.ActionSupport;

import java.util.List;
import java.util.ArrayList;

import javax.servlet.*;
import javax.servlet.http.*;

import java.sql.*;

public class RegisterationAction extends ActionSupport {
private String firstName;
private String lastName;
private String email;
private String username;
private String password;
private String phoneNumber;
private String confirmPassword;
private String gender;
private String dob;

public String getFirstName() {
return firstName;
}

public void setFirstName(String firstName) {
this.firstName = firstName;
}

public String getLastName() {
return lastName;
}

public void setLastName(String lastName) {
this.lastName = lastName;
}

public String getEmail() {
return email;
}

public void setEmail(String email) {
this.email = email;
}

public String getUsername() {
return username;
}

public void setUsername(String username) {
this.username = username;
}

public String getPassword() {
return password;
}

public void setPassword(String password) {
this.password = password;
}

public String getPhoneNumber() {
return phoneNumber;
}

public void setPhoneNumber(String phoneNumber) {
this.phoneNumber = phoneNumber;
}

public String getConfirmPassword() {
return confirmPassword;
}

public void setConfirmPassword(String confirmPassword) {
this.confirmPassword = confirmPassword;
}

public String getGender() {
return gender;
}

public void setGender(String gender) {
this.gender = gender;
}

public String getDob() {
return dob;
}

public void setDob(String dob) {
this.dob = dob;
}

public String execute() {

String ret = ERROR;
Connection conn = null;

try {

String URL = "jdbc:mysql://localhost/egstruts";
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(URL, "root", "root");
String sql = "INSERT into registration (login_name, login_password, first_name, last_name, gender, phone_no, dob, email) values (?, ?, ?, ?, ?, ?, ?, ?)";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, username);
ps.setString(2, password);
ps.setString(3, firstName);
ps.setString(4, lastName);
ps.setString(5, gender);
ps.setString(6, phoneNumber);
ps.setString(7, dob);
ps.setString(8, email);
ps.executeUpdate();

ret = SUCCESS;

} catch (Exception e) {
System.out.println(e.getMessage());
ret = ERROR;
} finally {
if (conn != null) {
try {
conn.close();
} catch (Exception e) {
System.out.println(e.getMessage());
}
}
}
return ret;

}

public void validate() {
if (firstName.length() == 0) {

addFieldError("firstName", "First name is required.");

}
if (lastName.length() == 0) {

addFieldError("lastName", "Last name is required.");

}

if (username.length() == 0) {

addFieldError("username", "Last name is required.");

}
if (email.length() == 0) {

addFieldError("email", "Email is required.");

}

if (password.length() == 0) {

addFieldError("password", "Password is required");

}
if (password.length() <6) {

addFieldError("password", "Password is required");

}
if (!(confirmPassword.equals(password))) {

addFieldError("confirmPassword", "Password not matched");

}

if (phoneNumber.length() < 11) {
addFieldError("phoneNumber","Phone Number is required and must be 10 digit");
}
}

}
--------------------------------------------------------------------------------------------------
Person.java

package egstruts;
import com.opensymphony.xwork2.ActionSupport;

public class Person extends ActionSupport
{
    private String FirstName;
    private String LastName;
    private String Email;
    private String Username;
    private String Password;
    private int PhoneNumber;
    
public String getFirstName() {
return FirstName;
}
public void setFirstName(String firstName) {
FirstName = firstName;
}
public String getLastName() {
return LastName;
}
public void setLastName(String lastName) {
LastName = lastName;
}
public String getEmail() {
return Email;
}
public void setEmail(String email) {
Email = email;
}
public String getUsername() {
return Username;
}
public void setUsername(String username) {
Username = username;
}
public String getPassword() {
return Password;
}
public void setPassword(String password) {
Password = password;
}
public int getPhoneNumber() {
return PhoneNumber;
}
public void setPhoneNumber(int phoneNumber) {
PhoneNumber = phoneNumber;
}
public String toString()
    {
        return "First Name: " + getFirstName() + " Last Name:  " + getLastName() + 
        " Email:      " + getEmail() + " phone Number:      " + getPhoneNumber() ;
    }
    public String execute()
    {
    return "success";
    }
}
--------------------------------------------------------------------------------------------------
struts.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts PUBLIC
    "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
    "http://struts.apache.org/dtds/struts-2.0.dtd">

<struts>
<package name="default" extends="struts-default">
<action name="registerUser" class="egstruts.RegisterAction"
method="execute">
<result name="success">SuccessfullLogin.jsp</result>
<result name="error">error.jsp</result>
<result name="input">welcome.jsp</result>
</action>
<action name="registration" class="egstruts.RegistrationAction"
method="execute">
<result name="success">thankyou.jsp</result>
<result name="error">error.jsp</result>
<result name="input">Registration.jsp</result>
</action>


</package>

</struts>
--------------------------------------------------------------------------------------------------
thankyou.jsp

<%@ taglib prefix="s" uri="/struts-tags" %>
<html>
<head>
</head>
<body>
<h1>Registeration Successful
  <s:property value="FirstName"/>
   <s:property value="Username"/>
   welcome!!!
</h1>
</body>
</html>
--------------------------------------------------------------------------------------------------
welcome.jsp

<%@ page contentType="text/html;charset=UTF-8" %>
<%@ taglib prefix="s" uri="/struts-tags" %>
<html>
<body>
<h1>Input Your name</h1>
<s:form action="registerUser">
<s:textfield key="NAME" name="username" />
<s:password key="Password" name="password" />
<s:submit name="submit"/>

</s:form>
<p><a href="Registration.jsp">Please register</a></p>
</body>
</html>
--------------------------------------------------------------------------------------------------
SuccessfulLogin.jsp

<%@ taglib prefix="s" uri="/struts-tags" %>
<html>
<head>
</head>
<body>
<h1>Your name is 
  <s:property value="username"/>
   welcome!!!
</h1>

</body>
</html>

No comments:

Post a Comment

Subscribe to: Posts (Atom)