Abstract:How to analyse the potential value of a customer is a problem that cannot be neglected while the e-commerce is becoming more and more mature. Aiming at solving this problem, the paper designs and implements a visual query system, which is used for analysing customers' preference and digging their potential value. Based on the SSH framework, this system uses Highcharts to do the data visualization at the front-end, while the database of products is established via the web parser and the database of user-expense behavior extracted from the campus's traffic is established via DPI. This system reaches the expected target for data analysis and is good for shopping preference analysis after testing.