100分的解析SQL条件题

Question

楼主请把上面的语句转换成一棵树形(我指的是平常看到的树)--你的那几个括号已经帮你分的很明显了.

Answer 1

<!-- SQL条件：where (not ((((id=33 or id=99) or (data ~2006-05%))) and (id>10 and id<20)) and id!=6)-->
解析后的XML树：
<?xml version="1.0" encoding="UTF-8"?>
<root>
<not>
        <and>
                <or>
                        <or>
                        <等于>
                        <字段名>id</字段名>
                        <值>33</值>
                        </等于>
                        <等于>
                        <字段名>id</字段名>
                        <值>99</值>
                        </等于>
                        </or>
                        <or>
                                <like>
                                <字段名>data</字段名>
                                <值>2006-05%</值>
                                </like>
                        </or>
                </or>
                <and>
                        <and>
                        <大于>
                        <字段名>id</字段名>
                        <值>10</值>
                        </大于>
                        <小于>
                        <字段名>id</字段名>
                        <值>20</值>
                        </小于>
                        </and>
                </and>
        </and>
</not>
<and>
<不等于>
<字段名>id</字段名>
<值>6</值>
</不等于>
</and>
</root>