# SqlResolver

**Repository Path**: heyang78/sql-resolver

## Basic Information

- **Project Name**: SqlResolver
- **Description**: 使用Java编制，基于Swing的SQL解析工具。能解析查询语句，按编译原理分解出其中的字段、表、条件等，形成抽象语法树，并据此将sql整理成层次分明、排列清晰的形式。
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 3
- **Forks**: 1
- **Created**: 2021-09-01
- **Last Updated**: 2024-09-23

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

#SqlResolver
软件功能：解析查询语句，按编译原理分解出其中的字段、表、条件等，形成抽象语法树，并据此将sql整理成层次分明、排列清晰的形式。
比如，原始SQL为：
select c.customer_id,count(o.order_id) as orders_ct from oe.customers c left join oe.orders o on c.customer_id=o.customer_id where c.gender='f' group by c.customer_id having count(o.order_id)>4 order by orders_ct,c.customer_id
整形后：
select
    c.customer_id,
    count(o.order_id) as orders_ct
from
    oe.customers c left join 
    oe.orders o
on
    c.customer_id = o.customer_id
where
    c.gender = 'f'
group by
    c.customer_id
having
    count(o.order_id) > 4
order by
    orders_ct,
    c.customer_id