⏹Mapper
public interface TestMapper30 {
List<I18MessageEnttiy> selectMessageByItem(String item);
}
concat('%', #{模糊查询的参数}, '%')
<select id="selectMessageByItem" parameterType="String" resultType="com.example.jmw.entity.I18MessageEnttiy">
SELECT
code
, locale
, item
FROM
i18message
WHERE
item LIKE concat('%', #{item}, '%');
</select>
⏹Entity
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder
public class I18MessageEnttiy {
private String code;
private String locale;
private String item;
}
⏹数据库
⏹查询效果