📄 index.jsp
字号:
<%@ include file="conn.jsp"%>
<%@ include file="fenlei.jsp"%>
<%String schoolname="",gonggao="",todaytimes="",times="",num1="";
sql="select * from scott.config ";
rs=stmt.executeQuery(sql);
if(rs.next()){
schoolname = rs.getString("schoolname");
gonggao = rs.getString("gonggao");
todaytimes = rs.getString("todaytimes");
times = rs.getString("times");
todaytimes = "0";
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<STYLE>TD {
FONT-SIZE: 9pt; LINE-HEIGHT: 140%
}
BODY {
FONT-SIZE: 9pt; LINE-HEIGHT: 140%
}
A:link {
COLOR: #0033cc; TEXT-DECORATION: none
}
A:visited {
COLOR: #0033cc; TEXT-DECORATION: none
}
A:active {
COLOR: #ff0000; TEXT-DECORATION: none
}
A:hover {
COLOR: #000000; TEXT-DECORATION: underline
}
.header {
font-family: Tahoma, Verdana; font-size: 9pt; color: #FFFFFF; background-color: #69C37C
}
.category{
font-family: Tahoma, Verdana; font-size: 9pt; color: #000000; background-color: #EFEFEF
}
</STYLE>
<title><%=schoolname%></title>
<script language="javascript">
function showdetail(id)
{
window.open("detail.jsp?id="+id,"detail","width=400,height=400,resizable=no,scrollbars=yes,menubar=no,status=no");
}
</script>
</head>
<body text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0>
<%@ include file="head.jsp"%>
<table style="BORDER-COLLAPSE: collapse" borderColor=#808080 align=center cellPadding=5 width="750" border=0>
<tr align=center valign=top>
<td width=170>
<table style="BORDER-COLLAPSE: collapse" borderColor=#808080 align=center cellPadding=1 width=100% border=1>
<tr class="header"><td align=center>管理员公告</td></tr>
<tr height=210>
<td align=center valign=middle>
<marquee id=newslist onmouseover=newslist.stop() onmouseout=newslist.start()
scrollAmount=1 scrollDelay=80 direction=up width=90% height=200><%=gonggao%></marquee>
</td></tr>
</table>
<br>
<table style="BORDER-COLLAPSE: collapse" borderColor=#808080 align=center cellPadding=1 width=100% border=1>
<tr class="header"><td align=center>新注册用户</td></tr>
<tr height=90><td align=left valign=top>
<% int i=0;
sql="select * from scott.teacher order by teacherid desc";
rs=stmt.executeQuery(sql);
if(!rs.next()){
out.print(" 暂无");
}else{
sql="select * from scott.teacher order by teacherid desc";
rs=stmt.executeQuery(sql);
while(i<5 && rs.next()){
out.print(" <font color=#42a5f7 face=Wingdings>v</font>");
out.print(" <a href=teacherinfo.jsp?id="+rs.getString("teacherid")+" title='查看"+rs.getString("teacher")+"的个人专集'>"+rs.getString("teacher")+"</a>（"+rs.getString("fenlei2")+"）<br>");
i++;
}
}
rs.close();
%>
</td></tr>
</table>
<form action="list.jsp" method="post">
<table style="BORDER-COLLAPSE: collapse" borderColor=#808080 align=center cellPadding=1 width=100% border=1>
<tr><td align="center" class="header" colspan=2>快速搜索</td></tr>
<tr>
<td width=40 align="center">资料</td>
<td> <input type=text name="course" size=12></td>
</tr>
<tr>
<td align="center">标题</td>
<td> <input type=text name="title" size=12></td>
</tr>
<%sql="select * from scott.type";
rs=stmt.executeQuery(sql);
%>
<tr>
<td align="center">类型</td>
<td>
<select name="filetype">
<%
while(rs.next()){
%>
<option value="<%=rs.getString("type")%>"><%=rs.getString("type")%></option>
<%
}
rs.close();
%>
</select>
</td>
</tr>
<tr><td colspan=2 align=center>
<input type=submit name="submit" value="搜索">
<input type=reset name="reset" value="清空">
</td></tr>
</table>
</form>
</td>
<td width=430>
<table style="BORDER-COLLAPSE: collapse" borderColor=#808080 align=center cellPadding=1 width=100% border=1>
<tr class="header"><td align=center colspan=4>最近更新</td></tr>
<tr align=center class="category"><td width=180>资料标题</td><td>教师姓名</td><td>更新日期</td><td>所属<%=strfenlei2%></td></tr>
<%sql="select * from scott.main,scott.teacher where main.idofteacher=teacher.teacherid order by main.dateandtime desc";
i=0;
rs=stmt.executeQuery(sql);
while(i<10 && rs.next()){
%>
<tr><td align=left> <img src=images/arrow.gif>
<a href=# title="<%=rs.getString("title")%>" onclick=javascript:showdetail(<%=rs.getString("mainid")%>);><%=rs.getString("title")%></a>
</td><td align=center><a href=teacherinfo.jsp?id=<%=rs.getString("teacherid")%> title="查看<%=rs.getString("teacher")%>的个人专集"><%=rs.getString("teacher")%></a></td>
<td align=center><%=rs.getString("dateandtime")%></td>
<td align=left> <%=rs.getString("fenlei2")%></td></tr>
<%
i++;
}
rs.close();
%>
</table>
<br>
<table style="BORDER-COLLAPSE: collapse" borderColor=#808080 align=center cellPadding=1 width=100% border=1>
<tr class="header"><td align=center colspan=4>阅读排行</td></tr>
<tr align=center class="category"><td width=180>资料标题</td><td>教师姓名</td><td>阅读次数</td><td>所属<%=strfenlei2%></td></tr>
<%sql="select * from scott.main,scott.teacher where main.idofteacher=teacher.teacherid order by main.times desc";
i=0;
rs=stmt.executeQuery(sql);
while(i<10 && rs.next()){
%>
<tr><td align=left> <img src=images/arrow.gif>
<a href=# title="<%=rs.getString("title")%>" onclick=javascript:showdetail(<%=rs.getString("mainid")%>);><%=rs.getString("title")%></a>
</td><td align=center><a href=teacherinfo.jsp?id=<%=rs.getString("teacherid")%> title="查看<%=rs.getString("teacher")%>的个人专集"><%=rs.getString("teacher")%></a></td>
<td align=center><%=rs.getString("times")%></td>
<td align=left> <%=rs.getString("fenlei2")%></td></tr>
<%i++;
}
rs.close();
%>
</table>
</td>
<td width=150>
<form action="check.jsp" method="post">
<table style="BORDER-COLLAPSE: collapse" borderColor=#808080 align=center cellPadding=1 width=100% border=1>
<tr class="header">
<td align=center colspan=2>教师登陆</td>
</tr>
<tr>
<td width=45 align=center>登录名</td>
<td align=left>
<input type=text name="username" size=10 title="请输入您的登录名">
</td>
</tr>
<tr>
<td width=45 align=center>密码</td>
<td align=left>
<input type=password name="password" size=10 title="请输入您的密码">
</td>
</tr>
<tr>
<td colspan=2 align=center>
<input type=submit name="submit" value="登陆">
</td>
</tr>
</table>
</form>
<table style="BORDER-COLLAPSE: collapse" borderColor=#808080 align=center cellPadding=1 width=100% border=1>
<tr class="header"><td align=center>资源列表</td></tr>
<tr height=254><td align=left valign=top>
<%sql="select count(teacherid) from scott.teacher";
i=0;
rs=stmt.executeQuery(sql);
rs.next();
i=rs.getInt(1);
rs.close();
out.print("<center>本站现有<br></center>");
out.print(" <font color=#42a5f7 face=Wingdings>v</font> <a href=teacherlist.jsp>注册教师</a>："+i+"<br>");
String sql1="select * from scott.type";
Statement stmt1=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
Statement stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs1=stmt1.executeQuery(sql1);
while(rs1.next()){
out.print(" <font color=#42a5f7 face=Wingdings>v</font> <a href=list.jsp?filetype="+rs1.getString("type")+">"+rs1.getString("type")+"</a>：");
sql="select count(mainid) from scott.main where idoftype="+rs1.getString("typeid");
rs=stmt2.executeQuery(sql);
rs.next();
i=rs.getInt(1);
out.print(i);
out.print("<br>");
}
%>
</td></tr></table>
<br>
</td>
</tr>
</table>
<%@ include file="foot.jsp"%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -