Analytic MyBatis method of continuously passing multiple parameters _java

MyBatis is an excellent persistence layer framework that supports common SQL queries, stored procedures, and advanced mappings. MyBatis eliminates the manual setting of almost all JDBC code and parameters and the retrieval encapsulation of the result set. MyBatis can use simple XML or annotations for configuration and raw mappings, mapping interfaces and Java Pojo (Plain old Java Objects, normal Java objects) to records in the database.

Here is a brief introduction to the MyBatis method of continuously passing multiple parameters. The specific code looks like this:

Order by sort 
//<![ cdata[value]]> filter symbol
//${} method causes SQL injection
//#{} resolves a placeholder
<![ cdata[ORDER by ${parameter 1} ${parameter 2}]]>

Example:

Sql:select * from A where a.id=#{id}
Id=hello

Analytical:

SELECT * from A where a.id=?

Sql:select * from A where a.id=#{id}
Id=hello

Analytical:

SELECT * FROM A where A.id=hello

The above is a small set to introduce mybatis continuous transmission of multiple parameters of the method, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!