package com.demo.util;import java.sql.*;public class DBUtil {private static final String DRIVER="com.mysql.cj.jdbc.Driver";private static final String URL="jdbc:mysql://localhost:3306/数据名字";private static final String USER="root";private static final String PASSWORD="123456";static {try{Class.forName(DRIVER);} catch (ClassNotFoundException e) {e.printStackTrace();System.out.println("数据库驱动加载失败");}}public static Connection getConnection(){Connection conn=null;try{conn= DriverManager.getConnection(URL,USER,PASSWORD);System.out.println("数据库连接成功");} catch (SQLException e) {e.printStackTrace();System.out.println("数据库连接失败");}return conn;}public static void close(Connection conn, PreparedStatement ps, ResultSet rs){try{if (rs!=null){rs.close();}if (ps!=null){ps.close();}if (conn!=null){conn.close();}} catch (SQLException e) {e.printStackTrace();System.out.println("数据库关闭失败");}}//测试运行public static void main(String[] args) {Connection conn=getConnection();System.out.println(conn);}
}