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

📄 user.jsp

📁 JSP+SQL2000做的火车站售票管理系统
💻 JSP
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ include file="connection.jsp" %>
<%
ResultSet rsVerify;
String cs_user,cs_password,cs_power,cs_age,cs_findyou,cs_addr,cs_ybno,cs_perno,sqlVerify,username,password,power,age,findyou,addr,ybno,perno;
%>
<html>
<head>
<title>用户审核</title>
<link href="css/rege.css" rel="stylesheet" type="text/css">
 </head>
 <body>
<div id="container">
	<div id="banner"><img src="image/top.jpg" width="700" height="93"></div>
	<%@ include file="dat/head.txt"%>
    <div id="main">
	<table width="500" border="1">
    <th>用户名:
    <th>密码:
    <th>年龄:
	<th>联系方式:
	<th>居住地址:
	<th>邮编号码:
	<th>证件号码:
    <%
   cs_power="1";
   sqlVerify="select * from cs_user where power='"+cs_power+"'";
   rsVerify=sql.executeQuery(sqlVerify);
   while(rsVerify.next())
   {
   cs_user=(String)rsVerify.getString("username");
   cs_password=(String)rsVerify.getString("password");
   cs_age=(String)rsVerify.getString("age");
   cs_findyou=(String)rsVerify.getString("findyou");
   cs_addr=(String)rsVerify.getString("addr");
   cs_ybno=(String)rsVerify.getString("ybno");
   cs_perno=(String)rsVerify.getString("perno");   
   %>
   <tr>
	 <td><%=cs_user%></td>
	 <td><%=cs_password%></td>
	 <td><%=cs_age%></td>
	 <td><%=cs_findyou%></td>
	 <td><%=cs_addr%></td>
	 <td><%=cs_ybno%></td>
	 <td><%=cs_perno%></td>
   </tr>
   <% }%> 
   </table>
   <% Conn.close(); %>
   <form action="deleteuser.jsp" method="post" name="search">
	<p>未通过审核的用户名:<input type="text" class="text" name="cs_user"></p>
	<p><input type="submit" class="btn" value="确定"> <input name="重置" type="reset" class="btn" value="重置"> 
   </form>
	</div>
	<div id="foot">
	版权所有<a href="mailto:xusongsong217x@126.com">作者</a>
	</div>
</body>
</html>

⌨️ 快捷键说明

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