public int addFoodOrder(FoodOrder order) { String sql="insert into foodorderinfo values(?,?,?,?,?,?,?,?,?,?,?)"; int id=0; try { getConnection(); //设置prepareStatement状态 允许返回插入主键值 pState=connection.prepareStatement(sql,PreparedStatement.RETURN_GENERATED_KEYS); pState.setString(1, order.getCustomerName()); pState.setString(2, order.getAddress()); pState.setString(3, order.getZipCode()); pState.setString(4, order.getTelephone()); pState.setString(5, order.getMovePhone()); pState.setString(6, order.getEmail()); pState.setString(7, order.getIsDeliver()); pState.setString(8, order.getPay()); pState.setString(9, order.getNotice()); pState.setDouble(10, order.getTotalPrice()); pState.setObject(11, order.getOrderTime()); pState.executeUpdate(); //得到插入数据结果集主键集合 rSet=pState.getGeneratedKeys(); //得到插入数据的子增列值 if (rSet.next()) { id=rSet.getInt(1); } } catch (SQLException e) { System.out.println("插入订单出错"); e.printStackTrace(); }finally{ closeAllResource(); } return id; }