- SELECT
- *
- FROM
- z_user
- WHERE
- <if test = "name != null and name != ''" >
- AND name LIKE
- <if test = "dbName == 'oracle'" >
- '%' || #{name}||'%'
- </if>
- <if test = "dbName == 'sqlServer'" >
- '%' + #{name}+'%'
- </if>
- <if test = "dbName == 'mySql'" >
- concat('%',#{name},'%')
- </if>
- </if >
终极解决sqlserver、MySQL、Oracle三种数据库模糊查询语句,ssm框架mybatis操作数据库
最新推荐文章于 2024-03-14 20:16:53 发布