每日一练||JavaWeb初学者将数据库的表展示在Jsp页面上

效果图JSP源代码<%@ page language="java" contentType="text/html; charset=utf-8"pageEncoding="utf-8"%><%@page import="java.sql.*"%><%--导入java.sql包--%><!DOCTYPE html PUBLIC "-//W3C//DTD HT

前途无量的彪哥

1634人浏览 · 2022-05-20 16:38:05

前途无量的彪哥 · 2022-05-20 16:38:05 发布

效果图

JSP源代码

<%@ page language="java" contentType="text/html; charset=utf-8"
         pageEncoding="utf-8"%>
<%@page import="java.sql.*"%>
<%--导入java.sql包--%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
  <title>从db_book数据库中读出book表</title>
</head>
<body>

  <%
    try {
      Class.forName("com.mysql.cj.jdbc.Driver"); //驱动程序名
      String url = "jdbc:mysql://localhost:3306/test"; //数据库名
      String username = "root"; //数据库用户名
      String password = "root"; //数据库用户密码
      Connection conn = DriverManager.getConnection(url, username, password); //连接状态
      System.out.println("数据库连接成功！");
  %>
  <center>
  <table border="2">
    <tr>
      <th>学号</th>
      <th>姓名</th>
      <th>年龄</th>

    </tr>
      <%
				Statement stmt = null;
					ResultSet rs = null;
					String sql = "SELECT * FROM student;"; //查询语句
					stmt = conn.createStatement();
					rs = stmt.executeQuery(sql);
					out.print("查询学生表如下：");
					out.print("<br/>");
					while (rs.next()) {
			%>
    <tr>
      <td><%=rs.getInt("sid")%></td>
      <td><%=rs.getString("Name")%></td>
      <td><%=rs.getString("Age")%></td>

    </tr>

      <%
				}
				} catch (Exception e) {
                    System.out.println("数据库连接失败");
                     e.printStackTrace();

				}
			%>
</center>
</body>
</html>