📄 asklist_grade.jsp

📁 在线教育平台：从小学
💻 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" />
<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">
</head>
<body>
<%
int allrow=0, intpage=1;
int pagesize=3;//一页显示行数
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="";


try{
	intpage=Integer.valueOf(request.getParameter("intpage")).intValue();}catch(NumberFormatException e){}
	try{
	    grade_id =Integer.valueOf(request.getParameter("grade_id")).intValue();

	    }catch(NumberFormatException e){}


	    ResultSet rs_ask=ask.getAskListCount(grade_id);
	if(rs_ask.next())
	allrow=rs_ask.getInt(1);
	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">
		<div align="center" class="STYLE1">主题</div>
		</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);
    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>
<table width="100%" border="0">
	<tr>
		<td width="41%">
		<div align="right"><a
			href="asklist_grade.jsp?grade_id=<%=grade_id%>">首页</a></div>
		</td>
		<td width="9%">
		<div align="center"><a
			href="asklist_grade.jsp?grade_id=<%=grade_id%>&intpage=<%=intpage-1%>">上一页</a></div>
		</td>

		

		<td width="9%">
		<div align="center"><a
			href="asklist_grade.jsp?grade_id=<%=grade_id%>&intpage=<%=intpage+1%>">下一页</a></div>
		</td>
		<td width="41%"><a
			href="asklist_grade.jsp?grade_id=<%=grade_id%>&intpage=<%=allpage%>">尾页</a></td>
	</tr>
</table>
<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 + -