Automation of Student Attendance Management Tool Project

Abstract:

The Automation of Student Attendance Management system maintains an analytical record of students, in accordance with the minimum attendance required by the faculty, for allowing students to sit for the examination. The front end of the project is being made using Netbeans IDE 8.2, in Java language; whereas the backend is being created and managed using MySQL 5.6 and WAMP Server. The project is being made by keeping in mind the problems faced while keeping attendance records on paper, or on spreadsheets, where the authority or faculty has to use formulae and decide which student matches the criteria and which student doesn’t.

All the tables are in a hierarchy. There is a view that holds the data of every student and their attendance table for the rows. We can only insert new data if we are logged in as a Faculty. But if we are logged in as students then we can only view our attendance. The front end is designed using Eclipse and the back end is built on MySQL and the connectivity between the two is done using JDBC Drivers.

Introduction:

It automatically calculates attendance percentage, total classes attended, and unattended classes for a particular student.
It enables performing some key administrative functions such as tracking absences, getting debar lists, etc.

The system maintains an analytical record of students, in accordance with the minimum attendance required by the faculty, for allowing students to sit for the examination.
The front end of the project is being made using Netbeans IDE 8.2, in Java language;

whereas the backend is being created and managed using MySQL 5.6 and WAMP Server.

Homepage of attendance manager

Homepage of Attendance Manager

The project helps the teachers upload their records to the system, and accordingly keeps track of each individual, and his attendance in classes. Even the students can access their records and maintain their attendance as per the criteria suggested.
It solves a big problem for teachers and saves time as well, which can be utilized in helping students in their box endeavors.
The project uses color coding and data assessment tools to manage attendance records. The attendance management software enables college and school students to improve the lecturer’s performance and productivity. The faculty does not have to expend their time in manual computation to obtain the student attendance percentage.
This system can help lecturers to take attendance easily. Manipulation and management of attendance data have to be taken care of, by the system so that the manual intervention can be removed.

You can also visit & download the Application project on Daily Student Classroom Attendance Management System Project

Overview of the Project

WHY DATABASE?

Record keeping is an essential part of every industry, it allows us to manipulate historic data and use that data to make decisions. Attendance is an important part of school and colleges it allows the faculty to know which student is coming regularly to classes and also helps in creating good students. It is also useful for the administrative authority to check for the late comers to work. Database tools like MySQL and Oracle are available for record-keeping purposes and are easily adaptable by nearly every industry. These records can be accessed later, and analyzed for further calculations, as needed by the user.

Advantages of database

• Single validated database throughout college/school.
• Current dataflow into Web-based access.
• Compliance of academic standards & best practices.
• Providing fast access to quality data to users.

This Attendance Tracking Management System is related to the Attendance Manager .Net Project. You can also visit & download the web application project on Attendance Tracking Management System PHP & MySQL Project

SCOPE OF THE PROJECT

The Scope of the proposed system is to develop a system for attendance marking and viewing using a database management system that can be accessed by the users through LAN/WAN. Respective departments of an organization can access the data easily from this proposed system.

ER Diagram:

ER Diagram of Attendance Management System

The present system handles data related to:

1) Attendance marking (For faculties).
2) Making calculations to check for debarred.
3) Viewing of attendance. (For students).
4) Subject-wise debarred list.

The developer is responsible for developing the proposed software i.e. he should analyze, design, and implement the proposed project.

The proposed system aims to manage the attendance of the students on the desktop and to insert/ update/ delete data in the attendance database.

The proposed system has the following objectives:

In the backend MySQL is used, the overview of tables is given below:

1. Faculty
2. Course
3. Subject
4. Class(Class name)

SYSTEM REQUIREMENT SPECIFICATION

Software Requirement :

  1. Operation System: Windows XP/7/8/10, Linux.

Programming Environment:

  1. Front End: Java (Eclipse)
  2. Back End: Wamp (MySQL)

Some output Pages of the Project

all the classes of the faculty for the system.
all the attendance records of the students for the system.
all the records of the subjects for the course.
all the attendance records of a class for the system.
users (Faculty/Students) can log in to the system.
the admin or the registered users to log in to the system.
the faculty to record the attendance of the student and then submit it.
show the attendance of the logged-in student and also show in which subject he is debarred.

Also, Read this Employee Attendance Monitoring System Java Project

Medical Shop Management System Java Project using Oracle Database

Introduction

This is software that aims at easy management of medical stores. In the market, a lot of work is done manually. In this era of the computer revolution, where everything is digital, data management and operation also need to be computerized. The existing manual database management system is more problematic and tedious. The calculation of data is not always accurate. The computerized system would reduce the complexity of managing the records and making them secure and easy to access, and get any type of information like the product detail, patient, etc in an easy manner by a quick search.
This system keeps the records of medicines such as medicine name, MRP, MFG, expiry date, quantity in stock, etc. The software also generates patient or customer reports as print out for later reference. After booking the patient order, our stores provide the medicines by hand or home delivery together with the proper bill generated by this software.
This software focuses on high security so that no unauthorized user can make a random transaction. Only the person provided with the proper user ID and password can do the billing or see the reports. And then for signing up as a new user it requires an Authentication number is required which is only owned by the owner of the store. So that no random person can signup for the account.
The software provides two levels of security. As “only billing rights” and “managing rights” so that a person or staff or helper who is appointed for only billing purposes can not manipulate the data stored in the database. But the administrator who has the managing right can have complete access to the data.

Objectives:

