jquery+fullcalendar+jsp+无组件(json)+oracle带日历考勤系统源码.docx

Jquery + fullcalendar + jsp + 无组件(JSON +ORACLE 带日历考勤系统 index.js里面代码 even ts: function( start, end, timez one, callback $.ajax({ type:POST, url:gettcdbsdb.jsp, dataType:js on, asyn c:false, data: { startstime: start.format(), en dstime: en d.format() }, success: function( data) { var events =[]; $.each(data, function (i) { even ts.push({ title: data[i].title, start: data[i].start, end: data[i].e nd, allDay: true }); }); callback(eve nts); }, error: function( XMLHttpRequest, textStatus, errorThrow n){ alert(errorThrow n); } }); }, url:gettcdbsdb.jsp ,(无数据库) 中的代码 %@ page conten tType=text/js on; charset=gb2312 % %@ page import=java.io.*% % String stime = request.getParameter(startstime); String etime = request.getParameter(e ndstime); String temps=[ { +\title\ +: \ 祝你成功 \,; temps=temps + \start\ +: \2020-06-30\,; temps=temps + \end\ +: \2020-06-30\ + },; temps=temps + { \title\ +: \ 祝你 1 成功 \,; temps=temps + \start\ +: \2020-06-28\,; temps=temps + \end\ +: \2020-06-28\ + } ]; out.println(temps); % 有数据库，无需JSON组件！ %@ page contentType=text/json; charset=gb2312 % %@ page import=java.io.*% %@ page info=database handler% %@ page import=java.io.*% %@ page import=java.lang.*% %@ page import=java.util.*% %@ page import=java.sql.*% % String stime = request.getParameter(startstime); String etime = request.getParameter(endstime); String col1=,col2=; String strSql; Connection con; Statement stmt; ResultSet rs; Class.forName(oracle.jdbc.driver.OracleDriver); String url=jdbc:oracle:thin:@:1521:tet3; con=DriverManager.getConnection(url,sys as sysdba,man123); stmt=con.createStatement(); strSql = select s1,s2 from test_yuye where s1 between + stime +and + etime + order by s1 ; rs=stmt.executeQuery(strSql); String stemp=[; while(rs.next()) { col1=rs.getString(1).trim(); col2=rs.getString(2).trim(); stemp=stemp+ { \title\ +: \+col2+\,; stemp=stemp + \start\ +: \+col1+\,; stemp=stemp + \end\ +: \+col1+\ + },; } stemp=stemp.substring(0,stemp.length()-10?stemp.length()-1:1); stemp=stemp+]