📄 a_membersign.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="Connections/conn.jsp" %>
<%
Driver Driverrecmlist = (Driver)Class.forName(MM_conn_DRIVER).newInstance();
Connection Connrecmlist = DriverManager.getConnection(MM_conn_STRING,MM_conn_USERNAME,MM_conn_PASSWORD);
PreparedStatement Statementrecmlist = Connrecmlist.prepareStatement("SELECT * FROM dbo.member");
ResultSet recmlist = Statementrecmlist.executeQuery();
boolean recmlist_isEmpty = !recmlist.next();
boolean recmlist_hasData = !recmlist_isEmpty;
Object recmlist_data;
int recmlist_numRows = 0;
%>
<%
int Repeat1__numRows = -1;
int Repeat1__index = 0;
recmlist_numRows += Repeat1__numRows;
%>
<%
// *** Recordset Stats, Move To Record, and Go To Record: declare stats variables
int recmlist_first = 1;
int recmlist_last = 1;
int recmlist_total = -1;
if (recmlist_isEmpty) {
recmlist_total = recmlist_first = recmlist_last = 0;
}
//set the number of rows displayed on this page
if (recmlist_numRows == 0) {
recmlist_numRows = 1;
}
%>
<%
// *** Recordset Stats: if we don't know the record count, manually count them
if (recmlist_total == -1) {
// count the total records by iterating through the recordset
for (recmlist_total = 1; recmlist.next(); recmlist_total++);
// reset the cursor to the beginning
recmlist.close();
recmlist = Statementrecmlist.executeQuery();
recmlist_hasData = recmlist.next();
// set the number of rows displayed on this page
if (recmlist_numRows < 0 || recmlist_numRows > recmlist_total) {
recmlist_numRows = recmlist_total;
}
// set the first and last displayed record
recmlist_first = Math.min(recmlist_first, recmlist_total);
recmlist_last = Math.min(recmlist_first + recmlist_numRows - 1, recmlist_total);
}
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>检视会员信息页面</title>
<STYLE>
#Layer1 {
Z-INDEX: 1;
WIDTH: 118px;
POSITION: absolute;
HEIGHT: 28px
}
body {
}
</STYLE>
</head>
<body>
<table width="95%" border="1" cellpadding="0" cellspacing="0" bordercolor="#B98631" style="FONT-SIZE: 14px; COLOR: #323229">
<tr>
<th bgcolor="#B98631" scope="col">检视会员信息
记录 <%=(recmlist_first)%> 到 <%=(recmlist_last)%> (总共 <%=(recmlist_total)%> 条） </th>
</tr>
<tr>
<td><% if (!recmlist_isEmpty ) { %>
<% while ((recmlist_hasData)&&(Repeat1__numRows-- != 0)) { %>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> 用户名</td>
<td> 姓名</td>
<td> 性别</td>
<td> 生日</td>
<td> 证件</td>
<td> 电话</td>
</tr>
<tr>
<td><%=(((recmlist_data = recmlist.getObject("m_logname"))==null || recmlist.wasNull())?"":recmlist_data)%></td>
<td><%=(((recmlist_data = recmlist.getObject("name"))==null || recmlist.wasNull())?"":recmlist_data)%></td>
<td><%=(((recmlist_data = recmlist.getObject("sex"))==null || recmlist.wasNull())?"":recmlist_data)%></td>
<td><%=(((recmlist_data = recmlist.getObject("birthday"))==null || recmlist.wasNull())?"":recmlist_data)%></td>
<td><%=(((recmlist_data = recmlist.getObject("id"))==null || recmlist.wasNull())?"":recmlist_data)%></td>
<td><%=(((recmlist_data = recmlist.getObject("tel"))==null || recmlist.wasNull())?"":recmlist_data)%></td>
</tr>
<tr>
<td> </td>
<td> 地址</td>
<td> 入会时间</td>
<td> 级别</td>
<td> 欠款</td>
<td> 备注</td>
</tr>
<tr>
<td> </td>
<td><%=(((recmlist_data = recmlist.getObject("address"))==null || recmlist.wasNull())?"":recmlist_data)%></td>
<td><%=(((recmlist_data = recmlist.getObject("jointime"))==null || recmlist.wasNull())?"":recmlist_data)%></td>
<td><%=(((recmlist_data = recmlist.getObject("jibie"))==null || recmlist.wasNull())?"":recmlist_data)%></td>
<td><%=(((recmlist_data = recmlist.getObject("debt"))==null || recmlist.wasNull())?"":recmlist_data)%></td>
<td><%=(((recmlist_data = recmlist.getObject("remark"))==null || recmlist.wasNull())?"":recmlist_data)%></td>
</tr>
</table>
<%
Repeat1__index++;
recmlist_hasData = recmlist.next();
}
%>
<% } /* end !recmlist_isEmpty */ %></td>
</tr>
<tr>
<td><% if (recmlist_isEmpty ) { %>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> 亲爱的 管理员，目前尚未有任何会员资料</td>
</tr>
</table>
<% } /* end recmlist_isEmpty */ %>
</td>
</tr>
</table>
</body>
</html>
<%
recmlist.close();
Statementrecmlist.close();
Connrecmlist.close();
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -