?? calendaredit.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>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -