Desarrolla sistemas en Java, MySQL, DAO, POO, Swing, 3 Capas

Develop a robust desktop information management system with Java and Open JDK! This course guides you through building a comprehensive application using Object-Oriented Programming (OOP) principles. Learn to manage data effectively with MySQL (adaptable to other databases via JDBC) and implement the DAO pattern for data access.

You'll gain practical experience with the Swing library for creating user-friendly interfaces and utilize the Apache Netbeans IDE for efficient development. The final project follows a well-defined, layered architecture, ensuring scalability and maintainability.

Project: Complete Purchase and Sales Management System

This hands-on project covers all essential functionalities for a desktop-based purchase and sales system, built from the ground up. Key features include:

• CRUD Operations: Implement Create, Read, Update, and Delete operations for independent and relational tables.
• Master-Detail Tables: Manage data with master and detail relationships.
• Pagination: Efficiently handle large datasets with pagination controls.
• Automated Document Numbering: Generate sequential document numbers for receipts.
• Access Control: Implement user roles and permissions for secure access.
• Comprehensive Reporting & Queries: Create powerful queries and export data in various formats.

Key Modules:

• Warehouse Management (AlmacénArtículos): Manage all warehouse items, including:
  • Category management for organized item classification.
  • Tracking of barcode, name, stock levels, selling price, description, and images.
• Purchase Management (ComprasProveedores): Streamline your purchasing process:
  • Supplier management (name, type, document number, address, contact details).
  • Record purchase/stock intake (date, supplier, document type - Boleta, Factura, Ticket - and number, tax details).
  • Detailed item selection with quantity, purchase price, and selling price.
  • Automatic stock level updates upon purchase.
  • PDF export for purchase documents.
  • Purchase report generation in PDF format.
• Sales Management (VentasClientes): Manage your customer base and sales transactions:
  • Customer management (name, type, document number, address, contact details).
  • Record sales (customer, date, document type - Boleta, Factura, Ticket - and number, tax details).
  • Detailed item selection with quantity, selling price, and discount options.
  • Automatic stock level updates upon sale.
  • PDF export for sales documents.
  • Sales report generation in PDF format.
• User & Access Management:
  • Roles: Define access levels (Administrator, Seller, Warehouse Staff).
  • Users: Manage user accounts (name, type, document number, contact details, job title, encrypted login, and role assignment).
• Reporting & Data Export:
  • Sales Queries: Search sales records within specified date ranges.
  • Reports: Export data in PDF, Word, and Excel formats for analysis and record-keeping.

This course is perfect for developers looking to build powerful and scalable desktop applications using Java, OOP, and database technologies.