JDBC Data Access

I have been talking about this new project I am working on. There are a lot of URLs that I want to scrape. The first task is to put the list into a database. I have decided to use JDBC to access the database from my Java program.

Java Standard Edition 6 comes with the "java.sql" package. You should import all the classes in that package. JDBC requires a driver to run. You load the driver in your code with a Class.forName.

Any SQL can be sent to the database using JDBC. By default, the objects used to connect to the database automatically commit after each statement. You should use the close method on the connection object to free database resources.