网页显示mysql表格数据_将数据库中用户信息表的内容使用表格显示在客户端浏览器中...

新建一个MysqlRoadServlet.java类

package com.lovo;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

@WebServlet("/MysqlRoadServlet")

public class MysqlRoadServlet extends HttpServlet {

private static final long serialVersionUID = 1L;

//加载的驱动程序类名

private static final String DB_DRIVER =

"com.mysql.jdbc.Driver";

//连接数据库的URL

private static final String DB_URL =

"jdbc:mysql://localhost:3306/test?charcterEncoding=utf-8";

//连接数据库的用户名

private static final String DB_USER = "root";

//连接数据库的密码

private static final String DB_PASSWORD = "";

public static Connection getConnection(){

Connection connection = null;

//第一步：加载JDBC驱动

try {

Class.forName(DB_DRIVER);

} catch (Exception e) {

System.out.println("找不到驱动程序类，加载驱动失败！");

e.printStackTrace();

}

//第二步：创建数据库连接

try {