The main objective of this software is to provide an easy way to submit information about medicines and some other information as well.
It also facilitates deletion or modification or searching of all information very easily. The system is also helpful for generating reports and statuses. The medical shop management system is software that processes computerized information and manages all the record of medicines which is under medical shop management.
The aim of this project is to make possible easy all the manual errors and problems by automating them, which the users are facing at different levels of management in medical stores as well as provide a high level of security for the data.

ER Diagram:

So in this project, we try to do the best of our effort and hard work to cover some parts of the system process.

Fast Query Process:-

Computerization of the query process is more economical than that of manual processing because the query is updated and stored instantly without any calculation mistakes here we have to just update the product master table or customer master table but in a manual process, we have to change all the records.

Entry new Records:-

Maintaining the records of new entry becomes very easy because every day there are new medicines coming into the market which has a huge demand in the market. So, it’s important to stay updated for patients’ health sake.

Maintenance of all of the records:-

Medical shop management helps in updating all the records from time to time.

Issuing reports:-

Issuing reports issues from the completion of the updating of all tables or records. Here reports issue status is maintained by which we know how much patient comes for medicines, we generate reports of stock status after updating the stock records, etc.

Highly secure:-

This software is highly secure because in the absence of authorized persons, nobody can provide medicines because they have a unique id or password to edit their records which are protected also.

Input or Output Screen Design

  • If the user clicks on generate report then the report page is visible otherwise log it is done according to the user´s rights provided.
  • Generate Report: Provides Report of the customer or patient for future reference and allows us to keep it as a Hard Copy.
  • A new user can get signed up by an authorized person for using this software.
  • The Main menu contains all quick links. In the menu bar, the user can jump to the desired location, saving his/ her time.
  • Search for the desired medicine quickly for modification or deletion.
  • View the stock as Table
  • Keep track of all the transactions by easily checking out the Sales Report
  • Hassle-Free Billing.
  • Easily Customize the purchases.

Download the complete project on Medical Shop Management System in Java & Oracle database using AWT and Swing with ODBC

Mini Project on Student Profile Management System using Java

Develop a java based application using GUI to maintain student records. This Student Profile Management application should have a login page. The Student Profile Management should take student details like name, address, branch, previous year scores, and curricular and extra-curricular activities, and all the entered data should be displayed at the end for confirmation.

Project Programming Details –

1) LoginFrame :

Login Frame is GUI based window that is displayed when the user first executes the program. It is the welcome page through which the user will move on to the next frame.
It contains a button with an ActionListener() which on pressing opens Frame2.

2) Frame2 :

Frame2 is the login page. This page takes the user id and password as input and only after successful verification of user the user is allowed to move to the next page.
The default user id password is
User id:- admin
Password:- admin1234

3) Frame3 :

Frame3 is where the user is given the option to enter their details such as name, age, branch, and address and select their gender from the drop-down menu. Each detail to be entered is stored using JTextField() and JRadioButton is used to display the drop-down menu for the gender selection. Finally, there is the submit details button which on pressing triggers ActionListener() and checks whether the user-given input is legitimate or not, if it is not then it pops an alert message that reminds the user to enter the correct details. Once the correct input is given, we pass this information on to Frame4.

4) Frame4 :

Frame4 is where the user is given the option to enter their details such as their previous academic achievements, their 10th, and 12th scores, their average pointer, and their extra-curricular and co-curricular activities. Each detail to be entered is stored using JTextField() and JRadioButton is used to display the drop-down menu for the gender selection. Finally, there is the submit details button which on pressing triggers ActionListener() and checks whether the user-given input is legitimate or not, if it is not then it pops an alert message that reminds the user to enter the correct details. Once the correct input is given, we pass this information on to Frame5.

5) Frame5 :

Frame5 class is where we receive the user input taken in Frame3 and Frame4 and using JLabel()’s we display it on our Java application windows. There are two buttons to either make a new entry or exit. On clicking on the first button, ActionListener() is triggered which calls Frame3(), and thus we can enter details of another entry.

6) Student Details :

This is the final class that contains the main method, which calls the LoginFrame().

The output Results of the project will be:

  • Welcome page
  • Login Frame
  • Credential verification
  • User input
  • User input verification
  • Additional inputs
  • User input verification
  • Displaying user details
  • Making new entry

Thus, using a GUI-based java application we have successfully created Student Profile Management application with a welcome page, and login verification page, which takes various student details as input, verifies them and displays it in the end.
A major advantage of GUI is that it makes computer operations more intuitive and thus easier to learn and use.
Icons are more user-friendly than long command lines. GUIs provide the user with immediate, visual feedback about the effect of each action.

Download the complete project source code on Student Profile Management System.

Online Shopping Management System Java Console Application

This Project simulates the working of an online shopping portal where customers can buy products. Our Online Shopping Management System project is a purely console-based application and is implemented using the programming language JAVA.

This Java Console Application contains mainly two panels :

  1. Admin Panel – functions provided like managing products and customers
  2. Customer Panel – functions provided like buying products and making payments

A total of 8 class files have been created which are :

  • Database connection.java
  • Shop.java ( This is the main or the starting point of the project )
  • Admin.java
  • Customer.java
  • Products.java
  • Cart.java
  • Payment.java
  • Bills.java

Java Concepts used in the project are :

  • String manipulations
  • Collections framework in form of ArrayList
  • JDBC
  • Exception Handling
  • Inheritance
  • Classes and Objects
  • BufferedReader for taking entry

