DbConnectionFactory 数据库连接

最新推荐文章于 2019-09-12 17:15:46 发布

原创最新推荐文章于 2019-09-12 17:15:46 发布 · 869 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#DbConnectionFactory

java编程同时被 2 个专栏收录

27 篇文章

订阅专栏

数据库

3 篇文章

订阅专栏

本文介绍了一个用于TMS费控系统的数据库连接工厂类的设计与实现。该工厂类支持多种数据库配置，并通过Scala的AbstractFunction0泛型来创建数据库连接。文中详细展示了如何使用静态方法获取不同环境下的数据库连接。

/**
 * 
 */
package com.sprucetec.dbatch.tmsfee;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import scala.runtime.AbstractFunction0;

public class DbConnectionFactory {
    
    static AbstractFunction0<Connection> getTmsBasic(){
        return new AbstractFunction0Seri(Constants.Url4TmsBasic, Constants.User4TmsBasic, Constants.Pass4TmsBasic);
    }
    
    static AbstractFunction0<Connection> getTms(){
        return new AbstractFunction0Seri(Constants.Url4Tms, Constants.User4Tms, Constants.Pass4Tms);
    }

    static AbstractFunction0<Connection> getTmsDC(){
        return new AbstractFunction0Seri(Constants.Url4TmsDC, Constants.User4TmsDC, Constants.Pass4TmsDC);
    }

    private static class AbstractFunction0Seri extends AbstractFunction0<Connection> implements Serializable{

        private static final long serialVersionUID = 1L;

        private final String url;
        
        private final String username;
        
        private final String password;
        
        public AbstractFunction0Seri(String url,String username,String password){
            this.url = url;
            this.username = username;
            this.password = password;
        }
        
        @Override
        public Connection apply() {
            try {
                return DriverManager.getConnection(this.url, this.username, this.password);
            } catch (SQLException e) {
                throw new RuntimeException("数据库连接失败", e);
            }
        }
    }
    
}