📄 asklist_class.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>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<jsp:useBean id="ask" scope="page" class="edu.AskBean" />
<jsp:useBean id="user" scope="page" class="edu.UserBean" />
<jsp:useBean id="classs" scope="page" class="edu.ClassBean" />
<jsp:useBean id="subjects" scope="page" class="edu.SubjectBean" />
<title>分类</title>
<style type="text/css">
<!--
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
.STYLE1 {
color: #FFFFFF;
font-size: 12px;
}
.STYLE2 {font-size: 12px}
-->
</style>
<link rel="stylesheet" href="style.css" type="text/css">
<style type="text/css">
<!--
.STYLE3 {color: #FF0000}
-->
</style>
</head>
<body>
<%
int allrow=0, intpage=1;
int pagesize=20;//一页显示行数
int grade_id=0;
int class_id=0;
int subject_id=0;
int ask_id=0;
int u_id=0;
String title="";
String time="";
String u_name="";
String count="";
String sort="";
String class_name=null,subject_name=null;
try{
intpage=Integer.valueOf(request.getParameter("intpage")).intValue();}catch(NumberFormatException e){}
try{
grade_id =Integer.valueOf(request.getParameter("grade_id")).intValue();
class_id =Integer.valueOf(request.getParameter("class_id")).intValue();
}catch(NumberFormatException e){}
ResultSet rs_ask=ask.getAskListCount(grade_id,class_id);
if(rs_ask.next())
allrow=rs_ask.getInt(1);
ResultSet rs_class2=classs.getClasss(class_id);
if(rs_class2.next())
class_name=rs_class2.getString("class");
rs_class2.close();
ResultSet rs_subject2=subjects.getSubjects(subject_id);
if(rs_subject2.next())
subject_name=rs_subject2.getString("subject");
rs_subject2.close();
int allpage = (allrow +pagesize-1)/ pagesize;
// 调整待显示的页码
if(intpage>allpage) intpage = allpage;
if(intpage<1) intpage = 1;
int startrow=(intpage-1)*pagesize;
ask.setStartpage(startrow);
ask.setPagesize(pagesize);
%>
<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="1">
<tr bgcolor="#66CCFF">
<td width="493"><span class="STYLE5">位于
<a href="asklist_class.jsp?grade_id=<%=grade_id %>&class_id=<%=class_id %>"><%=class_name %></a>
</span> <span align="center" class="STYLE1">主题</span>
</td>
<td width="134">
<div align="center" class="STYLE1">提问时间</div>
</td>
<td width="80">
<div align="center" class="STYLE1">提问人</div>
</td>
<td width="30">
<div align="center" class="STYLE1">回复</div>
</td>
</tr>
<%
rs_ask=ask.getAskList(grade_id,class_id);
while(rs_ask.next()){
title=rs_ask.getString("a_title");
String strtitle="";
if(title.length()>30)
strtitle=title.substring(0,30)+"...";
else strtitle=title;
sort=rs_ask.getString("ask_sort");
time=rs_ask.getString("a_time");
u_id=rs_ask.getInt("u_id");
ask_id=rs_ask.getInt("ask_id");
ResultSet rs_sort=ask.getAskSortName(sort,u_id);
while(rs_sort.next()){
u_name=rs_sort.getString(1);}rs_sort.close();
ResultSet rs_count=ask.countAsk(ask_id);
if(rs_count.next())
count=rs_count.getString(1);
rs_count.close();
%>
<tr>
<td height="22" bgcolor="#FFFFFF"><a class="STYLE2"
href="answer.jsp?ask_id=<%=ask_id%>" title="<%=title %>"><%=strtitle%></a></td>
<td height="22" bgcolor="#FFFFFF" class="STYLE2"><%=time%></td>
<td height="22" bgcolor="#FFFFFF" class="STYLE2">
<div align="center"><%=u_name%></div>
</td>
<td height="22" bgcolor="#FFFFFF" class="STYLE2">
<div align="center"><%=count%></div>
</td>
</tr>
<% }rs_ask.close(); %>
</table>
<div align="center">
<table width="750" border="0">
<tr>
<td width="30%" height="30" nowrap>
<div align="center">共<span class="STYLE3"><%=allrow %></span>条记录 当前第<span class="STYLE3"><%=intpage %></span>页/共<span class="STYLE3"><%=allpage %></span>页</div></td>
<td nowrap><div align="center">
<a href="asklist_class.jsp?grade_id=<%=grade_id%>&class_id=<%=class_id%>">首页</a>
<%
int tenpage=((int)(intpage/10))*10;
if(intpage-10>0) {%>
<a href="asklist_class.jsp?grade_id=<%=grade_id%>&class_id=<%=class_id%>&intpage=<%=intpage-10%>">上十页</a><%} %>
<a href="asklist_class.jsp?grade_id=<%=grade_id%>&class_id=<%=class_id%>&intpage=<%=intpage-1%>">上一页</a>
<%if(tenpage+10<=allpage){
for(int i=1;i<=10;i++){%>
<a href="asklist_class.jsp?grade_id=<%=grade_id%>&class_id=<%=class_id%>&intpage=<%=tenpage+i %>"><%=tenpage+i %></a>
<%}}if(tenpage+10>allpage){
for(int i=1;i+tenpage<=allpage;i++){%>
<a href="asklist_class.jsp?grade_id=<%=grade_id%>&class_id=<%=class_id%>&intpage=<%=tenpage+i %>"><%=tenpage+i %></a>
<%}} %>
<a href="asklist_class.jsp?grade_id=<%=grade_id%>&class_id=<%=class_id%>&intpage=<%=intpage+1%>">下一页</a>
<%if(intpage+10<=allpage) {%><a href="asklist_class.jsp?grade_id=<%=grade_id%>&class_id=<%=class_id%>&intpage=<%=intpage+10%>">下十页</a><%} %> <a href="asklist_class.jsp?grade_id=<%=grade_id%>&class_id=<%=class_id%>&intpage=<%=allpage%>">尾页</a></div></td>
</tr>
</table>
</div>
<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 + -