📄 index.jsp
字号:
<%@ page language="java" contentType="text/html; charset=GB2312"
pageEncoding="GB2312"%>
<%@page import="java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<script language="javascript">
<!--
function usercheck(){
var password,name;
name=document.user.name.value;
password=document.user.password.value;
if(name==""){
alert("用户名不能为空!");
return false;}
if(password==""){
alert("密码不能为空!");
return false;}
}
function teachercheck1(){
var password1,name1;
name1=document.teacher.name.value;
password1=document.teacher.password.value;
if(name1==""){
alert("用户名不能为空!");
return false;}
if(password1==""){
alert("密码不能为空!");
return false;}
}
//-->
</script>
<TITLE>eBaifeng-->助学考试100分!</TITLE>
<style type="text/css">
<!--
.STYLE6 {font-size: 13px}
.style5 {color: #0000FF; font-weight: bold; font-family: "华文新魏"; font-size: 24px; }
.STYLE7 {font-size: 12px; }
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<jsp:useBean id="grades" scope="page" class="edu.GradeBean" />
<jsp:useBean id="classs" scope="page" class="edu.ClassBean" />
<jsp:useBean id="subjects" scope="page" class="edu.SubjectBean" />
<jsp:useBean id="ask" scope="page" class="edu.AskBean" />
<jsp:useBean id="note" scope="page" class="edu.NoteBean" />
<jsp:useBean id="help" scope="page" class="edu.HelpBean" />
<link rel="stylesheet" href="style.css" type="text/css">
<jsp:useBean id="user" scope="page" class="edu.UserBean" />
<jsp:useBean id="teacher" scope="page" class="edu.TeacherBean" />
<style type="text/css">
<!--
.STYLE9 {font-size: 13px}
.STYLE9 {font-size: 12px}
-->
</style>
</HEAD>
<style type="text/css">
<!--
.style1 {
color: #0000FF;
font-weight: bold;
font-family: Arial, Helvetica, sans-serif;
font-size: 24px;
}
.style2 {font-weight: bold}
.style3 {font-family: "华文新魏"}
.style4 {
color: #FF0000;
font-weight: bold;
}
.style5 {color: #0000FF; font-weight: bold; font-family: "华文新魏"; font-size: 24px; }
.STYLE6 {font-size: 12px}
-->
</style>
<BODY>
<div align="center">
<table height="160" width="770" border="0" cellspacing="1"
align="center">
<tr>
<td><iframe name="top" height="160" width="770" scrolling="no"
src="top.jsp" frameborder="0"></iframe></td>
</tr>
</table>
</div>
<TABLE width="750" border="0" align="center" cellspacing="0">
<TR>
<TD width="183" rowspan="2" valign="top">
<TABLE width="100%" height="300" border=0 cellPadding=0 cellSpacing=0>
<TR>
<TD height=22 align=center valign="bottom"
background="images/green_left_top4.gif"><B>公告</B></TD>
</TR>
<TR>
<TD height="120" background="images/green_left_btm_bg.gif">
<TABLE width="95%" height="100" border=0>
<TR>
<TD height=4></TD>
</TR>
<%
int note_id=0;
String notetitle="";
ResultSet rs_note=note.getNoteTop5();
while(rs_note.next()){
note_id=rs_note.getInt("id");
notetitle=rs_note.getString("title");
String strtitle="";
if(notetitle.length()>13)
strtitle=notetitle.substring(0,13)+"...";
else strtitle=notetitle;
%>
<TR>
<TD height="18" class="STYLE6"><a href=shownh.jsp?sort=note&id=<%=note_id%> title="<%=notetitle %>"><%=strtitle %></a></TD>
</TR>
<%} rs_note.close();%>
<TR>
<TD height="12" align=right class="STYLE6"><A href="notelist.jsp"
target="_blank">更多»</A></TD>
</TR>
<TR>
<TD height=3></TD>
</TR>
</TABLE>
</TD>
</TR>
<TR>
<TD height=18 align=center valign="bottom"
background="images/green_left_top5.gif"><B>帮助向导</B></TD>
</TR>
<TR>
<TD height="120" background="images/green_left_btm_bg.gif">
<TABLE width="95%" height="100" border=0 align=center>
<TR>
<TD height=5></TD>
</TR>
<%
int help_id=0;
String helptitle="";
ResultSet rs_help=help.getHelpTop5();
while(rs_help.next()){
help_id=rs_help.getInt("id");
helptitle=rs_help.getString("title");
String strtitle="";
if(helptitle.length()>13)
strtitle=helptitle.substring(0,13)+"...";
else strtitle=helptitle;
%>
<TR>
<TD height="18" class="STYLE6"><A
href="shownh.jsp?sort=help&id=<%=help_id %>"
title="<%=helptitle %>"><%=strtitle %></A></TD>
</TR>
<%}rs_help.close(); %>
<TR>
<TD height="12" align=right class="STYLE6"><A href="helplist.jsp"
target="_blank">更多»</A></TD>
</TR>
</TABLE>
</TD>
</TR>
<TR>
<TD colSpan=9 height=5><img src="images/green_left_btm_btm.gif"></TD>
</TR>
</TABLE>
</TD>
<TD width="377" valign="top">
<TABLE width=368 border=0 align="center" cellPadding=0 cellSpacing=0>
<TR>
<TD height=4><img src="images/green_c_top.gif" border=0></TD>
</TR>
<TR>
<TD background="images/green_c_top_bg.gif" height=23>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TR>
<TD width=25></TD>
<TD width=93><B>最新问题</B></TD>
<TD width=193></TD>
<TD align=right width=57><A href="list.jsp" target="_blank">更多»</A> </TD>
</TR>
</TABLE>
</TD>
</TR>
<TD align=middle background="images/green_c_c_bg.gif">
<TABLE cellSpacing=3 cellPadding=0 width="95%" border=0>
<%try{
ResultSet rs_ask=ask.getAskTop5();
while(rs_ask.next()){
int ask_id=rs_ask.getInt("ask_id");
String title=rs_ask.getString("a_title");
String strtitle="";
if(title.length()>25)
strtitle=title.substring(0,25)+"...";
else strtitle=title;
int grade_id1=rs_ask.getInt("grade_id");
int class_id1=rs_ask.getInt("class_id");
int subject_id1=rs_ask.getInt("subject_id");
ResultSet rs_class2=classs.getClasss(class_id1);
if(rs_class2.next()){
String class_name=rs_class2.getString("class");
rs_class2.close();
ResultSet rs_subject2=subjects.getSubjects(subject_id1);
if(rs_subject2.next()){
String subject_name=rs_subject2.getString("subject");
rs_subject2.close();
%>
<TR>
<TD class="STYLE6">[<A
href="asklist.jsp?grade_id=<%=grade_id1 %>&&class_id=<%=class_id1 %>&&subject_id=<%=subject_id1 %>"><%=class_name %><%=subject_name %></A>]
<A href="answer.jsp?ask_id=<%=ask_id%>" title="<%=title %>"><%=strtitle %></A></TD>
</TR>
<TR>
<TD height="1" background="images/line_g.gif"></TD>
</TR>
<%}}}rs_ask.close(); }catch(NullPointerException e){}%>
</TABLE>
</TD>
<TR>
<TD colSpan=9 height=4><img src="images/green_c_btm.gif"
border=0></TD>
</TR>
</TABLE>
<TABLE width=368 border=0 align="center" cellPadding=0 cellSpacing=0>
<TR>
<TD height=4><img src="images/green_c_top.gif" border=0></TD>
</TR>
<TR>
<TD background="images/green_c_top_bg.gif" height=23><TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TR>
<TD width=25></TD>
<TD width=93><B>疑难问题</B></TD>
<TD width=193></TD>
<TD align=right width=57><A href="oldlist.jsp"
target="_blank">更多»</A> </TD>
</TR>
</TABLE></TD>
</TR>
<TD align=middle background="images/green_c_c_bg.gif"><TABLE cellSpacing=3 cellPadding=0 width="95%" border=0>
<%int i=0;
try{
ResultSet rs_ask_time=ask.getAsk_No();
while(rs_ask_time.next()){
String time=rs_ask_time.getString("a_time");
java.text.DateFormat df = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
java.util.Date date = df.parse(time);
java.util.Date now = new java.util.Date();
if (i==5)break;
if((now.getTime()-date.getTime())/(3600*1000*24)>3){
ResultSet rs_old = ask.getAsk_time(time);
rs_old.next();i++;
String ask_id=rs_old.getString("ask_id");
String title=rs_old.getString("a_title");
String strtitle="";
if(title.length()>22)
strtitle=title.substring(0,22)+"...";
else strtitle=title;
int grade_id1=rs_old.getInt("grade_id");
int class_id1=rs_old.getInt("class_id");
int subject_id1=rs_old.getInt("subject_id");
rs_old.close();
ResultSet rs_class3=classs.getClasss(class_id1);
rs_class3.next();
String class_name=rs_class3.getString("class");
rs_class3.close();
ResultSet rs_subject3=subjects.getSubjects(subject_id1);
rs_subject3.next();
String subject_name=rs_subject3.getString("subject");
rs_subject3.close();
%>
<TR>
<TD class="STYLE9">[<A
href="asklist.jsp?grade_id=<%=grade_id1 %>&&class_id=<%=class_id1 %>&&subject_id=<%=subject_id1 %>"><%=class_name %><%=subject_name %></A>] <A href="answer.jsp?ask_id=<%=ask_id%>" title="<%=title %>"><%=strtitle %></A></TD>
</TR>
<TR>
<TD height="1" background="images/line_g.gif"></TD>
</TR>
<%}}rs_ask_time.close();}catch(NullPointerException e){}
%>
</TABLE></TD>
<TR>
<TD colSpan=9 height=4><img src="images/green_c_btm.gif"
border=0></TD>
</TR>
</TABLE></TD>
<%String name=null,sort=null;int userid=0;
try{
name=session.getAttribute("name").toString();
userid=Integer.valueOf(session.getAttribute("userid").toString()).intValue();
sort=session.getAttribute("sort").toString();}catch(NullPointerException e){}
if(name==null||name.equalsIgnoreCase("null")){
%>
<TD width="155" align=middle valign="top" style="PADDING-TOP: 8px">
<form name="user" method="post" action="Servletlogin"><input
type="hidden" name="sort" value="user">
<TABLE cellSpacing=0 cellPadding=0 width="100%" bgColor=#ffffff border=0>
<TR>
<TD width=328 height=18 align="left" class="STYLE7">学生登陆</TD>
<TD align=left width=364><input name="name" type="text" id="name"
size="15" maxlength="16"></TD>
<TD width="331" align="left"></TD>
</TR>
<TR>
<TD height=8 align="left"></TD>
</TR>
<TR>
<TD height=18 align="left" class="STYLE7">
密 码</TD>
<TD align=left><input name="password" type="password"
id="password" size="15" maxlength="16"></TD>
<TD align="left"></TD>
</TR>
<TR>
<TD height=5 align="left"></TD>
</TR>
<TR>
<TD align=left height=18> <a href="registers.jsp" target="_blank">注册</a>
<a href="backps1.jsp?sort=user" target="_blank"><br />
找回密码</a></TD>
<TD align=left><span> <input name="提交"
type="submit" onClick="return usercheck()" value="提交" border=0>
<label> <input type="reset" name="Submit"
value="重置" /> </label> </span></TD>
</TR>
</TABLE>
</form>
<p> </p>
<form name="teacher" method="post" action="Servletlogin"><input
type="hidden" name="sort" value="teacher">
<TABLE cellSpacing=0 cellPadding=0 width="100%" bgColor=#ffffff border=0>
<TR>
<TD height=5 align="left"></TD>
</TR>
<TR>
<TD width=329 height=18 align="left" class="STYLE7">教师登陆</TD>
<TD align=left width=364><input name="name" type="text" id="name"
size="15" maxlength="16"></TD>
<TD width="330" align="left"></TD>
</TR>
<TR>
<TD height=8 align="left"></TD>
</TR>
<TR>
<TD height=18 align="left" class="STYLE7"> 密 码</TD>
<TD align=left><input name="password" type="password"
id="password" size="15" maxlength="16"></TD>
<TD align="left"></TD>
</TR>
<TR>
<TD height=5 align="left"></TD>
</TR>
<TR>
<TD align=left height=18> <a href="registert.jsp" target="_blank">注册</a>
<a href="backps1.jsp?sort=teacher" target="_blank"><br />
找回密码</a></TD>
<TD align=left><label> <input type="submit"
name="Submit2" onClick="return teachercheck()" value="提交">
<input type="reset" name="Submit3" value="重置"> </label></TD>
</TR>
</TABLE>
</form>
</TD><%}else{%><TD width="155" align=middle valign="top" style="PADDING-TOP: 8px"><table><tr height="20"><td> </td></tr><tr><td><div align="center" class="STYLE2">您好！<strong><%=name %></strong></div><p><div align="center">
<% if(sort.equalsIgnoreCase("user")){
int allowday=user.allowday(userid);
%>还剩<span class="STYLE1"><%=allowday %></span>天</div>
<p><div align="center"><a href="qask.jsp" target="_blank">快速提问</a> <%}if(sort.equalsIgnoreCase("teacher")){
String allow="";
boolean isallow=teacher.isallow(userid);
if(isallow){allow="已审核";
%><a href="admincourseware.jsp">课件管理</a><p>
<%
}else{allow="未审核";
}%><%=allow%>
<%} %></div>
</td>
</tr>
<tr>
<td>
<div align="center"><span class="STYLE2">
<%if(sort.equalsIgnoreCase("admin")){ %><a href="admin.jsp"
target="_blank">管理</a>
<p>
<%} %> <%if(sort.equalsIgnoreCase("user")){ %><a href="modifyuser.jsp"
target="_blank">修改资料</a>
<p><a href="card.jsp?userid=<%=userid%>" target="_blank">充值</a> <%}if(sort.equalsIgnoreCase("teacher")) {%>
<a href="modifyteacher.jsp" target="_blank">修改资料</a>
<% }%>
</span></div>
</td>
</tr>
<tr>
<td width="60%">
<div align="center"><a href="Servletlogin?action=logout"
class="STYLE2">退出</a></div>
</td>
</tr>
</table><%} %>
</TD>
</TR>
<TR>
</TR>
</TABLE>
<!-- 尾部 begin -->
<BR>
<div align="center">
<table height="155" width="750" border="0" cellspacing="1"
align="center">
<tr>
<td><iframe name="bottom" height="155" width="750" scrolling="no"
src="bottom.jsp" frameborder="0"></iframe></td>
</tr>
</table>
</div>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -