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("好了");}}}