Dictionary and Registration Applications

Overview

This project contains two JavaFX applications:

1. Dictionary Application - A bilingual translation tool between Oromo and English
2. Registration Form - A user registration interface with form validation

Dictionary Application

Features

• Bidirectional Translation: Translate words from Oromo to English and vice versa
• Database Integration: Stores and retrieves translations from an Apache Derby database
• User-Friendly Interface: Simple GUI with clear input fields and buttons

Database Schema

The application uses a table named Transilation with the following structure:

CREATE TABLE Transilation (
    OROMO VARCHAR(255),
    English VARCHAR(255)
);

Functionality

• Save Button: Stores new word pairs (Oromo-English) in the database
• Translate Button:
  • If only Oromo word is entered: translates to English
  • If only English word is entered: translates to Oromo
  • Displays error if both fields are filled

Database Configuration

Connection conn = DriverManager.getConnection(
    "jdbc:derby://localhost:1527/JAVA2025", 
    "bonbonsa", 
    "*******"
);

Registration Form Application

Features

• User Information Collection:
  • Name
  • Phone number
  • ID
  • Gender (Male/Female)
  • Department selection
• Form Controls:
  • Text fields for name, phone, and ID
  • Radio buttons for gender selection
  • Dropdown (ChoiceBox) for department selection
  • Save and Reset functionality

Form Fields

1. Name: Text input field
2. Phone: Text input field for phone number
3. ID: Text input field for identification
4. Gender: Radio button selection (Male/Female)
5. Department: Dropdown with options:
   • IT
   • Computer
   • Software
   • Biomed

Buttons

• Save Button: Processes and displays form data
• Reset Button: Clears all form fields

Prerequisites

Required Software

• Java Development Kit (JDK) 8 or higher
• JavaFX SDK
• Apache Derby Database Server
• IDE (NetBeans, Eclipse, or IntelliJ IDEA)

Database Setup

1. Install and start Apache Derby server
2. Create database named JAVA2025
3. Create table Transilation with OROMO and English columns
4. Update connection credentials in the Dictionary class

Installation & Setup

Step 1: Configure JavaFX

1. Download JavaFX SDK
2. Add JavaFX libraries to your project classpath
3. Set VM options: --module-path "path-to-javafx-sdk/lib" --add-modules javafx.controls,javafx.fxml

Step 2: Database Configuration

1. Ensure Derby server is running on localhost:1527
2. Update database credentials in the Dictionary class:

   // Replace with your actual credentials
   Connection conn = DriverManager.getConnection(
       "jdbc:derby://localhost:1527/JAVA2025", 
       "your-username", 
       "your-password"
   );

Step 3: Run Applications

Dictionary Application:

javac Dictionary.java
java Dictionary

Registration Form:

javac RegistrationForm.java
java RegistrationForm

Project Structure

src/
├── Registration/
│   ├── Dictionary.java
│   └── RegistrationForm.java
lib/
├── javafx-sdk/
└── derbyclient.jar

Dependencies

• JavaFX 8 or higher
• Apache Derby Client (derbyclient.jar)

Usage

Dictionary Application

1. Enter a word in either Oromo or English field (not both)
2. Click "Translate" to get the translation
3. To add new words, enter both Oromo and English, then click "Save"

Registration Form

1. Fill in all required fields
2. Select gender and department
3. Click "Save" to process the data
4. Use "Reset" to clear the form

Troubleshooting

Common Issues

1. Database Connection Error:

   • Verify Derby server is running
   • Check database URL and credentials
   • Ensure database and table exist

2. JavaFX Not Loading:

   • Verify JavaFX SDK path in VM options
   • Check module declarations

3. Class Not Found Exception:

   • Ensure derbyclient.jar is in classpath
   • Verify all dependencies are properly imported

Development Notes

• Built using JavaFX for GUI components
• Uses JDBC for database operations
• Implements prepared statements to prevent SQL injection
• Follows MVC pattern for separation of concerns

Future Enhancements

• Add input validation and error handling
• Implement search functionality in dictionary
• Add data persistence for registration form
• Enhance UI with CSS styling
• Add update and delete operations for dictionary entries

Author

Developed as a JavaFX application demonstration for bilingual dictionary and user registration systems.