新宋體摘 要
百貨店是生活中不可缺少的一部分，為了給顧客提供更方便的服務平臺以及更好的服務質量，而設計了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
