Skip to main content

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



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>

Comments

  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

POST Answer of Questions and ASK to Doubt

Popular posts from this blog

Uncontrolled form input in React-JS

  Uncontrolled form input in React-JS? If we want to take input from users without any separate event handling then we can uncontrolled the data binding technique. The uncontrolled input is similar to the traditional HTML form inputs. The DOM itself handles the form data. Here, the HTML elements maintain their own state that will be updated when the input value changes. To write an uncontrolled component, you need to use a ref to get form values from the DOM. In other words, there is no need to write an event handler for every state update. You can use a ref to access the input field value of the form from the DOM. Example of Uncontrolled Form Input:- import React from "react" ; export class Info extends React . Component {     constructor ( props )     {         super ( props );         this . fun = this . fun . bind ( this ); //event method binding         this . input = React . createRef ();...

JSP Page design using Internal CSS

  JSP is used to design the user interface of an application, CSS is used to provide set of properties. Jsp provide proper page template to create user interface of dynamic web application. We can write CSS using three different ways 1)  inline CSS:-   we will write CSS tag under HTML elements <div style="width:200px; height:100px; background-color:green;"></div> 2)  Internal CSS:-  we will write CSS under <style> block. <style type="text/css"> #abc { width:200px;  height:100px;  background-color:green; } </style> <div id="abc"></div> 3) External CSS:-  we will write CSS to create a separate file and link it into HTML Web pages. create a separate file and named it style.css #abc { width:200px;  height:100px;  background-color:green; } go into Jsp page and link style.css <link href="style.css"  type="text/css" rel="stylesheet"   /> <div id="abc"> </div> Exam...

JDBC using JSP and Servlet

JDBC means Java Database Connectivity ,It is intermediates from Application to database. JDBC has different type of divers and provides to communicate from database server. JDBC contain four different type of approach to communicate with Database Type 1:- JDBC-ODBC Driver Type2:- JDBC Vendor specific Type3 :- JDBC Network Specific Type4:- JDBC Client-Server based Driver  or JAVA thin driver:- Mostly we prefer Type 4 type of Driver to communicate with database server. Step for JDBC:- 1  Create Database using MYSQL ,ORACLE ,MS-SQL or any other database 2   Create Table using database server 3   Create Form according to database table 4  Submit Form and get form data into servlet 5  write JDBC Code:-     5.1)   import package    import java.sql.*     5.2)  Add JDBC Driver according to database ide tools     5.3)  call driver in program         ...