Question

mybatis 中，用${}怎么写入动态标签

sMap.put("userLoginname", userName);
String sql = " select * from sys_user_ext where 1 = 1 and user_name = #{userLoginname} ";
sMap.put("infomap",sql);
这样可以
但是加了动态标签就不行了
String sql = " select * from sys_user_ext <where> 1 = 1 and user_name = #{userLoginname} </where>";
如果这里查询条件需要动态判断

xml里面配置
<select id="list" parameterType="map" resultMap="SysUserExtMap" >
${infomap}
</select>

Answer 1

必须确认在执行这条指令时MySQL服务器必须没有启动