【连接池连不上数据库 _数据库】

连接池连不上数据库

我也踩过这个坑( 1 )

已统计您的踩坑,无需重复点击

回答(0)

数据库

详细描述

错误截图

源码

import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;

import javax.sql.DataSource;

import org.apache.commons.dbcp2.BasicDataSourceFactory;

/**
* DBCP配置类
* @author SUN
*/
public class KCYDBCPUtil {

private static Properties properties = new Properties();
   private static DataSource dataSource;
   //加载DBCP配置文件
   static{
try{
            InputStream fis = new FileInputStream("config/dbcp.properties");
           properties.load(fis);
       }catch(IOException e){
System.out.println("出错啦啦啦啦啦");
           e.printStackTrace();
       }

try{
dataSource = BasicDataSourceFactory.createDataSource(properties);
       }catch(Exception e){
e.printStackTrace();
       }
}

//从连接池中获取一个连接
   public static Connection getConnection(){
Connection connection = null;
       try {
connection = dataSource.getConnection();
           connection.setAutoCommit(false);
       } catch (SQLException e) {
e.printStackTrace();
       }
return connection;
   }

public static void main(String[] args) {
getConnection();
   }
}

编辑于2024-11-11