<%@page import="java.sql.ResultSetMetaData"%> <%@page import="java.sql.ResultSet"%> <%@page import="java.sql.Statement"%> <%@page import="java.sql.DriverManager"%> <%@page import="java.sql.Connection"%> <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <% String driverName = "com.mysql.jdbc.Driver"; String userName = "root"; String userPasswd = "root"; String dbName = "menagerie"; String url = "jdbc:mysql://localhost/" + dbName + "?user=" + userName + "&password=" + userPasswd; Class.forName(driverName); Connection conn = DriverManager.getConnection(url, userName, userPasswd); Statement statement = conn.createStatement(); String sql = "select * from pet"; ResultSet rs = statement.executeQuery(sql); while (rs.next()) { out.println(rs.getString(1)); } rs.close(); statement.close(); conn.close(); %>