DigitalWalletLite is a lightweight Java console application with a MySQL backend.
It’s designed as a simple, easy-to-understand demonstration of how Java programs can interact with a relational database to manage user accounts and transactions.
- 🔑 User registration and login
- 💰 Deposit and withdraw money
- 🔄 Transfer money to other users
- 📊 Check account balance
- 📝 View transaction history
Before running, ensure:
- ☕ Java JDK 8+ installed (
java -version) - 🖥️ IDE recommendation: VS Code (with Java Extension Pack) or any suitable editor
- 🗄️ MySQL server installed and running
- 📚 MySQL Connector/J (
mysql-connector-j-8.0.33.jar) in thelib/folder - (Optional): MySQL Workbench or any MySQL GUI client for easier visualization
git clone https://github.com/ArifRahman0102/DigitalWalletLite.gitcd /path/to/DigitalWalletLitebrew services start mysql
brew services stop mysql
brew services listmkdir -p bin
javac -d bin -cp "lib/mysql-connector-j-8.0.33.jar" Main.javajava -cp "bin:lib/mysql-connector-j-8.0.33.jar" Maincd C:\path\to\DigitalWalletLitenet start mysql
net stop mysqlmkdir bin
javac -d bin -cp "lib\mysql-connector-j-8.0.33.jar" Main.javajava -cp "bin;lib\mysql-connector-j-8.0.33.jar" MainCREATE DATABASE IF NOT EXISTS wallet_db_single;(Follow the schema provided in the project)
CREATE USER 'wallet_user'@'localhost' IDENTIFIED BY '1010';
GRANT ALL PRIVILEGES ON wallet_db_single.* TO 'wallet_user'@'localhost';
FLUSH PRIVILEGES;static final String URL = "jdbc:mysql://localhost:3306/wallet_db_single";
static final String USER = "wallet_user";
static final String PASS = "1010";- Register a new user or login.
- Use the menu options:
- Deposit
- Withdraw
- Transfer
- Transaction History
- Check Balance
- Logout when done.
- Java (JDK 8+)
- MySQL
- JDBC
Arif Rahman
🔗 GitHub: ArifRahman0102