MyBatis console print out SQL execution result is empty but put SQL to MySQL execute have data

The SQL in MyBatis is as follows

That's what I'm asking for. Parameter:/airportflight/findairportflight/?iata= ' WDS ' adds a quotation mark to the argument

Then MyBatis use # to pass in parameters, SQL statement parsing is added "", as a string to parse the equivalent of my SQL into a

Select Airln_cd airlncd,city_coordinate_j citycoordinatej,city_coordinate_w citycoordinatewfrom airportinfonew where Iata= "' WDS '"

So I'm sure I can't find the data.

The correct approach is to change the request to/airportflight/findairportflight/?iata=wds

1. #将传入的数据都当成一个字符串, a double quotation mark is added to the automatically passed data. For example: ORDER by #user_id #, if the value passed in is 111, then the value parsed into SQL is Order by "111", and if the value passed in is an ID, then the parsed SQL is the ORDER by "id".

　　
2. $ direct display of incoming data is generated in SQL. For example: ORDER by $user _id$, if the value passed in is 111, then the value to parse to SQL is Order by user_id, and if the value passed in is ID, the parsed SQL is the order by ID.
　　
3. #方式能够很大程度防止sql注入.
　　
The 4.$ method does not prevent SQL injection.

The 5.$ method is typically used to pass in database objects, such as incoming table names.
6. Do not use the $ in general. MyBatis sorting when using the order by dynamic parameter requires attention, with $ instead of #

MyBatis console print out SQL execution result is empty but put SQL to MySQL execute have data