ROLE OF EACH MEMBER IN THE PROJECT

  • Designed class files – DatabaseConnection.java, Shop.java, Admin.java, and Customer.java and contributed to Debugging
  • Designed class file – products.java and contributed to Debugging
  • Designed class file – bills.java and contributed to Debugging
  • Designed class files – Payment.java and Cart.java and contributed to Debugging
  • Combination of class files in the end and for their joint working, Each member contributed equally.

DETAILS OF CLASS FILES

MAIN CLASS ( superclass ) = Shop.java

SUBCLASSES of Shop.java = admin.java and customer.java

Shop.java :

Main functions = registration of customer or admin, login into system Entry through buffered Reader

Array List used in login function to store id, password, and user type ( C for the customer, A for admin ) as a list

Database tables used are login info, admin info, and cast info Login info = storing used id, password, and type of user Admininfo = storing all details of admin except password Custinfo = storing all details of the customer except password setUID() function sets the admin ID to store in database setCUID() function sets the customer ID to store in the database.

Admin.java 

Functions include managing products (add,delete,view,search) by calling productsPage() function of products.java

Other functions include adding customers, removing customers, editing profiles, view registered customers.

For registering customers, since admin.java is subclass of Shop.java , registerCustomer() function of Shop is called by Shop.registerCustomer(), hence the small use of inheritance is here as the function need not be rewritten.

Customer.java :

Database table custinfo accessed for editing profile function

The main functions are viewing products, searching for products, adding and removing products from the cart, view the cart, and proceeding to the payment function.

Here first initializeProducts() function is called to store all product info in array lists, so that database need not be accessed everytime, hence Concept of collection framework is used here in form of ArrayList and through ArrayList functions .add(), .get(), .clear()

.add() = to add to ArrayList

.get(int i) = to get the element stored at index i in the ArrayList

Proceed to payment function calls payment.java class file and functions like add to cart, remove from the cart, and view cart call Cart.java. Calling is done via class objects like customerCart and p.

customerCart = object of Cart class p=object of Payment class

Customer.java is also the subclass of Shop.java where it calls the registerCustomer() function of the Shop.java through Classname.methodname like Shop.registerCustomer()

Products.java :

The main functions are added, removing, altering product info, viewing, and searching products setPid() function is used to set product id to store in the database

database table products are accessed to add, remove and alter product info

Cart.java :

This class file contains functions of the cart like add to cart, view cart, remove the product from the cart and cancel cart which is called from the customer.java class file via object.

Here add to cart function gets the product details to be added from customer.class via the constructor and adds them to the ArrayList so that the ArrayList can be used later on for displaying cart details and other functions as required.

Payment.java :

The main function of the payment class is to display bills and pay bills by calling bill.java, therefore it is an intermediate class between customer.java and bill.java and this class also stores payment details like bill and card details.

Bill.java :

Bill. class is called from the payment page through an object, this class contains details of a bill like a billing id, products purchased, and total amount. It also contains customer details whose bill it is. It stores the product details that are purchased in the ArrayList for easy access later on.

It contains functions like :

Generate bill = for calculating and storing the total amount in a variable Set bill id = for setting the bill id

Display bill = for displaying bill details

addtoDatabase = to add bill details to database table bills.

DatabaseConnection.java :

 The database connection is a class file that is used to establish a connection with the MySQL server and to create a database “Onlineshop” and five tables – login info, admin info, bills, products, and cast info. It takes the help of a flag variable to check whether the database schema exists or not and if exists, it only connects Java to MySQL.

It is imported into the class files like Shop.java and products.java where it is used to access the database and make connections.

Exceptions that are used in the project are :

  • IOException: This exception is used wherever BufferedReader has been used.
  • For handling the exceptions caused due to database like

ClassNotFoundException or SQL Exception, a try-catch block has been added.

  • For any other type of exception, sufficient try-catch blocks have been added.

Exception Handling features that are used in the project are :

Try-Catch block

Exception class functions like printStackTrace() have been used

throws keyword has been added in those methods wherever an exception is thrown and not handled by the method itself.

Snapshot of DatabaseConnection.java where Exception handling is used.

COLLECTION FRAMEWORK USED IN THE PROJECT

The concept of collections framework is used in the project through the implementation of ArrayList .

Use of ArrayList in the project :

Array List is used in the project to store the fetched results from the database for easy access later on. ArrayList is used in many class files in the project, like in customer.java , available product details are fetched from the database and stored in the ArrayList so that whenever the customer tries to access product info, it is fetched from the ArrayList and not from the database which reduces the complexity of code and saves time.

For using ArrayList Wrapper classes used are :

  • Integer for storing integers
  • Float for storing float values
  • String as a class for storing String values

DATABASE SCHEMA USED IN THE PROJECT

Here, the concept of JDBC comes into the picture and is implemented using MySQL and JAVA. The database is used in the project for storing information about admins, customers, products, bills, and login details.

Database details are as follows :

Name of the database = Onlineshop

The tables used in the project are :

  • Login Info Table
  • Admin Info Table
  • Cust Info Table
  • Products Table
  • Bills Table

How connectivity to MySQL was done :

 To connect to the MySQL server, we have used the JDBC concept and used the SQL Driver class to connect to the MySQL database. For using the SQL Driver class and other classes used for connection, java.sql.* is imported into the java class file.

Creation of the database and creation of tables were made in the DatabaseConnection.java class file and to access the database, later on, the code written was :

Class.forName(“com.mysql.jdbc.Driver);

Connection con=DriverManager.getConnection(String URL,username,password);

SOME SNAPSHOTS OF PROJECT OUTPUT

