数据库连接工具类
来源：互联网 发布：excel2010数据分析 编辑：程序博客网 时间：2024/06/15 16:44
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 blocke.printStackTrace();}}public static Connection getConnection(){//获取连接System.out.println(conn);try {if(conn==null||conn.isClosed())new ConnDB();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return conn;}public void close() throws SQLException{ //关闭连接if(conn != null)conn.close();}} 0 0
