package com.lenovo.
ofp.
order.throwengine.dao;
imp
ort com.lenovo.
ofp.
order.domain.throwengine.domain.PaymentMessageVo;
imp
ort
org.apache.ibatis.annotations.Delete;
imp
ort
org.apache.ibatis.annotations.Param;
imp
ort
org.apache.ibatis.annotations.Select;
imp
ort
org.apache.ibatis.annotations.Update;
imp
ort java.util.List;
/**
* @Auth
or: zengdy1
* @Date: 2025
-09
-16 17:50
*/
public interface PaymentJob
Mapper {
@Select({
"<script>",
"SELECT * FROM
ordercommon.t_payment_message",
"WHERE process_status = 0",
"AND message_type IN",
"<f
oreach collection='messageTypes' item='messageType' open='(' separat
or=',' close=')'>",
"#{messageType}",
"</f
oreach>",
"AND create_time > (CURRENT_DATE
- INTERVAL '${limit} day')",
"</script>"
})
List<PaymentMessageVo> getPaymentMessageByType(@Param("messageType") List<Integer> messageType, @Param("limit") Integer limit);
@Update({
"<script>",
"UPDATE
ordercommon.t_payment_message",
"SET process_status = 1",
"WHERE id IN",
"<f
oreach collection='paymentMessageList' item='item' index='index' open='(' separat
or=',' close=')'>",
"#{item.id}",
"</f
oreach>",
"</script>"
})
void batchUpdateProcessStatus(@Param("paymentMessageList") List<PaymentMessageVo> authNotifyList);//实现这个批量更新sql
@Delete({
"<script>",
"DELETE FROM
ordercommon.t_payment_message where process_status = 1 AND create_time < (CURRENT_DATE
- INTERVAL '${limit} day') ",
"</script>"
})
Integer batchDelete( @Param("limit") Integer limit);
List<PaymentMessageVo> getPaymentMessageByType(int limit);
}
结合这个类 分析这个错误
org.springframew
ork.beans.fact
ory.UnsatisfiedDependencyException: Err
or creating bean with name 'paymentMessageJob': Unsatisfied dependency expressed through field '
orderPayment
Mapper': Err
or creating bean with name 'throwPaymentJob
Mapper' defined in URL [jar:file:/app/lib/
order
-async
-throw
-1.0.3
-SNAPSHOT.jar!/com/lenovo/
ofp/
order/throwengine/dao/PaymentJob
Mapper.class]:
org.apache.ibatis.builder.BuilderException: Err
or creating document instance. Cause:
org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 95;
The content of elements must consist of well-formed character data or markup.
at
org.springframew
ork.beans.fact
ory.annotation.AutowiredAnnotationBeanPostProcess
or$AutowiredFieldElement.resolveFieldValue(AutowiredA
本文解决了在mapper文件中添加SQL语句时遇到的符号解析问题，详细介绍了如何正确使用CDATA来包裹动态SQL语句中的特殊字符，避免XML解析错误。
扫一扫
310
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
