⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 xmycalendar.jsp

📁 oa系统 JAVA 办公管理系统 含有多项功能 快快下载
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="check.jsp" %>
<!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=gb2312">
<title>无标题文档</title>
<link href="../oa.css" rel="stylesheet" type="text/css">
</head>
<body class="notice">
        <p>
          <%
		  /*
	String byear = request.getParameter("byear"); 
	String bmon = request.getParameter("bmon"); 
	String bday = request.getParameter("bday"); 
	String eyear = request.getParameter("eyear"); 
	String emon = request.getParameter("emon"); 
	String eday = request.getParameter("eday"); 
	*/
	String content = request.getParameter("content"); 
	content = content.replaceAll("\"","&quot;");
	content = content.replaceAll("\'","&quot;");
	String title = request.getParameter("title"); 
	String share = request.getParameter("share"); 
	String myyes = request.getParameter("myyes"); 
	
	String sql="";
	String beg =  request.getParameter("xbeg");
	String end = request.getParameter("xend");
	String user = (String)session.getAttribute("user");
	String part = (String)session.getAttribute("part");
	String pubtime= ((dateformat.getStringDate()).toString()).substring(0,20);
	
	
	if((share==null)){
		response.sendRedirect("../mycalendar.jsp?t=1");
	}
	else {
		sql = "insert into  xcalendar(title,content,begtime,endtime,check,user,recorduser,part,pubtime,cid) ";
		sql = sql+" values('"+title+"','"+content+"','"+beg+"','"+end+"','"+myyes+"','"+user+"','"+user+"','"+part+"','"+pubtime+"','"+scid+"') ";
		
		dbc.getConnection();
		
		dbc.update(charset.ISO_2_GBK(sql));

		dbc.close();

		if(share.length()<1){
			//response.sendRedirect("../mycalendar.jsp?t=0");
		}
		else{
			if(share.indexOf(",")>0){
				String tmp = "";
				int cnt =share.indexOf(",");
				while(cnt>0){
					tmp = share.substring(0,cnt);
					dbc.getConnection();
					sql = "insert into  xcalendar(title,content,begtime,endtime,check,user,recorduser,part,pubtime,cid) ";
					sql = sql+" values('"+title+"','"+content+"','"+beg+"','"+end+"','"+myyes+"','"+tmp+"','"+user+"','"+part+"','"+pubtime+"','"+scid+"') ";
					dbc.update(charset.ISO_2_GBK(sql));

					dbc.close();

					share = share.substring(cnt+1);
					cnt =share.indexOf(",");
					out.println(tmp);
				}
			}
			else{
				//
			}
			out.println("share = "+share);
			if(share.length()>0){
				
				dbc.getConnection();
				
				sql = "insert into  xcalendar(title,content,begtime,endtime,check,user,recorduser,part,pubtime,cid) ";
				sql = sql+" values('"+title+"','"+content+"','"+beg+"','"+end+"','"+myyes+"','"+share+"','"+user+"','"+part+"','"+pubtime+"','"+scid+"') ";
				dbc.update(charset.ISO_2_GBK(sql));

				dbc.close();
	
			}
		}
		response.sendRedirect("../mycalendar.jsp?t=0");
	}
	
	
	
	
	//out.println(sql);
	//dbc.update(charset.ISO_2_GBK(sql));
	//out.println(charset.ISO_2_GBK(sql));
	//
	
%>
</p>

 <p align="center"><%@include file="../include/foot.jsp" %></p>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -