What is the way to judge the type of mybatis parameter String and Integer

This article mainly introduces the relevant knowledge of "what is the way to judge mybatis parameters String and Integer type". The editor shows you the operation process through an actual case. The operation method is simple, fast and practical. I hope this article "what is the way to judge the String and Integer types of mybatis parameters" can help you solve the problem.

The judgement of String and Integer types

When mybatis writes update, it is normal for update operation to take place only after the value of set.

We usually write SAMPLE_BATCH_NO = # {sampleBatchNo,jdbcType=VARCHAR} like this

1. The String type is consistent, but if it is an Integer type, mybatis will also recognize the value of iComple0 as an empty string.

So if it is Integer type, you only need to judge! = null.

2. If the String type needs to be judged to be not equal to 0, you need to write sampleBatchNo! = '0'.toString (), otherwise an error will be reported.

Use tags to determine Integer type pits

Previously, I only knew that if it was an Integer type, it would be good to decide whether to pass a parameter or not, because 0 would be considered equal to the empty character''.

Unexpectedly, there is another problem. Note that the second condition above uses a single equal sign.

At this time, no matter what value you req.type passes (0, null, negative), or even if you don't pass this attribute, the condition will be met.

Then I changed it to =, and everything went back to normal.

This is the end of the content about "what is the way to judge the String and Integer types of mybatis parameters". Thank you for reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.