📄 first.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="con" scope="page" class="numb1.com.db"/>
<jsp:useBean id="d" scope="page" class="numb1.com.Dodate"/>
<jsp:useBean id="ht" scope="page" class="numb1.com.Dohtml"/>
<jsp:useBean id="onLine" scope="application" class="numb1.com.onLine"/>
<%@ include file = "include/config.jsp" %>
<%
String id=(String)session.getAttribute("id");id=ht.donull(id);
String root=(String)session.getAttribute("root");root=ht.donull(root);
String adm="";
String tim="";
String name="游客";
String txt="0";
String sup="0";
String recom="0";
String point="0";
String popu="0";
String ontims="0";
String duty="";
String face="face/1.gif";
String ip=request.getRemoteAddr();
String sql;
ResultSet rs;
int count=0;
int todaycount=0;
int mcount=0;
int nmcount=0;
sql="SELECT numb1.tim, user.root, user.face, user.name, online.ontims, online.txt, online.point, online.popu, online.suptxt, online.recomtxt FROM numb1, user, online WHERE numb1.userid='"+id+"' AND user.userid='"+id+"' AND online.userid='"+id+"'";
rs=con.query(sql);rs.next();
if(rs.getRow()!=0){
tim=rs.getString(1);tim=tim.substring(0,10);
duty=rs.getString(2);
face=rs.getString(3);
name=con.getStr(rs.getString(4));
ontims=rs.getString(5);
txt=rs.getString(6);
sup=rs.getString(7);
recom=rs.getString(8);
point=rs.getString(9);
popu=rs.getString(10);
}
con.close();
sql="SELECT COUNT(userid) FROM numb1";
rs=con.query(sql);rs.next();
if(rs.getRow()!=0){
count=rs.getInt(1);
}
con.close();
java.util.Date day=new java.util.Date();
sql="SELECT COUNT(userid) FROM numb1 WHERE TO_DAYS(tim)=TO_DAYS(NOW())";
rs=con.query(sql);rs.next();
if(rs.getRow()!=0){
todaycount=rs.getInt(1);
}
con.close();
if(root.compareTo("")==0){root="0";}
int step=Integer.parseInt(root);
sql="SELECT COUNT(id) FROM massage WHERE toid='"+id+"'";
rs=con.query(sql);rs.next();
if(rs.getRow()!=0){
mcount=rs.getInt(1);
}
sql="SELECT COUNT(id) FROM massage WHERE isread=0 AND toid='"+id+"'";
rs=con.query(sql);rs.next();
if(rs.getRow()!=0){
nmcount=rs.getInt(1);
}
if(online_enable == "on"){
String uId, uName;
if(id.compareTo("")==0){
uId="guest";
uName="guest";
}else{
uId=id;
uName=name;
}
onLine.addUser(uId,uName,"first.jsp",ip,onTime);
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>论坛首页</title>
<style type="text/css">
<!--
th{font-size:15px;color:#686868}
td{font-size:13px;color:#686868}
a:link{text-decoration:none;color:#686868}
a:visited{text-decoration:none;color:#686868}
a:hover{text-decoration:none;color:#0000ff}
body {
font-size:13px;
margin-top: 0px;
}
.style3 {color: #ffffff}
-->
</style>
</head>
<body>
<table width="100%" border="0" align="center" cellspacing="0" bgcolor="#fafafa">
<tr>
<td height="10"></td>
</tr>
<tr>
<td><table width="88%" border="0" align="center" cellspacing="0">
<tr>
<td><div align="right"> [<a href="index.jsp" target="_parent">论坛首页</a>]
<% if(id.compareTo("")==0){%>
[<a href="login.jsp">登录</a>] [<a href="reg.jsp">注册</a>]
<% }else{%>
[<a href="shutdown.jsp">离开</a>]
<% }%>
</div></td>
</tr>
</table></td>
</tr>
<tr>
<td height="10"></td>
</tr>
<tr>
<td><table width="88%" border="0" align="center" cellspacing="0" bgcolor="#f1f1f1">
<tr bgcolor="#f8f8f8">
<td colspan="2"><table width="100%" border="0" cellspacing="0">
<tr>
<th bgcolor="#7188e0" class="style3">我 的 资 料</th>
</tr>
</table></td>
</tr>
<tr bgcolor="#f8f8f8">
<td width="19%"><table width="151" border="0" cellspacing="0">
<tr>
<td width="19%" height="196"><table width="95%" border="0" align="center" cellspacing="1" bgcolor="#0000FF">
<tr>
<td bgcolor="#FFFFFF"><img src="<%=face%>" width="140" height="190"></td>
</tr>
</table></td>
<td bgcolor="#aaaaaa"></td>
</tr>
<tr bgcolor="#aaaaaa">
<td height="5"></td>
<td bgcolor="#aaaaaa"></td>
</tr>
</table></td>
<td width="76%" valign="top"><table width="98%" border="0" align="center" cellspacing="0">
<tr>
<td><table width="100%" border="0" align="center" cellspacing="1" bgcolor="#e8e8e8">
<tr bgcolor="#f8f8f8">
<td width="28%" height="20"><div align="right">用户ID：</div></td>
<td width="21%"> <% if(id.compareTo("")!=0){out.print(id);}else{out.print("numb1");}%></td>
<td width="24%"><div align="right">昵 称：</div></td>
<td width="27%"> <%=name%></td>
</tr>
<tr bgcolor="#f8f8f8">
<td height="20"><div align="right">发 贴：</div></td>
<td> <%=txt%></td>
<td><div align="right">精华贴：</div></td>
<td> <%=sup%></td>
</tr>
<tr bgcolor="#f8f8f8">
<td height="20"><div align="right">推荐帖：</div></td>
<td> <%=recom%></td>
<td><div align="right">得 分：</div></td>
<td> <%=point%></td>
</tr>
<tr bgcolor="#f8f8f8">
<td height="20"><div align="right">上线次数：</div></td>
<td> <%=ontims%></td>
<td><div align="right">社区职务：</div></td>
<td> <% if(step==0){out.print("游客");} if(step==1){out.print("会员");} if(step==2){out.print("斑竹");} if(step > 2 && step<6){out.print("管理员");}if(step==6){out.print("<font color=#ff0000>站长</font>");}%></td>
</tr>
<tr bgcolor="#f8f8f8">
<td height="20"><div align="right">注册日期：</div></td>
<td colspan="3"> <%=tim%></td>
</tr>
</table></td>
</tr>
<tr>
<td height="8"></td>
</tr>
<tr>
<td height="15"><table width="100%" border="0" bgcolor="#e8e8e8">
<tr bgcolor="#f8f8f8">
<td width="35%" height="20"><div align="right"><center>注册总人数：</center></div></td>
<td width="15%"> <%=count%></td>
</tr>
</table></td>
</tr>
<tr>
<td height="10"></td>
</tr>
<tr>
<td height="15" bgcolor="#ECECFF">
<%
if(online_enable == "on"){
%>
<table width="100%" border="0" bgcolor="#e8e8e8">
<tr bgcolor="#f8f8f8">
<td width="35%" height="20"><div align="right"><center>当前在线总人数：</center></div></td>
<td width="15%"> <a <% if(id.compareTo("")!=0){out.print("href=online.jsp?user=guest");}%> target="_blank"><%=onLine.gCount()%></a></td>
</tr>
</table>
<%
}
%></td>
</tr>
</table></td>
</tr>
</table></td>
</tr><%
if(step>3){
%>
<tr>
<td height="15"></td>
</tr>
<tr>
<td height="15"> </td>
</tr><%} if(id.compareTo("")!=0){%>
<tr>
<td height="15"></td>
</tr>
<tr>
<td><table width="88%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#7188e0">
<tr bgcolor="#f8f8f8">
<td width="100%"><table width="100%" border="0" cellpadding="0" cellspacing="1">
<tr>
<th bgcolor="#7188e0" class="style3">个 人 管 理</th>
</tr>
</table></td>
</tr>
<tr bgcolor="#f8f8f8">
<td><table width="100%" border="0" align="center" bgcolor="#e8e8e8">
<tr bgcolor="#f8f8f8">
<td height="20"><div align="center"><a href="modify.jsp">修改资料</a></div></td>
<td height="20"><div align="center"><a href="admin/changeroot.jsp">更改权限</a></div></td>
<td><div align="center"><a href="#" onClick="window.open('face.jsp','face','toolbar=0,location=0,directories=0,status=0,menubar=0,scrollbars=0,top=150,left=100,width=520,height=250');">更换照片</a></div></td>
<td><div align="center"><a href="#" onClick="window.open('repassword.jsp','face','toolbar=0,location=0,directories=0,status=0,menubar=0,scrollbars=0,top=150,left=100,width=360,height=180');">修改密码</a></div></td>
<td><div align="center"><a href="#" onClick="window.open('modifype.jsp','face','toolbar=0,location=0,directories=0,status=0,menubar=0,scrollbars=0,top=50,left=50,width=690,height=500');">修改签名</a></div></td>
<td><div align="center"><a href="#" onClick="window.open('showpenname.jsp?pn1=y&pn2=y','face','toolbar=0,location=0,directories=0,status=0,menubar=0,scrollbars=1,top=50,left=50,width=690,height=500');">预览签名</a></div></td>
</tr>
<tr bgcolor="#f8f8f8">
<td height="20" colspan="5"><table width="89%" border="0" align="center" cellspacing="1">
</table>
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<% }%>
<tr>
<td> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td> </td>
</tr>
</table></td>
</tr>
<tr>
<td></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -