DeveloperCollabPlatform is a Java console-based application that allows developers to collaborate on software projects. It supports user registration, project creation, team management, and collaboration features — all backed by a MySQL database using JDBC.
- Language: Java (JDK 8+)
- Database: MySQL
- Connector: MySQL JDBC (mysql-connector-java)
- IDE Recommended: IntelliJ IDEA, Eclipse, or VS Code
- Build Tool: Manual / Maven
Run the following SQL commands:
CREATE DATABASE dev_collab;
USE dev_collab;
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100),
email VARCHAR(100) UNIQUE
);
CREATE TABLE projects (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100),
description TEXT
);
CREATE TABLE team_members (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT,
project_id INT,
FOREIGN KEY (user_id) REFERENCES users(id),
FOREIGN KEY (project_id) REFERENCES projects(id)
);
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.33</version>
</dependency>
If you're not using Maven, download the JAR manually from the MySQL Connector/J website and add it to your classpath.
private static final String URL = "jdbc:mysql://127.0.0.1:3306/dev_collab?useSSL=false&allowPublicKeyRetrieval=true";
private static final String USER = "root";
private static final String PASSWORD = "your_password";
public static Connection getConnection() {
Connection conn = null;
try {
Class.forName("com.mysql.cj.jdbc.Driver");
conn = DriverManager.getConnection(URL, USER, PASSWORD);
System.out.println("Database Connected Successfully");
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
return conn;
}
📝 Note: Replace
your_password
with your actual MySQL password.
- ✅ User registration
- ✅ View all users
- ✅ Create project
- ✅ View all projects
- ✅ Join a project
- ✅ View project members
- Compile the program:
javac DeveloperCollabPlatform.java
- Run the program:
java DeveloperCollabPlatform
- Use the menu-driven interface to interact with the system.
This is a beginner-friendly, console-based Java project.
Feel free to fork this repository and contribute by adding:
- GUI (JavaFX or Swing)
- Authentication system
- Project search functionality
- Export/Import features
- REST API support
Saurabh Kumar Bajpai
📧 Email: [email protected]
🔗 LinkedIn: linkedin.com/in/saurabhbajpai03
🐙 GitHub: 8packcoder
This project is licensed under the MIT License. See the LICENSE file for more details.