Skip to content

Desktop application developed in Java, using the Model-View-Controller (MVC) design pattern and CRUD (Create, Read, Update, Delete) operations for managing a SQL Server database.

Notifications You must be signed in to change notification settings

Ne052003/Yeralitas-DB-Manager

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

1 Commit
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

Yeralitas Program

Yeralitas Program is a desktop application developed in Java following the MVC (Model-View-Controller) design pattern. It provides a user-friendly interface to manage a database in SQL Server, implementing full CRUD (Create, Read, Update, Delete) operations for efficient data management.

πŸš€ Features

  • πŸ“Œ Graphical User Interface (GUI) built with Java Swing
  • πŸ“‚ Database Connectivity using JDBC
  • πŸ”„ CRUD Operations for managing records efficiently
  • πŸ—οΈ Structured Architecture following the MVC pattern
  • πŸ“§ Email Notifications using Javax.mail
  • πŸ—“οΈ Integrated Calendar with JCalendar Library

πŸ› οΈ Technologies & Libraries

  • Programming Language: Java
  • Database: SQL Server
  • Libraries Used:
    • AbsoluteLayout
    • JCalendar
    • Javax.mail
    • MSSQL 12.2.0

πŸ“¦ Generating a .jar with dependencies

To generate an executable .jar file with all required libraries:

  1. Generate Javadoc for the project.
  2. Copy libraries into the dist/lib folder.
  3. Configure packaging to include dependent libraries.

πŸ“· Screenshots

Main Window

Login

Menu

Inventory

Filter inventory

Sales

Adding a sale

See sale details

Calculator

Persoal information

πŸ“Œ Setup & Installation

  1. Clone the repository:
    git clone https://github.com/YOUR-USERNAME/Yeralitas-DB-Manager.git
  2. Open the project in NetBeans or any preferred IDE.
  3. Ensure SQL Server is running and configured.
  4. Run the YeralitasQuery script
  5. Update database credentials in the JDBC connection settings.
  6. Run the application.

πŸ“¬ Contact

For inquiries or contributions, feel free to reach out:


πŸš€ This project demonstrates my skills in Java development, database management, and software architecture. If you find it useful, feel free to ⭐ the repository!

About

Desktop application developed in Java, using the Model-View-Controller (MVC) design pattern and CRUD (Create, Read, Update, Delete) operations for managing a SQL Server database.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages