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

🔥1.3 K Views

15
Leave a Reply

Do you have anything to Ask?

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

  Subscribe  
newest oldest most voted
Notify of
ntivuguruzwa vedaste
Guest

which relation ship with sudent and colle?

Student Project Guide
Guest
Student Project Guide

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

ntivuguruzwa vedaste
Guest

which relation ship with sudent and colle?

khalidajamal
Guest

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

Shiva Prasad
Guest
Shiva Prasad

We will update this in one month.

kalidsjamal
Guest

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

Student Project Guide
Guest
Student Project Guide

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

Khalida Jamal
Guest
Khalida Jamal

Hi
I m waiting for your tutorial video

Shiva Prasad
Guest
Shiva Prasad

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

khalidajamal
Guest

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

kalidsjamal
Guest

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

srisurya kalidindi
Guest
srisurya kalidindi

can u tell me how to execute it