Main Page :

Customer section :

Some important points regarding the project :

  • The connector jar file should be added to the “Java project” using :
    JRE System Library > Build Path > Configure build path > Libraries > Add External JARs
  • For connecting to the database used in the project, enter the root password of MySql

Download the Complete Java Console Application Project on Online Shopping Management System

E-Commerce Order Management System Project using JAVA Swing

We have made a project on Order Management using Java AWT. Abstract Window Toolkit (AWT) is a set of application program interfaces ( API s) used by Java programmers to create graphical user interfaces ( GUI ) objects, such as buttons, scroll bars, and windows.  We have made our project by creating a store “E-Commerce Store”.

In our project we have to build a user interface where there is a login page where the user will be required to enter their email-id and password, after inserting, their details will be checked via JDBC with the information in the database if their information is incorrect an error message will be displayed, if the user does not have an account there is a button below which is create an account and after clicking that button the user will be taken to a different window where the user will be asked to input additional information and will be required to verify his email-id where the user will receive a onetime password (OTP), after entering that OTP the user will be required to set a password and other related information after successfully creating the account the user will receive a successful message.

After that, the user will be taken to the payment setup page where they have to enter a couple more information like Newark Id, Newark Pin, and Newark Password. Also, on the login page, if the user fails to remember their password, they can click on forget password and will be taken to another window where they will be required to enter their email-id and will receive an OTP after that they can change their password which in turn will be reflected in the database also.

After successful login the user will be taken to the store where there are some items to buy accompanied by a chat box and cart, the former takes you to the chat box where you can talk to our store and can directly go to the specific item purchase page as well you can also report a complaint regarding a specific item.

Talking about Cart, on that page you can see the items you have purchased and also delete the items that you have purchased but wish to keep no longer. For every item, there are specific specifications that you have to choose like memory, model color, etc., and below that there are three buttons cart, done and clear clicking on done will confirm your order and clear will clear the existing choices you have made there is also a button at the bottom which is back to store and it does what it reads.

On the cart page, once you have confirmed your order and wish to make no changes you can select on proceed to pay and after that, you will be taken to a new page where you can make your payment. To make a payment you will have to enter your Newark Id, Pin, and Password and then if you still wish to go back to the cart you can go before paying the amount. After paying the total amount of the items you purchased, the same amount will be deducted from the database as well and in case you have insufficient funds an error message will be displayed

The E-commerce system has massively replaced physical shopping, especially for electronic goods. Therefore, we have created our mini project to stimulate the initial aspects of an e-commerce engine starting with the user creating an account and ending with checkout and payment.

AIM

The first thing that comes to your mind when you think of an order management system is Amazon. Therefore, we decided to model our project on a mini version of Amazon, trying to incorporate some of its features including registration, purchasing items, placing orders, payment, etc.

Literature Review

To place an order on Amazon we need to create an account or if we have an account we just need to sign in.
We navigate to the product we want to buy.
We can then add the product to the cart.
We check the cart and remove the product that we don’t want.
We can then check out and proceed to pay.
We have to specify user details.
We also have Amazon Pay from Amazon their in-house UPI for quicker payment.

PROBLEM STATEMENT

To create a secure small-scale and affordable online store for small vendors for managing inventory and orders as an order management system.

BLOCK DIAGRAM

FEATURES

Account Handling:

Our program is able to create an account for both accessing the account and generating a house payment account, log in into an account by verifying necessary credentials like passwords and forgot passwords.
Our primary verification is done through email:
We use email for:
Verifying email during creating an account by sending an OTP through email.
Authenticate the user when there is forget password request for an account.

Cart system:

A simple easy-to-use GUI for users to select items to add to a shopping cart.
The user can even remove the item once they added it to the cart and simultaneous updating of the final price.

Chatbot:

A simple chatbot to respond to simple queries from the users.

Payment gateway:

We have created an in-house gateway where the user only needs to verify his bank credential once and then he can create an id and password that he can use during checkout making the process easier for the user every time he makes a purchase.

CONCLUSION & FUTURE SCOPE

We have successfully created an online shopping store that can be distributed to small vendors to employ for their use.

Our future endeavors include: Ordering more than 4 items of a particular product auto-updating inventory verifying phone number

We have successfully used the above features for the creation of the order management system using the code mentioned above using java. Our future endeavors in improving our project include connecting our payment gateway to a bank account id, verifying a phone number, and being able to order more than 4 numbers of a particular product.

IT Banking Portal Student Java Project Using Eclipse

EXECUTIVE SUMMARY OF THE PROJECT

Synopsis 

The mini-project made by us is basically a demonstration of the banking systems around the world on a very basic scale, in which we have created a GUI (Graphic User Interface) using the eclipse platform of JAVA and using the file management systems in JAVA. Basically, we have provided an interface to add, delete and view the different many accountants of a particular branch of a bank and also to add, delete and view the different bank holders and also store their account numbers, contact numbers, and salaries in the file, just to use whenever required. We have used the file management system in JAVA to store the details of all the accountants and the account holders.

Introduction 

The application that is the essence of the project works by defining various classes that even have further subclasses so as to modularize the final code. The code is written in a neat fashion with appropriate documentation. It provides a smooth, unfaltering user experience so as to facilitate its use among all age groups.

The use of exception handling in Java is implemented so as to prevent the user from getting stuck in a process and understanding the use of the application in a more suitable manner. It eases the reading and understanding of naive runtime errors generated. The use of the multithreading concept in Java lets us use multiple threads at a single time and also lets us do multiple tasks simultaneously which is required in the banking system.

