DBUtils.java

    1. import com.mchange.v2.c3p0.ComboPooledDataSource;
    3. import javax.sql.DataSource;
    4. import java.sql.Connection;
    5. import java.sql.SQLException;
    7. /**
    8.  * Function:
    9.  * Time: 2022/2/8 13:44
    10.  */
    12. public class DBCUtils {
    13.     private static DataSource ds;
    15.     static {
    16.         ds = new ComboPooledDataSource();
    17.     }
    19.     public static DataSource getDataSource() {
    20.         return ds;
    21.     }
    23.     public static Connection getConnection() throws SQLException {
    24.         return ds.getConnection();
    25.     }
    28.     public static void closeConnection(Connection conn){
    29.         try {
    30.             if(conn!=null && !conn.isClosed()){
    31.                 conn.close();
    32.             }
    33.         } catch (SQLException e) {
    34.             e.printStackTrace();
    35.         }
    36.     }
    37. }

    DBUtils的使用需要导包，并且需要依赖c3p0或者是druid来提供数据源。