MySQL Connect Form

Computer Science

The project My SQL connect form is one of the most powerful MySQL manager and an administration tool which combines the feature of SQL browser, administrator, PHP and other MySQL front end features. It is a complete Unicode support and has table diagnostics and also has the provision of dropping a database. There is also presence of a multitab query editor and result set editor. Administer MySQL accounts as easily as a toy. Create, modify databases and visually create and edit tables, create exact copies of an existing table, within the same database or in another one. Table contents are editable in a grid, switchable columns and sorting orders. The results of various data grids are saved to HTML and XML files. It holds various filtering mechanisms. Effort has been spent on holding numerous MySQL queries as options to implement. These queries are accessed by dragging or selecting the queries from a drop down section. These components along with several easy queries are make up the GUI for of the connect form. The system also allows for creating multiple tables at once, adhering by the concurrent data property of database management. Before creating the GUI, different strategies have been formulated and analysis of alternative solution strategies were compared. The final GUI is the simplified version of all its predecessors. Java is the primary language used for creating the GUI. Several in-built Java functions have made the formation of this connect form easier. Although user-defined functions are used to maintain the integrity of our application.

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.