title: How to use check duplicate record in beanshell and the database is using Heidi SQL
body: <p>I have face some issue for the requirement that stated that the user can only order one order on that day. I am using beanshell and my database is HeidiSQL. How can I scan the database and find is there any duplication of the record? such as i thinking of using date and UserID to check the duplication in the record. What can I use? Is there any sample code or solution about this?</p>