General Database Query System

General Database Query System is a web application that allows users to easily query and view data from a database. It provides a user-friendly interface that makes it easy for non-technical users to access and analyze data.

Features

• Connect to a variety of databases, including MySQL, PostgreSQL, Oracle, and Microsoft SQL Server
• Execute SQL queries with syntax highlighting and auto-completion
• View query results in a table or as raw data
• Download query results as CSV or Excel files
• Save and share queries with other users
• Manage database connections and query history

Requirements

• Java Development Kit (JDK) 15 or higher
• Apache Tomcat 9 or higher

Installation

1. Clone the repository

   git clone https://github.com/xingnan88/GeneralDatabaseQuerySystem.git

2. Build the project using a build tool such as Apache Maven or IntelliJ IDEA
3. Deploy the .war file generated by the build tool to your Apache Tomcat server
4. Edit the config.properties file in the conf directory to configure the database connection parameters

Usage

1. Open your web browser and go to http://localhost:8080/GeneralDatabaseQuerySystem/
2. You will be directed to the login page
3. Login using the default username and password: admin / password
4. Once logged in, you will be directed to the dashboard
5. Click on "New Query" to create a new SQL query
6. Select the database you want to query and enter your SQL code
7. Click on "Execute" to execute the query and view the results

Technology Stack

• Java Server Pages (JSP)
• Java Servlets
• Java Database Connectivity (JDBC)
• MySQL / PostgreSQL / Oracle / Microsoft SQL Server
• Apache Tomcat

License

This project is licensed under the MIT License. See the LICENSE file for details.

Credits

• Xingnan Ji (https://github.com/xingnan88) - Developer
• Icons made by Freepik from www.flaticon.com