⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 userlist.jsp

📁 实例大全
💻 JSP
字号:
🔍 
<%
String sn=null;
sn=request.getParameter("SerialNum");
if (sn==null)
  sn="";
%>
<html>
<head>
 <meta http-equiv=Content-Type content="text/html;charset=gb2312">
 <title>当前用户列表</title>
</head>

<%@ page import="java.io.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>

<jsp:useBean id="bbsdb" scope="page" class="bbs.Bbsdb">

<%
ResultSet rs=null;
String sql=null;
String uid=null;
int totaltime=0;

String info=null;
int newinfo=0;

String title=null;

int rnum=bbsdb.getRowNum("ever_user WHERE UID IN (SELECT UID FROM current_user                                 WHERE SerialNum=\'"+sn+"\')");
if (rnum==0)
{
%>
	您的帐号已经过期，请重新登录或注册新的用户!<br>
<%
}
else
{
	sql="SELECT * FROM ever_user WHERE UID IN ("
	    +"SELECT UID FROM current_user WHERE SerialNum=\'"+sn+"\')";
	rs=bbsdb.executeQuery(sql);
	while (rs.next())
	{
		uid=rs.getString("uid");
		totaltime=rs.getInt("TotalTime");
		info=rs.getString("Info");
		newinfo=rs.getInt("newinfo");
	}
	rs.close();
	totaltime++;
	sql="UPDATE ever_user SET TotalTime ="+totaltime+"WHERE UID=\'"+uid+"\'";
	bbsdb.executeQuery(sql);
%>
	<body bgcolor="pink">
	<p>
	<font face="隶书" color="#800040">
	<big><big><strong>
	当前论坛有以下用户：
	</strong></big></big>
	</font>

	<font face="隶书">
<%
	if (info==null)
	{
%>
	<a href="showlist.jsp?target=<%uid%>" target="parent">
	查看以前留言</a><br>
<%
	}
	else
	{
%>
	<a href="showlist.jsp?target=<%uid%>" target="parent">
	朋友给你留言</a><br>
<%
	}
	sql="SELECT * FROM current_user";
	rs=bbsdb.executeQuery(sql);
	while (re.next())
	{
		String cuid=null;
		cuid=rs.getString("UID");
		if (cuid!=null)
		{
%>
	<a href="getuserinfo.jsp?SerialNum=<%=sn%>&amp;target=<%cuid%>" target="parent">
	<%=cuid%></a><br>

<%
		}
	}
	rs.close();
%>
	<hr><ul>
<%
	sql="SELECT * FROM new_essay";
	rs.executeQuery(sql);
	while (rs.next())
	{
		String nuid=null;
		String fileid=null;
		String theme=null;
		String num=null;

		nuid=rs.getString("UID");
		fileid=rs.getString("FileId");
		theme=rs.getString("Theme");
		num=rs.getString("Num");

		if ((nuid!=null)&&(fileid!=null)&&(theme!=null))
		{
%>
	<li><%=nuid%>刚发表了题为
	<a href="showdetail.jsp?SerialNum=<%=sn%>&amp;Num=<%=num%>" target="bottom">
	<%=theme%></a>的文章
	<br></li>
<%
		}
	}
	rs.close();
%>
	</ul>
	<p></p>

	<p><font face="隶书">
		<big><big>
		<a href="list.jsp?SerialNum=<%=sn%>" target="top">
		刷新文章列表
		</a>
		</big></big></font><br>
		</p>

		<p><font face="隶书">
		<big><big>
		<a href="addnew.jsp?SerialNum=<%=sn%>" target="top">
		发表新文章
		</a>
		</big></big></font><br>
		</p>
<%
	}
%>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -