Department Event Portal

This mini project is part of curriculum activity using Java, MySQL

To run this project you required some basic softwares

1. Java 8.0+
2. MySQL 5.1+

Run Locally

Clone the project

  git clone /https://github.com/hashanant/Mini-Project

Go to the project directory

  cd Mini-Project

Start MySQL local server with default port 3306

  net start <DATABASE USERNAME>

Create and configure tables in database

  CREATE DATABASE miniproject;

  CREATE TABLE signup (ID INT(10) AUTO_INCREMENT, fName TEXT, lName TEXT, userName VARCHAR(10), pwd VARCHAR(15), PRIMARY KEY (ID));

  CREATE TABLE admin (id INT(10) AUTO_INCREMENT, userName VARCHAR(10), pwd VARCHAR(15), PRIMARY KEY (id));

  INSERT INTO admin VALUES (1, admin, hash);

  CREATE TABLE events (id INT(4), title VARCHAR(255), description LONGTEXT, PRIMARY KEY (id));

  CREATE TABLE applied (id INT(10) AUTO_INCREMENT, userName VARCHAR(10), title VARCHAR(255), PRIMARY KEY (id));

Compile Java files

  javac *.java

Connect MySQL Connector to Java

  java -cp .;mysql-connector-java.jar MainWindow

Documentation

Java Documentation

MySQL Documentation

🛠 Skills

Java, Python, MySQL, HTML5, CSS, JavaScript...

🔗 Links

License

MIT