A JDBC datasource takes care of connection handling for you. It may be connection pooling or not. It could be implemented as a single connection. A datasource can be used in a standalone application or on an application server.
A JDBC standalone application just means an application with a mean method that accesses a database.