jsp连接数据库遇到的问题

最新推荐文章于 2022-11-16 21:47:50 发布

逆来顺受

最新推荐文章于 2022-11-16 21:47:50 发布

阅读量1.3k

点赞数 2

分类专栏：日常积累

本文链接：https://blog.csdn.net/qq_36501295/article/details/83009718

版权

日常积累专栏收录该内容

9 篇文章 0 订阅

订阅专栏

<%@ page contentType="text/html;charset=UTF-8" language="java" pageEncoding="UTF-8" %>
<%@ page import="java.sql.*" %>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html;charset = UTF-8">
    <title>查询数据</title>
</head>
<body>
<%
    String uri = "jdbc:mysql://localhost:3306/test";
    String username = "root";
    String password = "zfrzfr";
    Class.forName("com.mysql.jdbc.Driver");
    Connection con = DriverManager.getConnection("jdbc:mysql://localhost/test?" +
            "user=root&password=zfrzfr&serverTimezone=GMT%2B8");
    Statement sql = con.createStatement();
    ResultSet rs = sql.executeQuery("SELECT * FROM course");
%>
<table border="2">
    <tr>
        <th width="100">cno</th>
        <th width="100">cname</th>
        <th width="100">cpo</th>
        <th width="100">ccredit</th>
    </tr>

    <%
        while (rs.next()) {
            out.print("<tr>");
            out.print("<td>" + rs.getString(1) + "</td>");
            out.print("<td>" + rs.getString(2) + "</td>");
            out.print("<td>" + rs.getString(3) + "</td>");
            out.print("<td>" + rs.getString(4) + "</td>");
            out.print("</tr>");
        }
    %>
</table>
<%
    con.close();
%>
</body>
</html>

主要是这个问题Connection con = DriverManager.getConnection("jdbc:mysql://localhost/test?" +
"user=root&password=zfrzfr&serverTimezone=GMT%2B8");