人员列表展示-优快云博客

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<head>
<title>分页显示</title>
</head>
<body>
<center>
<h1>人员列表</h1>
<hr>
<br>
<%
  final String DBDRIVER = "org.gjt.mm.mysql.Driver" ;
  final String DBURL = "jdbc:mysql://localhost/oa" ;
  final String DBUSER = "root" ;
  final String DBPASSWORD = "root" ;
  Connection conn = null ;
%>
<%
  try
  {
   Class.forName(DBDRIVER) ;
   conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD) ;
   String sql = "SELECT id,uid,name,password FROM person" ;
   PreparedStatement pstmt = null ;
   pstmt = conn.prepareStatement(sql) ;
   ResultSet rs = pstmt.executeQuery() ;
%>
<table border="1" width="80%">
<tr>
  <td>编号</td>
  <td>登陆名称</td>
  <td>姓名</td>
  <td>密码</td>
  <td colspan="2">操作</td>
</tr>
<%
   int i = 0 ;
   while(rs.next())
   {
    i++ ;
    int id = rs.getInt(1) ;
    String userid = rs.getString(2) ;
    String name = rs.getString(3) ;
    String password = rs.getString(4) ;
%>
   <tr>
    <td><%=id%></td>
    <td><%=userid%></td>
    <td><%=name%></td>
    <td><%=password%></td>
    <td>更新</td>
    <td>删除</td>
   </tr>
<%
   }
   rs.close() ;
   pstmt.close() ;
   if(i==0)
   {
%>
    <tr>
     <td colspan="6">没有任何数据！！</td>
    </tr>
<%
   }
%>
</table>
<%
  }
  catch(Exception e)
  {
%>
   <h2>系统出错！！！</h2>
<%
  }
  finally
  {
   conn.close() ;
  }
%>
</center>
</body>
</html>

直接显示数据