How ojwanganto/sqleo works
Main Components Identification
The system should be divided into these primary components:
a) Core Application Layer:
• Environment Module (com.sqleo.environment)
• Query Builder Module (com.sqleo.querybuilder)
• Common Utilities (com.sqleo.common)
b) User Interface Layer:
• MDI (Multiple Document Interface) Components
• GUI Controls
• Dialogs and Windows
c) Database Connectivity Layer:
• JDBC Connection Management
• Connection Interceptors
• Database Metadata Handling
• [Presentation Layer]
• ↑↓
• [Business Logic Layer]
• ↑↓
• [Data Access Layer]
• ↑↓
• [External Database Systems]
Key Components
a) Core Modules:
• Application Controller (Application.java)
• Query Builder Engine (QueryBuilder.java)
• Metadata Explorer (MetadataExplorer.java)
• Command Editor (CommandEditor.java)
b) UI Components:
• Main Window (ClientFrame.java)
• Query Designer View
• Content View
• Metadata Browser
c) Data Access:
• Connection Assistant
• JDBC Wrappers
• SQL Command Interceptors
Relationships to Highlight
a) Data Flow:
• User Input → Query Builder → SQL Generation → Database
• Database → Metadata Explorer → UI Display
• Command Editor → SQL Execution → Result Display
b) Component Dependencies:
• How MDI components interact with core modules
• Connection management flow
• Query execution pipeline
Special Features
• Multi-language Support System
• SQL History Management
• Data Export/Import Functionality
• Query Visualization System
• Auto-completion System
Technical Details
Technical aspects:
Supported Databases:
• Oracle
• MySQL/MariaDB
• PostgreSQL
• SQLite
• Firebird
• Derby
File Formats:
• SQL (.sql)
• Query Layout (.xlq)
• CSV Export/Import
• Join Definitions (CSV)
Implementation Notes
• MVC pattern implementation
• Plugin architecture for database drivers
• Event-driven UI design
• Query builder visualization system
• SQL parsing and execution pipeline