[attachment=12977]
SQL EDITOR 9i
OVERVIEW
Universal SQL Editor is a powerful, yet easy-to-use database query tool.
It allows you connect Oracle, DB2, SQL Server , JSP and other ODBC compliant databases, and edit complex SQL code, highlight references, parameter hinting, syntax highlighting, SQL formatting, plus other useful features that allow you to work more efficiently.
Fast and low memory consumption.
Objects in database explorer will be updated automatically after execution of statements.
INTRODUCTION
The project is an extension of existing SQL editor that users get to see while installing the oracle ( edition 8,9i).
SQL editor is a code editor and explorer for SQL server databases.
SQL editor gives the developer an immediate in into a complex or unfamiliar database by providing the sortest and most intuitive path from “ wanting to knowing ” to “ knowing “.
It helps you to understand the relationships and dependencies between objects.
SYSTEM REQUIREMENT
Min. Hardware Environment
Intel Pentium 4 processor (1.7 GHz).
512 Megabyte of RAM.
40 GB Hard drive.
Min. Software Environment
Microsoft® Windows™ 98 and Above.
Adobe® Dreamweaver Enterprise Edition 8.
Oracle® 9i.
Web server (Tomcat™ from Apache®).
Any web browser.
FREATURE OF SQL
SQL stands for Structured Query Language. SQL lets you
access and manipulate databases. SQL is an ANSI (American National Standards Institute) standard.
SQL can execute queries against a database.
SQL can retrieve data from a database.
SQL can insert records in a database.
SQL can update records in a database.
SQL can delete records from a database’
SQL can create new databases.
SQL can create new tables in a database.
SQL can set permissions on tables, procedures.
WHY JSP
Java Server Pages (JSP) technology enables Web developers and designers to rapidly develope and easily maintain, information-rich, dynamic Web pages that leverage existing business systems.
As part of the Java technology family, JSP technology enables rapid development of Web-based applications that are platform independent.
We can use JSP technology without learning how to write Java Scriplets . Although scriptlets are no longer required to generate dynamic content, they are still supported to provide backward compatibility.
Java tag library developers and designers can extend the JSP language with "simple tag handlers," which utilize a new, much simpler and cleaner, tag extension AP.
DEVELOPEMENTAL PROCESS
These standards steps are to be followed while creating Visual Basic Programs:
Deciding what your application does by creating an overall design.
Creating the JSP and HTML portion of the application (the serene and menus that the users will interact with)
Adding the JSP programming language code to tie the HTML elements together and to automate the program.
Testing the application to locate and remove any bugs.
SYSTEM DESING
SDLC (System Development Life Cycle)
A structured sequence of phases for implementing an information system is system design life cycle of that system.
The various steps involved in the system design life cycle.
Feasibility Study.
System Analysis.
System Requirement.
System Design.
Implementation.
Software Development Life Cycle
IMPLEMENTATION
Input & Output Consideration :
Welcome to ‘ORACLE DATABASE EDITOR’ The ORACLE DATABASE EDITOR handles all kinds of SQL operations. It uses JSP and HTML as a front end & ORACLE 9i as a back end . With the help of this ORACLE DATABASE EDITOR the user can create tables, perform select, update, alter, drop, delete operations etc.
MAIN WINDOW
This is the main window of ‘ORACLE DATABASE EDITOR’. From here you can perform all the operations.
Main window
Create Table Window
Table Format Window
Execute Query Window
Error Window
FUTURE DEVELOPEMENT
As per users requirement our whole program is designed. we are also trying to make this project for online use, so that customer can execute SQL statements directly through the internet.
CONCLUSION
As per the result of a proper analysis on the component that we have developed, it can be safely concluded that the product is highly efficient, user friendly and can meet clients demand.