数据库连接工具类

最新推荐文章于 2025-07-21 09:37:39 发布

原创最新推荐文章于 2025-07-21 09:37:39 发布 · 456 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#工具类 #数据库



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();
		
	}

}