Problem Statement 

The motivation behind the project was the lack of a simple well-written application to access and modify the details of the bank accountants of a particular branch and the bank account holders at the same time. It gave us enough motivation to make a GUI-based application to solve the same. In a world like this, can a whole lot of the population afford to waste the time looking for the details in the hard-copied registers and looking for all the accountants and the account holders when they can be easily maintained as a simple application?

Objective 

The main objective of the project makes the user to access the details of all the bank accountant’s bank account holders. It also gives the accountant the authority to delete, and modify the details of the account holders but the reverse is not possible

because that’s the hierarchy in a banking system works in that way. The aim is to give the accountant entire power virtually on the application. With our application, we have achieved just that. The application could have been designed in many different ways, but we have produced a solution of application that minimizes time complexity as well as space complexity by using Encapsulation, Polymorphism, Inheritance, and data abstraction. Along with these, Interfaces and various access modifiers have been implemented so as to maintain privacy and definition of access in different blocks Of code. The use of exception handling lets the user know exactly what went wrong.

METHOD

The application works by reading all the accountants and the account holders from a different file, which can be updated by the proprietor of the application, and also the same power is given to the admin of the bank. The file has the information stored in a particular format, which is decoded by the string reader functions in the code. Each time we enter or want output from the file we have to read this string reader function which is an in-built function of java and can be directly used just by importing the required files.

If there exists an object for the particular accountant or the account holder already, then that object is accessed, instead of creating a new one. If an object that is not available in the file is to be accessed then that object needs to be created and then accessed hence access to that object is not allowed and hence access is denied. We have to make sure that the object we want to access is present in the file system otherwise we have to create an object. The usage of various JFrames also enables us to increase our scope and work beyond the limitations of java by using the GUI effectively to give users an attractive interface to work with and get the work done.

SYSTEM REQUIREMENTS:-

  • Eclipse platform for JAVA GUI (Graphic User Interface)
  • JDK(Java Development Kit)
  • Windows Operating System

WORKS DONE:- (SCREENSHOT PF OUTPUT AND EXPLANATION)

  1. Main Page:–

This is the main frame that will be displayed as soon as our project gets executed. This is also the first page and the directive page as it directs us either to the admin section or to the accountant section. It consists of two buttons ADMIN LOGIN AND ACCOUNTANT LOGIN.

  1. Admin login page:–

This is the page that gets displayed as soon as the user clicks on the admin login button.

It consists of 2 labels namely enter a name, enter a password, one button, one text field, and one password field to get the password. To hide the password we have here used the echo Code property of the password field to encrypt it.

  1. Login Failed:–

This page gets displayed as soon as the user gets the name and the password on the frame admin login form but the dialog box with the message “Sorry, Username or Password Error” only when either the password or the name entered is incorrect.

4. Admin login Section:–

This frame gets displayed when the user enters the correct name and password. It has 4 different buttons which will direct to the things written on them. Only the ADMIN can enter the details of the Accountant and no one else. It consists of the addition, viewing, and removal of the accountant.

5. Add Accountant Page:–

This frame appears when the Accountant login button has been selected and the name and password entered are correct. This frame consists of the heading Add Accountant and it consists of 6 labels and 6 text fields and 2 buttons. This

6. Accountant Added Successfully:–

This frame appears when an accountant is added successfully.

This frame comes under the admin section. It consists of a dialog box that is used to make a JOptionPane.showMessageDialog() function.

  1. Database of all accountants:–

This is the database frame of all accountants under the institution. This contains various information about the accountants.

  1. Deleting an accountant:–

This frame comes under the admin section.

This frame does the job of deleting an accountant.

This is in the control of the admin whether to delete or not.

  1. Record Deleted Successfully:–

This frame comes when the record is deleted.

This frame confirms that the record is deleted successfully.

  1. Accountant Login Form:–

This frame can be chosen from the main frame of the project.

In this framed name and password of an accountant has to be given and if it is correct then the accountant section frame pops up.

  1. Accountant Section:–

This frame comes under the accountant’s control.

In this Frame, the accountant can add and view users.

  1. Add Account section:–

This frame appears when the button to add an account is hit in the Accountant section.

This frame saves the user’s various details in the database.

  1. Account Added Successfully:–

This frame confirms that the user is added successfully. This frame comes under the accountant section.

  1. Database of users:–

This is the database of users.

This comes under the accountant view section.

FUTURE WORKS:-

  • Since the project was made on a very basic level the obvious future work for the project would be to inculcate into it more complexities of the real-life kind of banking system. Since the project we made was only for the students of the branch IT in its future work we can inculcate more branches
  • Another future work that might sound interesting is to provide a server to it and make it using a database like MySQL(My Structured Query Language) which is a database used often with Java to store the details and the contents into it. It will be relatively easier for both the user as well as the programmer to use MySQL instead of the file management system, this is because in the file management system, we have to distinctly code to read in a string or anything else but when using MySQL we can directly use the add, delete and modify inbuilt functions of the MySQL database system and connect it to the Java program through server and then take in the command from the user in java and then pass on the same command to MySQL. Java and MySQL can be connected to each other through database connectivity which basically connects them through

RESULT AND DISCUSSION:-

The main result of the project is that we are now able to create a banking interface within a branch and between the accountants and the bank account holders. It can also be used to display the details of the users/bank account holders if we want to know something about them as and when we require it.

