I'm planning to develop a software for my father's business.
The software is very simple, it has two tables.
Whenever stock arrives, the quantity and content will be added to Stock table.. Structure is something like
1. Stock Table
| Brand | Quantity | Rate | Balance |
2. Sale table - (whenever customer purchase something, it will be deducted from Stock Table)
| Brand | Sold Quantity | Rate | Balance |
I'm very good with Basic Java programming, I can use Swing, JOption Pane kinda GUI things. If I want, I can develop whole software in Swing.
Now the problem is. I don't know where to store those tables with regular updated values. Use of file handling is bad approach. I need something like Database but the software is just for offline use.
I've worked with MySQL, Access etc database along with Java. But is there any STRONG OFFLINE Database? How is Java DB? I need a simple GUI with only 2 forms and processing between them.