, and great spirit; Big brother sisters,, want to ask like this set of two parameters for a query conditions; How to change this for loop into in XML; Thank you very much, thank you very much

CodePudding user response:

Reference under the
Under the changes themselves
https://blog.csdn.net/weixin_43689040/article/details/84717412

CodePudding user response:

I this is a corresponding a fixTyperId areaId, this is a query condition,,,, have more than one such parameters, I wrote in the XML how to write, how foreach, foreach separately if not

CodePudding user response:

You mean a SQL but the value of a field corresponding to multiple fixTyperId? Direct use in combining foreach tag line
https://blog.csdn.net/qq_29072049/article/details/81384795

CodePudding user response:

This is a corresponding a fixTyperId areaId, fish a result, the pair, and a lot of to

CodePudding user response:

Rather it should be called multiple times mapper method is executed multiple times over the SQL in the select tag specified in good parameterType
Then write in the tag # {queryMap. AreaId}
For example,
Select * from xx where areaId=# # {queryMap. AreaId} and fixTypeId={queryMap. FixTypeId}


Ps: how wrong I feel this problem.. Good simple

CodePudding user response:

You this is just a pair of values,,,, I said is much value to the

CodePudding user response:

refer to 6th floor weixin_45302192 response:

you this is just a pair of values,,,, I said is of more value

, and how to use in value