久久最新,欧美1—12sexvideos,日本亚洲欧美

mybatis like %%問題

				?

									<select id="getMaxNotOnlineInfoByConditon" resultType="com.shishike.susie.entity.CustomConfirmInfo">

									SELECT *

									FROM t_customconfirminfo

									WHERE (if(#{pduName,jdbcType=VARCHAR} IS NULL, 0 = 0, pduname = #{pduName,jdbcType=VARCHAR})

									   AND if(#{moduleName,jdbcType=VARCHAR} IS NULL, 0 = 0, modulename = #{moduleName,jdbcType=VARCHAR})

									   AND if(#{env,jdbcType=VARCHAR} IS NULL, 0 = 0, confirminfo = #{env,jdbcType=VARCHAR})

									   AND if(#{ossAddress,jdbcType=VARCHAR} IS NULL, 0 = 0, ossaddress = #{ossAddress,jdbcType=VARCHAR})

									   AND if(#{branch,jdbcType=VARCHAR} IS NULL, 0 = 0,  branch like concat(concat('%',#{branch,jdbcType=VARCHAR}),'%'))

									   AND if(#{confirmId,jdbcType=BIGINT} IS NULL, 0 = 0, id > #{confirmId,jdbcType=BIGINT})

									   AND onlineinfo is null)

									ORDER BY CREATED DESC

									LIMIT 1

									</select>

mybatis 關于like的處理

1、利用"%"對入參進行拼接

2、SQL語句字符串拼接

				?

									SELECT * FROM tableName WHERE name LIKE CONCAT(CONCAT('%', #{text}), '%');

3、bind標簽

				?

									<select id="findUserByFuzzyEmail" resultMap="BaseResultMap"

									        parameterType="java.lang.String">

									        select id,username,email,status,createtime,updatetime from tb_user

									        <bind name="pattern" value="'%'+_parameter.getEmail() +'%'" />

									        <where>

									            <if test="email != null and email != ''">

									                email like #{pattern}

									            </if>

									        </where>

									    </select>