Online College Fee Payment System project is for educational institute. An Educational institutes running colleges at multiple locations.They want an centralized application to pay Fees by student online.Project must also manage salary of accountant and Details of Student.Various customized report must be generated as per requirement.student must be able to pay Fees online.

Online College Fee Payment System

User’s of the System:-

  1. Admin of the System:-
    1. Manage Accountant of Various Colleges-means Insert,Update or Delete Accountant Details after LogIn
    2. Search and Generate report of Accountant.
    3. Search and Modify Details of Student.
  2. Accountant of Colleges
    1. Accountant can Search For Particular Student.
    2. Update Details of Student.
    3. Enroll New Student in the System.
  3. Student of the System
    1. Student can pay their Fees Online.
    2. Search History of Paid Fees.

Tools and Technology used:-
1.Use any Java integrated IDE to develop this project.you can use eclipse or netbeans for this project.
2.Oracle as a back end for the database.
3.Apache Tomcat as a web server to run this project.

Table Fields:

 

CREATE TABLE  "STUDENT2" 
   (	"ID" NUMBER, 
	"NAME" VARCHAR2(4000), 
	"COURSE" VARCHAR2(4000), 
	"MOBILE" VARCHAR2(4000), 
	"FEESUB" VARCHAR2(4000), 
	"FEE" VARCHAR2(4000), 
	"PAID" VARCHAR2(4000), 
	"BALANCE" VARCHAR2(4000), 
	"ADDRESS" VARCHAR2(4000), 
	"FATHERNAME" VARCHAR2(4000), 
	"MOTHERNAME" VARCHAR2(4000), 
	"DATEOFBIRTH" VARCHAR2(4000), 
	"QUALIFICATION" VARCHAR2(4000), 
	"DATEOFJOINING" VARCHAR2(4000), 
	"DESCRIPTION" VARCHAR2(4000), 
	"TRAINER" VARCHAR2(4000), 
	 CONSTRAINT "STUDENT2_PK" PRIMARY KEY ("ID") ENABLE
   )
/

CREATE OR REPLACE TRIGGER  "BI_STUDENT2" 
  before insert on "STUDENT2"               
  for each row  
begin   
    select "STUDENT3_SEQ".nextval into :NEW.ID from dual; 
end; 

/
ALTER TRIGGER  "BI_STUDENT2" ENABLE
/

----------------------------------------------------------------
CREATE TABLE  "PAYREGISTER" 
   (	"ID" NUMBER, 
	"USERNAME" VARCHAR2(4000), 
	"USERPASS" VARCHAR2(4000), 
	"BRANCH" VARCHAR2(4000), 
	"DATEOFJOINING" VARCHAR2(4000), 
	"DATEOFBIRTH" VARCHAR2(4000), 
	"SALARY" VARCHAR2(4000), 
	 CONSTRAINT "PAYREGISTER_PK" PRIMARY KEY ("ID") ENABLE
   )
/

CREATE OR REPLACE TRIGGER  "BI_PAYREGISTER" 
  before insert on "PAYREGISTER"               
  for each row  
begin   
    select "PAYREGISTER_SEQ".nextval into :NEW.ID from dual; 
end; 

/
ALTER TRIGGER  "BI_PAYREGISTER" ENABLE
/

Download Project source code:

download source code

🔥3.1 K Views
0 0 vote
Article Rating
Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

15 Comments
oldest
newest most voted
Inline Feedbacks
View all comments
ntivuguruzwa vedaste
May 20, 2019 1:01 PM

which relation ship with sudent and colle?

khalidajamal
July 26, 2019 9:10 PM

how to execute it,can u plzz commenet me execution steps

kalidsjamal
July 26, 2019 9:12 PM

how to execute it??
can u plzz help me with the execution process

kalidsjamal
August 6, 2019 8:12 PM

how to execute it??
can u plzz help me with the execution process

Student Project Guide
Student Project Guide
August 6, 2019 8:12 PM
Reply to  kalidsjamal

Hi kalid s jamal
We creating video video tutorial for all our project. once we complete that we will inform you.

Khalida Jamal
Khalida Jamal
August 30, 2019 11:06 PM

Hi
I m waiting for your tutorial video

Shiva Prasad
Shiva Prasad
September 2, 2019 11:16 PM
Reply to  Khalida Jamal

Ok we will create video on this. Please wait for one week time.

khalidajamal
August 6, 2019 8:12 PM

how to execute it,can u plzz commenet me execution steps

Shiva Prasad
Shiva Prasad
September 2, 2019 11:16 PM
Reply to  khalidajamal

We will update this in one month.

ntivuguruzwa vedaste
August 6, 2019 8:12 PM

which relation ship with sudent and colle?

Student Project Guide
Student Project Guide
August 6, 2019 8:12 PM

I didn’t get you.. Can you elaborate what you said?

srisurya kalidindi
srisurya kalidindi
November 3, 2019 11:45 PM

can u tell me how to execute it