如何在JSP页面显示mysql数据库内容

 我来答

2个回答

匿名用户
2016-12-17

展开全部

直接上个jsp显示mysql数据库内容的源码，你可以参考一下：

<span style="font-size:12px;"><span style="font-size:14px;"><%@ page language="java" import="java.sql.*,java.io.*,java.util.*"%>
<%@ page contentType="text/html;charset=utf-8"%>
<html>
<head>
<style type="text/css">
table {
    border: 2px #CCCCCC solid;
    width: 360px;
}
td,th {
    height: 30px;
    border: #CCCCCC 1px solid;
}
</style>
</head>
<body>
    <%
        //驱动程序名 
        String driverName = "com.mysql.jdbc.Driver";
        //数据库用户名 
        String userName = "root";
        //密码 
        String userPasswd = "szy";
        //数据库名 
        String dbName = "studentmanage";
        //表名 
        String tableName = "student";
        //联结字符串 
        String url = "jdbc:mysql://localhost:3306/" + dbName + "?user="
                + userName + "&password=" + userPasswd;
        Class.forName("com.mysql.jdbc.Driver").newInstance();
        Connection connection = DriverManager.getConnection(url);
        Statement statement = connection.createStatement();
        String sql = "SELECT * FROM " + tableName;
        ResultSet rs = statement.executeQuery(sql);
    %>
    <br>
    <br>
    <table align="center">
        <tr>
            <th>
                <%
                    out.print("学号");
                %>
            </th>
            <th>
                <%
                    out.print("姓名");
                %>
            </th>
            <th>
                <%
                    out.print("专业");
                %>
            </th>
            <th>
                <%
                    out.print("班级");
                %>
            </th>
        </tr>
        <%
            while (rs.next()) {
        %>
        <tr>
            <td>
                <%
                    out.print(rs.getString(1));
                %>
            </td>
            <td>
                <%
                    out.print(rs.getString(2));
                %>
            </td>
            <td>
                <%
                    out.print(rs.getString(3));
                %>
            </td>
            <td>
                <%
                    out.print(rs.getString(4));
                %>
            </td>
        </tr>
        <%
            }
        %>
    </table>
    <div align="center">
        <br> <br> <br>
        <%
            out.print("数据查询成功，恭喜你");
        %>
    </div>
    <%
        rs.close();
        statement.close();
        connection.close();
    %>
</body>
</html></span><span style="font-size:24px;color: rgb(255, 0, 0);">
</span></span>