Tomcat配置jndi数据源

<Resource name="jdbc/test2"
    auth="Container"
    type="javax.sql.DataSource"
    username="root"
    password="xxx"
    driverClassName="com.mysql.jdbc.Driver"
    url="jdbc:mysql://192.168.142.129:3306/test2"
    maxActive="8"
    maxIdle="4"/>

<resource-ref>
    <description>
        Resource reference to a factory for java.sql.Connection
        instances that may be used for talking to a particular
        database that is configured in the Context
        configuration for the web application.
    </description>
    <res-ref-name>
        jdbc/test2
    </res-ref-name>
    <res-type>
        javax.sql.DataSource
    </res-type>
    <res-auth>
        Container
    </res-auth>
</resource-ref>

try {
    Context initCtx = new InitialContext();

    Context envCtx = (Context) initCtx.lookup("java:comp/env");
    DataSource ds = (DataSource)envCtx.lookup("jdbc/test2");    
    Connection conn = ds.getConnection();
    Statement stmt = conn.createStatement();
    ResultSet rst = stmt.executeQuery("select uid, name from user");
    
    while (rst.next()) {
        System.out.println(rst.getString("name"));
    }
    rst.close();
    stmt.close();
    conn.close();
} catch (NamingException e1) {
    e1.printStackTrace();
} catch (SQLException e) {
    e.printStackTrace();
}