Er_vel的博客

Mybatis 设置sql超时时间方法一：针对全局设置超时时间在application.properties里设置mybatis.configuration.default-statement-timeout = 1方法二: 针对单条sql设置超时时间在mapping.xml文件里设置<select id="getXXXX" parameterType="java.lang.String" resultMap="dataMap" timeout="1">...

1.获取单层Jsonselect * from t_pay_order_extendwhere paid_info->'$.paychannel' = 4 2.获取数组Json串select merchant_order_id,json_extract(paid_info,'$[0].paychannel') as paychannel,json_extract...