1.SQL语句之间使用分号“;”来分割;
例如:
<insert id="addPurchase" parameterType="com.itcast.crm.pojo.Product">
insert into purchase(id,purchasenum,purchasedate) values(#{id},#{purchasenum},#{purchasedate});
update productdetail set num=num+#{purchasenum} where id=#{id};
</insert>
2.在连接数据库的url中写上:
allowMultiQueries=true
例如:
jdbc.url=jdbc:mysql://localhost:3306/finaltest?characterEncoding=utf-8&allowMultiQueries=true