The usage of JFrame also enables a good graphical user interface making the banking system look more attractive and hence more appealing to the user. Since we have used many components on the JFrame like the text fields, password fields, radio buttons, and other buttons. All the components within them contain a lot of properties that can further be used to make it more attractive and more user friendly and also more encrypted in a way hence ensuring the data encryption in the Java program.

CONCLUSION:-

This was our project ever involving the connectivity of a language with the file management systems. This surely taught us a lot of things like how to store the details and how to look for the details in the backup database and how to create a database and how to back up our data regularly. Through this project, we ended up making an IT portal that has important significance and is very essential to us all. Through this project, we have gathered more knowledge about java, eclipse, and file systems in java. We also got to know a bit more about databases and how we use them.

This project also taught us how to work in a team and taught us various leadership skills and how to coordinate in a team and get the work done.

Credit Card Application Portal Java MySQL DBMS Mini Project

Problem Statement:

The credit Card Application Portal provides a platform for Users to avail of a credit card by filling in the relevant details. Further, it enables them to manage card services in the application portal.

Description:

The Credit Card Application Portal not only enables users to avail of a credit card but also allows them to manage services related to it too.

The DBMS Project works in the following way:

• It initially checks whether a user is pre-registered at the application portal. If so, then he or she is directed to the services menu. If not, then it allows users to sign up as first-time users at the application portal.

• Upon completion of the above sign-up process, a confirmation email is sent to the user’s registered email id which he or she had provided during the sign-up process. The confirmation email also contains the user’s login credentials as well as his or her form number.

• Once the user receives the email, he or she is redirected to the initial login page of the application portal. Here, he or she can use the credentials that had been sent earlier to his or her email id to login into the services menu. Once the credentials are verified, the user is directed to the services menu.

• In the services menu, the user can avail of four major services i.e., he or she can update the pin or view his/her application details or view the type of card he/she would be issued with, or view the set of FAQs which he or she can refer to.

E-R Diagram:

ER Diagram Credit Card Application Portal

Tool to be used:

1. IntelliJ / Eclipse / NetBeans
2. WampServer / Xampp
3. Internet Browser (Microsoft Edge, Google Chrome, etc.)
4. PDF Viewer (Adobe Acrobat, Nitro Pro, etc.)

Modules in Credit Card Application Portal

This Java & MySQL Project is aimed at taking a step forward towards digitalizing the entire process of applying for a credit card as well as managing the same.

• Login
• Signup1
• Signup2
• Signup3
• CardType

LOGIN:

Credit Card Application Portal initially checks whether a user is pre-registered at the application portal.

• If so, then he or she is directed to the services menu. In the services menu, the user can avail of four major services i.e., he or she can update the pin or view his/her application details or view the type of card he/she would be issued with, or view the set of FAQs which he or she can refer to.

• If not, then it allows users to sign up as first-time users at the application portal.

SIGNUP1:

This module basically deals with inserting values into the database. Relevant details such as the User’s name, father’s name, date of birth, e-mail id, gender type, marital status, and his/their complete residential address are requested to be filled by the user in order to process the user’s application for availing a credit card. Upon filling in the above-mentioned details, a unique form number is generated which is associated with the user who has filled up the relevant details

SIGNUP2:

This module also deals with inserting values into the database. The user’s application is processed based on the form number generated in the previous module. Details such as Aadhar number, PAN number, educational details, salary, category, etc. are to be filled in by the user. Credit Card Application Portal Department of CSE, Sai Vidya Institute of Technology

SIGNUP3:

Being directed to this module from SIGNUP2, the user is further supposed to fill in details that would be stored in the database. Here, s/he is required to fill in the desired cash withdrawal limit, credit limit, monthly cycle, and the services which they wish to avail. Upon completion of the above-mentioned signup process, a confirmation email is sent to the user’s registered email id which he or she had provided in the SIGNUP1 module.

The confirmation email also contains the user’s login credentials as well as his or her form number. Once the user receives the email upon successful signup as a first-time user, he or she can use the credentials that had been sent earlier to his or her email id in order to login into the services menu.

Card Type

This module tells the user the type of card s/he would be granted. The type of card to be granted to the user is decided upon his/her income.

View Here and Download the Complete Credit Card Application Portal Java MySQL DBMS Mini Project Standalone Desktop application Source Code, Project Synopsis, Report, How to setup files, etc

Software Requirements

Programming language: Java, MYSQL
Operating system: Any OS (Recommended: Windows 10,
Windows Vista, Windows XP)
Application required: Standalone desktop application & Wamp Coding
language: Core Java

Related Projects on Credit Card Management System:

Java and MySQL Project on Credit Card Approval System
Credit Card Approval System Project in Java
Credit Card Approval System Project
Analysis on Credit Card Fraud Detection Methods CSE Project Abstract
Credit Card Fraud Detection Using Hidden Markov Model .Net Project Report
Credit Card Fraud Detection Using Hidden Markov Model Project Report
Analysis on Credit Card Fraud Detection Methods
Cyber Credit Card System Project Source Code In Java And Report
Petro Credit Card Management System Project with Source code
Cyber Credit Card System Java Project with Source Code
Credit Card Fraud Detection Using Hidden Markov Model Project Source Code
Credit Card Management System
Credit Card Approval System Java Project
Analysis on Credit Card Fraud Detection Methods Project
Credit Card Management System

Interactive Hostel Management System Java and MySQL Project

Objective

The main objective of this Java and MySQL-based project is to create an interactive Hostel management GUI application that helps in the management of Hostel records about registration of students and employees, and fee and salary management. Through this application, the admin can register & manage students & employees of the hostel.

