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

This article will explain in detail how to pass multiple parameters in mapper. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

How to pass multiple parameters in mapper

Method 1: sequential parameter transfer method

Public User selectUser (String name, int deptId); select * from user where user_name = # {0} and dept_id = # {1}

The numbers in # {} represent the order in which the parameters are passed.

This method is not recommended, the SQL layer expression is not intuitive, and it is easy to make mistakes once the order is adjusted.

Methods 2:@Param annotated parameter transfer method

Public User selectUser (@ Param ("userName") String name, int @ Param ("deptId") deptId; select * from user where user_name = # {userName} and dept_id = # {deptId}

The name in # {} corresponds to the name decorated in parentheses in the annotation @ Param.

This method is relatively intuitive in the case of few parameters, and it is recommended to use.

Methods 3:Map transmission parameter method

Public User selectUser (Map params); select * from user where user_name = # {userName} and dept_id = # {deptId}

The name in # {} corresponds to the key name in Map.

This method is suitable for transferring multiple parameters, and the parameters are changeable and can be transferred flexibly.

Methods 4:Java Bean transmission parameter method

Public User selectUser (User user); select * from user where user_name = # {userName} and dept_id = # {deptId}

The name in # {} corresponds to the member attribute in the User class.

This method is intuitive, needs to build an entity class, is not easy to expand, needs to add attributes, but the readability of the code is strong, business logic processing is convenient, and it is recommended to use.

This is the end of this article on "how to pass multiple parameters in mapper". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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.