效果:
数据库上的内容:
目录树:
text.jsp:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" import="java.sql.*"%>
<html>
<head>
<title>数据库内容</title>
</head>
<body>
<%
String driver_name = "com.mysql.jdbc.Driver"; //mysql数据库驱动
String user_name = "root"; //访问数据库的用户
String password = "zhujunwen"; //用户登陆密码
String db_name="student"; //要访问的数据库
String table_name = "stu_info"; //要访问的数据表
//url指定要访问的数据库和访问数据库的用户及密码
String url = "jdbc:mysql://localhost/"+db_name+"?user="+user_name+"&password="+password;
//加载mysql数据库驱动
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
String sql = "select * from "+table_name;
ResultSet rs = stmt.executeQuery(sql);
out.print("id | name |sex ");
out.print("<br>");
while(rs.next()){
out.print(rs.getString(1)+""); //取结果集里某行的第一列的数据
out.print(" | ");
out.print(rs.getString(2)+""); //取结果集里某行的第二列的数据
out.print(" | ");
out.print(rs.getString(3)+""); //取结果集里某行的第三列的数据
out.print(" | ");
out.print("<br>");
}
out.print("<br>");
//关闭相关参数
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>