Closed

School Management System

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.

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

First step is download ORACLE DATABASE 10g EXPRESS, then install it on your pc.

Create a user with Username: sms & Password: sms.

download this project from the given link in this post.

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\[url removed, login to view] for database, then lib\[url removed, login to view] and lib\[url removed, login to view] for look and feel. The reference problem should be resolved.

In database there is no schema named sms. To create the schema you should run schoolmanagementsystem\[url removed, login to view] file. After running [url removed, login to view] schema named sms should be created automatically. Now the database schema is ready to store data.

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.

[url removed, login to view] 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.

[url removed, login to view] you can see the Home page.

How to connect database

Function connectdba() of [url removed, login to view] 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.

1String url = "jdbc:oracle:thin:@localhost:1521:XE";

con = [url removed, login to view](url, "sms", "sms");

2String url = "jdbc:oracle:thin:@localhost:1521:XE";

con = [url removed, login to view](url, "sms", "sms");

Source Code Description

[url removed, login to view] is the starting point of this project.

[url removed, login to view] play important role. All events is handled in this class and manipulate different portion of UI.

Others classes hold UI layout and design.

[url removed, login to view] is responsible to interact with database. All data transactions between UI and database are coded in this class.

Warning

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.

Skills: Engineering, Java, MySQL, PHP, Software Architecture

See more: school management system free, school management system open source, school management system php, school management system software, school management system pdf, school management system codecanyon, school management system demo, school management system wordpress, school management system php, school management system java, school management system project overview, school management system presentation, example web school management system, language school management system, school management system project, web school management system, top school management system, dot net school management system source code, background school management system, project report school management system

About the Employer:
( 0 reviews ) DELHI SOUTH, India

Project ID: #16018778

26 freelancers are bidding on average ₹26429 for this job

bchandra1955

Professional software development Engineer with experience in design and development Relevant Skills and Experience Pls attach the requirements

₹20000 INR in 45 days
(64 Reviews)
5.9
₹27777 INR in 10 days
(47 Reviews)
5.1
Mangal01

I am a programmer as i have 7+ years of working experience in Magento 1.9/2.0, php,mysql,ajax, jquery, javascript, css, html,Codeigniter, Graphics Design. I am a Developer with a team of developers and designers. I ha More

₹30000 INR in 4 days
(23 Reviews)
4.2
panjvirsingh

I would like to offer myself as a probable candidate for this assignment as I am confident of delivering a quality output. I have excellent expertise in this area. I have total 7 years or experience in web developme More

₹27777 INR in 10 days
(18 Reviews)
4.0
YonTech

Hello Relevant project is ready with me. Even SMS gateway is also implemented in my project. I would like to do your project. I have 3+ year experience in Java. I can do your project in your budget and time. I have r More

₹22222 INR in 12 days
(9 Reviews)
3.9
choksihemang4

Hello, This is really nice concept you're working on. We would like to help you in this dream project if you can assign project to us. We are team of java professionals having experience of 6-7 years in web develop More

₹38500 INR in 30 days
(2 Reviews)
3.1
akankshakhare06

We having 6+ yrs experience in Android and IOS application development, feature enhancement, bug fixing and debugging in Android, Java. Known for writing efficient, maintainable and reusable code that preserves privac More

₹27777 INR in 10 days
(2 Reviews)
3.1
AMancer

hello i'm a java developer and also web developer . i make my web apps using angular for the front end and nodejs for the back end i invite you to discuss more on chat thank you in advance.

₹27777 INR in 10 days
(4 Reviews)
2.6
₹22222 INR in 3 days
(9 Reviews)
2.6
NadirBelhadj

hi, I've already worked on similar projects in my university ( I'm computer science student). I can develop your project in time. contact me to discuss the details

₹22222 INR in 10 days
(2 Reviews)
0.4
yashwantchavan

A proposal has not yet been provided

₹22222 INR in 25 days
(0 Reviews)
0.0
₹27777 INR in 12 days
(0 Reviews)
0.0
rk586

A proposal has not yet been provided

₹27777 INR in 45 days
(0 Reviews)
0.0
₹27777 INR in 10 days
(0 Reviews)
0.0
₹27777 INR in 10 days
(1 Review)
0.0
₹27777 INR in 10 days
(0 Reviews)
0.0
LakshmiKowsi26

I am very much interested in this BN project. share me the cod. I will complete in 7 days surely.

₹16666 INR in 7 days
(0 Reviews)
0.0
₹27777 INR in 10 days
(0 Reviews)
0.0
sahadmohammed96

We can complete your project fully flexible and with short amount of time with less budget

₹22222 INR in 30 days
(0 Reviews)
0.0
parashuram24

A proposal has not yet been provided

₹26666 INR in 10 days
(0 Reviews)
0.0