import javax.naming.InitialContext;
import javax.resource.spi.ManagedConnectionFactory;
import javax.resource.spi.ConnectionManager;
import javax.resource.ResourceException;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
public class ResourceExample {
public static void main(String[] args) {
try {
InitialContext ctx = new InitialContext();
ManagedConnectionFactory mcf = (ManagedConnectionFactory) ctx.lookup("java:comp/env/jdbc/myDataSource");
ConnectionManager cm = (ConnectionManager) ctx.lookup("java:comp/env/jdbc/myConnectionManager");
DataSource ds = (DataSource) cm.allocateConnection(mcf, null);
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM myTable");
while (rs.next()) {
System.out.println(rs.getString(1));
}
rs.close();
stmt.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
