WebRoot/admin/TempInfo/TempInfoOut_Post.jsp

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%
request.setCharacterEncoding("UTF-8"); 
%>
<jsp:useBean id="connDbBean" scope="page" class="db.db"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    <title>My JSP 'adminyanzheng.jsp' starting page</title>
  </head>
  <body>
  <%
String id=request.getParameter("id");
String temInfoInTime=request.getParameter("temInfoInTime");
String times=(new java.util.Date()).toLocaleString();
String sql=" DECLARE @hours int";
 sql+=" DECLARE @carPayMon int";
sql+=" set @hours =(SELECT datediff(hour,'"+temInfoInTime+"', '"+times+"'))";
sql+=" set @carPayMon = (select carpayTemp  from dbo.carType where carTypeName='自由车位')";
 sql+=" Update TempInfo set temInfoOutTime = '"+times+"',carPayInfo= (@hours+1)*@carPayMon  where tempInfoId="+id+" ";  	
  sql+=" Update ziyouchewei set Flag = '空闲' where ID=(SELECT temStopId FROM  TempInfo where tempInfoId="+id+" )";  	  	
connDbBean.executeUpdate(sql);
out.print("<script>alert('离开成功!!');location.href='"+request.getHeader("Referer")+"';</script>");
 %>
  </body>
</html>