gvuserpm.jsp

来自「今晚在线（天津）工作室开发的 GVclub论坛系统.采用hibernate 3.」· JSP 代码 · 共 86 行

<%@ page language="java" contentType="text/html;charset=gb2312"
 session="true" errorPage="err.jsp" %>
 <%
ConnClub bridge = new ConnClub();
Connection con = bridge.getConnection();
String sql;
	sql = "Select * From GVclubTopic";
	sql += " where (topicPro <> 4 and userName='"+ gvUserName +"')  ";
	if(!layer.equals("3")){
	sql += " and topicLayer="+ Integer.parseInt(layer) +"";
	}
	sql += " order by topicID desc";
Pageable rs;
Statement sta;
PreparedStatement pps;
%>
<table width="99%" border="0" align="center" cellpadding="2" cellspacing="1" class="tab">
<tr align="center">
<td width="128"><strong>发信人</strong></td>
<td height="22"><strong>主题</strong></td>
<td width="100"><strong>类别</strong></td>
<td width="30"><strong>型别</strong></td>
  </tr>
<%
//int totalPage = 0;
//int iPage = 1;
//if(request.getParameter("iPage")!=null){
	//iPage = Integer.parseInt(request.getParameter("iPage"));
//}
//int ccStyle = 0;
//try {
	//out.print(sql);
	//pps = con.prepareStatement(sql, ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
	//rs = new PageableResultSet2(pps.executeQuery());
	//rs.setPageSize(20);//每页20个记录
	//totalPage = rs.getPageCount();
	//if(iPage > totalPage){iPage=totalPage;}
	//rs.gotoPage(1);//跳转到第iPage页
	//int pageRows = rs.getPageRowsCount();
	//if(pageRows>0){


%>
<tr class="tab2">
<td width="118" height="25" align="center">&nbsp;</td>
<td width="#">&nbsp;
</td>
  <td width="100" align="center">&nbsp;
</td>
<td width="30" align="center">
</td>
</tr>
<%
	//rs.next();
	//}
	///}else{
	//out.print("<tr class=\"tab2\"><td height=\"40\" colspan=\"8\" align=\"center\"><strong>");
	//out.print("暂无主题!");
	//out.print("<br /></strong></td></tr>");
	//}
	//rs.close();
//catch(Exception e){
%>
<tr class="tab2">
<td height="40" colspan="8" align="center"><strong>
维护中，请稍候访问！
<br />
</strong></td>
  </tr>
<%
//}finally{
	//con.close();
//}
%>
</table>
<script language="JavaScript" type="text/javascript">tabline(1,4,"#ffffff");</script>
<table width="99%" height="25" border="0" align="center" cellpadding="2" cellspacing="1" class="tab">
  <tr class="tab1">
    <td>
<strong>「<%//=totalPage%>」</strong>&nbsp;&nbsp;<strong>
<%
//out.print(pageJump(totalPage, iPage, "userMyTopic.jsp?layer="+layer+"&"));
%>
</td>
  </tr>
</table>