插入一条记录后，马上得到新插入记录ID值的方法

jgiCmd.CommandText = "insert into productVariant (productId, isDefault, ImageFileNameOverride) values (" & id & ", 1, '" & rd("web_image") & "'); select @@identity id"
                    strReturnValue += jgiCmd.CommandText & vbLf
                    jgiCmd.Connection = jgiCn
                    jgiCn.Open()
                    idProductVariant = jgiCmd.ExecuteScalar()