package com.tools; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class ConnDB { private static Connection conn; public ConnDB() { final String DRIVER = "com.mysql.jdbc.Driver"; final String DBURL = "jdbc:mysql://localhost:3306/chat_db"; final String DBUSER = "root"; final String DBPASS = "123456"; try { Class.forName(DRIVER); conn = DriverManager.getConnection(DBURL,DBUSER,DBPASS); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static Connection getConnection(){//获取连接 System.out.println(conn); try { if(conn==null||conn.isClosed())new ConnDB(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return conn; } public void close() throws SQLException{ //关闭连接 if(conn != null) conn.close(); } }
数据库连接工具类
最新推荐文章于 2024-08-25 10:24:38 发布