PC Build

     

What's This? 🧠

• This is a Java Application, which helps in building a customized PC.
• It contains data about various products to build a PC (Like RAM, GPU, CPU, Display, etc) and their product details.
• Finally it generates an estimate for building your dream PC, which can be later exported as PDF.
• Some of the Features are:

  • Product Details will get updated accurately (When We Run The Scrapper Program, It Scrapes Realtime Data)
  • Easy To Use UI
  • Estimate can be exported as PDF either to the desktop or can be sent to e-mail

• Implemented using

  • Java Swing (For Frontend)
  • Oracle DB (For Backend)
  • Externa JARs

  • Jsoup (For Web Scrapping)
  • Apache POI (For Reading and Writing Office Format Files)
  • Aspose Cells (For Generating PDF From XLS)

  • Python Script (For Mailing)

Important Note? 📓

Please Make Sure to Change These Lines To Make This Program Working Perfectly

• In src/pcBuild/NewPCBuild.java file

Change Username and Password Of Your Oracle DB in the following Lines

ln 104, 205, 243, 270, 289, 3091, 3273

Change E-Mail ID and Password Of Your SMTP Mail in the following Lines

ln 3595, 3622

Create table in your database with these query

CREATE TABLE PCBPRODUCTS
(	PRID VARCHAR2(6), 
  PNAME VARCHAR2(500),
  PIMG VARCHAR2(500), 
  PDESC VARCHAR2(500), 
  TYPE VARCHAR2(20), 
  PRICE NUMBER(10,2)
);

PC Build User Details Table

CREATE TABLE PCBUSERDETAILS
(	MOBILE VARCHAR2(10), 
	NAME VARCHAR2(30), 
  CHECK (length(mobile) = 10), 
	PRIMARY KEY ("MOBILE")
);

PC Build Table

CREATE TABLE PCBUILDS
(	BUILDNAME VARCHAR2(50) NOT NULL, 
	MOBILE VARCHAR2(10), 
	PROCESSOR VARCHAR2(6), 
	MOTHERBOARD VARCHAR2(6), 
	STORAGE VARCHAR2(6), 
	RAM VARCHAR2(6), 
	CABINET VARCHAR2(6), 
	COOLER VARCHAR2(6), 
	GPU VARCHAR2(6), 
	POWERSUPPLY VARCHAR2(6), 
	DISPLAY VARCHAR2(6), 
	ESTIMATE NUMBER(20,2), 
	CREATEDAT TIMESTAMP (6), 
	CONSTRAINT "FK_MOBILE" FOREIGN KEY ("MOBILE")
	REFERENCES PCBUSERDETAILS ("MOBILE")
);

How does it works? 🤔

Initial Screen

Welcome Screen	Login or Register Screen

CPU Selection Screen	Display Selection Screen

Selected Build Screen	Export Build Screen

Estimate (PDF File)	Estimate To E-Mmail

NOTE ⚠️

Feel free to fork This Project😇

CREDITS

• ✅Karthik Raja
• ✅Prasath RK
• ✅Vignesh R

Connect with me: