基于List集合的多条件查询优化算法研究

在数据库应用程序的研发过程中,经常涉及到对数据表的任意字段进行任意形式的组合查询,这样可以大大缩小查询范围,这就是多条件查询。文章首先对多条件查询的常用方法予以介绍,包括枚举法、递进法;最后笔者给出防止注入攻击的基于List集合的多条件查询优化算法。同时,为了提高性能,避免产生垃圾内存,SQL语句都使用StringBuilder类来创建字符串实例进行拼接,文中的代码均在VS2008平台下运行通过。

Research on multi-conditional query optimization algorithms based on List Set

The development of database application programs often involves any form of combination query of any field of the data table, which can greatly reduce the query range. And that is called multi-conditional query. This paper first introduces the commonly used methods of multi-conditional query, including enumeration method and progressive method. Finally, the author gives the multi- conditional query optimization algorithm based on List Set to prevent injection attack. At the same time, in order to improve the performance and avoid producing waste memory, SQL sentence uses StringBuilder class to create a string instance and the codes in the text run through the VS2008 platform.