基于SQL的多条件选择智能实现算法

SQL-Based Multi-condition Selection Intelligent Algorithm Realization

在进行B／S项目开发过程中，经常会遇到按照用户的选择进行数据库查询语句构造的问题，但是由于对于具备n个条件的二元组合而言，其组合数为2n，代表编程要实现2n个条件判断，提高了逻辑的复杂性，代码也十分冗长。本文就针对基于SQL的多条件选择智能实现算法展开讨论，以提高编程效率。

During B/S project development process,often encountered by the user the choice to construct a database query problem,but because of the conditions for a binary with a combination of n,its number of combinations is 2n, on behalf of program 2n condition to achieve the judge increased the complexity of the logic,code is also very long.In this paper, the conditions for the SQL-hased multi-choose smart algorithm to discuss,in order to improve programming efficiency.