基于存储过程的计费查询统计系统设计与实现

Design and Implementation of the Accounting System for Query & Statistics Based on Stored Procedure

利用存储过程来封装数据库操作,避免了冗余代码,从而大大提高了开发效率。首先分析了存储过程的主要思想和方法,然后探讨了计费查询统计系统中运用SybaseSQLServer来进行存储过程设计的思路及编码实现,最后提出了该系统中存储过程的优化问题及扩展存储过程的应用。

By means of the stored procedure to encapsulate database operation,avoiding redundancy encoding so that developing efficiency can be greatly improved.First,this paper analyses the brief theory and method of the stored procedure.Then,it discusses design thoughtway and encoding implementation of the stored procedure by Sybase SQL Server in accounting system for query & statistics.At last,the optimize of stored procedure and application of extended stored procedure are also indicated in the system.