jdbcTemplate简单使用

package com.bizvane.spider.tools;

import org.apache.commons.dbcp.BasicDataSource;
import org.springframework.jdbc.core.JdbcTemplate;

import java.util.HashMap;
import java.util.Map;

/**
 * Created by Administrator on 2018/1/10.
 */
public class JDBCHelper {
    private static Map<String,JdbcTemplate> templateMap = new HashMap<String,JdbcTemplate>();

    /**
     * 创建连接
     */
    public static JdbcTemplate createTemplate(String templateName,
                                                   String url, String username, String password,
                                                   int initialSize, int maxActive) {

        BasicDataSource dataSource = new BasicDataSource();
        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource.setUrl(url);
        dataSource.setUsername(username);
        dataSource.setPassword(password);
        dataSource.setInitialSize(initialSize);
        dataSource.setMaxActive(maxActive);
        JdbcTemplate template = new JdbcTemplate(dataSource);
        templateMap.put(templateName, template);
        return template;
    }

    /**
     *  获取 JdbcTemplate
     */
    public static JdbcTemplate getJdbcTemplate(){
        String templateName = JdbcConfig.getTemplateName();
        String url = JdbcConfig.getUrl();
        String username = JdbcConfig.getUsername();
        String password = JdbcConfig.getPassword();
        int initialSize = (JdbcConfig.getInitialSize()==null)?5:Integer.parseInt(JdbcConfig.getInitialSize());
        int maxActive = (JdbcConfig.getMaxActive()==null)?30:Integer.parseInt(JdbcConfig.getMaxActive());
        return createTemplate(templateName,url,username,password,initialSize,maxActive);
    }

    /**
     * 获取 JdbcTemplate
     */
    public static JdbcTemplate getJdbcTemplate(String templateName){
        if (templateMap.get(templateName) != null) return templateMap.get(templateName);
        JdbcTemplate template = getJdbcTemplate();
        templateMap.put(templateName, template);
        return template;
    }

}