Online College Fee Payment System

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

Leave a Reply

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