📄 calendaredit.jsp

📁 GJMOA网络自动化办公系统是一套基于jsp的办公自动化系统在LINUX+ORACLE+TOMCAT环境下运行
💻 JSP
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="check.jsp" %>
<%@ page import="java.util.*" %>
<script language=javascript src="mouse.js"></script>

<%
String op = "9";
if(request.getParameter("op")!=null){
	op = request.getParameter("op");
}	
String stitle = "";		
String content = "";
String id = request.getParameter("id");
String time = "";
String remindtime ="";
String sql ;
String status ="";
int op2= 0;
String title ="增加安排";

if(op.compareTo("1")==0 || op.compareTo("4")==0 || op.compareTo("5")==0 ){ ////添加/察看//编辑
	
	if( op.compareTo("4")==0 || op.compareTo("5")==0 ){
		sql = "select * from calendar where ID="+id;
		sqlbean.executeQuery(sql);
			
		if(sqlbean.next()){
			title = sqlbean.getString("title");
			content = sqlbean.getString("Content");
			time = sqlbean.getString("time");
			remindtime = sqlbean.getString("remindtime");
		}
		
		if(op.compareTo("4")==0){
			status = " readonly";
			op2 = 0;
			stitle ="查看日程！";
			sql = "update calendar set state=1 where ID="+id;
			sqlbean.executeUpdate(sql);
		}else{
			status = "";
			op2 = 2;
			stitle ="编辑日程！";
		}
	}								
	if(op.compareTo("1")==0 ){
		op2 = 6;
		stitle = "添加日程";
	}	
	

//<SCRIPT LANGUAGE="JavaScript">
//opener.location=opener.location;window.close();
//</SCRIPT> 

%>
<html> 
<head> 
<title><%=stitle%></title> 
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"> 
<link rel="stylesheet" href="oa.css"> 
 
<script>
function OpenWindows(url)
{
  var 
 newwin=window.open(url,"_blank","toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,top=50,left=120,width=600,height=400");
 return false;
 
}
function OpenSmallWindows(url)
{
  var 
 newwin=window.open(url,"_blank","toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,top=50,left=120,width=550,height=270");
 return false;
 
}
</script> 

<script language="Javascript">
	function ChkSubmit()
	{
		if(isNaN(document.calendar.minute1.value)||isNaN(document.calendar.minute2.value)|| (document.calendar.minute1.value)>"59" || (document.calendar.minute2.value)>"59" || (document.calendar.minute1.value)<"00" || (document.calendar.minute2.value)<"00")
		{
			alert("请正确输入时间！");
			return false;
		}
		if(document.calendar.title.value=="")
		{
			alert("标题不能为空！");
			return false;
		}
		
	}
</script>
</head> 
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> 
<center> <br> <form action="calendaredit.jsp" method="post" name="calendar" onsubmit="return ChkSubmit();"> 
<input name=op type=hidden value='<%=op2%>'>
<input name=id type=hidden value='<%=id%>'>
<table width="90%" border="0" cellpadding="1" cellspacing="1" bgcolor="#666666" > 
<tr><td colspan=2 bgcolor="#000000" class="heading"><font color="#FFFFFF"><b><%=stitle%></b></font></td></tr> 
<tr> <td bgcolor="#EFEFEF" >活动名称：</td><td bgcolor="#FFFFFF">
<input name="title" size=40 value='<%=title%>' <%=status%>></td></tr> 
<tr> <td bgcolor="#EFEFEF">活动时间：</td><td bgcolor="#FFFFFF"> 

 

<%
if(op.compareTo("1")==0){
Calendar jj = Calendar.getInstance();
int j = jj.get(Calendar.YEAR);
int i=0;

out.println("<select name=year1>");
for(i=j;i<j+4;i++){
	out.println("<option value="+i+">"+i+"</option>"); 
}
out.println("</select> 年 <select name=month1>");

for(i=1;i<=12;i++){
	out.println("<option value="+i);
	if(i==jj.get(Calendar.MONTH)+1) 	out.println("selected");
	out.println(">"+i+"</option> ");
}
out.println("</select> 月 <select name=day1>");
for(i=1;i<=31;i++){
	out.println("<option value="+i);
	if(i==jj.get(Calendar.DAY_OF_MONTH)) 	out.println("selected");
	out.println(">"+i+"</option> ");
}
out.println("</select> 日 <select name=hour1>");
for(i=1;i<=24;i++){
	out.println("<option value="+i);
	if(i==jj.get(Calendar.HOUR_OF_DAY)) 	out.println("selected");
	out.println(">"+i+"</option> ");
}
out.println("</select> 点");
out.println("<input name=minute1 size=2 value=00>分 </td></tr>");
out.println("<tr><td bgcolor=#EFEFEF>提醒时间：</td><td bgcolor=#FFFFFF>");

out.println("<select name=year2>");
for(i=j;i<j+4;i++){
	out.println("<option value="+i+">"+i+"</option>"); 
}
out.println("</select> 年 <select name=month2>");

for(i=1;i<=12;i++){
	out.println("<option value="+i);
	if(i==jj.get(Calendar.MONTH)+1) 	out.println("selected");
	out.println(">"+i+"</option> ");
}
out.println("</select> 月 <select name=day2>");
for(i=1;i<=31;i++){
	out.println("<option value="+i);
	if(i==jj.get(Calendar.DAY_OF_MONTH)) 	out.println("selected");
	out.println(">"+i+"</option> ");
}
out.println("</select> 日 <select name=hour2>");
for(i=1;i<=24;i++){
	out.println("<option value="+i);
	if(i==jj.get(Calendar.HOUR_OF_DAY)) 	out.println("selected");
	out.println(">"+i+"</option>");
}
out.println("</select>点");
out.println("<input name=minute2 size=2 value=00>分");
}else{
	out.println("<input name=time type=text value='"+time+"' "+status+">");
	out.println("提醒时间<input name=remindtime type=text value='"+remindtime+"' "+status+">");
}
%>
 
 </td></tr>
<tr> <td valign=top bgcolor="#EFEFEF">活动内容：</td>
<td bgcolor="#FFFFFF">
<TEXTAREA NAME="content" ROWS="6" COLS="40"  <%=status%>><%=content%></TEXTAREA>
</td></tr>
<tr> <td bgcolor="#EFEFEF"></td><td bgcolor="#FFFFFF">
<% if(op.compareTo("1")==0 || op.compareTo("5")==0){ %>
<input value="提交" name="sub1" type="submit"> 
<input value="重写" name="set1" type="reset">
<% } %>
</td></tr> 
</table></form></center> 

<% 

}else if(op.compareTo("3")==0){  //删除
	sql = "delete from calendar where ID="+id;
	sqlbean.executeUpdate(sql);
	//out.println("删除数据成功！");
	sqlbean.close();
	response.sendRedirect("calendar.jsp");		
}else if(op.compareTo("2")==0){  //修改

	sql = "update calendar set "
		+"title ='" + sqlbean.to_8859_1(request.getParameter("title"))
		+"',content='"+ sqlbean.to_8859_1(request.getParameter("content"))
		+"',time='"+ request.getParameter("time")
		+"',remindtime='"+ request.getParameter("remindtime")
		+"' where ID="+ id;
		
	sqlbean.executeUpdate(sql);
	//response.sendRedirect("calendar.jsp");
	//out.println("<script language=javascript>");
	//out.println("window.close();");
	//out.println("</script>");				
	out.println(sqlbean.showMsg("javascript:window.close()","修改数据成功！","系统提示"));

}else if(op.compareTo("6")==0){ //插入
	
	sql = "INSERT INTO calendar(title,content,time,remindtime,userid) values('"
		+ sqlbean.to_8859_1(request.getParameter("title"))
		+"','"+ sqlbean.to_8859_1(request.getParameter("content"))
		+"','"+ request.getParameter("year1")+"-"+request.getParameter("month1")+"-"+request.getParameter("day1")+" "+request.getParameter("hour1")+":"+request.getParameter("minute1")+":00"
		+"','"+ request.getParameter("year2")+"-"+request.getParameter("month2")+"-"+request.getParameter("day2")+" "+request.getParameter("hour2")+":"+request.getParameter("minute2")+":00"
		+"','"+ session.getAttribute("Uid")+"')";
		
	sqlbean.executeUpdate(sql);
	out.println(sqlbean.showMsg("javascript:window.close()","插入数据成功！","系统提示"));
		
	//out.println("<script language=javascript>");
	//out.println("window.close();");
	//out.println("</script>");				
	//response.sendRedirect("calendar.jsp");	
}else if(op.compareTo("8")==0){ //日程检查
	Date nowtime = new Date();
	int tid = 0;
	String ttitle;
	boolean t = false;
	sql ="select * from calendar where state=0 and remindtime<='"+nowtime.toLocaleString()+"'";
	sqlbean.executeQuery(sql);
	if(sqlbean.next()){
		tid = sqlbean.getInt("ID");
		ttitle = sqlbean.getString("title");		
		t = true;		
	}	
	if(t){
		sql = "update calendar set state=1 where ID="+tid;
		sqlbean.executeUpdate(sql);
	}else{
		out.println("<script language=javascript>");
		out.println("window.close();");
		out.println("</script>");				
	}
	//response.sendRedirect("calendar.jsp");	

}
sqlbean.close();
%>
<p align=center>
  <a href="Javascript:window.close();" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image3','','images/close_2.gif',1)">
  <img name="Image3" border="0" src="images/close_1.gif" width="85" height="19" hspace="5"></a> 
  </p>
💿 文件大小 1740 K
👤 上传用户 lilacky
📂 所属分类 OA系统
🏷️ 相关标签

#ORACLE #TOMCAT #GJMOA #LINUX
⌨️ 快捷键说明

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