📄 userlist.jsp

📁 一个自己完成的网上书店
💻 JSP
字号:
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="gb2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'user.jsp' starting page</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

  </head>
  
  <body>
   <%       Class.forName("com.mysql.jdbc.Driver");
			DriverManager.registerDriver(new com.mysql.jdbc.Driver());
			String dburl = "jdbc:mysql://localhost:3306/bookstore?useUnicode=true&characterEncoding=GB2312";
			String user = "root";
			String pass = "ptnest";
			Connection con;
			con = java.sql.DriverManager.getConnection(dburl, user, pass);
			Statement stmt = con.createStatement();
			String sql="select * from user;";
			ResultSet rs = stmt.executeQuery(sql);
	%>
	<table border="0" width="80%" cellspacing="0" cellpadding="0" align="center">
			<tr>
				<td width="100%" height="30" bgcolor="#3399ff"align="center">&nbsp;<font
					color="#ffffff">用户列表</font></td>
			</tr>
			<tr></tr><tr></tr><tr></tr>
	</table>
	<%out.println("<table width='80%' align='center' bgcolor=#3399ff>");
			out.println("<tr>");
			out.println("<td width='100'><b>登录名</b></td>");
			out.println("<td width='100'><b>真实姓名</b></td>");
			out.println("<td width='100'><b>Email</b></td>");
			out.println("<td width='100'><b>地址</b></td>");
			out.println("<td width='100'><b>性别</b></td>");
			out.println("<td width='100'><b>操作</b></td>");
			out.println("</tr>");
			out.println("</table>");
			int searchnum = 0;
			while (rs.next()) {
				String name, realname, email, address;
				int sex,BN,id;
				id=rs.getInt("id");
				name = new String(rs.getString("name"));
				realname = new String(rs.getString("real_name"));
				email = rs.getString("email");
				address = new String(rs.getString("address"));
				sex = rs.getInt("sex");
				
				out.println("<table width='80%' align='center' >");
				out.println("<tr>");
				out.println("<td width='110'>" + name + "</td>");
				out.println("<td width='50'>" + realname + "</td>");
				out.println("<td width='100'>" + email + "</td>");
				out.println("<td width='100'>" + address + "</td>");
				if (sex == 0)
					out.println("<td width='100'>男</td>");
				else
					out.println("<td width='100'>女</td>");		

							
				out.println("<td width='100'><a href=/bookstore/admin/userimformation.jsp?BN="+id+">[察看详情]</a></td></table>");
				out.println("<td width='100'>");
				out.println("</tr>");
				out.println("<br>");
				searchnum++;
			}
			rs.close();
			out.println("<br>");
			out.println("<table width='770' align='center'>");
			out.println("<tr>");
			out.println("<td>");
			out.println("共搜索到<b><font color=red>" + searchnum		+ "</font></b>条用户记录");
			out.println("</td>");
			out.println("</tr>");
			out.println("</table>");
			out.print("<div align=center><font color=#FF0000><a href=/bookstore/admin/index.jsp>点击此处返回上级目录</a></font></div>");
		%>
		<p align="center"></p>
  </body>
</html>
⌨️ 快捷键说明

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