Java Revision Blog: Spring and Hibernate

Spring MVC CRUD

Emp.java
package com.javatpoint.beans;

public class Emp {
private int id;
private String name;
private float salary;
private String designation;

public int getId() {
return id;
}

public void setId(int id) {
this.id = id;
}

public String getName() {
return name;
}

public void setName(String name) {
this.name = name;
}

public float getSalary() {
return salary;
}

public void setSalary(float salary) {
this.salary = salary;
}

public String getDesignation() {
return designation;
}

public void setDesignation(String designation) {
this.designation = designation;
}

}

EmpDao.java

package com.javatpoint.dao;

import org.springframework.jdbc.core.BeanPropertyRowMapper;

import org.springframework.jdbc.core.JdbcTemplate;

import org.springframework.jdbc.core.RowMapper;

import com.javatpoint.beans.Emp;

import com.kenai.jaffl.struct.Struct.String;

import com.mysql.jdbc.ResultSet;

public class EmpDao {

JdbcTemplate template;

public void setTemplate(JdbcTemplate template) {

this.template = template;

}

public int save(Emp p) {

String sql = "insert into Emp99(name,salary,designation) values('"

+ p.getName() + "'," + p.getSalary() + ",'"

+ p.getDesignation() + "')";

return template.update(sql);

}

public int update(Emp p) {

String sql = "update Emp99 set name='" + p.getName() + "', salary="

+ p.getSalary() + ", designation='" + p.getDesignation()

+ "' where id=" + p.getId() + "";

return template.update(sql);

}

public int delete(int id) {

String sql = "delete from Emp99 where id=" + id + "";

return template.update(sql);

}

public Emp getEmpById(int id) {

String sql = "select * from Emp99 where id=?";

return template.queryForObject(sql, new Object[] { id },

new BeanPropertyRowMapper<Emp>(Emp.class));

}

public List<Emp> getEmployees() {

return template.query("select * from Emp99", new RowMapper<Emp>() {

public Emp mapRow(ResultSet rs, int row) throws SQLException {

Emp e = new Emp();

e.setId(rs.getInt(1));

e.setName(rs.getString(2));

e.setSalary(rs.getFloat(3));

e.setDesignation(rs.getString(4));

return e;

}

});

}

EmpController.java

package com.javatpoint.controllers;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Controller;

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

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

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

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

import org.springframework.web.servlet.ModelAndView;

import com.javatpoint.beans.Emp;

import com.javatpoint.dao.EmpDao;

@Controller

public class EmpController {

@Autowired

EmpDao dao;// will inject dao from xml file

* It displays a form to input data, here "command" is a reserved request

* attributewhich is used to display object data into form

@RequestMapping("/empform")

public ModelAndView showform() {

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

}

* It saves object into database. The @ModelAttribute puts request data into

* model object. You need to mention RequestMethod.POST method because

* default request is GET

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

public ModelAndView save(@ModelAttribute("emp") Emp emp) {

dao.save(emp);

return new ModelAndView("redirect:/viewemp");// will redirect to viewemp

// request mapping

}

/* It provides list of employees in model object */

@RequestMapping("/viewemp")

public ModelAndView viewemp() {

List<Emp> list = dao.getEmployees();

return new ModelAndView("viewemp", "list", list);

}

* It displays object data into form for the given id. The @PathVariable

* puts URL data into variable.

@RequestMapping(value = "/editemp/{id}")

public ModelAndView edit(@PathVariable int id) {

Emp emp = dao.getEmpById(id);

return new ModelAndView("empeditform", "command", emp);

}

/* It updates model object. */

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

public ModelAndView editsave(@ModelAttribute("emp") Emp emp) {

dao.update(emp);

return new ModelAndView("redirect:/viewemp");

}

/* It deletes record for the given id in URL and redirects to /viewemp */

@RequestMapping(value = "/deleteemp/{id}", method = RequestMethod.GET)

public ModelAndView delete(@PathVariable int id) {

dao.delete(id);

return new ModelAndView("redirect:/viewemp");

}

jsp:
empeditform.jsp
<%@ taglib uri="http://www.springframework.org/tags/form" prefix="form"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>

<h1>Edit Employee</h1>
<form:form method="POST" action="/SpringMVCCRUDSimple/editsave">
<table>
<tr>
<td></td>
<td><form:hidden path="id" /></td>
</tr>
<tr>
<td>Name :</td>
<td><form:input path="name" /></td>
</tr>
<tr>
<td>Salary :</td>
<td><form:input path="salary" /></td>
</tr>
<tr>
<td>Designation :</td>
<td><form:input path="designation" /></td>
</tr>

<tr>
<td></td>
<td><input type="submit" value="Edit Save" /></td>
</tr>
</table>
</form:form>

empform.jsp

<%@ taglib uri="http://www.springframework.org/tags/form" prefix="form"%>

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>

<h1>Add New Employee</h1>

<form:form method="post" action="save">

<tr>

</tr>

<tr>

<td>Salary :</td>

</tr>

<tr>

<td>Designation :</td>

</tr>

<tr>

</tr>

</table>

</form:form>

viewemp.jsp

<%@ taglib uri="http://www.springframework.org/tags/form" prefix="form"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>

<h1>Employees List</h1>
<table border="2" width="70%" cellpadding="2">
<tr>
<th>Id</th>
<th>Name</th>
<th>Salary</th>
<th>Designation</th>
<th>Edit</th>
<th>Delete</th>
</tr>
<c:forEach var="emp" items="${list}">
<tr>
<td>${emp.id}</td>
<td>${emp.name}</td>
<td>${emp.salary}</td>
<td>${emp.designation}</td>
<td><a href="editemp/${emp.id}">Edit</a></td>
<td><a href="deleteemp/${emp.id}">Delete</a></td>
</tr>
</c:forEach>
</table>
<br />
<a href="empFform">Add New Employee</a>

web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">

<servlet>
<servlet-name>spring</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>spring</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>

</web-app>

spring-servlet.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd">

<context:component-scan base-package="com.javatpoint.controllers"></context:component-scan>

<bean
class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/jsp/"></property>
<property name="suffix" value=".jsp"></property>
</bean>

<bean id="ds"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>
<property name="url" value="jdbc:oracle:thin:@localhost:1521:xe"></property>
<property name="username" value="raghu"></property>
<property name="password" value="raghu"></property>
</bean>

<bean id="jt" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="ds"></property>
</bean>

<bean id="dao" class="com.javatpoint.dao.EmpDao">
<property name="template" ref="jt"></property>
</bean>
</beans>

WebContent:-
index.jsp
<a href="empform">Add Employee</a>
<a href="viewemp">View Employees</a>



Spring MVC Pagination

Emp.java
package com.javatpoint.beans;

public class Emp {
private int id;
private String name;
private float salary;

public int getId() {
return id;
}

public void setId(int id) {
this.id = id;
}

public String getName() {
return name;
}

public void setName(String name) {
this.name = name;
}

public float getSalary() {
return salary;
}

public void setSalary(float salary) {
this.salary = salary;
}

}

EmpDao.java

package com.javatpoint.dao;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.List;

import org.springframework.jdbc.core.JdbcTemplate;

import org.springframework.jdbc.core.RowMapper;

import com.javatpoint.beans.Emp;

public class EmpDao {

JdbcTemplate template;

public void setTemplate(JdbcTemplate template) {

this.template = template;

}

public List<Emp> getEmployeesByPage(int pageid, int total) {

String sql = "select * from Emp limit " + (pageid - 1) + "," + total;

return template.query(sql, new RowMapper<Emp>() {

public Emp mapRow(ResultSet rs, int row) throws SQLException {

Emp e = new Emp();

e.setId(rs.getInt(1));

e.setName(rs.getString(2));

e.setSalary(rs.getFloat(3));

return e;

}

});

}

EmpController.java

package com.javatpoint.controllers;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Controller;

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

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

import org.springframework.web.servlet.ModelAndView;

import com.javatpoint.beans.Emp;

import com.javatpoint.dao.EmpDao;

@Controller

public class EmpController {

@Autowired

EmpDao dao;

@RequestMapping(value = "/viewemp/{pageid}")

public ModelAndView edit(@PathVariable int pageid) {

int total = 5;

if (pageid == 1) {

} else {

pageid = (pageid - 1) * total + 1;

}

List<Emp> list = dao.getEmployeesByPage(pageid, total);

return new ModelAndView("viewemp", "list", list);

}

viewemp.jsp

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>

<h1>Employees List</h1>

<tr>

<th>Salary</th>

</tr>

<c:forEach var="emp" items="${list}">

<tr>

<td>${emp.salary}</td>

</tr>

</c:forEach>

</table>

<br />

web.xml

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

<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://java.sun.com/xml/ns/javaee

http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">

<servlet-name>spring</servlet-name>

<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>spring</servlet-name>

<url-pattern>/</url-pattern>

</servlet-mapping>

</web-app>

spring-servlet.xml

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

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"

xmlns:context="http://www.springframework.org/schema/context"

xsi:schemaLocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans-3.0.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context-3.0.xsd">

<context:component-scan base-package="com.javatpoint.controllers"></context:component-scan>

<bean

class="org.springframework.web.servlet.view.InternalResourceViewResolver">

</bean>

<bean id="ds"

class="org.springframework.jdbc.datasource.DriverManagerDataSource">

</bean>

</bean>

</bean>

</beans>

WebContent:

index.jsp

<a href="viewemp/1">View Employees</a>





Java Revision Blog

Pages

Spring and Hibernate

No comments:

Post a Comment