Sql Workbench

SQL WORKBENCH A PROJECT REPORT Submitted by

V.RAJU In partial fulfillment for the award of the degree Of

BACHELOR OF TECHNOLOGY IN COMPUTER SCIENCE & ENGINEERING AT

TIRUMALA ENGINEERING COLLEGE (Jawaharlal Nehru technological University) Approved by AICTE, India BOGARAM - R.R. Dist. Sepemteber,2009

DECLARATION I hereby declare that the project entitled “SQL WORK BENCH” submitted for the B.Tech Degree is my original work and the project has not formed the basis for the award of any degree, associate ship, fellowship or any other similar titles.

Signature of the Student: Place: Date:

CERTIFICATE

This is to certify that the project entitled “SQL WORK BENCH” is the bonafide work carried out by V.Raju student of B.Tech, Tirumala Engineering College, Bogaram, Keesar (M), A.P, during the year 2009, in partial fulfillment of the requirements for the award of the Degree of Bachelor of Computer Science and Engineering and that the project has not formed the basis for the award previously of any degree, diploma, associate ship, fellowship or any other similar title.

Signature & Name of the Guide:

H.O.D‘s Signature

Place:

Professor T.V.Narayana

Rao. Date:

Head, Dept. of C.S.E

ABSTRACT SQL Work Bench is a GUI SQL client written in 100% Java. SQL Work Bench can communicate with any database that has a JDBC driver. It should run anywhere Java

runs. I use it on Linux and Windows 2000 Professional with Oracle's 100% Java JDBC driver. SQL Work Bench acts like a universal database client which can connect to any database and perform any required operations on that database.SQL Work Bench runs each query in a separate thread so the GUI remains alive while a query is running. SQL Work Bench has got a simple tabbed pane where provision for connecting to any database is available. Its File->Configure feature helps to specify the database name to which a connection is needed. Once connected to the database using Query option, we can execute any statement on the database. SQL Work Bench is versatile in such a way it can connect to any database, execute any query and show the results in the same window, create multiple connections to multiple databases, the executed set of commands can be saved in a SQL file and can be later retrieved and run. This is useful to perform repeated tasks, open multiple SQL files in multiple windows. File option has sub options like: New, Open, Save, Close, Configure options. These are all highly useful to perform various tasks on files and configuring the databases. Edit option has cut, copy, paste options. Query option has commit, rollback and execute options. After a set of commands are executed, we can save the changes permanently to a database using commit. To cancel the affect of earlier changes, by using rollback. There is cancel option to cancel a query and type a new one. Save document option is very helpful to save a set of given commands as a file. This file can be later on retrieved and executed. When this file is executed, all those commands will be one by one executed. This is useful for the people who want to repeatedly perform certain tasks. Once the task related commands are stored in a file like this, he/she can execute them whenever they want.SQL Work Bench also allows us to export the data to .csv file by using specified delimiters. Further we can use that .csv file to import that same data to any database.

Hardware Specifications: Processor Memory Hard Disk CD-ROM Display Card

Pentium 1GHz 256 MB RAM 40 GB 52X SVGA

Software Specifications: Operating System Technologies

Windows 2000 prof or XP J2SE, JFC –Swing and

Back End Parser Documentation

XML Any Database SAX Parser MS word 2003

TABLE OF CONTENTS Description 1. INTRODUCTION

page no 1

1.1 Project Overview/ Problem Description

2

1.2 Literature Survey

3

2. SYSTEM STUDY AND ANALYSIS

15

2.1 Existing System

16

2.2 Proposed System

17

2.3 Hardware Specification

19

2.4 Software Specification

19

2.5 Feasibility Study

19

3. SYSTEM DESIGN

21

3.1 Database Design

23

3.2 UML Diagrams

26

4. IMPLEMENTATION

33

5. TESTING

56

6. CONCLUSION

59

7. BIBLIOGRAPHY

61

LIST OF FIGURES Description

page no

1. Figure 1. Class diagram

26

2. Figure 2. Class diagram for connection management

27

3. Figure 3. Class diagram for query management

28

4. Figure 4. Use Case diagram

29

5. Figure 5. Sequence diagram for connection management

30

6. Figure 6. Sequence diagram for query management

31

7. Figure 7. Activity diagram

32

8. Screen 1. Main Page

36

9. Screen 2. Creating a connection to the database

37

10. Screen 3. Selecting a NEW button

38

11. Screen 4. Giving details about the Oracle Connection

39

12. Screen 5: Selecting the OracleConnection

40

13. Screen 6: Inserting values into the table

41

14. Screen 7: Retrieving the details from the table

42

15. Screen 8: Deleting the details from the table

43

16. Screen 9: Saving the queries in one.sql file

44

17. Screen 10: Exporting the queries

45

18. Screen 11: Giving the output file format

46

19. Screen 12: Displaying the message as exported 3 rows

47

20. Screen 13: Displaying the exported details in MSExcel

48

21. Screen 14: Giving details about the MySQL Connection

49

22. Screen 15: Selecting the MySQLConnection

50

23. Screen 16: creating a table with name Student in MSaccess

51

24. Screen 17: Giving details about the MSAccess Connection

52

25. Screen 18: Selecting the MSAccess Connection

53

26. Screen 19: Inserting the values into Student table

54

27. Screen 20: Retrieving the details from the table

55