Tomcat 数据源配置

<?xml version="1.0" encoding="UTF-8"?>

<Context reloadable="true" crossContext="true">

    <Resource

        name="jdbc/iridium"

        auth="Container"

        type="javax.sql.DataSource"

        driverClassName="oracle.jdbc.driver.OracleDriver"

        url="jdbc:oracle:thin:@172.168.1.104:1521:IRIDIUM"

        maxActive="50"

        maxldle="10"

        maxWait="5000"

        username="scott"

        password="hello" />

</Context>

    public static Connection getConnection2() {

        Connection conn = null;

        Context context;

        try {

            context = new InitialContext();

            // 获得数据源

            DataSource ds = (DataSource) context.lookup("java:comp/env/jdbc/iridium");

            // 获取连接

            conn = ds.getConnection();

            System.out.println("It's me!");

        } catch (NamingException e) {

            e.printStackTrace();

        } catch (SQLException e) {

            e.printStackTrace();

        }

        return conn;

    }