An input parameter is used to make a query flexible, so that the parameters may not be hard coded in a bean class. This enables a user to input parameters in a query. An input parameter is designated by a question mark (?) followed by an integer. The following rules apply to the input parameter in the EJB query language:
- An input parameter must be numbered using integer values starting from 1.
- The number of input parameters in the WHERE clause must be less than or equal to the number of parameters in the corresponding finder or select method.
- An input parameter can be used only in the WHERE clause and not in a SELECT or FROM clause.
- An input parameter in the WHERE clause must match the type of the parameter in the finder or select method.
Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.