Database connectivity


This practical we'll do a little database reading and writing.

First of all we'll make ourselves a new project - this practical we'll start off outside of Arc, so we won't make a new ESRI project. If you're feeling fancy, you can combine them later.


First of all, go to New > Java Project, use the 1.7 JDK, and give the project a name. Click Finish (you could do the next step by pushing Next but it is more useful to see how to do it from a menu).


Next, right-click on the project directory, which should have appeared on the Package Explorer window on the left of the screen. Click New > Class. Give the class the name DBConnect, no package, and the following options: main method (on); superclass constructors (on); abstract methods (off). Hit Finish. This will generate the class. Add:

new DBConnect();

to the main method so it calls the constructor, and add in the standard constructor if it isn't there.


We'll now make sure our classpath includes the Derby jar files.

Right-click on the project directory again in the Package Explorer window, and select Build Path > Add External Archive.... Navigate to C:\Program Files\Java\jdk1.7.0_55\db\lib and select the derby.jar file. Hit Open. You should see that this adds a new branch to the project directory Referenced Libraries, and under this there should be a whole set of regionalised jar files, and derby.jar.


We should now be able to use the Derby database management system.

Finally in our setup, we'll make a directory to store the database in. Make yourself a directory somewhere easy to get at. For our purposes we'll assume m:\databases\.


When you're done with that, go on to Part Two where we'll start our coding.