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

📄 emaillist.jsp

📁 使用jsp和access数据库写的bbs论坛系统
💻 JSP
字号:
🔍 
<%@ page session="true" %>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="incdb.jsp"%>
<jsp:useBean id="user" class="test.bbsuser" scope="page"/>
<%
String tempSTR,whereTo;
byte[] tmpbyte;
int method;

tempSTR=(String)session.getValue("adminlogin");
if (tempSTR!="true") {
%>
<jsp:forward page='adminlog.jsp'/>
<%
}
%>

<html>

<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>邮件列表</title>
<link rel="stylesheet" type="text/css" href="bbs03.css">

</head>

<body>
<table border="0" width="100%">
  <tr>
    <td width="25%" align="center"><a href="boardmanager.jsp" target="_self">版面管理</a></td>
    <td width="25%" align="center"><a href="usermanager.jsp" target="_self">注册用户管理</a></td>
    <td width="25%" align="center"><a href="emaillist.jsp" target="_self">用户邮件列表</a></td>
    <td width="25%" align="center"><a href="boardmanager.jsp?method=6" target="_self">退出</a></td>
  </tr>
  <tr>
    <td width="100%" colspan="4">
      <hr>
    </td>
  </tr>
</table>

<table border="1" width="100%" bordercolorlight="#FFFFFF" cellspacing="0" cellpadding="0" bordercolordark="#000000">
  <tr>
    <td width="100%" colspan="4" bgcolor="#000080">
      <p align="center"><font color="#FFFFFF">邮件列表</font></td>
  </tr>
  <tr>
    <td width="20%" align="center">网名</td>
    <td width="30%" align="center">E_mail</td>
    <td width="20%" align="center">网名</td>
    <td width="30%" align="center">E_mail</td>
  </tr>
<%    
int i;
String strSQL;
java.sql.ResultSet sqlRst;
String username,useremail;
            
i=1;
sqlRst=user.listUser(1);
while (sqlRst.next()) {
username=sqlRst.getString("username");
useremail=sqlRst.getString("useremail");
if (useremail==null) {
  useremail="没填";
}   //'end if
%>
    <tr>
    <td width="20%" align="center"><%=username%></td>
    <td width="30%" align="center"><%=useremail%></td>
<%
if (!sqlRst.next()){
  continue;
}

i++;
username=sqlRst.getString("username");
useremail=sqlRst.getString("useremail");

if (useremail==null) {
  useremail="没填";
}   //'end if
%>
    <td width="20%" align="center"><%=username%></td>
    <td width="30%" align="center"><%=useremail%></td>
  </tr>
<%
i++;
}  //' end while
sqlRst.close();
%>   
</table>

</body>

</html>

⌨️ 快捷键说明

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