School Management System in NetBeans(Must see)

종료 등록 시간: 6년 전 착불
종료 착불

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\[login to view URL] for database, then lib\[login to view URL] and lib\[login to view URL] 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\[login to view URL] file. After running [login to view URL] 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.

[login to view URL] 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.

[login to view URL] you can see the Home page.

How to connect database

Function connectdba() of [login to view URL] 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 = [login to view URL](url, "sms", "sms");

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

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

Source Code Description

[login to view URL] is the starting point of this project.

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

Others classes hold UI layout and design.

[login to view URL] 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.

공학 자바 MySQL PHP 소프트웨어 아키텍처

프로젝트 ID: #13735189

프로젝트 소개

15 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 6년 전

이 일자리에 대한 프리랜서 15 명의 평균 입찰가: $2050

yassine008

Good day! I`m expert Java Dev with more than +7 years in It area. I have a success career in web/soft development using cutting edge Tech with latest frameworks in Java. Best Regards

$1666 USD (35일 이내)
(44 리뷰)
7.1
king18yat

In the bid amount , I can provide the website version , android application , ios application with one year support . I am available on all days to discuss and shall provide 2 work updates per week ( Tuesday and Frid 기타

$1500 USD (33일 이내)
(27 리뷰)
6.0
sunwebsystem

I have already school management system if you want then I can show this software using teamviewer Hello, Hope you are doing well..............! I saw your job posted that I can handle because I have already wor 기타

$2500 USD (30일 이내)
(22 리뷰)
4.9
WebApp4expert

Hello, Greetings This is konika We are with extensive experience and have Skilled experts 15 Professionals around. We dedicate Team for any project as per the size of the Project. We are expertise in Mobile a 기타

$1500 USD (30일 이내)
(3 리뷰)
2.8
infocentroidtech

Hi, Kindly watch my latest review regarding java's project. I have more then 10 years of experienced in java, i did lots of work on Swing,AWT, JDBC, servlet, JSP, Spring. we are Currently working this type project. 기타

$1666 USD (30일 이내)
(21 리뷰)
3.7