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