CarUseInfoOperation.jsp
1.31 KB
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="java.sql.Timestamp" %>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<%
String operation = Util.null2String(request.getParameter("operation"));
String id = Util.fromScreen(request.getParameter("id"),user.getLanguage());
int bywhat = Util.getIntValue(request.getParameter("bywhat"),4);
String currentdate = Util.null2String(request.getParameter("currentdate"));
String movedate = Util.null2String(request.getParameter("movedate"));
Date newdate = new Date() ;
long datetime = newdate.getTime() ;
Timestamp timestamp = new Timestamp(datetime) ;
String cancelDate = (timestamp.toString()).substring(0,4) + "-" + (timestamp.toString()).substring(5,7) + "-" +(timestamp.toString()).substring(8,10);
String cancelTime = (timestamp.toString()).substring(11,13) +":" +(timestamp.toString()).substring(14,16);
if(operation.equals("cancel")){
if(!id.equals("")){
String sql = "update CarUseApprove set cancelDate='"+cancelDate+"',cancelTime='"+cancelTime+"',cancel='1' where id="+id;
//System.out.println("sql:"+sql);
RecordSet.executeSql(sql);
}
response.sendRedirect("/car/CarUseInfo.jsp?bywhat="+bywhat+"¤tdate="+currentdate);
}
%>