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

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

直接上个jsp显示mysql数据库内容的源码，你可以参考一下：
<%@ page language="java" import="java.sql.*,java.io.*,java.util.*"%>
<%@ page contentType="text/html;charset=utf-8"%>



table {
    border: 2px #CCCCCC solid;
    width: 360px;
}
td,th {
    height: 30px;
    border: #CCCCCC 1px solid;
}



    <%
        //驱动程序名 
        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);
    %>
    

    

    
        
            
                <%
                    out.print("学号");
                %>
            
            
                <%
                    out.print("姓名");
                %>
            
            
                <%
                    out.print("专业");
                %>
            
            
                <%
                    out.print("班级");
                %>
            
        
        <%
            while (rs.next()) {
        %>
        
            
                <%
                    out.print(rs.getString(1));
                %>
            
            
                <%
                    out.print(rs.getString(2));
                %>
            
            
                <%
                    out.print(rs.getString(3));
                %>
            
            
                <%
                    out.print(rs.getString(4));
                %>
            
        
        <%
            }
        %>
    
    
        
 
 

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

mysql的驱动放tomcat的lib目录
在JSP直接引用 jdbc，使用Connection、Statement、PreparedStatement、执行SQL语句，得到 ResultSet，就得到数据，可以通过out输出到JSP页面了
~~~~~~~~~~~~~~~