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();

                }

            }

        }

    }

}