JDBC-GUI_PROJECT

STUDENT MANAGEMENT SYSTEM

This is a subset of an actual Student Management System devloped using Java GUI, Core Java Concepts, JDBC Connector, and Mysql Database.

MYSQL DATABASE AND TABLE

Created a Database "student_m" on my local machine

image

FIRST FRAME("student_add_frame.java") CALLED FROM MAIN OF "start.java"

In start.java file, it contains the main function which calls student_add_frame.java, which is a JFrame class used to provide variety of features to the user

student_add_frame:

image

ADDING A STUDENT

To add a student, "add_frame.java" class collects data from user and then transfer to "studentDao.java" class which interacts with database using "connection.java" class which further uses JDBC connector to communicate with MySql DataBase .

add_frame.java:

image

In add_frame.java ,entries will be only submitted if correctly entered otherwise prompts will be given as well as for null entry After submiting correct details , a pop-up will appear whether the data is stored in database or not

entry

image

pop-up:

image

ALL STUDENT's DATA

For Presenting all the details of the students present in the database we have "students_display.java" class which implements JTable to show students details in tabular form.

image

Refresh button updates changes in data