谁能帮我在jsp日历表中加入MYSQL连接

myemail665 2012-07-31 03:05:36
在网上复制了修改了下jsp日历表，我又新增了一个MYSQL的数据库表添加了备忘录，求高手帮我jsp里连接数据库，将有备忘录的日期用底色来突出。
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>日期选择器</title>

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

</head>

<script language=javascript>

<!--

var monthNames = new Array ( "", "1","2","3","4","5","6","7", "8", "9", "10", "11", "12" );

var endDay = new Array ( 0, 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 );

var dayNow = 0;

var monthNow = 0;

var yearNow = 0;

function load ( form ) {

set_month_year_now ();

var found = false;

for ( var month=0; month<form.monthList.length; month++ )

if ( form.monthList[month].text == monthNames[monthNow] ) {

form.monthList[month].selected = true;

found = true;

}

if ( !found) {

error ();

return;

}

var found = false;

for ( var year=0; year<form.yearList.length; year++ )

if ( form.yearList[year].text == yearNow ) {

form.yearList[year].selected = true;

found = true;

}

if ( !found) {

error ();

return;

}

display_month ( form );

}

function preceding_month ( form ) {

var month_selected = form.monthList.selectedIndex;

var year_selected = form.yearList.selectedIndex;

if ( !month_selected && !year_selected ) {

error ();

return;

}

if ( month_selected > 0 )

month_selected --;

else {

month_selected = 11;

year_selected --;

}

form.monthList[month_selected].selected = true;

form.yearList[year_selected].selected = true;

display_month ( form );

}

function following_month ( form ) {

var month_selected = form.monthList.selectedIndex;

var year_selected = form.yearList.selectedIndex;

if ( month_selected >= ( form.monthList.length - 1 ) && year_selected >= ( form.yearList.length - 1 ) ) {

error ();

return;

}

if ( month_selected < 11 )

month_selected ++;

else {

month_selected = 0;

year_selected ++;

}

form.monthList[month_selected].selected = true;

form.yearList[year_selected].selected = true;

display_month ( form );

}

function set_month_year_now () {

var form = document.calendar;

var now = new Date ();

monthNow = now.getMonth () + 1;

yearNow = now.getYear ();

dayNow = now.getDate();

yearNow = ( yearNow < 100 ) ? yearNow + 1900 : yearNow;

var count = 0

for (var i = yearNow-12; i < yearNow + 20; i++) {

eval("form.yearList.options[count] = new Option('"+i+"', '"+i+"')");

count++;

}

form.yearList.selectedIndex = 103;

form.yearList.length = count;

}

function error () {

alert ( "超出范围!" );

}

function display_month ( form ) {

var month = form.monthList.selectedIndex + 1;

var year = parseInt ( form.yearList.options[ form.yearList.selectedIndex].text );

var start_day = start_day_in_month ( year, month );

var count = 0;

for ( var row=0; row<6; row++) {

for ( var col=0; col<7; col++ )

{

if ( row == 0 && col < ( start_day - 1 ) )

var day = "";

else if ( count < endDay[month] )

day = ++count;

else

day = "";

form.dayBox[(row*7)+col].style.display = "";

form.dayBox[(row*7)+col].style.color = "black";
form.dayBox[(row*7)+col].style.width = "15";

if (day == "") {

form.dayBox[(row*7)+col].style.display = "none";

} else {

form.dayBox[(row*7)+col].value = day;

if (col%7 == 0) form.dayBox[(row*7)+col].style.color = "red";
if (col%7 == 0) form.dayBox[(row*7)+col].style.width = "15";

if (yearNow == year && monthNow == month && dayNow == day) form.dayBox[(row*7)+col].style.color = "blue";;

}

}

}

}

function start_day_in_month ( year, month ) {

var day, daynum, ndays, mnum;

sday = start_day_in_year ( year );

endDay[2] = ( year % 4 ) ? 28 : 29;

if ( month == 1 )

daynum = sday;

else {

ndays = sday;

for ( mnum=2; mnum<month+1; mnum++ )

ndays = ndays + endDay[mnum-1];

daynum = ndays % 7;

}

daynum = (!daynum) ? 7 : daynum;

return (daynum);

}

function start_day_in_year ( year ) {

var y, m, d;

var n;

y = year - 1; m = 13; d = 1;

n = d + 2 * m + ( Math.floor ( ( 0.6 + (m + 1) ) ) + y );

n = n + Math.floor ( ((y / 4) - Math.floor ( (y / 100 ) ) + Math.floor ( ( y / 400 ) ) ) ) + 2 ;

n = Math.floor ( ( (n / 7 - Math.floor ( (n / 7) ) ) * 7 + 0.5 ) );

return (n+1);

}

function CheckDate(strDay) {

var docFrm = document.calendar;

var choice_daynum = 0;

var current_daynum = 0;

var day_temp;

if (strDay != "") {

var strY = docFrm.yearList.value;

var strM = docFrm.monthList.value;

var curr_y = new String(yearNow);

var curr_m = new String(monthNow);

var curr_d = new String(dayNow);

if (curr_m.length == 1) curr_m = "0"+curr_m;

if (curr_d.length == 1) curr_d = "0"+curr_d;

current_daynum = new Number(curr_y + curr_m + curr_d) ;

if (strM.length == 1) strM = "0"+strM;

if (strDay.length == 1) strDay = "0"+strDay;

choice_daynum = new Number(strY + strM + strDay);

parent.window.returnValue = strY+"-"+strM+"-"+strDay; //将选择的日期传递到父窗口中

//parent.window.close();
window.location.href="item.jsp?date="+choice_daynum;
}

return false;

}

-->

</script>


</html>

...全文
112 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
myemail665 2012-07-31
  • 打赏
  • 举报
 回复
<body onLoad="load(document.calendar)" topmargin="0">

<center>

<form name="calendar">

<table width="158" border="0" cellpadding="0" cellspacing="0">

<tr>

<td colspan="3" height="24"></td>

</tr>

<tr>
<td width="84" nowrap="nowrap" align="center">來訪日曆表</td>

<td width="39" nowrap="nowrap" align="right"><select name="yearList" onChange="display_month(this.form)">

</select>

</td>

<td width="35" nowrap="nowrap" align="left"><select name="monthList" size="1" onChange="display_month(this.form)">

<%for (int i = 1; i < 13; i++) {%>

<option value="<%=i%>"><%=i%></option>

<%}%>

</select>

</td>

<td width="1"></td>

</tr>

<tr>

<td colspan="3" height="6"></td>

</tr>

<tr>

<td colspan="3"><table border="0" cellpadding="1" cellspacing="0" align="center">

<tr>

<td bgcolor="#82664F"><table border="0" cellpadding="0" cellspacing="0">

<tr bgcolor="#E1E100" height="18">

<td width="22" align="center" nowrap="nowrap"><font color="#FF0000">日</font></td>

<td width="22" align="center" nowrap="nowrap">一</td>

<td width="22" align="center" nowrap="nowrap">二</td>

<td width="22" align="center" nowrap="nowrap">三</td>

<td width="22" align="center" nowrap="nowrap">四</td>

<td width="22" align="center" nowrap="nowrap">五</td>

<td width="22" align="center" nowrap="nowrap">六</td>

</tr>

<%for (int r = 0; r < 6; r++) {%>

<tr bgcolor="#FFFFFF" height="18">

<%for (int d = 0; d < 7; d++) {%>

<td align="center"><input type="text" size="1" name="dayBox" readOnly onClick="javascript:CheckDate(this.value);" onMouseOver="this.style.background='#EEEEEE'" onmouseout="this.style.background='white'">

</td>

<%}%>

</tr>

<%}%>

</table></td>

</tr>

</table></td>

</tr>
<tr>

<td colspan="3" height="24"><a href="./memo.jsp">新增</a>   <a href="./select.jsp">查询</a></td>

</tr>

</table>

</form>

</center>

</body>
myemail665 2012-07-31
  • 打赏
  • 举报
 回复
