Home > All, Source Code > School Management system in Java using oracle database

School Management system in Java using oracle database

Most of the peoples are familiar with the School Management System(SMS). SMS can be developed as a web application or a desktop application. I developed this project as desktop application to complete my database assignment. This project is now in alpha version and has many bugs. But it can help novice students to complete their database assignment and also get knolege about

  • How to connect Oracle 1og express database with java.
  • How Store in database, fetch from database, process and manipulate those data using Java.
  • How to configure Oracle 1og express database with NetBeans IDE 6.8.
  • How to add any .jar file with any project using NetBeans IDE.

Click here to download this project


SMS is developed in Java using database Oracle 10g express in NetBeans IDE. Workable Features of this project is given bellow:

  • Add, edit, remove student
  • Students profile
  • Add or remove class
  • Add or remove section
  • Marks entry
  • Generate mark-sheet
  • Advance search option which is able to search by student name, class, section, exam marks.
  • Changeable theams

How to configure School Management System

  1. First step is download ORACLE DATABASE 10g EXPRESS, then install it on your pc.
  2. Create a user with Username:  sms & Password: sms.
  3. download this project from the given link in this post.
  4. Now open this project in NetBeans IDE. This time SMS project have some reference problem. To solve this problem we have to add few .jar files with this project SMS. this .jar files are located at lib folder of the project folder. Now add lib\ojdbc6.jar for database, then lib\JTattoo.jar and lib\liquidlnf.jar for look and feel. The reference problem should be resolved.
  5. In database there is no schema named sms. To create the schema you should run schoolmanagementsystem\Initializetion.java file. After running Initializetion.java schema named sms should be created automatically. Now the database schema is ready to store data.
  6. Now run this project you should see (Figure 1) view. There should be four options. This options are not workable so that you can  choose any one from those options ie. Admin.

    Figure 1

    Figure 1

  7. After choosing one option you should view Login face (figure 2). there is no user name and password and no authorization process. this Login button is dam-mi  so you can just click Login button to view the home page.

    Figure 2

    Figure 2

  8. Now you can see the Home page (figure 3).

    Figure 3

How to connect database

Function connectdba() of SelectAndInsertData.java is responsible for connecting database. I used

  • database URL : jdbc:oracle:thin:@localhost:1521:XE
  • username         : sms
  • password          : sms

connection URL description should be found oracle tutorial.

String url = "jdbc:oracle:thin:@localhost:1521:XE";
con = DriverManager.getConnection(url, "sms", "sms");

Source Code Description

  • Main.java is the starting point of this project.
  • MainFrame.java play important role. All events is handled in this class and manipulate different portion of UI.
  • Others classes hold UI layout and design.
  • SelectAndInsertData.java is responsible to interact with database. All data transactions between UI and database are coded in this class.

This slideshow requires JavaScript.


In this project I used Regular Expression query function in normal search and advance search option to simplify the query string. But it does not work properly for every environment. I dont know why this problem occured and how to solve it. Still now i cant resolve this problem. So if this search query does not work properly you should change the query string without using regular expression query function.

Categories: All, Source Code
  1. Narsing
    July 18, 2012 at 5:01 pm

    Excellent job Hasib, if possible please provide the complete working project because the downloadable project is incomplete and most of the options are not working especially toolbar options.

    • July 19, 2012 at 4:01 am

      Thanks Narsing and sorry to publish incomplete project. Actually it was my Database project when i m a student, at that time i had no enough knowledge on object oriented java, design pattern, and working with Oracle database. As a professional i should say that this project is now in alpha version, cause this project has many bugs and incomplete functionality. For my professional activities i could not give much time in this project but i will try to spend my few time to Upgrade this project.

  2. PM
    July 19, 2012 at 8:47 am

    Does your system also do fess receivables (billing) and balances?

    • September 3, 2012 at 8:05 am

      No it doesn’t.

  3. Ahmed
    August 21, 2012 at 11:26 am

    Hasib, great job, could if have chance publish the complete source i already read your answer at last comment but if you have a few time to re complete the project will be helpful for us, thanks for share.

  4. September 3, 2012 at 6:31 am

    MyClassboard’s school management system is the trusted choice of school administrators across India and in African countries. Founded over six years ago, our school management software is designed to meet the needs of all types of schools, colleges and universities from elementary to post-secondary to the masters.

  5. Matthew Kankhulungo
    January 11, 2013 at 9:16 am

    please e-mail me this project at kankhulungo.265@gmail.com

  6. Tushar
    February 22, 2013 at 4:53 pm

    Hey how can i run your project? when I run it, it just seems that JTatto version is 1.4.0. nothing much.. How can I run this can you please guide me?

  7. sekartaji
    March 3, 2013 at 1:48 pm

    You can give me database of this aplication,ser?
    I can’t access it…
    good job for you…

  8. March 25, 2013 at 5:37 pm

    Awesome issues here. I’m very satisfied to peer your article. Thank you a lot and I’m having a look forward
    to touch you. Will you please drop me a mail?

  9. March 29, 2013 at 11:25 am

    It is not my first time to go to see this website, i
    am browsing this web page dailly and obtain nice information
    from here all the time.

  10. Sharif
    May 17, 2013 at 5:25 am

    provided rar file don’t have build folder. Please provide it. It will be possible to run then.

    Thank you.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: