Mybatis多個參數連續傳遞，mybatis多個傳遞

Mybatis多個參數連續傳遞，mybatis多個傳遞

// order by 排序 

//<![CDATA[ 值 ]]> 過濾符號

//${}方式會引發SQL注入

//#{} 解析的是占位符

<![CDATA[ order by ${參數1} ${參數2} ]]>

例子：

SQL:select * from A where A.id=#{id}

id=hello

解析:select * from A where A.id=?

SQL:select * from A where A.id=#{id}

id=hello

解析:select * from A where A.id=hello