ConnectionFactory

 package util;

import global.GlobalParameter;

import java.io.IOException;

import java.io.InputStream;

import java.sql.Connection;

import java.sql.DriverManager;

import java.util.Properties;

import property.PropertyConfig;

public class ConnectionFactory {

// private static Logger log =

// Logger.getLogger(ConnectionFactory.class.getName());

public static final String KEY_DATABASE_USER = "user";

public static final String KEY_DATABASE_PASSWORD = "password";

public static final String KEY_DATABASE_URL = "url";

public static final String KEY_JDBC_DRIVER = "driver";

public static final String KEY_JDBC_COUNT = "count";

public static final String KEY_JDBC_TIME = "time";

public static final String KEY_PAGE_SIZE = "size";

private static Properties config;

private static int count = 10;

private static int time = 5000;

private static int size = 1000;

private ConnectionFactory() {

}

public static synchronized Connection getConnection() {

Connection conn = GlobalParameter.conn;

try {

while (conn == null || conn.isClosed()) {

try {

Class.forName(config.getProperty("driver").trim());

conn = DriverManager.getConnection(config

.getProperty("url").trim(), config.getProperty(

"user").trim(), config.getProperty("password")

.trim());

break;

} catch (Exception e) {

// e.printStackTrace();

try {

Thread.sleep(5000);

} catch (InterruptedException e1) {

e1.printStackTrace();

}

// log.info("数据库连接异常");

System.out.println("数据库连接异常");

}

}

} catch (Exception e) {

e.printStackTrace();

}

GlobalParameter.conn = conn;

return conn;

}

static {

config = null;

InputStream in = null;

try {

in = Class.forName(PropertyConfig.class.getName())

.getResourceAsStream("config.properties");

} catch (ClassNotFoundException e1) {

e1.printStackTrace();

}

config = new Properties();

try {

config.load(in);

in.close();

count = Integer.parseInt(config.getProperty("count").trim());

time = Integer.parseInt(config.getProperty("time").trim());

String pageSize = config.getProperty("size").trim();

if (pageSize != null && !pageSize.equals(""))

size = Integer.parseInt(pageSize);

} catch (IOException e) {

System.out.println("No dbconfig.properties defined error");

}

}

public static void main(String[] args) {

Connection con = getConnection();

System.out.println(con);

// System.out.println(PropertyConfig.getProperty("driver"));

}

}