首次提交

Administrator

2022-06-17 c5bff04a7761b7aca5dbd511a5989ebab20adb24

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
package com.base; 
 
import java.sql.Connection; 
import java.sql.SQLException; 
import java.util.Properties; 
 
import javax.sql.DataSource; 
 
import org.apache.commons.dbcp.DriverManagerConnectionFactory; 
import org.apache.commons.dbcp.PoolableConnectionFactory; 
import org.apache.commons.dbcp.PoolingDataSource; 
import org.apache.commons.pool.impl.GenericObjectPool; 
 
public class ConnectionFactory { 
    private static interface Singleton { 
        final ConnectionFactory INSTANCE = new ConnectionFactory(); 
    } 
 
    private final DataSource dataSource; 
 
    private ConnectionFactory() { 
         
        try { 
            Class.forName("com.mysql.jdbc.Driver"); 
        } catch (ClassNotFoundException e) { 
            e.printStackTrace(); 
            System.exit(0); 
        } 
     
        Properties properties = new Properties(); 
        properties.setProperty("user", "root"); 
        properties.setProperty("password", "lmx8688139"); 
     
        GenericObjectPool<Object> pool = new GenericObjectPool<Object>(); 
        DriverManagerConnectionFactory connectionFactory = new DriverManagerConnectionFactory( 
                                        "jdbc:mysql://localhost:3360/db_app_sys", properties); 
     
        new PoolableConnectionFactory( 
            connectionFactory, pool, null,"SELECT 1", 3, false, false, Connection.TRANSACTION_READ_COMMITTED 
       ); 
     
        this.dataSource = new PoolingDataSource(pool); 
    } 
 
    public static Connection getDatabaseConnection() throws SQLException { 
        return (Connection) Singleton.INSTANCE.dataSource.getConnection(); 
        //return (Connection) Singleton.INSTANCE.GB_MysqlConnPool.getConn(); 
             
    } 
}