connectionmanager.java

java编码：JavaCode_version01.rar

/**
 * 
 */
package com.waytojob.util;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.DriverManager;
import java.util.Properties;

/**
 * @author Administrator
 *
 */
public class ConnectionManager
{
	private static boolean isDriverOk=true;
	private static String jdbcDriver=null;
	private static String jdbcUrl=null;
	private static String jdbcUser="";
	private static String jdbcPwd="";
	static
	{
		InputStream is=ConnectionManager.class.getResourceAsStream("/com/waytojob/util/jdbc_config.properties");
		if(is != null)
		{
			Properties prop=new Properties();
			try
			{
				prop.load(is);
				ConnectionManager.jdbcDriver=prop.getProperty("jdbc.driver");
				if(ConnectionManager.jdbcDriver == null)
				{
					ConnectionManager.isDriverOk=false;
				}
				else
				{
					Class.forName(ConnectionManager.jdbcDriver);
				}
				ConnectionManager.jdbcUrl=prop.getProperty("jdbc.url");
				if(ConnectionManager.jdbcUrl == null)
				{
					ConnectionManager.isDriverOk=false;
				}
				String user=prop.getProperty("jdbc.user");
				if(user != null)
				{
					ConnectionManager.jdbcUser=user;
				}
				String pwd=prop.getProperty("jdbc.password");
				if(pwd != null)
				{
					ConnectionManager.jdbcPwd=pwd;
				}
			}
			catch (IOException e)
			{
				ConnectionManager.isDriverOk=false;
				e.printStackTrace();
			}
			catch (ClassNotFoundException e)
			{
				ConnectionManager.isDriverOk=false;
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
		}
		else
		{
			ConnectionManager.isDriverOk=false;
		}
	}
	/**
	 * 禁止创建实例
	 */
	private ConnectionManager()
	{
		super();
		// TODO 自动生成构造函数存根
	}
	public static Connection getConnection() throws SQLException
	{
		if(!ConnectionManager.isDriverOk)
		{
			throw new SQLException("JDBC驱动器配置文件错误");
		}
		return DriverManager.getConnection(ConnectionManager.jdbcUrl,
				ConnectionManager.jdbcUser,
				ConnectionManager.jdbcPwd);
	}
}