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

1


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>

Tags

Post a Comment

1Comments

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.

    ReplyDelete
Post a Comment