CONNECTING TO THE DATABASE USING NETBEANS
Firstly, ensure that the database location is correct by right clicking on JavaDB and going to properties (my database is inside my CourworkV2 folder called 'ShStockDB') under the 'Services' tab in Netbeans
Form a new connection with the database using the network driver by right clicking on databases
Host is “localhost”
Port is “1527”
Database name is “ShStockDB”
Both the username and password is “derby”
Use 'admin' as the username and password to have access to all forms when you run my program