本論文提出一個手搖茶飲的生產履歷系統,此系統可以讓使用者透過茶飲杯上的QR(Quick Response)碼標籤貼紙,來了解茶飲的詳細原料資訊。本論文之貢獻主要是將MySQL與Hbase資料庫做整合,並且與Android應用程式做連結,讓資料庫的資訊可以更加的多元化。 本論文使用QR碼,利用Android系統的智慧型裝置的相機搭配自行開發的應用程式去擷取QR碼影像,並進行辨識出茶飲的產品編號與產品購買時間。透過手機無線網路連結到外部資料庫MySQL,再利用辨識出的產品編號,對應資料庫中各種原料的無線射頻辨識標籤碼,去查詢茶飲的進貨原料資訊,並回傳到智慧型手機或平板電腦上。消費者如果想做更進一步查詢,還可以點擊原料名稱,就會顯示進貨廠商與製作時間資訊。為了使製作過程更加透明化,讓消費者對於產品更加放心,本系統還可以利用QR碼中,辨識出的購買時間去雲端影像伺服器中,調出茶飲購買時的記錄片段,讓消費者可以看到茶飲製作過程影片,藉此達到生產透明化。而在資料庫的部份我們還可以使用雲端技術的Hbase資料庫,讓Android應用程式不只是可以擷取Mysql資料庫中的資料,還能夠將雲端技術Hadoop的資料庫Hbase中的資料擷取出來做更便利的使用。
This study proposed a production resume system for hand-shaken tea drinks. This system enables users to know the detailed information of materials tea drinks from the QRcode paster on the tea cups. The contribution of this thesis is to do the integration of MySQL and Hbase database, and link to the Android application. it’s can be more diversified in our Database information. The camera of an intelligent device with Android system was used to capture the QRcode image to identify the identification of product and the buying time of tea drinks. The mobile phone was connected to the external database MySQL via wireless network, and the RFID of the materials in tea drinks will be inquired. Beside according to the identified QRcode of the product, the RFID(Radio Frequency IDentification) code of the materials in tea drinks will be inquired and the collected data will also be transmitted to the manufacturing time. In order to make the manufacturing process more transparent for consumer protection, this system can call out the recorded video of tea drink from the cloud video server according to the identified buying time, so that the consumers can see the video of the tea drink manufacturing process.