This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
The code is pretty much identical. If you are using the DriverManager its all about the JDBC url - the DriverManager looks for a loaded driver which accepts a connection with the specified URL syntax. SO, if you want to find out about the other driver types I'd down load drivers for whichever database you are using and read the accompanying docs for each, since they always include an example URL.