java使用数据库连接池连接MySQL/MariaDB--DBCP2

最新推荐文章于 2022-04-25 12:03:41 发布

原创

最新推荐文章于 2022-04-25 12:03:41 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍了如何在Java中利用DBCP2数据库连接池连接MySQL/MariaDB，强调了使用连接池的资源效率优势，并提供了Maven项目的依赖添加方法和官方文档链接。

如果每次操作数据库都需要重新连接数据库，那么会很浪费资源。因此建议使用数据库的连接池来满足多线程的数据库操作。

Java中数据库连接池有多种实现方法，推荐使用DBCP，这是Apache 提供的数据库连接池的实现。

在Maven中添加如下依赖：

    <dependency>
      <groupId>org.apache.commons</groupId>
      <artifactId>commons-dbcp2</artifactId>
      <version>2.6.0</version>
    </dependency>

注意：2.6.0版本是最新的版本，不支持低于Java8的版本，更多内容参考官方文档:DBCP – Overview

官方样例：

/*
 * Licensed to the Apache Software Foundation (ASF) under one or more
 * contributor license agreements.  See the NOTICE file distributed with
 * this work for additional information regarding copyright ownership.
 * The ASF licenses this file to You under the Apache License, Version 2.0
 * (the "License"); you may not use this file except in compliance with
 * the License.  You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;

//
// Here are the dbcp-specific classes.
// Note that they are only used in the setupDataSource
// method. In normal use, your classes interact
// only with the standard JDBC API
//
import org.apache.commons.pool2.ObjectPool;
import org.apache.commons.pool2.impl.GenericObjectPool;
import org.apache.commons.dbcp2.ConnectionFactory;
import org.apache.commons