<%@ page contentType="text/html" %>
<%@ page pageEncoding = "utf-8" %>
<%@ page import="java.sql.*" %>


 <% Connection con=null;
    Statement sql; 
    ResultSet rs;
    try{  //加载JDBC-MySQL8.0连接器:
       Class.forName("com.mysql.cj.jdbc.Driver");
    }
    catch(Exception e){
       out.print("
"+e);
    }
    String url = "jdbc:mysql://localhost:3306/bookDatabase?"+
    "useSSL=false&serverTimezone=CST&characterEncoding=utf-8";
    String user ="root";
    String password ="123456";
    out.print("");
    out.print("");
    out.print(""); 
    try{
       con = DriverManager.getConnection(url,user,password);//连接数据库。
       sql=con.createStatement();
       String SQL = "SELECT * FROM bookList";//SQL语句。
       //String SQL="select * from bookList "+
       //"where year(publishDate) between 1999 and 2021 and price>=30 "+
       // " order by publishDate";
       rs=sql.executeQuery(SQL);//查表。
       while(rs.next()) {
           out.print("");
           out.print(""); 
           out.print("");
           out.print("");
           out.print("");
           out.print("") ; 
       }
       out.print("
"+"ISBN");
    out.print("
"+"名称");
    out.print("
"+"价格");
    out.print("
"+"日期");
    out.print("
"+rs.getString(1)+"
"+rs.getString(2)+"
"+rs.getFloat(3)+"
"+rs.getDate(4)+"
");
       con.close();
    }
    catch(SQLException e) { 
       out.print("
"+e);
    }
%>

"useSSL=false&serverTimezone=CST&characterEncoding=utf-8";把CST改成GMT就可以了。

jar包版本不对吧，要跟驱动的版本一致

前后端分离呀,搞jsp头大

参考一下：https://blog.csdn.net/qq_45756657/article/details/114930820?%r

• 请看👉 ：Tomcat的配置以及访问tomcat主页面无法进入的问题以及解决的办法