# DataStealer

**Repository Path**: yangsp45/DataStealer

## Basic Information

- **Project Name**: DataStealer
- **Description**: DataStealer是一个内置的网页数据库管理工具。项目集成了DataStealer的依赖后，无需任何配置，就可以查看所连接的数据库以及执行SQL语句，为开发人员提供了一种简单便携的查询数据的途径。
- **Primary Language**: Java
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 2
- **Created**: 2020-11-23
- **Last Updated**: 2020-12-20

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# DataStealer

## Description
DataStealer is a built-in web database management tool. After the project integrates the dependency of DataStealer, you can view the connected database data and execute SQL statements with a simple configuration, providing developers with a simple and fast way to query and process data.

## Software architecture
Built on Spring Boot Web, running on Tomcat container, not relying on ORM framework, supporting Mysql and Oracle.

## Configuration instructions
### Integrates dependency
```XML
<dependency>
    <groupId>org.datastealer</groupId>
    <artifactId>datastealer-spring-boot-starter</artifactId>
    <version>0.0.1</version>
</dependency>
```

### Parameter configuration
| parameter | meaning | default |
| :-----| :---- | :---- |
| datastealer.enable | Whether to enable | false |
| datastealer.dbType | Database type | mysql |
| datastealer.logQuery | Whether to query through log records | false |
| datastealer.newTomcatPortEnable | Whether to enable the new port (only supports Spring Boot 1.X) | false |
| datastealer.newTomcatPort | New port | 2020 |

## Instructions for use
### Enable DataStealer
```
#If you want to enable DataStealer, add the system configuration as follows：
datastealer.enable=true
```

### Configure database type
```
#Currently only supports mysql and oralce, the default is mysql, if it is another database, please add the corresponding configuration：
datastealer.dbType=oralce
```

## Custom query configuration
For different versions of databases, users can customize the SQL configuration to be compatible with the currently used database。
```
#If you add the following configuration in the configuration file, you can override the SQL statement querying the schema：
datastealer.mysql.schema.query=SELECT \
  TABLE_SCHEMA AS schemaName \
  FROM INFORMATION_SCHEMA.TABLES \
  GROUP BY TABLE_SCHEMA
```

## Participate in contribution
1.[Arthur Meng](https://github.com/Arthur-Meng)