斯卡拉anorm检索插入的ID(Scala anorm retrieve inserted id)

斯卡拉anorm检索插入的ID(Scala anorm retrieve inserted id)

我有一个id为id字段的autoid表。 用anorm插入一行后，我想检索生成的id。 任何想法？

SQL( """ insert into accom (id,places,lat,lon,permaname,country,defaultLanguage) values ( {places}, {lat}, {lon}, {permaname}, {country}, {defaultLanguage} ) """).on( 'id -> id, 'places -> places, 'lat -> lat, 'lon -> lon, 'permaname -> permaname, 'country -> country, 'defaultLanguage -> defaultLanguage).executeUpdate() }

I have a table with autoid for the id field. After inserting a row with anorm I'd like to retrieve the generated id. Any idea?

SQL( """ insert into accom (id,places,lat,lon,permaname,country,defaultLanguage) values ( {places}, {lat}, {lon}, {permaname}, {country}, {defaultLanguage} ) """).on( 'id -> id, 'places -> places, 'lat -> lat, 'lon -> lon, 'permaname -> permaname, 'country -> country, 'defaultLanguage -> defaultLanguage).executeUpdate() }

最满意答案

在最新版本中，你需要一个标量：

val newId = SQL( """ insert into accom (places,lat,lon,permaname,country,defaultLanguage) values ({places}, {lat}, {lon}, {permaname}, {country}, {defaultLanguage}) """).on( 'places -> places, 'lat -> lat, 'lon -> lon, 'permaname -> permaname, 'country -> country, 'defaultLanguage -> defaultLanguage).executeInsert(scalar[Long].single)

In the latest version you need a scalar:

val newId = SQL( """ insert into accom (places,lat,lon,permaname,country,defaultLanguage) values ({places}, {lat}, {lon}, {permaname}, {country}, {defaultLanguage}) """).on( 'places -> places, 'lat -> lat, 'lon -> lon, 'permaname -> permaname, 'country -> country, 'defaultLanguage -> defaultLanguage).executeInsert(scalar[Long].single)