How kanav-arora/financify works
Project type and purpose
• Financify is a monolithic, full-stack desktop accounting application.
• Front-end: Java Swing GUI (multiple frames for register, login, main dashboard, items, ledger, sale/purchase invoices, vouchers, analysis).
• Back-end: Java business-logic and data-access layers using JDBC to a MySQL database.
• Build & deploy: Apache Ant (build.xml), NetBeans project.
File structure
• /Financify/src/Frames → all Swing UI classes and .form definitions
• /Financify/src/Data → utility classes (Excel export)
• /Financify/lib → third-party JARs (mysql-connector, Apache POI, JFreeChart, jCalendar, etc.)
• /db → SQL schema/dump files for MySQL
• build.xml & nbproject → Ant and NetBeans build configurations
Main components
A. Presentation Layer (UI)
• RegisterFrame, LoginFrame, MainFrame, ItemsFrame, LedgerAccountsFrame, TrialBalanceFrame, SaleFrame, PurchaseFrame, VoucherFrame, AnalysisFrame
• Uses Swing components (JPanel, JTable, JComboBox, etc.)
B. Business Logic Layer
• Controller classes embedded in each Frame or in Data/Excel.java
• Validation (e.g., regex in Register/Login), invoice generation, balance calculations
C. Data Access Layer (DAL)
• JDBC utility code (java.sql.*)
• DAO or direct SQL in Frame code invoking mysql-connector-java
D. Database
• MySQL instance
• Tables: users, accounts, items, stocks, transactions, vouchers, etc. (see db/*.sql and database.dbml)
E. External Libraries/Services
• Apache POI (Excel export)
• JFreeChart (graphical analysis)
• jCalendar (date pickers)
• MySQL Connector/J (JDBC driver)
Relationships and interactions
• UI Layer → invokes Business Logic → calls Data Access Layer → communicates with MySQL DB
• UI Layer → directly uses external libs for charts and Excel export
• Build tool (Ant) packages UI + logic + libs into a runnable JAR
Architectural patterns and design principles
• Layered architecture (Presentation → Logic → Data)
• MVC-style separation (Swing views, embedded controllers, data models in DB & Data package)
• Single deployment unit (desktop application)
Technologies/Frameworks to annotate
• Java Swing (javax.swing.*)
• JDBC (java.sql) with MySQL Connector/J
• Apache POI (org.apache.poi.*)
• JFreeChart (org.jfree.chart.*)
• jCalendar (com.toedter.calendar.*)
• Apache Ant (build.xml)