SSM的CRUD,使用ajax实现
基本信息介绍
版本2 - 使用ajax来进行CRUD。
在
Controller
中对于
@RequestMapping
注解参数path的值,用两种区分,一种带后缀UI,一种不带。
-
地址后缀带UI的表示显示(打开)一个页面,只是做单纯的页面跳转,不访问数据库。
-
不带UI的是访问数据库,通过sql查询,然后通过jackson实现返回json格式的参数。
使用aJax进行增删查改的时候,是不需要切换页面的,所有的内容都在一个页面上,通过css设置style的属性display,将其值设置为none不可见(这种方式是不占页面空间的),需要显示的时候通过设置display为block显示出来。
可以用一下方法实现:
最终效果:
1. 主要代码(模板)
1.1 环境
pom.xml
需要fasterxml的依赖实现javabean对象与json数据之间转换。
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.11.3</version>
</dependency>
Msg
返回信息类,通过创建静态init方法,以后直接通过Msg.init()方法使用就行,简化调用操作
public class Msg {
private int code;
private String message;
private Object data;
public static Msg init(int code, String msg, Object data){
Msg result =new Msg(code,msg,data);
return result;
}
}
Department
public class Department {
private Integer did;
private String dname;
}
1.2 DepartmentController
@Controller
@RequestMapping("/deptv2")
public class DepartmentController {
private static final Logger log = LoggerFactory.getLogger(DepartmentController.class);
@Autowired
private IDepartmentService departmentService;
@RequestMapping(path = "/deptListUI",method = RequestMethod.GET)
public String deptListUI(Model model){
return "list_depts";
}
@RequestMapping(path="/deptList",method = {RequestMethod.GET})
@ResponseBody
public Object deptList(){
List<Department> allDepartments = departmentService.findAllDepartments();
log.info("deptList 查询所有部门 " + allDepartments);
return Msg.init(200,"",allDepartments);
}
@RequestMapping(path ="/saveDept",method = {RequestMethod.POST})
@ResponseBody
public Object saveDept(Department dept){
log.info("saveDept 保存信息: dept="+dept);
try {
departmentService.saveDepartment(dept);
return Msg.init(200,"添加成功",null);
} catch (Exception e) {
e.printStackTrace();
}
return Msg.init(-200,"添加失败",null);
}
@RequestMapping(path = "/deleteDept",method = RequestMethod.GET)
@ResponseBody
public Object deleteDept(Integer did){
log.info("deleteDept 删除部门 did = "+did);
try {
departmentService.deleteDepartmentById(did);
return Msg.init(200,"删除did = "+did+"的部门成功",null);
} catch (Exception e) {
e.printStackTrace();
}
return Msg.init(-200,"异常,删除失败",null);
}
@RequestMapping(path = "/findDeptById", method = RequestMethod.GET)
@ResponseBody
public Object findDeptById(Integer did) {
log.info("findDeptById 通过id查找部门 did=" + did);
if (did != null) {
Department dept = departmentService.findDepartmentById(did);
if (dept != null) {
return Msg.init(200, null, dept);
}
}
return Msg.init(-200, "没有查询到结果", null);
}
@RequestMapping(path="/updateDept",method = RequestMethod.POST)
@ResponseBody
public Object updateDept(Department dept){
log.info("updateDept 更新信息: dept="+dept);
try {
departmentService.updateDepartmentById(dept);
return Msg.init(200, "更新部门信息成功", null);
} catch (Exception e) {
e.printStackTrace();
}
return Msg.init(-200, "异常,更新失败", null);
}
}
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
- 101
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
- 101
1.3 list_depts.jsp前端html和jquery代码
<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
<title>部门crud-ajax版本</title>
<%-- 项目路径,简化${pageContext.request.contextPath}获取一长串 --%>
<% pageContext.setAttribute("path",request.getContextPath()); %>
<script type="text/javascript" src="${path}/js/jquery-1.11.0.min.js"></script>
<%-- ajax实现 --%>
<script type="text/javascript">
function switchDiv(part) {
$('#addDiv').css("display","none")
$('#listDiv').css("display","none")
$('#editDiv').css("display","none")
if(1 == part){
$('#addDiv').css("display","block")
$('#add_dname').val('')
}else if(2 == part){
$('#listDiv').css("display","block")
}else if(3 == part){
$('#editDiv').css("display","block")
}
}
$(function () {
switchDiv(2)
deptListUI()
$('#btn_add').click(function () {
var data = $('#add_form').serialize()
$.post('${path}/deptv2/saveDept',data,function (resultMsg) {
console.info(resultMsg)
switchDiv(2)
deptListUI()
switchDiv(2)
alert(resultMsg.message)
},'json')
})
})
function deptListUI() {
$.get('${path}/deptv2/deptList', function (resultMsg){
console.info("resultMsg = " + resultMsg)
var trs = ''
trs += ' <tr>\n' +
' <th>序号</th>\n' +
' <th>部门编号</th>\n' +
' <th>部门名称</th>\n' +
' <th>操作</th>\n' +
'\n' +
' </tr>'
if (200 == resultMsg.code) {
var items = resultMsg.data;
for (var i = 0; i < items.length;i++) {
var dept = items[i]
console.info(dept)
trs += ' <tr>\n' +
' <td>' + (i + 1) + '</td>\n' +
' <td>' + dept.did + '</td>\n' +
' <td>' + dept.dname + '</td>\n' +
' <td><a href="javascript:deleteDept('+dept.did+')">删除 | </a><a href="javascript:updateDeptUI('+dept.did+')">修改</a></td>\n' +
'\n' +
' </tr>'
}
$('#table').html(trs)
}
},'json')
}
function deleteDept(did) {
$.get('${path}/deptv2/deleteDept?did='+did,function (resultMsg) {
console.info(resultMsg)
if(200==resultMsg.code){
alert(resultMsg.message)
deptListUI()
}else{
alert(resultMsg.message)
}
},'json')
}
function updateDeptUI(did) {
switchDiv(3)
$.get('${path}/deptv2/findDeptById?did='+did,function (resultMsg) {
if(200==resultMsg.code){
var dept = resultMsg.data;
$('#u_did1').val(dept.did)
$('#u_did2').val(dept.did)
$('#u_dname').val(dept.dname)
}else{
alert(result.message)
}
},'json')
}
function updateDept() {
var data=$('#update_form').serialize();
$.post('${path}/deptv2/updateDept',data,function (resultMsg) {
console.info(resultMsg)
alert(resultMsg.message)
deptListUI()
switchDiv(2)
},'json')
}
</script>
</head>
<body>
<br/>
<div id="listDiv" style="display: block">
<a href="javascript:switchDiv(1)">新增部门</a>
<table border="1px" width="100%" id="table"></table>
</div>
<div id="addDiv">
<h1>添加部门页面</h1>
<form id="add_form" >
<input type="hidden" name="did"/><br/>
<input type="text" name="dname" id="add_dname"/><br/>
<input id="btn_add" type="button" value="保存"/><br/>
</form>
</div>
<div id="editDiv">
<%--更新回显页面--%>
<h1>编辑页面</h1>
<form id="update_form">
<%-- disabled的数据表单提交是不会发送给后台的,设置一个隐藏域 --%>
<input id="u_did1" type="hidden" name="did" >
<input id="u_did2" type="text" disabled="disabled"/><br/>
<input id="u_dname" type="text" name="dname" /><br/>
<input id="btn_update" onclick="updateDept()" type="button" value="保存修改"/><br/>
</form>
</div>
</body>
</html>
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
- 101
- 102
- 103
- 104
- 105
- 106
- 107
- 108
- 109
- 110
- 111
- 112
- 113
- 114
- 115
- 116
- 117
- 118
- 119
- 120
- 121
- 122
- 123
- 124
- 125
- 126
- 127
- 128
- 129
- 130
- 131
- 132
- 133
- 134
- 135
- 136
- 137
- 138
- 139
- 140
- 141
- 142
- 143
- 144
- 145
- 146
- 147
- 148
- 149
- 150
- 151
- 152
- 153
- 154
- 155
- 156
- 157
- 158
- 159
- 160
- 161
- 162
- 163
- 164
- 165
- 166
- 167
- 168
- 169
- 170
- 171
- 172
- 173
- 174
- 175
- 176
- 177
- 178
- 179
- 180
- 181
- 182
- 183
- 184
- 185
- 186
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
- 101
- 102
- 103
- 104
- 105
- 106
- 107
- 108
- 109
- 110
- 111
- 112
- 113
- 114
- 115
- 116
- 117
- 118
- 119
- 120
- 121
- 122
- 123
- 124
- 125
- 126
- 127
- 128
- 129
- 130
- 131
- 132
- 133
- 134
- 135
- 136
- 137
- 138
- 139
- 140
- 141
- 142
- 143
- 144
- 145
- 146
- 147
- 148
- 149
- 150
- 151
- 152
- 153
- 154
- 155
- 156
- 157
- 158
- 159
- 160
- 161
- 162
- 163
- 164
- 165
- 166
- 167
- 168
- 169
- 170
- 171
- 172
- 173
- 174
- 175
- 176
- 177
- 178
- 179
- 180
- 181
- 182
- 183
- 184
- 185
- 186
2. 具体步骤
2.1 通过ajax实现显示所有部门信息
2.1.1 后台
DepartmentController
这里面使用
@ResponseBody
注解将返回的结果转换为
json
数据格式,需要
jackson
的使用
@Controller
@RequestMapping("/deptv2")
public class DepartmentController {
private static final Logger log = LoggerFactory.getLogger(DepartmentController.class);
@Autowired
private IDepartmentService departmentService;
@RequestMapping(path = "/deptListUI",method = RequestMethod.GET)
public String deptListUI(Model model){
return "list_depts";
}
@RequestMapping(path="/deptList",method = {RequestMethod.GET})
@ResponseBody
public Object deptList(){
List<Department> allDepartments = departmentService.findAllDepartments();
log.info("deptList 查询所有部门 " + allDepartments);
return Msg.init(200,"",allDepartments);
}
}
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
2.1.2 前端
list_depts.jsp
页面
环境准备:获取当前项目的路径保存到path中,导入jquery包
<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" %>
<%
//获取当前项目的路径
pageContext.setAttribute("path",request.getContextPath());
%>
<head>
<title>Title</title>
<script type="text/javascript" src="${path}/js/jquery-1.11.0.min.js"></script>
</head>
2.1.3 jQuery实现部门列表的展示
<%-- ajax实现 --%>
<script type="text/javascript">
function switchDiv(part) {
$('#addDiv').css("display","none")
$('#listDiv').css("display","none")
$('#editDiv').css("display","none")
if(1 == part){
$('#addDiv').css("display","block")
$('#add_dname').val('')
}else if(2 == part){
$('#listDiv').css("display","block")
}else if(3 == part){
$('#editDiv').css("display","block")
}
}
$(function () {
$.get('${path}/deptv2/deptList', function (resultMsg){
console.info("resultMsg = " + resultMsg)
var trs = ''
trs += ' <tr>\n' +
' <th>序号</th>\n' +
' <th>部门编号</th>\n' +
' <th>部门名称</th>\n' +
' <th>操作</th>\n' +
'\n' +
' </tr>'
if (200 == resultMsg.code) {
var items = resultMsg.data;
for (var i = 0; i < items.length;i++) {
var dept = items[i]
console.info(dept)
trs += ' <tr>\n' +
' <td>' + (i + 1) + '</td>\n' +
' <td>' + dept.did + '</td>\n' +
' <td>' + dept.dname + '</td>\n' +
' <td><a href="javascript:deleteDept('+dept.did+')">删除 | </a><a href="javascript:updateDeptUI('+dept.did+')">修改</a></td>\n' +
'\n' +
' </tr>'
}
$('#table').html(trs)
}
},'json')
})
</script>
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
2.1.4 html页面内容
<div id="listDiv" style="display: block">
<a href="javascript:switchDiv(1)">新增部门</a>
<table border="1px" width="100%" id="table"></table>
</div>
最终显示效果:
访问
deptListUI
,只进行页面跳转,jquery在页面加载时通过异步获取值。
访问
deptList
获取数据,只获取json格式数据
2.2 增加操作
2.2.1 后台
DepartmentController
@RequestMapping(path ="/saveDept",method = {RequestMethod.POST})
@ResponseBody
public Object save(Department dept){
log.info("saveDept 保存信息: dept="+dept);
try {
departmentService.saveDepartment(dept);
return Msg.init(200,"添加成功",null);
} catch (Exception e) {
e.printStackTrace();
}
return Msg.init(-200,"添加失败",null);
}
2.2.2 前端
list_depts.jsp
页面
jQuery的ajax实现
$('#btn_add').click(function () {
var data = $('#add_form').serialize()
$.post('${path}/deptv2/saveDept',data,function (resultMsg) {
console.info(resultMsg)
switchDiv(2)
deptListUI()
alert(result.msg)
},'json')
})
html内容
<div id="listDiv" style="display: block">
<a href="javascript:switchDiv(1)">新增部门</a>
<table border="1px" width="100%" id="table"></table>
</div>
<div id="addDiv">
<h1>添加部门页面</h1>
<form id="add_form" >
<input type="hidden" name="did"/><br/>
<input type="text" name="dname" id="add_dname"/><br/>
<input id="btn_add" type="button" value="保存"/><br/>
</form>
</div>
2.3 删除操作 通过id删除部门
2.3.1 后台
DepartmentController
@RequestMapping(path = "/deleteDept",method = {RequestMethod.GET})
public Object delete(Integer did){
log.info("deleteDept 删除部门 did = "+did);
try {
departmentService.deleteDepartmentById(did);
return Msg.init(200,"删除成功",null);
} catch (Exception e) {
e.printStackTrace();
}
return Msg.init(-200,"异常,删除失败",null);
}
2.3.2 前端
list_depts.jsp
页面
jquery的ajax提交
function deleteDept(did) {
$.get('${path}/deptv2/deleteDept?did='+did,function (resultMsg) {
console.info(resultMsg)
if(200==resultMsg.code){
alert(resultMsg.message)
deptListUI()
}else{
alert(resultMsg.message)
}
},'json')
}
2.4 更新操作(通过id更新)
2.4.1 后台
DepartmentController
先通过id查询到信息,然后回显到页面,给其赋值
@RequestMapping(path = "/findDeptById", method = RequestMethod.GET)
@ResponseBody
public Object findDeptById(Integer did) {
log.info("findDeptById 通过id查找部门 did=" + did);
if (did != null) {
Department dept = departmentService.findDepartmentById(did);
if (dept != null) {
return Msg.init(200, null, dept);
}
}
return Msg.init(-200, "没有查询到结果", null);
}
然后进行更新操作
@RequestMapping(path="/updateDept",method = RequestMethod.POST)
@ResponseBody
public Object updateDept(Department dept){
log.info("updateDept 更新信息: dept="+dept);
try {
departmentService.updateDepartmentById(dept);
return Msg.init(200, "更新部门信息成功", null);
} catch (Exception e) {
e.printStackTrace();
}
return Msg.init(-200, "异常,更新失败", null);
}
2.4.2 前端
list_depts.jsp
页面
jquery更新回显页面
function updateDeptUI(did) {
switchDiv(3)
$.get('${path}/deptv2/findDeptById?did='+did,function (resultMsg) {
if(200==resultMsg.code){
var dept = resultMsg.data;
$('#u_did1').val(dept.did)
$('#u_did2').val(dept.did)
$('#u_dname').val(dept.dname)
}else{
alert(result.message)
}
},'json')
}
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
jquery实现更新
function updateDept() {
var data=$('#update_form').serialize();
$.post('${path}/deptv2/updateDept',data,function (resultMsg) {
console.info(resultMsg)
alert(resultMsg.message)
deptListUI()
switchDiv(2)
},'json')
}
html页面
<div id="editDiv">
<%--更新回显页面--%>
<h1>编辑页面</h1>
<form id="update_form">
<%-- disabled的数据表单提交是不会发送给后台的,设置一个隐藏域 --%>
<input id="u_did1" type="hidden" name="did" >
<input id="u_did2" type="text" disabled="disabled"/><br/>
<input id="u_dname" type="text" name="dname" /><br/>
<input id="btn_update" onclick="updateDept()" type="button" value="保存修改"/><br/>
</form>
</div>
3. 源码下载
SSM整合CRUD,aJax实现