Jsp/Servlet

开发平台：
Java

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">&nbsp;
                </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);
  }
%>

						