<!-- oracle --> <select id="searchUserBySearchName" parameterType="java.lang.String" resultType="com.urm.entity.User">select * from t_user where user_name like CONCAT('%',#{search_name},'%') </select> <!-- 或者 --> <select id="searchUserBySearchName" parameterType="java.lang.String" resultType="com.urm.entity.User">select * from t_user where user_name like '%'||#{search_name}||'%' </select><!-- m...
<!-- oracle --> <select id="searchUserBySearchName" parameterType="java.lang.String" resultType="com.urm.entity.User">select * from t_user where user_name like CONCAT(%,#{search_name},%) </select> <!-- 或者 --> <select id="searchUserBySearchName" parameterType="java.lang.String" resultType="com.urm.entity.User">select * from t_user where user_name like %||#{search_name}||% </select><!-- mysql -->...
----Mybaits调用db2存储过程<update id="changeTableName" parameterType="java.util.Map" statementType="CALLABLE">call PRO_RENAME_TABLE_CONSTRUCT(#{tableName,jdbcType=VARCHAR,mode=IN},#{tableLikeName,jdbcType=VARCHAR,mode=IN})</update><update id="createTableByLike" parameterType="java.util.Map" statementType="CALLABLE">call PRO_COPY_TABLE_CONSTRUCT(#{tableName,jdbcType=VARCHAR,mode=IN},#{tableLikeName...