Shulou(Shulou.com)06/01 Report--

# means that precompilation is used to prevent sql injection. And $is not.

Use # to default the passed parameter to a string. While $will not, whatever is passed in is what is passed in.

$is generally used to pass in database objects, such as table names.

If you pass in a Date type, use #.

Ps: also encountered in the use of mybatis, statements within this symbol will not be treated as strings, but directly as sql statements, such as to execute a stored procedure.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.