显示数据库数据的jsp代码如下：
解释及说明在代码的注释中即可查看
<%@ 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://数据库地址:端口号/" + 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("数据查询成功，恭喜你");
%>
