Configuration files :
pom.xml, web.xml, root-context.xml. servlet-context.xml, contifuration.xml, Dept.xml
pom.xml
- dependencies
- encoding
servlet-context.xml
- prefix
- suffix
- base-package
root-context.xml
Spring controls DB, so we need :
- dataSource bean instance
- SqlSessionFactoryBean instance
- property
- Database connection
- constructor DI
configuration.xml
- typeAlias
Department and Employees Management System
Dept.java
Dept class has three columns. It is connected to the Dept table in the database.
package myBatis2.model;
public class Dept {
private int deptno;
private String dname;
private String loc;
public int getDeptno() {
return deptno;
}
public void setDeptno(int deptno) {
this.deptno = deptno;
}
public String getDname() {
return dname;
}
public void setDname(String dname) {
this.dname = dname;
}
public String getLoc() {
return loc;
}
public void setLoc(String loc) {
this.loc = loc;
}
}Emp.java
Emp class has eight columns. It is connected to the Emp table in the database.
package myBatis2.model;
import java.sql.Date;
public class Emp {
private int empno;
private String ename;
private String job;
private int mgr;
private Date hiredate;
private int sal;
private int comm;
private int deptno;
private String dname;
private String loc;
public String getDname() {
return dname;
}
public void setDname(String dname) {
this.dname = dname;
}
public String getLoc() {
return loc;
}
public void setLoc(String loc) {
this.loc = loc;
}
public int getEmpno() {
return empno;
}
public void setEmpno(int empno) {
this.empno = empno;
}
public String getEname() {
return ename;
}
public void setEname(String ename) {
this.ename = ename;
}
public String getJob() {
return job;
}
public void setJob(String job) {
this.job = job;
}
public int getMgr() {
return mgr;
}
public void setMgr(int mgr) {
this.mgr = mgr;
}
public Date getHiredate() {
return hiredate;
}
public void setHiredate(Date hiredate) {
this.hiredate = hiredate;
}
public int getSal() {
return sal;
}
public void setSal(int sal) {
this.sal = sal;
}
public int getComm() {
return comm;
}
public void setComm(int comm) {
this.comm = comm;
}
public int getDeptno() {
return deptno;
}
public void setDeptno(int deptno) {
this.deptno = deptno;
}
}configuration.xml
configuration file connects to the tables.
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<typeAliases>
<typeAlias alias="dept" type="myBatis2.model.Dept" />
<typeAlias alias="emp" type="myBatis2.model.Emp" />
</typeAliases>
</configuration>In the service folder, there consist of interfaces.
index.jsp
Once you run this file, the dispatcher servlet will be run right away and it is loaded to the controller classes.
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<script type="text/javascript">
location.href="deptList.do";
</script>
</body>
</html>deptList.do -> DeptController.java
DeptController.java
DeptController class receives the deptList.do with the @RequestMapping annotation.
The name of the service is injected as ds.
package myBatis2.controller;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;
import myBatis2.model.Dept;
import myBatis2.service.DeptService;
@Controller
public class DeptController {
@Autowired
private DeptService ds;
// Dept List
@RequestMapping("deptList.do")
public String deptList(Model model) {
List<Dept> list = ds.list();
model.addAttribute("list", list);
return "deptList";
}Control key + Click the second one -> you will be loaded to the DeptServiceImpl.java.
Dept.xml (Mapper)
To avoid overlapped id values, you must use <mapper namespace="deptns">.
Whenever we need to connect to the database, we will return to Dept.xml to execute the SQLs.
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="deptns">
<!-- Use type aliases to avoid typing the full classname every time. -->
<resultMap id="deptResult" type="dept">
<result property="deptno" column="deptno" />
<result property="dname" column="dname" />
<result property="loc" column="loc" />
</resultMap>
<select id="list" resultMap="deptResult">
select * from dept order by deptno
</select>
<select id="select" parameterType="int" resultType="dept">
select * from dept where deptno=#{deptno}
</select>
<update id="update" parameterType="dept">
update dept set dname=#{dname},loc=#{loc} where deptno=#{deptno}
</update>
<delete id="delete" parameterType="int">
delete from dept where deptno=#{deptno}
</delete>
<insert id="insert" parameterType="dept">
insert into dept values(#{deptno},#{dname},#{loc})
</insert>
</mapper>deptList.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ include file="header.jsp"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<div class="container" align="center">
<h2 class="text-primary">Dept List</h2>
<table class="table table-hover">
<tr>
<th>Dept Code</th>
<th>Dept Name</th>
<th>Dept Location</th>
<th></th>
<th></th>
</tr>
<c:if test="${empty list}">
<tr>
<td colspan="5">There is no data.</td>
</tr>
</c:if>
<c:if test="${not empty list }">
<c:forEach var="dept" items="${list}">
<tr>
<td>${dept.deptno}</td>
<td><a href="empList.do?deptno=${dept.deptno}"
class="btn btn-info">${dept.dname}</a></td>
<td>${dept.loc }</td>
<td><a href="deptUpdateForm.do?deptno=${dept.deptno }"
class="btn btn-success">Edit</a></td>
<td><a href="deptDelete.do?deptno=${dept.deptno }"
class="btn btn-danger">Delete</a></td>
</c:forEach>
</c:if>
</table>
<a href="deptInsertForm.do" class="btn btn-info">New Dept</a>
<a href="empAllList.do" class="btn btn-default">Emp List</a>
</div>
</body>
</html>index.jsp leads to the Dept List.
When you click the Emp List, it leads to the empAllList.do, EmpController.java.
EmpController.java
In this class, you need to use the @Autowired annotation separately, not like this :
package myBatis2.controller;
import java.sql.Date;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import myBatis2.model.Dept;
import myBatis2.model.Emp;
import myBatis2.service.DeptService;
import myBatis2.service.EmpService;
@Controller
public class EmpController {
@Autowired
private EmpService es;
@Autowired
private DeptService ds;
@RequestMapping("empList.do")
public String empList(int deptno, Model model) {
Dept dept = ds.select(deptno);
List<Emp> list = es.list(deptno);
model.addAttribute("dept", dept);
model.addAttribute("list", list);
return "emp/empList";
}empAllList.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ include file="../header.jsp"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<div class="container">
<table class="table table-striped">
<tr>
<td>No.</td>
<td>Name</td>
<td>Position</td>
<td>Salary</td>
<td>Dept Code</td>
<td>Dept Name</td>
<td>Dept Location</td>
</tr>
<c:forEach var="emp" items="${list }">
<tr>
<td>${emp.empno }</td>
<td>${emp.ename }</td>
<td>${emp.job }</td>
<td>${emp.sal }</td>
<td>${emp.deptno }</td>
<td>${emp.dname }</td>
<td>${emp.loc }</td>
</tr>
</c:forEach>
</table>
<a href="deptList.do" class="btn btn-default">Dept List</a>
</div>
</body>
</html>
When you click the Dept List, you will go back to the Dept List, and when you click the New Dept, it will load to the DeptController.java, and to the deptInsertForm.jsp.
deptInsertForm.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ include file="header.jsp"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<div class="container" align="center">
<h2 class="text-primary">New Dept Data</h2>
<form action="deptInsert.do" method="post">
<table class="table table-hover">
<tr>
<td>Dept Code</td>
<td><input type="number" maxlength="2" name="deptno"
required="required" autofocus="autofocus"></td>
</tr>
<tr>
<td>Dept Name</td>
<td><input type="text" name="dname" required="required"></td>
</tr>
<tr>
<td>Dept Location</td>
<td><input type="text" name="loc" required="required"></td>
</tr>
<tr>
<td colspan="2"><input type="submit" value="Submit"></td>
</tr>
</table>
</form>
</div>
</body>
</html>DeptController.java
By using the @ModelAttribute annotation, you can receive the values at once.
//New Dept Insert
@RequestMapping("deptInsertForm.do")
public String deptInsertForm() {
return "deptInsertForm";
}
@RequestMapping("deptInsert.do")
public String deptInsert(@ModelAttribute Dept dept,
Model model) {
Dept dt = ds.select(dept.getDeptno());
if (dt == null) {
int result = ds.insert(dept);
model.addAttribute("result", result);
} else {
model.addAttribute("msg", "Overlapped Data");
model.addAttribute("result", -1);
}
return "deptInsert";
}
If you insert the overlapped Data, you will get this alert.
Successfully updated.
DeptDaoImpl.java
package myBatis2.dao;
import java.util.List;
import org.mybatis.spring.SqlSessionTemplate;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import myBatis2.model.Dept;
@Repository
public class DeptDaoImpl implements DeptDao {
@Autowired
private SqlSessionTemplate st;
public List<Dept> list() {
return st.selectList("deptns.list");
}
public int insert(Dept dept) {
return st.insert("deptns.insert", dept);
}
public Dept select(int deptno) {
return st.selectOne("deptns.select", deptno);
}
public int update(Dept dept) {
return st.update("deptns.update", dept);
}
public int delete(int deptno) {
return st.delete("deptns.delete", deptno);
}
}To edit and delete, we will click these green and red buttons.
deptUpdateForm.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ include file="header.jsp"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<div class="container" align="center">
<h2 class="text-primary">Edit Dept Info</h2>
<form action="deptUpdate.do" method="post">
<input type="hidden" name="deptno" value="${dept.deptno }">
<table class="table table-hover">
<tr>
<td>Dept Code</td>
<td>${dept.deptno}</td>
</tr>
<tr>
<td>Dept Name</td>
<td><input type="text" name="dname" required="required"
value="${dept.dname}"></td>
</tr>
<tr>
<td>Dept Location</td>
<td><input type="text" name="loc" required="required"
value="${dept.loc}"></td>
</tr>
<tr>
<td colspan="2"><input type="submit" value="Submit"></td>
</tr>
</table>
</form>
</div>
</body>
</html>
deptUpdate.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ include file="header.jsp"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<c:if test="${result > 0 }">
<script type="text/javascript">
alert("Successfully edited.");
location.href = "deptList.do";
</script>
</c:if>
<c:if test="${result <= 0 }">
<script type="text/javascript">
alert("Failed to edit.");
history.go(-1);
</script>
</c:if>
</body>
</html>DeptController.java
// Update
@RequestMapping("deptUpdateForm.do")
public String deptUpdateForm(int deptno, Model model) {
Dept dept = ds.select(deptno);
model.addAttribute("dept", dept);
return "deptUpdateForm";
}
@RequestMapping("deptUpdate.do")
public String deptUpdate(@ModelAttribute Dept dept, Model model) {
int result = ds.update(dept);
model.addAttribute("result", result);
return "deptUpdate";
}
There is no delete form since we don't need any information to be inserted.
deptDelete.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ include file="header.jsp"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<c:if test="${result > 0 }">
<script type="text/javascript">
alert("Successfully Deleted.");
location.href = "deptList.do";
</script>
</c:if>
<c:if test="${result <= 0 }">
<script type="text/javascript">
alert("Failed to delete."");
location.href = "deptList.do";
</script>
</c:if>
</body>
</html>DeptController.java
//Delete
@RequestMapping("deptDelete.do")
public String deptDelete(@RequestParam ("deptno") int deptno, Model model) {
int result = ds.delete(deptno);
model.addAttribute("result", result);
return "deptDelete";
}
You can delete the things that have no foreign key references.
deptList.jsp was for showing the list of departments. If you click the department's name, you will see the list of employees.
EmpController.java controls the Emp List.
EmpController.java
// Emp List
@RequestMapping("empList.do")
public String empList(int deptno, Model model) {
Dept dept = ds.select(deptno);
List<Emp> list = es.list(deptno);
model.addAttribute("dept", dept);
model.addAttribute("list", list);
return "emp/empList";
}Since we are dealing with two different tables, we
EmpDaoImpl.java
package myBatis2.dao;
import java.util.List;
import org.mybatis.spring.SqlSessionTemplate;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import myBatis2.model.Dept;
@Repository
public class DeptDaoImpl implements DeptDao {
@Autowired
private SqlSessionTemplate st;
public List<Dept> list() {
return st.selectList("deptns.list");
}
public int insert(Dept dept) {
return st.insert("deptns.insert", dept);
}
public Dept select(int deptno) {
return st.selectOne("deptns.select", deptno);
}
public int update(Dept dept) {
return st.update("deptns.update", dept);
}
public int delete(int deptno) {
return st.delete("deptns.delete", deptno);
}
}Emp.xml (Mapper)
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="empns">
<!-- Use type aliases to avoid typing the full classname every time. -->
<resultMap id="empResult" type="emp">
<result property="empno" column="empno" />
<result property="ename" column="ename" />
<result property="job" column="job" />
<result property="mgr" column="mgr" />
<result property="hiredate" column="hiredate" />
<result property="sal" column="sal" />
<result property="comm" column="comm" />
<result property="deptno" column="deptno" />
<result property="dname" column="dname" />
<result property="loc" column="loc" />
</resultMap>
<select id="empList" resultMap="empResult">
select * from emp order by empno
</select>
<select id="list" parameterType="int" resultMap="empResult">
select * from emp where deptno=#{deptno} order by empno
</select>
<select id="select" parameterType="int" resultType="emp">
select * from emp where empno=#{empno}
</select>
<insert id="insert" parameterType="emp">
insert into emp values(#{empno},#{ename},#{job},#{mgr},
#{hiredate},#{sal},#{comm},#{deptno})
</insert>
<delete id="delete" parameterType="int">
delete from emp where empno=#{empno}
</delete>
<update id="update" parameterType="emp">
update emp set ename=#{ename},job=#{job},sal=${sal},
comm=#{comm},deptno=#{deptno} where empno=#{empno}
</update>
<select id="empAllList" resultMap="empResult">
select e.*,dname,loc from emp e, dept d
where e.deptno=d.deptno order by empno
</select>
</mapper>empList.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ include file="../header.jsp"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<script type="text/javascript">
$(function() {
$('#list').load('deptList.do');
});
</script>
</head>
<body>
<div class="container" align="center">
<h2 class="text-primary">${dept.dname} Emp List</h2>
<table class="table table-striped">
<tr>
<td>No.</td>
<td>Name</td>
<td>Position</td>
<td>Salary</td>
<td>Dept Code</td>
</tr>
<tr>
<c:if test="${empty list }">
<tr>
<td colspan="5">No Employees.</td>
</tr>
</c:if>
<c:if test="${not empty list }">
<c:forEach var="emp" items="${list }">
<tr>
<td>${emp.empno }</td>
<td><a href="empView.do?empno=${emp.empno}"
class="btn btn-info">${emp.ename}</a></td>
<td>${emp.job}</td>
<td>${emp.sal}</td>
<td>${emp.deptno}</td>
</tr>
</c:forEach>
</c:if>
</table>
<a href="deptList.do" class="btn btn-success">Dept List</a>
<a href="empInsertForm.do" class="btn btn-success">New Emp</a>
<div id="list"></div>
</div>
</body>
</html>To insert new employee data, click the New Emp button in the Emp List.
empInsertForm.java
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ include file="../header.jsp"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<script type="text/javascript">
$(function() {
$('#dupCheck').click(function() {
var empno = $('#empno').val();
if (!empno) {
alert('Insert the Emp No first');
$('#empno').focus();
return false;
}// $.post("요청이름","전달될 값","콜백함수");
$.post('dupCheck.do', 'empno=' + empno, function(msg) {
alert(msg);
});
});
});
</script>
</head>
<body>
<div class="container">
<h2 class="text-primary">New Employee</h2>
<form action="empInsert.do" method="post">
<table class="table table-bordered">
<tr>
<td>Emp No</td>
<td><input type="number" name="empno" required="required"
id="empno" autofocus="autofocus">
<input type="button" value="Check" id="dupCheck"></td>
</tr>
<tr>
<td>Name</td>
<td><input type="text" name="ename" required="required"></td>
</tr>
<tr>
<td>Position</td>
<td><input type="text" name="job" required="required"></td>
</tr>
<tr>
<td>Manager</td>
<td><select name="mgr">
<c:forEach var="emp" items="${empList }">
<option value="${emp.empno}">${emp.ename}</option>
</c:forEach>
</select>
</td>
</tr>
<tr>
<td>Hired date</td>
<td><input type="date" name="hiredate" required="required"></td>
</tr>
<tr>
<td>Salary</td>
<td><input type="number" name="sal" required="required"></td>
</tr>
<tr>
<td>Bonus</td>
<td><input type="number" name="comm" required="required"></td>
</tr>
<tr>
<td>Dept Code</td>
<td><select name="deptno">
<c:forEach var="dept" items="${deptList }">
<option value="${dept.deptno}">${dept.dname}</option>
</c:forEach>
</select>
</td>
</tr>
<tr>
<td colspan="2"><input type="submit" value="Submit"></td>
</tr>
</table>
</form>
</div>
</body>
</html>
Once you get this alert box, you will see the emp number you inserted on the console.
EmpController.java
// New Emp
@RequestMapping("empInsertForm.do")
public String empInsertForm(Model model) {
List<Dept> deptList = ds.list();
List<Emp> empList = es.empList();
model.addAttribute("deptList", deptList);
model.addAttribute("empList", empList);
return "emp/empInsertForm";
}
// Emp Number Check
@RequestMapping("dupCheck.do")
public String dupCheck(int empno, Model model) {
System.out.println("empno:"+empno);
Emp emp = es.select(empno);
String msg = "";
if (emp != null)
msg = "Overlapped Data";
else
msg = "Available emp Number";
model.addAttribute("msg", msg);
return "emp/dupCheck";
}
@RequestMapping("empInsert.do")
// public String empInsert(Emp emp, String hiredate1, Model model) {
public String empInsert(Emp emp, Model model) {
// emp.setHiredate(Date.valueOf(hiredate1)); // String -> Date Type Conversion
int result = es.insert(emp);
model.addAttribute("result", result);
model.addAttribute("deptno", emp.getDeptno());
return "emp/empInsert";
}To Edit the emp click the name of the employees and see the detail page.
empView.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ include file="../header.jsp"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<script type="text/javascript">
$(function() {
$('#list').load('empList.do?deptno=${emp.deptno}');
});
</script>
</head>
<body>
<div class="container">
<h2 class="text-primary">Employee Detail</h2>
<table class="table table-bordered">
<tr>
<td>Emp No.</td>
<td>${emp.empno }</td>
</tr>
<tr>
<td>Name</td>
<td>${emp.ename}</td>
</tr>
<tr>
<td>Position</td>
<td>${emp.job }</td>
</tr>
<tr>
<td>Manager</td>
<td>${emp.mgr }</td>
</tr>
<tr>
<td>Hired Date</td>
<td>${emp.hiredate }</td>
</tr>
<tr>
<td>Salary</td>
<td>${emp.sal }</td>
</tr>
<tr>
<td>Bonus</td>
<td>${emp.comm }</td>
</tr>
<tr>
<td>Dept Code</td>
<td>${emp.deptno }</td>
</tr>
</table>
<a href="empUpdateForm.do?empno=${emp.empno}" class="btn btn-info">Edit</a>
<a class="btn btn-danger" href="empDelete.do?empno=${emp.empno}">Delete</a>
<a href="empList.do?deptno=${emp.deptno}" class="btn btn-default">List</a>
<div id="list"></div>
</div>
</body>
</html>Click Edit or Delete to process.
empUpdateForm.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ include file="../header.jsp"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<div class="container" align="center">
<h2 class="text-primary">Edit Employee Information</h2>
<form action="empUpdate.do" method="post">
<table class="table table-bordered">
<tr>
<td>Emp No.</td>
<td><input type="text" name="empno" readonly="readonly"
value="${emp.empno}"></td>
</tr>
<tr>
<td>Name</td>
<td><input type="text" name="ename" required="required"
value="${emp.ename }"></td>
</tr>
<tr>
<td>Position</td>
<td><input type="text" name="job" required="required"
value="${emp.job }"></td>
</tr>
<tr>
<td>Salary</td>
<td><input type="text" name="sal" required="required"
value="${emp.sal}"></td>
</tr>
<tr>
<td>Bonus</td>
<td><input type="text" name="comm" required="required"
value="${emp.comm }"></td>
</tr>
<tr>
<td>Dept Code.</td>
<td><select name="deptno">
<c:forEach var="dept" items="${deptList}">
<c:if test="${emp.deptno==dept.deptno}">
<option value="${dept.deptno}" selected="selected">
${dept.dname}(${dept.deptno})</option>
</c:if>
<c:if test="${emp.deptno!=dept.deptno}">
<option value="${dept.deptno}">${dept.dname}(${dept.deptno})</option>
</c:if>
</c:forEach>
</select></td>
</tr>
<tr>
<td colspan="2"><input type="submit" value="Edit"></td>
</tr>
</table>
</form>
</div>
</body>
</html>
EmpController.java
// Update Emp Information
@RequestMapping("empUpdateForm.do")
public String empUpdateForm(int empno, Model model) {
Emp emp = es.select(empno);
List<Dept> deptList = ds.list();
model.addAttribute("emp", emp);
model.addAttribute("deptList", deptList);
return "emp/empUpdateForm";
}
@RequestMapping("empUpdate.do")
public String empUpdate(Emp emp, Model model) {
int result = es.update(emp);
model.addAttribute("deptno", emp.getDeptno());
model.addAttribute("result", result);
return "emp/empUpdate";
}
To delete,
empDelete.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ include file="../header.jsp"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<c:if test="${result > 0 }">
<script type="text/javascript">
alert("Successfully deleted. ");
location.href = "empList.do?deptno=${deptno}";
</script>
</c:if>
<c:if test="${result <= 0 }">
<script type="text/javascript">
alert("Failed to delete.");
history.go(-1);
</script>
</c:if>
</body>
</html>EmpController.java
// Delete Emp
@RequestMapping("empDelete.do")
public String empDelete(int empno, Model model) {
Emp emp = es.select(empno);
int result = es.delete(empno);
model.addAttribute("result", result);
model.addAttribute("deptno", emp.getDeptno());
return "emp/empDelete";
}