SQL生成器的设计与实现

编写复杂的SQL语句既耗费时间又容易出错,出现了许多SQL生成工具.现有的SQL生成工具大多缺乏完善的错误检测功能和良好的可扩展性.在吸收现有SQL生成工具优点的基础上设计了Select_SQL_Builder系统,它基于SQL92标准,实现了复杂的查询语句.系统对SQL语句进行了完整性、重复性和类型匹配等检查,并且把函数、表达式和条件作为对象,便于显示、修改、检查和生成SQL语句.同时经过简单的修改,系统能适应不同的数据库和增加更新语句、删除语句等功能.

Design and implementation of SQL builder

Writing complicated SQL statement needs lots of time and is easy to make mistakes.So many SQL builders are designed,but some of which have no ability of mistake-checking and good extensibility.Select_SQL_Builder is designed on the basis of the ad-vantage of existing SQL builders,which is based on SQL92 standards and the most complicated select statement can be realized.The integrity,repeatability and type matching of SQL statement are checked via the system.In order to display,modify,check and build SQL statement,function,expression and condition are defined as object.Furthermore,the change database is changed easy,delete statement and update statement are realized with a little modification.