<%@ page language="java" import="java.sql.*,java.io.*,java.util.*"%> <%@ page contentType="text/html;charset=utf-8"%> <% String user=(String)session.getAttribute("user"); if(user==null){ response.sendRedirect("index.jsp"); } %> <% Class.forName("com.mysql.jdbc.Driver");//加载驱动器 Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test?serverTimezone=UTC","root","123"); String sql = "select * from addbook"; Statement st = con.createStatement(); ResultSet rs = st.executeQuery(sql); %> <% if(rs.next()){ %> <% do{ %> <% }while (rs.next()); %>

<% out.print("姓名"); %>	<% out.print("电话"); %>	<% out.print("地址"); %>	<% out.print("操作"); %>
<% out.print(rs.getString(1)); %>	<% out.print(rs.getString(2)); %>	<% out.print(rs.getString(3)); %>	修改删除

<% out.print("数据查询成功，恭喜你"); %>

<% rs.close(); con.close(); st.close(); %> <% } else { out.print("通讯录没有联络人！请添加好友."); } %>