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
Add or remove class
Add or remove section
Advance search option which is able to search by student name, class, section, exam marks.
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.
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.
Bu iş için 26 freelancer ortalamada $2141 teklif veriyor
Dear Sir, I'm quite interested by your project. I am programmer with sincere and capable. I can provide to you to the best cheap prices the best results. If you had interest for my proposal, please contact Daha Fazla
Dear Sir, We are having many development experience in Java and MySQL, We have experience in various technologies such as barcodes, RFID, FingerPrint Scanners, Touch Screens, Poll bars, Cash Drawers, Different Kind of Daha Fazla
The key strengths that I possess for success in this position include, but are not limited to, the following: - I have successfully designed, developed, and supported live use applications. - Strive for continued Daha Fazla
Hi! I have checked your requirement carefully. I am a expert of WebSite development and mobile apps. I am an iOS/Android software expert with rich experience. I have built several successful iOS/android games: si Daha Fazla
Hello, sir. I have enough experience for your task. I can do your project successfully. I want to work with you. Thanks. Regards.
Sir, i can work with java android PHP MYSQL HTML5 wordpress jquery bootstrap. I can do your work and can communicate with ease. So if you give me an opportunity to work with you i will be thankful to you.
ILM Tech .Pvt .Ltd. URBAN TECH Metrix Tower, Noida Sec. 132, India. Skyp=[login to view URL] [login to view URL] Welcome to Information Logical Method Technology Pvt. Ltd. clients ranging from Indian business giants to Daha Fazla
e have readily available Campus Management ERP solution which is suitable for your requirement, which is developed on Asp.Net MVC3 with MSSQL DB. Please download presentation of SimplifyCampus https://www.dropbox. Daha Fazla
Hello. I've got more then 10 years of Oracle and 5 years of Java development. Tasks for project are clear for me so I think that I can make this work faster. Best regards, Vyacheslav.
We are an enthusiastic team of professionals with variety of skills in building websites and android applications. Experience of people in our group vary from 3 years to 18 years across Core PHP, Zend, CakePHP, WordPre Daha Fazla
Hello I have made a similar project using the mysql database. If you want i can deliver a demo for each step of your prject starting the next Monday. Best Regards,
i agree i''ll complete your work . I understand ur requirement completely and i have already done such kind of project .
I have a skill on database that u [login to view URL] Sql ,Oracle Database on IDE netbeans Offer me a opportunity to enhance my skill thank you
Hi, This is Vivek Mishra, I have done Master’s in Computer Science and MS in consultancy Management. I have 10+ years of development experience using Java technologies like, Struts1.3, Servlet, JSP, SpringMVC, Hibernat Daha Fazla