Database API

[iainworkman]

We need to create an API for systematic reading from/writing to a database

[iainworkman]

Altered:

• Renamed class database to Database, to meet code conventions

095623d

[iainworkman]

Altered:

• Database ~ Defined the interface that the database subclass(es) will use

cd4206f

[iainworkman]

Altered:

• Database ~ Made minor changed to documentation of the interface super class

Added:

• JdbcDatabase ~ Class implementing the database interface. Will use the standard JDBC driver to connect to the database

3454263

[iainworkman]

Altered:

• JdbcDatabase.java ~ Added method implementations for selecting, inserting and updating

6b20384

[iainworkman]

ToDo: This needs some testing. Haven't even had chance to run it on a database yet.

[iainworkman]

Okay, that methods isn't going to work. Closing the statement closes the resultset. This means you can't pass results from queries about, effectively.

[matchulul]

Yes that.

[iainworkman]

Added:

• MainMenu ~ Basic main menu window that will display (for now just tests the database)

Altered:

• JdbcDatabase ~ executeSelect now returns the result set with the statement still open
• MovieScheduler ~ Main method now opens the main menu

93ee33e

[iainworkman]

@RyanLaForge is going to make some changes to the structure of this to allow the API to queue up a bunch of commands and wrap them in a BEGIN and ROLLBACK/COMMIT in order that we can ensure all logical transactions are atomic.