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:

499Add to cart

🔥4.2 K Views

15 Comments

  • ntivuguruzwa vedaste

    August 6, 2019 - 8:12 PM

    which relation ship with sudent and colle?

    • Student Project Guide

      August 6, 2019 - 8:12 PM

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

  • ntivuguruzwa vedaste

    May 20, 2019 - 1:01 PM

    which relation ship with sudent and colle?

    • Student Project Guide

      May 20, 2019 - 6:32 PM

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

  • khalidajamal

    August 6, 2019 - 8:12 PM

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

    • Shiva Prasad

      September 2, 2019 - 11:16 PM

      We will update this in one month.

  • kalidsjamal

    August 6, 2019 - 8:12 PM

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

    • Student Project Guide

      August 6, 2019 - 8:12 PM

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

    • Khalida Jamal

      August 30, 2019 - 11:06 PM

      Hi
      I m waiting for your tutorial video

    • Shiva Prasad

      September 2, 2019 - 11:16 PM

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

  • 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

    • Student Project Guide

      July 26, 2019 - 9:42 PM

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

  • srisurya kalidindi

    November 3, 2019 - 11:45 PM

    can u tell me how to execute it

    • Student Project Guide

      November 5, 2019 - 6:58 AM

      Did you installed all necessary softwares..

  • omary

    September 12, 2020 - 9:55 AM

    Hi!.

  • Aman Bastia

    October 9, 2020 - 11:18 PM

    can u please send the video how to execute it!!!

Do you have anything to Ask?

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