Inserting values into MySQL, Struts 2 , hibernate

DataBase: employee

Table: Dept
column: DeptId  ,DeptName

------------------------------------------------------------------------------------
DeptAction.java


package employee;

import com.opensymphony.xwork2.ActionSupport;

public class DeptAction extends ActionSupport {

/**
*
*/
private static final long serialVersionUID = -4968983731735129524L;
/**
*
*/

private DeptManager deptManager;
private Dept dept;

/**
* @return the dept
*/
public Dept getDept() {
return dept;
}

/**
* @param dept
*            the dept to set
*/
public void setDept(Dept dept) {
this.dept = dept;
}
public DeptAction()
{
deptManager = new DeptManager();
}
public String execute() {

try {
System.out.println(getDept());
System.out.println("SUCCESS");
deptManager.updateDept(getDept());
} catch (Exception e) {
System.out.println("Exception occured. "+e.getMessage());
e.printStackTrace();
}

return SUCCESS;
}
}

------------------------------------------------------------------------------------
Dept.java

package employee;

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "dept")
public class Dept implements Serializable {

@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name = "deptId")
private int deptId;
@Column(name = "deptName")
private String deptName;

/**
* @return the deptId
*/
public int getDeptId() {
return deptId;
}

/**
* @param deptId
*            the deptId to set
*/
public void setDeptId(int deptId) {
this.deptId = deptId;
}

/**
* @return the deptName
*/
public String getDeptName() {
return deptName;
}

/**
* @param deptName
*            the deptName to set
*/
public void setDeptName(String deptName) {
this.deptName = deptName;
}

}
------------------------------------------------------------------------------------

DeptManager.java

package employee;

import employee.HibernateUtil;

import org.hibernate.Session;

public class DeptManager extends HibernateUtil {

public Dept updateDept(Dept dept) {

Session session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();

session.save(dept);
session.getTransaction().commit();
return dept;

}

}


------------------------------------------------------------------------------------
RegisterDept.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">
<%@ taglib prefix="s" uri="/struts-tags"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Employee Database</title>

</head>
<body>
<h2>Employee</h2>
<s:form action="deptEntry" method="post">
<s:textfield name="dept.deptName" Label="Department Name" ></s:textfield>
<s:submit value="INSERT" align="center"/>
</s:form>



</body>
</html>


------------------------------------------------------------------------------------
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="employee" extends="struts-default" >
 
        <action name="deptEntry"
            class="employee.DeptAction" method="execute">
            <result name="success">successful.jsp</result>
            
        </action>
        
         
    </package>
   
</struts>

------------------------------------------------------------------------------------

No comments:

Post a Comment