如何用jsp做一个日程计划的程序

puppypuss 2003-08-11 09:07:46

我用jsp和js做，可是，用javascript画出一个月的表格以后，怎么分别在每个日期里显示这一天的计划安排呢,数据库里都已经保存好了，可是，不能显示
function fDrawCal(iYear, iMonth, iCellWidth, iCellHeight, sDateTextSize, sDateTextWeight, iDayStyle) {
var myMonth;
myMonth = fBuildCal(iYear, iMonth, iDayStyle);
//document.write("<table style=LINE-HEIGHT: 160% cellSpacing=0 borderColorDark=#ffffff cellPadding=0 width=100% borderColorLight=#cccccc border=1 >");
document.write("<tr bgcolor=#EDEDE9>");
document.write("<td align='center' style='FONT-FAMILY:Arial;FONT-SIZE:12px;FONT-WEIGHT: bold'>" + myMonth[0][0] + "</td>");
document.write("<td align='center' style='FONT-FAMILY:Arial;FONT-SIZE:12px;FONT-WEIGHT: bold'>" + myMonth[0][1] + "</td>");
document.write("<td align='center' style='FONT-FAMILY:Arial;FONT-SIZE:12px;FONT-WEIGHT: bold'>" + myMonth[0][2] + "</td>");
document.write("<td align='center' style='FONT-FAMILY:Arial;FONT-SIZE:12px;FONT-WEIGHT: bold'>" + myMonth[0][3] + "</td>");
document.write("<td align='center' style='FONT-FAMILY:Arial;FONT-SIZE:12px;FONT-WEIGHT: bold'>" + myMonth[0][4] + "</td>");
document.write("<td align='center' style='FONT-FAMILY:Arial;FONT-SIZE:12px;FONT-WEIGHT: bold'>" + myMonth[0][5] + "</td>");
document.write("<td align='center' style='FONT-FAMILY:Arial;FONT-SIZE:12px;FONT-WEIGHT: bold'> " + myMonth[0][6] + "</td>");
for (w = 1; w < 7; w++) {
document.write("<tr>")
for (d = 0; d < 7; d++) {
<% n=11;%>
document.write("<td align=center width='" + iCellWidth + "' height='" + iCellHeight + "' id=calCell style='CURSOR:Hand' onMouseOver='fToggleColor(this)' onMouseOut='fToggleColor(this)' >");
if (!isNaN(myMonth[w][d])) {
if(myMonth[w][d]==<%= days %>){
document.write("" + myMonth[w][d] + "");
<%
temp=String.valueOf(n);//当前日期数
selectdayinmonth=years+"-"+months+"-"+temp;//当前日期
try{
// 连接数据库
dbmysql.setoracle();
dbmysql.connect();
// 查询语句
sql="select count(*) from calendar where calendardate= to_date('"+selectdayinmonth+"','yyyy-mm-dd hh24:mi:ss')";
dbmysql.query(sql);
// 显示记录
while(dbmysql.next())
{
// 取得各字段的值
title=dbmysql.getString(1);
%>
document.write("<%=title%>");
<%
}

dbmysql.close();
dbmysql.connclose();
}
catch(Exception e){
out.println(e);
}
%>
}
else{
document.write("" + myMonth[w][d] + "");
<%
temp=String.valueOf(n);//当前日期数
selectdayinmonth=years+"-"+months+"-"+temp;//当前日期
%>
document.write("<%=selectdayinmonth%>");
document.write("<%=n%>");
}
}
else {
document.write(" ");
}
document.write("</td>")
}
document.write("</tr>");

}
//document.write("</table>")
}

...全文