Spring MVC With Hibernate Example, Database connectivity in Spring MVC + Hibernate + MYSQL



Create Database and Table.

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


Create hibernate.cfg.xml:-

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

<!DOCTYPE hibernate-configuration PUBLIC

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




<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>



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

package com.scs.dao;

import javax.persistence.*;



public class Emp {


private int empid;


private String empname;


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.*;


public class EmployeeController {


    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();


SessionFactory sf = cfg.buildSessionFactory();

Session sess = sf.openSession();

Transaction tx= sess.beginTransaction();




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

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

    return obj;



Create View File and design form using JSTL
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<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"%>
<form:form action="empinsert.html" method="post">
<form:input path="empid"></form:input>
<form:input path="empname"></form:input>
<form:input path="job"></form:input>
<input type="submit" name="btnsubmit" value="Click" />


Post a Comment


POST Answer of Questions and ASK to Doubt

  1. It’s based on the 5-card draw poker and uses a single deck of fifty two half in} playing cards. Video poker has a number of} variants, however the oldest is Jacks or Better, also known as|also called|also referred to as} Draw Poker. Is an excellent sport and simple to play if you already know the way to|tips on how to} play five-card draw poker. It has a component of talent along with luck, in contrast with the pure luck of half in} slot machines. Your possibilities of successful are improved if you use a great strategy to 카지노 play the machine.

Post a Comment