基于Java的通用SQL查询分析器论文.docVIP

学号: 江 苏 工 业 学 院 毕业设计（论文） （ 2007 届） 题 目： 通用SQL查询分析器 通用SQL查询分析器 摘要： 本文主要针对当前很多软件都无法实现跨数据库、跨平台来执行sql语句而用户又仅需做一些基本的增删改查操作的矛盾，设计了一个能够跨平台跨数据库的软件。此软件是一个通用SQL查询分析器，利用java语言本身的跨平台性，它能够在多种类型平台的机器中使用，并根据用户的需求选择连接本地还是远程数据库。本设计使用到的技术主要是JDBC和Swing。swing用于做图形界面，jdbc用于实现对数据库的操作。在本设计中用户既可通过命令行直接对数据库中的表进行增删改查的操作，又可通过图形界面进行简易操作，这即适用于普通的使用者也适用于有一定sql知识的用户。软件在设计上采用了MVC模式的分层思想，将显示层、控制层、modul层分开使用实现了代码的最大化重用。在图形界面方面最主要的是使用了树(JTree）和表（JTable)这两个组件。利用swing组件的MVC优势，通过构造模型并将模型装载到树或表中，实现对树和表的便捷控制。在功能上用户可以根据需要导入脚本或导出数据。在程序运行过程中能自动记录用户对数据库所做的所有操作。 关键字：SQL(sql) 查询分析器 java 跨平台 跨数据库 jdbc Abstract： This article is mainly aim at the inconsistency that many software cant span flat roof and database to execute sql statement while many ordinary user only need to do some basic operation such as insertingdeleting、altering and querying. So, I design this software that solves this problem. This software is called SQL query analyzer. With the javas characteristic of spanning flat roof, it can be used many computers which is different type. And it can be connected to local or remote database by users need. The main technology in this design is JDBC and Swing. Swing is used to make graphic interface, and jdbc is used to operate database. In this design, user not only can operate with database by inserting、deleting、altering and querying but also operate easily by graphic interface. It is suitable for ordinary user and the users with some acknowledge in sql. This software, in design, takes in the thinking of MVC model’s delamination. It realize the target of code being maximum used by detaching view layer、control layer and modul layer. In the aspect of graphic, there are two components that are JTree and JTable mainly used. With the advantages of Swing component, tree and table can be easily controlled by constructing of models and load them to tree or table. In function, users ca