我这里需要存的是年月日时分秒,在数据库里存放数据类型是Date格式。
Java实体类里边存放了时间戳Timestrap。Oracle确实没有MySQL那么随意,出了太多的问题。
在Java的实体类里边,getter方法上边加上注解:
@JsonFormat(pattern="yyyy-MM-dd HH:mm:ss",timezone="GMT+8")
public Timestamp getSubDate() {
return subDate;
}
不加注解的话查询的时候就会显示一串的数字。
Dao:
@Update("update t_flow set status=#{status},passDate=#{passDate} where flow_id=#{flow_id}")
int updateFlow(Flow flow);
Service:
public Map<String,Object> updateFlow(Flow flow){
Map<String,Object> map=new HashMap<>();
int result=flowdao.updateFlow(flow);
System.out.println(flow+"sssssssssskkkkkkkkkkkk");
if(result>0){
map.put("status", "ok");
}else{
map.put("status", "error");
}
return map;
}
Controller:
@RequestMapping(value="checkFlow",method=RequestMethod.POST)
@ResponseBody
public Map<String,Object> checkFlow(Flow flow){
return flowservice.updateFlow(flow);
}
JSP:
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%
String path=request.getContextPath();
String basePath=request.getScheme()+"//"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!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=UTF-8">
<title>Insert title here</title>
<script type="text/javascript" src="<%=path %>/jquery/jquery-2.1.1.min.js"></script>
<script type="text/javascript" src="<%=path %>/bootstrap/js/bootstrap.js"></script>
<link type="text/css" rel="stylesheet" href="<%=path %>/bootstrap/css/bootstrap.min.css"/>
<script type="text/javascript" src="<%=path%>/layer/layer.js"></script>
<style type="text/css">
#form{
margin:0 auto;
margin-top:100px;
margin-left:350px;
}
</style>
</head>
<body>
<form class="form-horizontal" role="form" id="fm">
<input type="hidden" name="flow_id" value="${flow.flow_id }"/>
<div id="form">
<div class="form-group">
<label class="col-sm-2 control-label"><span style="color:red;">*</span> 申请人:</label>
<div class="col-sm-3">
<input type="text" class="form-control" name="sq_id" value="${flow.sq_id }" disabled="disabled">
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label"><span style="color:red;">*</span> 审批人:</label>
<div class="col-sm-3">
<input type="text" class="form-control" name="sq_id" value="${flow.sp_id }" disabled="disabled">
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label"><span style="color:red;">*</span> 申请标题:</label>
<div class="col-sm-3">
<input type="text" class="form-control" name="flow_title" value="${flow.flow_title }" disabled="disabled">
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label"><span style="color:red;">*</span> 申请类型:</label>
<div class="col-sm-3">
<input type="text" class="form-control" name="flow_type" value="${flow.flow_type}" disabled="disabled">
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label"><span style="color:red;">*</span> 申请原因:</label>
<div class="col-sm-3">
<input type="text" class="form-control" name="flow_reason" value="${flow.flow_reason}" disabled="disabled">
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label">开始时间:</label>
<div class="col-sm-3">
<input type="text" class="form-control" name="begindate" value="${flow.beginDate }" disabled="disabled">
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label">结束时间:</label>
<div class="col-sm-3">
<input type="text" class="form-control" name="enddate" value="${flow.endDate }" disabled="disabled">
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label">提交时间:</label>
<div class="col-sm-3">
<input type="text" class="form-control" name="subdate" value="${flow.subDate}" disabled="disabled"/>
</div>
</div>
<input type="hidden" class="form-control" id="passDate" name="passDate" value=""/>
<input type="hidden" class="form-control" id="status" name="status" value=""/>
<br>
<div class="box-footer col-xs-4" style="text-align: center;">
<button type="submit" class="btn btn-primary" id="subBtn1">同意</button>
<button type="submit" class="btn btn-primary" id="subBtn2">拒绝</button>
<button type="submit" class="btn btn-primary" onclick="javascript:window.history.back();">返回</button>
</div>
</div>
</form>
</body>
<script type="text/javascript">
$("#subBtn1").click(function(){
$('#status').val(1);
var time = new Date();
var year = time.getFullYear();
var month = time.getMonth()+1;
var date = time.getDate();
var h = time.getHours();
var m = time.getMinutes();
var s = time.getSeconds();
$("#passDate").val(year+"-"+month+"-"+date+" "+h+":"+m+":"+s);
$.ajax({
method:'post',
url:'${pageContext.request.contextPath}/checkFlow',
data:$('#fm').serialize(),
dataType:'json',
success:function(ret){
if(ret.status=='ok'){
layer.msg('审批成功!',{time:3000,icon:1});
setTimeout(function(){ location.href ='${pageContext.request.contextPath}/flowDataBySpIdInput'; },1000);
}else if(ret.status=='error'){
layer.msg('审批信息失败!!!接口方法异常,请联系管理员!',{time:3000,icon:7});
}
}
})
});
$("#subBtn2").click(function(){
$('#status').val(2);
var time = new Date();
var year = time.getFullYear();
var month = time.getMonth()+1;
var date = time.getDate();
var h = time.getHours();
var m = time.getMinutes();
var s = time.getSeconds();
$("#passDate").val(year+"-"+month+"-"+date+" "+h+":"+m+":"+s);
$.ajax({
method:'post',
url:'${pageContext.request.contextPath}/checkFlow',
data:$('#fm').serialize(),
dataType:'json',
success:function(ret){
if(ret.status=='ok'){
layer.msg('审批成功!',{time:3000,icon:1});
setTimeout(function(){ location.href ='${pageContext.request.contextPath}/flowDataBySpIdInput'; },1000);
}else if(ret.status=='error'){
layer.msg('审批信息失败!!!接口方法异常,请联系管理员!',{time:3000,icon:7});
}
}
})
})
</script>
</html>
数据可以了,ajax有点问题 操作成功后并没有执行跳转操作,时间原因 明天修改。