Java, .NET, PHP, PYTHON, ANGULAR, ML, Data Science, Testing, CI Tutorials in Easy Languages.

"Best Software Training, Internship, Project Development center of Indore India, Helpline 780506-3968"

 Spring MVC With Hibernate Connection:-


Step1s:-


Create Database and Table.

database name hiberdb and tablename employee(empid,empname,jo)


Step2nd:-

Create hibernate.cfg.xml:-

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-configuration PUBLIC

"-//Hibernate/Hibernate Configuration DTD 3.0//EN"

"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">


<hibernate-configuration>

<session-factory>

<property name="connection.driver_class">com.mysql.jdbc.Driver</property>

<property name="connection.url">jdbc:mysql://localhost:3306/hiberdb</property>

<property name="connection.username">root</property>

<property name="dialect">org.hibernate.dialect.MySQLDialect</property>

<mapping class="com.scs.dao.Emp"></mapping>

</session-factory>

</hibernate-configuration>

Step3rd:-


Create POJO or BEAN Class under package com.scs.dao

package com.scs.dao;


import javax.persistence.*;


@Entity

@Table(name="employee")

public class Emp {

@Id

private int empid;

@Column

private String empname;

@Column

private String job;

public int getEmpid() {

return empid;

}

public void setEmpid(int empid) {

this.empid = empid;

}

public String getEmpname() {

return empname;

}

public void setEmpname(String empname) {

this.empname = empname;

}

public String getJob() {

return job;

}

public void setJob(String job) {

this.job = job;

}




}


Step4th:-  Create Controller to load dynamic view

package com.scs.bao;




import org.hibernate.Session;

import org.hibernate.SessionFactory;

import org.hibernate.Transaction;

import org.hibernate.cfg.Configuration;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.ModelAttribute;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RequestMethod;

import org.springframework.web.servlet.ModelAndView;


import com.scs.dao.*;

@Controller

public class EmployeeController {

@RequestMapping("emp")

    public ModelAndView additon(){

    return new ModelAndView("empview","command",new Emp());

    }

@RequestMapping(value="empinsert",method = RequestMethod.POST)

    public ModelAndView additonLogic(@ModelAttribute("Spring-MVC-Addition")Emp s){

Configuration cfg = new Configuration();

cfg.configure("hibernate.cfg.xml");

SessionFactory sf = cfg.buildSessionFactory();

Session sess = sf.openSession();

Transaction tx= sess.beginTransaction();

sess.save(s);

tx.commit();

sess.close();

ModelAndView obj=new ModelAndView("empview","command",new Emp());

obj.addObject("res", "Data Inserted Successfully ");

    return obj;

    }

}



Step5th:-

Create View File and design form using JSTL

<%@ 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>Insert title here</title>
<%@taglib uri="http://www.springframework.org/tags/form" prefix="form"%>
</head>
<body>
<form:form action="empinsert.html" method="post">
<form:input path="empid"></form:input>
<br>
<br>
<form:input path="empname"></form:input>
<br>
<br>
<form:input path="job"></form:input>
<br>
<br>
<input type="submit" name="btnsubmit" value="Click" />


</form:form>

<%
if(request.getAttribute("res")!=null)
{
out.print(request.getAttribute("res"));
}

%>
</body>
</html>









Post a Comment

POST Answer of Questions and ASK to Doubt

Previous Post Next Post