MODULES IN HOSTEL MANAGEMENT SYSTEM:

Admin:

Admin can log in to the software using the Username and password provided by the developers. After login, he can register students and employees. He has to update the data of all the participants of the system i.e., Students and employees. He can Insert, update and as well as delete records from the system.

Student:

This module is about the residents of the hostel. It holds the data of the students residing in the hostel eg. Names, addresses, USN, RoomNo & Phone. The complete information about a particular student can be obtained by referring to this module.

Fee Payment (Insert):

This module is necessary to hold the information related to the Fees of the residents of the hostel. It has fields for Name, total fees, the amount paid, mode of payment, and balance amount remaining to be paid by every individual student. The individual student details can be accessed by providing a unique USN.

Employee:

This module is related to the employees of the hostel. It holds the data of the employees like Name, Age, Eid, Designation & Salary. The complete information of a particular employee can be obtained by the unique employee ID.

Salary Payment (Insert & Update):

This module is necessary to hold the information related to the salary of the employees of the hostel. It has fields for Name, Eid, total salary, the amount paid, and balance amount remaining to be paid for every individual employee. The individual employee details can be accessed by providing a unique Eid.

Features page of the Hostel Management project

Output Pages will be below:

  • Login Page of the project
  • Features page of the project
  • Registration page for new Students
  • Employee registration page
  • Options for employee management
  • Fee update and fetch the page
  • Fetch fee details of individual students
  • Maintain student records of the system
  • Update fee details of a specific student

Download the complete Hostel Management System Project source code and Project report.

Mall Guide Project in Java

Study of the system:

In proposed system, we present a new GUI based system. The type of application that we are proposing to develop is a Mall Guide using automation. Our proposed project would be working using a server for database and information storage and users for information retrieval purpose such as list of shops, location of shops, and availability of goods and cost of goods.

This system is also useful for customers, who are interested to own a shop. for example, if a shop empty on the shopping mall then the customer who is interested can send a proposal to the owner of the shopping mall.

Customer Page

Functions:

These are the functions implemented into our application. They are:

  1. Browse:
  2. Search by name
  3. Search by category
  4. Explore map

1. Browse:

This function allows users to browse all the stores in the shopping malls.

2. Search by name:

This function allows users to search a particular store by name. The user will query the database according to the text given. If the database contains none of the text input by the user, the program will notify the users to try again.

3.  Search by category:

This function allows the user to select one option from a list of categories.  Once the user selects the category, the application will query the database to display the result.

4. Explore Map:

This function allows the users to view the map of the shopping mall and also magnify the view of the map. 

Advantages:

Create a paperless environment: All the information regarding the stores and the mall itself will be stored in the server. This will create a paperless environment in which whenever a visitor needs to obtain related information regarding a tenant in the shopping mall. 

It is user friendly interface to the customer: Requires no technical knowledge for searching. 

Easy to search: Search becomes easy based on the input provided. 

It requires less time: When a customer is searching for a product in a manual process it takes much time in searching for the store and the product, but when compared to our proposed system it takes less time because it gives the output based on the input i.e., searching of a store or shop.

Details of store

It also takes less time for a customer to own a shop 

Modules:

          In this project we include three modules. They are:

  1. Administrator
  2. Customer
  3. Shopkeeper 

1. Administrator:

The administrator responsibility is to create logs containing each and every information regarding stores, goods available, shop numbers , route for the shop through maps , updation of the shop details and routes if any changes from shopkeepers in the entire shopping mall.

A successful online mall demands a solution that integrates all the offerings in to one common interface, while at the same time, allowing each vendor the flexibility to add, edit and change their offerings in real time

Customer:

              The user is a person who comes to the shopping mall for shopping. The customer can avail the details of the stores and their respective products at the entrance of the shopping mall. User requirements are the input to Mall Guide.

Any person wishing to set up shop in the mall can send a proposal to the mall owner.

This system is also useful for customers, who are interested to own a shop. for ex: if a shop  is empty in the shopping mall then the customer who is interested can send a proposal to the owner of the shopping mall

Shopkeeper:

  The Shopkeeper is a person who owners the shops or a store in the shopping malls. He is the person who gives information on goods and services to the administrator about his shop.

Software Requirement Specification:

Introduction:

With tremendous changes in the technology, making the things very simple and more user friendly to the people and at the same time people also demand the information about everything in the simple form. So, we are introducing the concept of MALL GUIDE to make the people more convenient and comfortable.

Purpose:

MALL GUIDE is a system, which gives an overview of all shops in current retail shopping mall. MALL is a large retail complex containing a variety of stores, restaurants and other business establishments housed in a series of connected or adjacent buildings are in a single large building.

Nowadays the shopping MALLs are becoming center points to get any type of goods and services needed by the people. But the methods they are using to provide information regarding the goods such as, the availability of goods, range varieties and their locations are traditional. These methods take more time and the customers may feel inconvenient with these approaches .To overcome these problems in the existing system we propose new GUI based system, which is more user friendly to ordinary user with no technical knowledge.

Scope:

The aim of this Project is to perform the following operations

  • Managing all the details of the stores. The details will include the no of stores, name of store, location of the stores, product details of particular store and etc.
  • It is useful to the customers who are going to shopping.
  • Providing updates of store names, store locations & goods availability.
  • Administrator can always watch the progress of the mall details.
  • To create a paperless environment: All the information regarding the stores and the mall itself will be stored in the server. This will create a paperless environment in which whenever a visitor needs to obtain related information regarding a tenant in the shopping mall.
  • It is user friendly interface to the customer: Requires no technical knowledge for searching.
  • Easy to search: Search becomes easy based on the input provided.
  • It requires less time: When a customer is searching for a product in a manual process it takes much time in searching for the store and the product, but when compared to our proposed system it takes less time because it gives the output based on the input i.e., searching of a store or shop.

