本文共 2363 字,大约阅读时间需要 7 分钟。
Class.forName("com.mysql.jdbc.Driver");
jdbc:mysql://127.0.0.1:3306/test?serverTimezone=GMT%2B8
Connection con = DriverManager.getConnection(url,username,password);
<%--Created by IntelliJ IDEA.User: 御承扬Date: 2019/11/30Time: 10:55To change this template use File | Settings | File Templates.--%><%@ page contentType="text/html;charset=UTF-8" language="java" %><%@ page import="java.sql.Connection" %><%@ page import="java.sql.DriverManager" %><%@ page import="java.sql.SQLException" %>JDBC 连接 MySQL 数据库 <% String msg = null; try { Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2B8"; String username = "root"; String password = "*********"; try { Connection conn = DriverManager.getConnection(url,username,password); if(conn != null){ msg = "数据库连接成功"; conn.close(); } } catch (SQLException e) { e.printStackTrace(); msg = "数据库连接失败!!!"; } } catch (ClassNotFoundException e) { e.printStackTrace(); msg = "找不到合适数据库驱动!!!"; }%><%=msg%>
转载地址:http://iaqgn.baihongyu.com/