Light

shubh2-0 / tender-management-system Goto Github PK

View Code? Open in Web Editor NEW

11.0 1.0 0.0 7.02 MB

This is a Tender Management System application. In this application two persons are allow to login ,first one is Admin and second one is Vendor. Admin can register new Vendors and will provide a username and password to Vendor. Vendor can login with username and password and handle all present tender according to him.

Home Page: https://github.com/Shubh2-0/Tender-Management-System

Java 99.97% Makefile 0.02% HTML 0.01%

java jdbc jdbc-driver buffered-reader class database methods mysql

tender-management-system's Introduction

𝐇𝐞𝐥𝐥𝐨, <𝚌𝚘𝚍𝚎𝚛𝚜/> !

I'm Shubham Bhati

About me

🌱 I love to learn to code in different languages.
✨ One of my main interests is Artificial Intelligence (AI) and its applications in daily life.
🙋🏻‍♂️ I am very passionate to learn new things ❤️.
👨🏽‍💻 Currently, learning and growing my skillset in deep learning, competitive coding, data structures and algorithms.
👥 I’m looking forward to collaborating on open-source projects.🌟
💬 Ask me about anything, I am happy to help.
🔄 Routine: Eat - Sleep - Code - Repeat.
📫 How to reach me [email protected]
⚡ Coding fact: There are over 700 different programming languages.
💪🏼 Fav Quote: Great Developers never stop learning.
👉 Click Here to view my projects 💻.

Connect with me:

Tech Stacks :

Java	Spring Boot	Apache Kafka	Maven	Hibernate	MySQL	RESTful API
Spring	JDBC	Swagger	MongoDB	Python	Django	Thymeleaf
Swing	JavaScript	HTML	CSS	Lombok	Postman	JavaFX
Emmet	GitHub	Eclipse	Open AI	Netlify	VS Code	Replit

Github stats

⚡Activity Graph:

🔝 Top Contributed Repo

tender-management-system's People

Contributors

Stargazers

Watchers

tender-management-system's Issues

MySQL

create a database for the project
database name should same as the project name
create 4 tables for the operations

Vendor Password Change Method

Create a method name called changePassword in VendorUser class (inside com.masai.users package).
That method is able to change the password of the administrator.
Import neccesarry class.
take the input by the help of BufferedReader class.
Take care of Exceptions also

Vendor User Class

Create a class called VendorUser (Inside the users package).
Inside that class create 5 static methods which take the input from the user and perform operations.
Import necessary classes.
Take care of Exceptions also.
create static variables also for helping those methods

Exception Package

Create a package called a com.masai.exception.
Inside that create 4 classes that extend Exception Class.
First Exception name called AdministratorException
Second Exception name called VendorException
Third Exception name called TenderException
Fourth Exception name called BidderException

MySQL Table Number 4

Create a table called a bidder
Create 5 columns in that table
First column for bidder number name called br_number
Second column for the tender id gives a foreign key Constraint name called tender_id
Third column for a vendor id gives a foreign key Constraint name called vendor_id
Fourth column for the bidder price name called br_price
Fifth column for bidder status name called br_status

MySQL Tables Number 1

Create a table called an administrator
Create 6 columns in that table
First column for administrator id as the primary key name called ad_id
Second column for the administrator password gives not null Constraint name called ad_password
Third column for an administrator name gives not null Constraint name called ad_name
Fourth column for the administrator email name called ad_email
Fifth column for administrator contact number name called ad_mobile_number
Sixth column for administrator city name called ad_city

DTO Package

Utility Package

Create a package called a com.masai.utility.
Inside that create 1 class name called DBUtil.
Inside that class create two static blocks and two static methods
First block is for fetching the required details for creating a connection to the database
Second block is for loading the Driver class
First method name called getConnection which creates the connection
Second method name called closeConnection which closes the connection
Handle the Exception part also

Admin UI class

Create a class called AdministratorUI (Inside the UI package).
Inside that class create 2 static methods which take the input from the user and perform operations.
Import necessary classes.
Take care of Exceptions also.
Create static variable which help those methods

Vendor UI Class

Create a class called VendorUI (Inside the UI package).
Inside that class create 2 static methods which take the input from the user and perform operations.
Import necessary classes.
Take care of Exceptions also.
Create static variables also which helps those methods

day-1_Planning

Project Setup
Guidelines, and issues tracker setup

DAO Package

Create a package called a com.masai.dao
Inside that create 2 Interface and their Implemented class.
First Interface name called AdministratorDao
Second Interface name called VendorDao
Create a class name AdministratorDaoImpl which implements AdministratorDao Interface
Create a class name VendorDaoImpl which implements VendorDao Interface
Create Methods for the user-opeations

Create Dao Pattern

Design Dao Pattern for application

Admin Password Change Method

Create a method name called changePassword in AdminstratorUser class (inside com.masai.users package).
That method is able to change the password of the administrator.
Import neccesarry class.
take the input by the help of BufferedReader class.
Take care of Exceptions also

Administrator User Class

Create a class called AdministratorUser (Inside the users package).
Inside that class create 7 static methods which take the input from the user and perform operations.
Import necessary classes.
Take care of Exceptions also.

MySQL Table Number 2

Create a table called an vendor
Create 6 columns in that table
First column for vendor id as the primary key name called vr_id
Second column for the vendor password gives not null Constraint name called vr_password
Third column for vendor name gives not null Constraint name called vr_name
Fourth column for the vendor email name called vr_email
Fifth column for vendor contact number name called vr_contact_number
Sixth column for vendor city name called vr_city

MySQL Table Number 3

Create a table called a tender
Create 5 columns in that table
First column for vender id as the primary key name called tr_id
Second column for the tender name gives not null Constraint name called tr_name
Third column for a tender type of name called tr_type
Fourth column for the tender price name called tr_price
Fifth column for tender location name called tr_location

UI Package (USER - INTERFACE)

Create a package called a com.masai.UI.
Inside that create 3 classes.
Inside that classes create static methods which perform operations by user input.

Main UI CLASS

Create a class called MainUI (Inside the UI package) --> PROGRAM STARTING.
Inside that class create 3 static methods which take the input from the user and perform operations.
One Method for admin
Second Method for vendor
Third is the main method where the program begins
Import necessary classes.
Take care of Exceptions also.
Create static variables which help those methods.

Users Package

Create a package called a com.masai.users.
Inside that create 2 classes.
Inside that classes create static methods which perform operations by user input.

Recommend Projects

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.
Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
TensorFlow

An Open Source Machine Learning Framework for Everyone
Django

The Web framework for perfectionists with deadlines.
Laravel

A PHP framework for web artisans
D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web

Some thing interesting about web. New door for the world.
server

A server is a program made to process requests and deliver data to clients.
Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization

Some thing interesting about visualization, use data art
Game

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft

Open source projects and samples from Microsoft.
Google

Google ❤️ Open Source for everyone.
Alibaba

Alibaba Open Source for everyone
D3

Data-Driven Documents codes.
Tencent

China tencent open source team.