3.8 修改学生
<link type="text/css" rel="stylesheet" href="<c:url value='/bootstrap-3.3.7-dist/css/bootstrap-editable.css'/>" />
<script type="text/javascript" src="<c:url value='/js/jquery.serializejson.min.js'/>"></script>
<script type="text/javascript"
src="<c:url value='/bootstrap-3.3.7-dist/js/bootstrap-editable.min.js'/>"></script>
@PutMapping("/student.action")
public ResponseVO<String> updateOneMethod(@RequestBody Student student){
System.out.println("student==="+student);
return new ResponseVO<>(200,null,"修改成功行数:"+service.updateOneMethod(student));
}
columns:[
{checkbox:true},
{field:"sid",title:"学号"},
{field:"sname",title:"名字",editable:
{
title:"请输入新的名字:",
type:"text",
validate:function(v){
v=v.trim();
if(v.length>6){ return "长度不能大于6";}
if(!v){ return "名字不能为空"; }
}
}
},
{field:"sex",title:"性别",editable:
{
title:"请选择性别:",
type:"select",
source:[{value:"男",text:"男"},{value:"女",text:"女"}]
}
},
{field:"score",title:"分数",editable:
{
title:"请输入新的分数:",
type:"text",
validate:function(v){
v=v.trim();
v=parseFloat(v);
if(v>100||v<0){ return "分数必须在[0,100]内!";}
if(isNaN(v)){ return "分数格式错误"; }
}
}
},
{field:"sbirth",title:"生日",formatter:function(value,row,index){
var myDate=new Date(row.sbirth);
return myDate.getFullYear()+"年"+(myDate.getMonth()+1)+"月"+myDate.getDate()+"号";
}
},
{field:"sage",title:"年龄",editable:
{
title:"请输入新的年龄:",
type:"text",
validate:function(v){
v=v.trim();
v=parseInt(v);
if(v>120||v<=0){ return "年龄必须在(0,120]内!";}
if(isNaN(v)){ return "年龄格式错误"; }
}
}
},
{field:"sdy",title:"政治面貌",editable:
{
title:"请选择政治面貌:",
type:"select",
source:[{value:"true",text:"党员"},{value:"false",text:"群众"}]
}
},
{field: "sclass", title: "班级", editable:
{
title: "请选择班级:",
type: "select",
source: [
{value: "java第1期", text: "java第1期"},
{value: "java第2期", text: "java第2期"},
{value: "java第3期", text: "java第3期"},
{value: "java第4期", text: "java第4期"},
{value: "java第5期", text: "java第5期"}
]
}
}
]
- 给bootstrapTable方法添加属性onEditableSave 实现编辑保存时 执行ajax操作数据库
onEditableSave: function(field,row,oldValue){
alert(field+":"+row+":"+oldValue);
var rowJsonStr=JSON.stringify(row);
$.ajax({
type:"PUT",
data:rowJsonStr,
cache:false,
async:false,
contentType:"application/json;charset=utf-8",
url:path+"student.action",
success:function(responseVo){
if(responseVo.status==200){
alert(responseVo.data);
$("#table_student").bootstrapTable("refresh");
return;
}
alert(responseVo.errorMessage);
}
});
}