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;
}
}
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;
}
}
Post a Comment
POST Answer of Questions and ASK to Doubt