Database API - Githubissues

ipw969 / 370Project

GNU General Public License v2.0

2 stars 1 forks source link

Database API #39

Open iainworkman opened 10 years ago

iainworkman commented 10 years ago

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

iainworkman commented 10 years ago

Altered:

Renamed class database to Database, to meet code conventions

095623d8248d5d5d3ed62d1eef81cf954231b190

iainworkman commented 10 years ago

Altered:

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

cd4206f4cb54376014b5503fea65fa94b2e6aaa8

iainworkman commented 10 years ago

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

345426333ff7b1f6b898560b547bca44e58fd0a4

iainworkman commented 10 years ago

Altered:

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

6b20384c66310be0c7f8a014e7674a4322c92671

iainworkman commented 10 years ago

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

iainworkman commented 10 years ago

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 commented 10 years ago

Yes that.

iainworkman commented 10 years ago

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

93ee33ec64aec36fe615cde35f805c0c11c5b0c

iainworkman commented 10 years ago

@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.