With tremendous changes in the technology, making the things very simple and more user friendly to the people and at the same time people also demand the information about everything in the simple form. So, we are introducing the concept of MALL GUIDE  to  make  the  people more convenient and comfortable.

MALL GUIDE gives an overview of all shops in current retail shopping mall.

In this system, we present a new GUI based system. The type of application that we are proposing to develop is a Mall Guide using automation. Our proposed project would be working using a server for database and information storage and users for information retrieval purpose such as list of shops, location of shops, and availability of goods and cost of goods.

The main reason behind our conceptual idea of this project is to feel that there are times when users often change their plan to go to other shops instead of the ones in their minds. This is probably due to the complicated buildup structure of the mall. 

Future Scope:

We have done the project based on standalone system. We have done the project placing the system at the entrance of the mall. For future enhancement, we can provide LAN connection, to the systems by placing single system at each floor. In the future we provide sms alerts to the regular registered customers if the shop is vacated or any shop is lended.

Virtual Assistance Java Project

Objective of the Project:

Virtual Assistance does not mean that a computer will automatically generate every document that you want, customized and ready to use. Each document will have some unique content, even if it is only the name and address of the addressee. This unique content will still need to be provided by you (or a database in the case of a mail-merged form letter).

Virtual Assistance software can help you create templates, specify rules and assemble documents. They might also be able to use the templates created by word processing programs such as Word.

Documents templates have been in use for quite some time now. Word processing programs typically have provision to create such templates, e.g., the .dot files in Microsoft Word. Word processing programs also offer facilities to generate customized documents from these templates, such as the mail merge facility of Word.

With document automation software of such capabilities, you need to do only the absolute minimum to create a document. It would almost seem that further document automation is possible only when computers can grasp your thoughts and convert them into relevant documents!

Virtual Assistance software can help you create templates, specify rules and assemble documents. They might also be able to use the templates created by word processing programs such as Word.

With document automation software of such capabilities, you need to do only the absolute minimum to create a document. It would almost seem that further document automation is possible only when computers can grasp your thoughts and convert them into relevant documents!

Study of the system: 

Virtual Assistance is a standalone application; it means that a computer will automatically generates every document that the user needed is customized and ready to use. Each document will have some unique content, if it is only the name and address of the addressee. This unique content will be taken from the database. And this database will look after by the profile manager. The details present in the data base can only access his /her desired document, for example letters. It is useful in everywhere like colleges, organizations. 

Administrator:

Administrator is the super user who maintains the profile of the personnel and maintains the document templates.

Profile Manager:

Profile Manager can add, delete, and update the details of the personnel.

Template Manager: 

Administrator

  •   Login into the System.
  •  Creates new Users, template.
  •   Views all the details of existing users, template.
  • Updates the template, user details.
  • Deletes the Template, user details.
  • Prints the Required document.

Template Manager can create ,deletes, modify the existing template and save the template for the future use.

Software Requirement Specification:

Introduction

Rapid development in science and technology is forcing the human beings to depend on some technology at some stage in solving very simple problem to complex problem. This software called virtual assistance is used to reduce some work at different places in the daily life work process. This document provides details about the entire software requirements specification for the software VIRTUAL ASSISTANCE.

Purpose:

Virtual Assistance is a standalone application; it means that a computer will automatically generates every document that the user needed is customized and ready to use. Each document will have some unique content, if it is only the name and address of the addressee. This unique content will be taken from the database. And this database will look after by the profile manager. The details present in the data base can only access his /her desired document, for example letters. It is useful in everywhere like colleges, organizations.

Scope:

The scope of the project is to perform the following operations

  • Managing all the details of the user, for ex: name, address etc is stored in database all these details will look after by profile master.
  • Profile master and user will be looking after by an administrator. All the changes are done by administrator only. Adminstrator can create, update different types of documents or letters, at the same time he can delete.
  • As administrator provides some templates, it is very easy to use the documents or letters at a time.
  • It is user friendly interface to the user: Requires no technical knowledge for his required document.
  • Easy to use:  becomes easy based on the input provided.
  • To Create a paperless environment: When many of the users require the same application, the same content will be written individually. This will require lot of paper work.  The unique content of all the documents will be stored in the database. This will create a paperless environment in which whenever the user require the document the content will be same, but the details will be different. Here the content is reusable.
  • It requires less time: When a user is needed for a document/letter in a manual process it takes much time in writing the document or letter, but when compared to our proposed system it takes less in providing the documents/letters because we mainly use the templates. And we can get many documents at a time.

 Login Page 

Login Page

Login Page for Administrator

Administrator Page:   

Admin Page

Administrator Task 

Conclusion: 

Virtual Assistance software automatically generates a document that the user needed. It provides same document for the different people by changing the details.

System is fully GUI based. It is easy to operate and user-friendly. Platform includes the in built back-up and recovery facility. Virtual Assistance reduces paper work, equipment maintenance.

All the objectives that had been charted out in the initial phases were achieved successfully.

Future Scope:

We have done the project based on standalone system. The future scope for this project can be developed using web based application. Using this application we can enhance the project to email process .i.e., we can provide the documents on the request of users to their email address. It reduces the paper cost and time.