<body onLoad="load(document.calendar)" topmargin="0">

<center>

<form name="calendar">

<table width="158" border="0" cellpadding="0" cellspacing="0">

<tr>

<td colspan="3" height="24"></td>

</tr>

<tr>
<td width="84" nowrap="nowrap" align="center">來訪日曆表</td>

<td width="39" nowrap="nowrap" align="right"><select name="yearList" onChange="display_month(this.form)">

</select>

</td>

<td width="35" nowrap="nowrap" align="left"><select name="monthList" size="1" onChange="display_month(this.form)">

<%for (int i = 1; i < 13; i++) {%>

<option value="<%=i%>"><%=i%></option>

<%}%>

</select>

</td>

<td width="1"></td>

</tr>

<tr>

<td colspan="3" height="6"></td>

</tr>

<tr>

<td colspan="3"><table border="0" cellpadding="1" cellspacing="0" align="center">

<tr>

<td bgcolor="#82664F"><table border="0" cellpadding="0" cellspacing="0">

<tr bgcolor="#E1E100" height="18">

<td width="22" align="center" nowrap="nowrap"><font color="#FF0000">日</font></td>

<td width="22" align="center" nowrap="nowrap">一</td>

<td width="22" align="center" nowrap="nowrap">二</td>

<td width="22" align="center" nowrap="nowrap">三</td>

<td width="22" align="center" nowrap="nowrap">四</td>

<td width="22" align="center" nowrap="nowrap">五</td>

<td width="22" align="center" nowrap="nowrap">六</td>

</tr>

<%for (int r = 0; r < 6; r++) {%>

<tr bgcolor="#FFFFFF" height="18">

<%for (int d = 0; d < 7; d++) {%>

<td align="center"><input type="text" size="1" name="dayBox" readOnly onClick="javascript:CheckDate(this.value);" onMouseOver="this.style.background='#EEEEEE'" onmouseout="this.style.background='white'">

</td>

<%}%>

</tr>

<%}%>

</table></td>

</tr>

</table></td>

</tr>
<tr>

<td colspan="3" height="24"><a href="./memo.jsp">新增</a>   <a href="./select.jsp">查询</a></td>

</tr>

</table>

</form>

</center>

</body>
日历日程表jsp
【日历日程表jsp】是一个基于Java Web技术（JSP和Servlet）开发的日历应用程序，主要用于管理和规划个人或团队的日程安排。该程序提供了一个交互式的日历界面，用户可以方便地添加、删除和查看日程，同时限制只能...
jsp日历日程安排
【标题】"jsp日历日程安排"是一个利用JavaServer Pages (JSP)技术构建的网页应用程序，专门用于实现日历功能和日程管理。在Web开发领域，JSP是Java平台上的一个重要组成部分，它允许开发者创建动态、交互式的网页...
jsp高级日历
【JSP高级日历】是一种在网页中展示日期和时间信息的交互式组件，它通常包含日、周、月和年视图，允许用户进行日期选择、事件添加和日程管理。在网页开发中，使用JSP（JavaServer Pages）技术来实现高级日历功能，...
毕业设计javajsp校园跳蚤平台(jsp+servlet+mysql)-qkr源码含文档
日历表 系统属性 会员中心 我发布的商品 我参与竞拍的商品 在线竞拍系统后台 系统属性 基本操作 注册用户管理 商品类别管理 商品管理 留言管理 公告管理 包含：源码、数据库脚本、论文、答辩ppt、环境工具包、相同...
jsp+js日程表代码
5. 数据库集成：尽管这个示例中没有提供数据库连接，但实际应用中，日程数据通常会存储在关系型数据库如MySQL或非关系型数据库如MongoDB中。JSP需要编写SQL语句（或使用ORM框架如Hibernate）来操作数据库，添加、...
JavaScript

87,992

社区成员

224,685

社区内容

发帖
与我相关
我的任务
社区描述
Web 开发 JavaScript
社区管理员
  • JavaScript
  • 无·法
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章