新宋体摘 要
百货店是生活中不可缺少的一部分，为了给顾客提供更方便的服务平台以及更好的服务质量，而设计了POS积分管理系统。百货店通过点积分的管理获得顾客更好的信誉，增加客户流量，获得更多的利益。在百货店经营的过程中，每天的交易次数成千上万，所以，对顾客使用积分卡信息的查询是很重要的。根据这一点，设计了积分更新生成及通票回收处理的功能。积分点更新生成是指，将顾客交易情况生成更新查询文件；通票回收处理是指，对一定时间后没有使用过的通票进行回收处理以及保存相关信息。涉及到的技术主要是对文件的读和写操作、对数据库的查询和插入以及简单计算编程等等。是基于日文操作系统Windows 2000，采用Java开发语言，并使用SQL server 2000数据库，JDBC驱动器来完成积分点更新生成以及通票回收处理的功能。
关键字: POS积分管理；百货店；积分点；更新生成；通票回收处理
An Integral Management of POS System for A Department Store—Integral Point Generation Update and Coupon Recycling
Abstract
Department store is an essential part in our lives. In order to provide the more convenient service platforms and better service qualities with customers, the POS integral management system is designed. Through this integral management the department store obtains a better prestige from customers, attracts more consumers and gains more benefits. For the customers, the searching of information of the used integral card is very important because of the large number of transaction every day. According to this point, the integral update document generation and coupon recycling functions are designed. Integral Point Generation Update is to make the information of customer transactions into inquiring updated document and Coupon Recycling is to recycle the un-used coupon after a certain period of time and preserve relevant information. The technology involved is mainly concerned with the reading and writing of documents, the inquiring and inserting of the database, simple calculation programming and so on. The system is based on the Windows 2000 of Japanese, developed though JAVA, with SQL server 2000 as the database, JDBC as the driver.
Key words: Integral management of POS; Department store; Integral point; Generation update; Coupon recycling
