package nankang.test;import java.sql.Connection;import com.alibaba.druid.pool.DruidDataSource;public class ConnectionFactory {    private static DruidDataSource dataSource = null;    static {        try {            String driver = "oracle.jdbc.driver.OracleDriver";            String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";            String user = "phonesurvey";            String password = "world";            dataSource = new DruidDataSource();            dataSource.setDriverClassName(driver);            dataSource.setUrl(url);            dataSource.setUsername(user);            dataSource.setPassword(password);            dataSource.setInitialSize(5);            dataSource.setMinIdle(1);            dataSource.setMaxActive(10);            dataSource.setPoolPreparedStatements(false);        } catch (Exception e) {            e.printStackTrace();        }    }    public static synchronized Connection getConnection() {        Connection conn = null;        try {            conn = dataSource.getConnection();        } catch (Exception e) {            e.printStackTrace();        }        return conn;    }}

package nankang.test;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;public class Main {    /**     * @param args     */    public static void main(String[] args) {        Connection conn = null;        PreparedStatement pstm = null;        ResultSet rs = null;        try {            conn = ConnectionFactory.getConnection();            String sql = "select * from Agent";            pstm = conn.prepareStatement(sql);            rs = pstm.executeQuery();            while (rs.next()) {                String agentId = rs.getString("AgentId");                System.out.println(agentId);            }            System.out.println("成功");        } catch (Exception e) {            System.out.println(String.format("失败，%s", e.getMessage()));        } finally {            if (rs != null) {                try {                    rs.close();                } catch (Exception e) {                    e.printStackTrace();                }            }            if (pstm != null) {                try {                    pstm.close();                } catch (Exception e) {                    e.printStackTrace();                }            }            if (conn != null) {                try {                    conn.close();                } catch (Exception e) {                    e.printStackTrace();                }            }        }    }}