摘 要
计算机诞生以来,对数据的管理一直是计算机应用中最为重要的环节,数据库管理系统便是这一环节中坚力量。在.NET平台推出以后,由于其通用语言基础结构和规范性,让不同语言开发的程序员们都能得心应手地在.NET平台下进行高效的程序开发,ADO.NET框架对数据库管理系统的访问控制是相当的灵活和方便,减少了程序员们操作数据库底层代码,让程序员的精力完全集中到逻辑代码开发之中。因此,采用.NET平台开发管理信息系统是一个明智的选择。
某店积分更新记录管理前台采用.NET,后台采用SQL 2000,语言使用C#。实现的系统功能是对用户消费和追加的积分进行更新,并对积分变化进行记录。程序模块读取临时积分表,通过返回临时积分表的数据对积分表,用户状态表,积分奖励记录表进行更新,并对积分累积记录表进行更新,系统着重于对更新失败和程序异常时进行处理。
关键词:计算机应用;数据库管理系统;积分更新记录;.NET平台;ADO.NET;C#;SQL2000
The Shop’s Integral Update Record Management
Abstract
Data management is always the most important link of the computer’s application, since the invention of the computer, and the database management system is a very important in this link. After the .NET was launched, for its common language structure and standard, programmers of all languages carry on the procedure high effectively under the .NET platform. The structure of ADO.NET give a flexible and suitable manage to the access control of database management system, this reduce the chance of operating lower layer code, and make programmer pay more attention to logical code development. Therefore it is wise to choice the .NET platform to development management information.
.NET is used as onstage,SQL 2000 is used as backstage and C# is used as developing language in the Integral to update records management. The function of system is to update the integral of consuming and producing, and carries on the record of the integral changing information. When the program module read the temporary integral table, it updated the integral table, the user condition table, the integral reward data sheet through returns the data of temporary integral table. This system pay more attention to dealing with update failure and procedure exceptionally when carried on processing.