Loading...
Tuesday, October 20, 2015

AJAX implementation in Struts 2 using JQuery And Bootstrap





SQL

CREATE TABLE [UserDetails](
[UserId] int IDENTITY(1,1) PRIMARY KEY,
[FirstName] [varchar](500) NULL,
[LastName] [varchar](500) NULL,
[EmailId] [varchar](500) NULL,
[MobileNo] [int] NULL,

)


DBconnection.java


package connection.com;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBconnection {
public static Connection getConnection(){
Connection con = null;
try{
//Class.forName("oracle.jdbc.driver.OracleDriver");
//con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","username","password");

//Class.forName("com.mysql.jdbc.Driver");
// con=DriverManager.getConnection("jdbc:mysql://localhost:3306/databasename","username","password");

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con=DriverManager.getConnection("jdbc:sqlserver://localhost:53245;"+"databaseName=java9r;user=sa;password=password");

}catch(SQLException e){
e.printStackTrace();
}catch(Exception e){
e.printStackTrace();
}

return con;
}
}


UserBean.java

package userbean.com;

public class UserBean {
private String fname,lname,email;
private int mobile, userid;
public String getFname() {
return fname;
}
public void setFname(String fname) {
this.fname = fname;
}
public String getLname() {
return lname;
}
public void setLname(String lname) {
this.lname = lname;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public int getMobile() {
return mobile;
}
public void setMobile(int mobile) {
this.mobile = mobile;
}

public int getUserid() {
return userid;
}
public void setUserid(int userid) {
this.userid = userid;
}


}



UserController.java

package java9r.com.user.controller;
import java9r.com.user.dao.UserDAO;

import com.opensymphony.xwork2.ActionSupport;
import userbean.com.UserBean;
public class UserController extends ActionSupport {

private static final long serialVersionUID = -6239703166715154765L;

private UserDAO ub=new UserDAO();
private UserBean urb=new UserBean();

public String adduser(){

this.ub.adduser(this.urb);

return SUCCESS;
}

public UserDAO getUb() {
return ub;
}

public void setUb(UserDAO ub) {
this.ub = ub;
}

public UserBean getUrb() {
return urb;
}

public void setUrb(UserBean urb) {
this.urb = urb;
}



}




UserDAO.java

package java9r.com.user.dao;
import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.SQLException;



import connection.com.DBconnection;

import userbean.com.UserBean;
public class UserDAO {



public void adduser(UserBean urb) {

try {
Connection con=DBconnection.getConnection();
String sql="insert into UserDetails (FirstName,LastName,EmailId,MobileNo) values(?,?,?,?)";
PreparedStatement ps=con.prepareStatement(sql);

ps.setString(1, urb.getFname());
ps.setString(2, urb.getLname());
ps.setString(3, urb.getEmail());
ps.setInt(4, urb.getMobile());
ps.executeUpdate();
} catch (SQLException e) {
System.err.println(e.getMessage());
}
}



}

struts.xml

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

<constant name="struts.enable.DynamicMethodInvocation" value="false"/>
<constant name="struts.devMode" value="false"/>
<constant name="struts.multipart.saveDir" value="/tmp"> </constant>
<constant name="struts.action.extension" value=","/>
<package name="abc" namespace="/" extends="struts-default" >




<action name="adduser" class="java9r.com.user.controller.UserController" method="adduser">
<result name="success" >UserDetailsList.jsp</result>
</action>
</package>
</struts>


web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
<display-name>Struts2Ajax</display-name>
<welcome-file-list>

<welcome-file>index.jsp</welcome-file>

</welcome-file-list>
<filter>
<filter-name>struts2</filter-name>
<filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
</filter>

<filter-mapping>
<filter-name>struts2</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
</web-app>


Index.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html ">
<html>
<head>

<title>User</title>
<link rel="stylesheet" href="css/bootstrap.min.css" >
<script src="js/bootstrap.min.js"></script>


<!-- Ajax start -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js" ></script>
<script type="text/javascript">
$(document).ready(function() {
$('#ibuttonuser').click(function(e) {
e.preventDefault();
var firstname = jQuery("#urb.fname").val();
var lastname = jQuery("#urb.lname").val();
var mailid = jQuery("#urb.email").val();
var mobileno = jQuery("#urb.mobile").val();
$.ajax({
url: "adduser",
// type: "post",

data: "fname=" + firstname+"&lname"+lastname+"&email"+mailid+"&mobile"+mobileno,

cache: false,
success: function(data) {
$("#usermessage").html(data).slideDown('slow');
}
});
});
});
</script>
<!-- Ajax End -->
</head>
<body background="java9r.png" marginheight="100px;">
<div class="container">

<br>
<form action="adduser" method="post">
<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">

<h4 class="modal-title">Add New User Using Ajax </h4>
</div>
<div class="modal-body">
<div class="form-group">
<label for="usr">First Name:</label>


<input type="text" name="urb.fname" class="form-control" >
</div>
<div class="form-group">
<label for="usr">Last Name:</label>
<input type="text" name="urb.lname" class="form-control" >
</div>

<div class="form-group">
<label for="usr">Mobile No:</label>
<input type="text" name="urb.mobile" class="form-control" >
</div>

<div class="form-group">
<label for="usr">Email Id:</label>
<input type="text" name="urb.email" class="form-control" >
</div>

</div>
<div class="modal-footer">
<div id="usermessage" align="center"></div>
<input type="submit" class="btn btn-default" id="ibuttonuser" value="Save">
<!-- here calling ajax id id="ibuttonuser" -->
<button type="reset" class="btn btn-default" data-dismiss="modal">Reset</button>
</div>
</div>
</form>
</div>



</body>
</html>


success.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!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>Success</title>
</head>
<body>

<h3>Success Fully Added Record</h3>

</body>
</html>

OUTPUT






0 comments:

Post a Comment

 
TOP