sourcedatabase.java#1.1.1.1

数据库远程同步软件NetBeans项目源文件 项目采用Jdesktop集成组件（JDesktop Integration Components

package com.qixuan.jdbc.common;

import java.io.IOException;
import java.io.InputStream;
import java.sql.*;
import java.util.Properties;

import org.apache.commons.dbcp.BasicDataSource;

/**
 * 实现与数据库连接
 */

public class SourceDataBase {
	private static BasicDataSource bds ;
	private static String filePath = "conf/dbconfig_source.properties";
	private static Properties info = new Properties();
	public static final String DRIVER = "driverClass";
	public static final String URL = "url";
	public static final String USER = "user";
	public static final String PWD = "password";


	//配置一个 数据源
	static {
		InputStream in = null;
		try {
			//获取输入流
			in = Thread
					.currentThread()
					.getContextClassLoader()
					.getResourceAsStream(filePath);
			info.load(in);

		} catch (IOException e) {
			e.printStackTrace();
		} finally {
			if(in != null)
				try {
					in.close();
				} catch (IOException e) {
					e.printStackTrace();
				}
		}
		bds = new BasicDataSource();
		//一个数据源必需的几个要素：
		//驱动类名
		bds.setDriverClassName(info.getProperty(DRIVER));
		//URL
		bds.setUrl(info.getProperty(URL));
		//USER
		bds.setUsername(info.getProperty(USER));
		//PASSWD
		bds.setPassword(info.getProperty(PWD));

		//当前连接最大维护几个连接
		bds.setMaxActive(10);
		//
		bds.setMaxIdle(6);
		//最大等待时间：3秒
		bds.setMaxWait(3000);

	}

	public static Connection getConnection() {
		Connection con = null;

			try {
				con = bds.getConnection();
				System.out.println(con);

			} catch (SQLException e) {
				e.printStackTrace();
			}
			return con;

	}

}