Skip to content

8packcoder/DeveloperCollabPlatform

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

💻 DeveloperCollabPlatform

📌 Project Description

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.


💻 Tech Stack

  • Language: Java (JDK 8+)
  • Database: MySQL
  • Connector: MySQL JDBC (mysql-connector-java)
  • IDE Recommended: IntelliJ IDEA, Eclipse, or VS Code
  • Build Tool: Manual / Maven

🧩 MySQL Database Setup

📁 1. Create the Database and Tables

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)
);

🔌 Add JDBC Dependency

If using Maven, add this to your pom.xml:

<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.


⚙️ Database Connection Code (Java)

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.


📦 Features Implemented

  • ✅ User registration
  • ✅ View all users
  • ✅ Create project
  • ✅ View all projects
  • ✅ Join a project
  • ✅ View project members

🏁 Running the Application

  1. Compile the program:
javac DeveloperCollabPlatform.java
  1. Run the program:
java DeveloperCollabPlatform
  1. Use the menu-driven interface to interact with the system.

📎 Contribution

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

📫 Contact

Saurabh Kumar Bajpai
📧 Email: [email protected]
🔗 LinkedIn: linkedin.com/in/saurabhbajpai03
🐙 GitHub: 8packcoder


📄 License

This project is licensed under the MIT License. See the LICENSE file for more details.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages