JDBC+C3p0

package com.jsecode.gps.db.connection;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.springframework.beans.factory.BeanFactory;
import org.springframework.beans.factory.xml.XmlBeanFactory;
import org.springframework.core.io.ClassPathResource;

import com.mchange.v2.c3p0.ComboPooledDataSource;
import com.sun.corba.se.spi.orbutil.fsm.Guard.Result;
/**
 * 数据库连接池管理连接
 * @author bgc
 *
 */
public class ConnectionManager {
	
	private static ConnectionManager manager;
	ComboPooledDataSource dataSource;
	
	private ConnectionManager(){
		/*ClassPathResource resource = new ClassPathResource("applicationContext.xml");
        BeanFactory factory = new XmlBeanFactory(resource);
        dataSource = (ComboPooledDataSource)factory.getBean("GPSDataSource");*/
		dataSource = new ComboPooledDataSource("dataSource");
	}
	
	public static final ConnectionManager getInstance(){  
        if(manager == null){  
            try{  
            	manager = new ConnectionManager();  
            }catch (Exception e) {  
                e.printStackTrace();  
            }  
        }  
        return manager;  
    }  
    public synchronized final Connection getConnection() {    
        try {  
            return dataSource.getConnection();  
        } catch (SQLException e) {       
            e.printStackTrace();  
        }  
        return null;  
    } 
	
    
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		Connection con = new ConnectionManager().getConnection();
		if(con!=null){
			System.out.println("好了");
		}

	}

}