📄 user_check.jsp
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.sql.*"%>
<%
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
String strUrl = "jdbc:oracle:thin:@slight:1521:LOCAL";
String strUser = "eshop";
String strPassword = "eshop";
Connection con = DriverManager.getConnection(strUrl, strUser, strPassword);
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from RegUser");
%>
<html>
<head>
<title>用户审查</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<STYLE type=text/css>.main {
FONT-SIZE: 12px
}
.main1 {
FONT-SIZE: 14px
}
.main2 {
FONT-SIZE: 16px
}
.main3 {
FONT-SIZE: 7px
}
.main4 {
FONT-SIZE: 10px
}
A:link {
COLOR: #ffffff; TEXT-DECORATION: none
}
A:visited {
COLOR: #ffffff; TEXT-DECORATION: none
}
A:active {
COLOR: #ff0000; TEXT-DECORATION: none
}
A:hover {
COLOR: #aa0000; TEXT-DECORATION: underline
}
</STYLE>
<script language="javascript">
function confirmdel(id){
if (confirm("真的要删除这个用户?"))
window.location.href="del_user.jsp?USERID=" + id;
}
</script>
</head>
<body text="#000000">
<br>
<div align="center">
<center>
<TABLE cellSpacing=1 cellPadding=4 width=100% bgColor=#000000 height="136">
<TR vAlign=top bgColor=#BECFF1>
<TD class=main1 width="662" height="10" bgcolor="#BECFF1"></TD></TR>
<TR vAlign=top bgColor=#BECFF1>
<TD class=main1 width="662" height="18">用户审查--</TD></TR>
<TR vAlign=top bgColor=#BECFF1>
<TD class=main1 width="662" height="15">
<table border="1" cellpadding="0" cellspacing="0" width="100%" bordercolorlight="#BECFF1" bordercolordark="#BECFF1">
<tr class=main1>
<td bgcolor="#BECFF1" align="center" height="20">帐号</font></td>
<td bgcolor="#BECFF1" align="center" height="20">姓名</font></td>
<td bgcolor="#BECFF1" align="center" height="20">电子信箱</font></td>
<td bgcolor="#BECFF1" align="center" height="20">联系电话</font></td>
<td bgcolor="#BECFF1" align="center" height="20">操作</font></td>
<td bgcolor="#BECFF1" align="center" height="20">DEL</font></td>
</tr>
<%
while (rs.next()){
%>
<tr class=main1>
<td align="center" height="25"><%=rs.getString("UserId")%></td>
<td align="center" height="25"><%=rs.getString("Name")%></td>
<td align="center" height="25"><%=rs.getString("Email")%></td>
<td align="center" height="25"><%=rs.getString("usePhone")%></td>
<td align="center" height="25">
<font color=#0000FF>详细资料</font>
</td>
<td align="center" height="25">
<a href="javascript:confirmdel('<%=rs.getString("USERID")%>')">
<font color=#0000FF>删除</font></a>
</td>
</tr>
<%
}
%>
</table>
</TD></TR>
<TR bgColor=#BECFF1>
<TD class=main1 width="662" height="27">
<p align="center">
</TD></TR>
<TR bgColor=#BECFF1>
<TD class=main1 width="662" height="4" bgcolor="#BECFF1"></TD></TR>
</TABLE>
<br>
</center>
</div>
</td></tr>
</table>
</body>
</html>
<%
}catch(Exception e){
throw (e);
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -