xonduty.jsp

来自「一款采用java技术编写的OA办公软件系统」· JSP 代码 · 共 24 行

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="check.jsp" %>
<%
	String reason = request.getParameter("reason");
	if(reason!=null){
		reason = reason.replaceAll("\"","&quot;");
		reason = reason.replaceAll("'","&quot;");
	}
	
	String zt = request.getParameter("zt");
	String user = (String)session.getAttribute("user");
	String part = (String)session.getAttribute("part");
	String pubtime = dateformat.getStringDate();

	dbc.getConnection();
	String sql="";
	{	 
		sql = "insert into  onduty(zt,reason,user,part,pubtime,cid) values('"+zt+"','"+reason+"','"+user+"','"+part+"','"+pubtime+"','"+scid+"')";
//		out.println(charset.ISO_2_GBK(sql)+"<br>");
		dbc.update(charset.ISO_2_GBK(sql));
		dbc.close();
		response.sendRedirect("../onduty.jsp?t=0");
	}
%>