1.关键字问题
** Error updating database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version**
sql语句中存在关键字冲突，注意使用规范！
2.插入数据返回主键
<insert id="submitOrder">
<selectKey keyProperty="order.o_id" order="AFTER" resultType="java.lang.Integer">
select LAST_INSERT_ID()
</selectKey>
insert into orders (username,o_username,o_tel,o_street) values(#{username},#{order.o_username},#{order.o_tel},#{order.o_street})
</insert>
可以使用bean对象的get方法获得返回主键的值
//提交订单
@Override
public int submitOrder(String username, Order order) {
orderMapper.submitOrder(username,order);
return order.getO_id();
}
