如何将mybatis全局配置文件改写为支持长尾词查询的？

本文共计464个文字，预计阅读时间需要2分钟。

MyBatis全局配置文件 + DAO层XML映射文件 + 插入语句

xml INSERT INTO tb_allorders (buy_personid, receive_person, receive_phone, receive_address, state, ispay) VALUES (#{buyPersonid}, #{receivePerson}, #{receivePhone}, #{receiveAddress}, #{state}, #{ispay})

mybatis全局配置文件

DAO层xml映射文件

insert into tb_allorders (buy_personid,receive_person,receive_phone,receive_address,state,ispay) values (#{buyPersonid},#{receivePerson},#{receivePhone},#{receiveAddress},#{state},#{ispay}) select * from tb_allorders where orders_id=#{ordersId} select count(orders_id) from tb_allorders update tb_allorders set state = #{state} where orders_id = #{ordersId} select * from (select tb_allorders.* , rownum rn from tb_allorders where rownum <= #{endIndex})temp where temp.rn >#{startIndex} order by orders_id desc select * from tb_allorders orders_id = #{ordersId} and buy_personid = #{buyPersonid} select tall.*,t.* from tb_allorders tall left join tb_order t on tall.orders_id = t.orders_id