Mybatis小问题

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();
    }