将变量赋给新生成的ID
本文关键字:ID 新生 变量 | 更新日期: 2023-09-27 17:51:21
我在我的新项目中运行这个查询:
dbClient.setQuery("INSERT INTO `rooms` (`roomtype`, `caption`, `owner`, `description`, `category`, `state`, `users_now`, `users_max`, `model_name`, `public_ccts`, `score`, `tags`, `icon_bg`, `icon_fg`, `icon_items`, `password`, `wallpaper`, `floor`, `landscape`, `allow_pets`, `allow_pets_eat`, `allow_walkthrough`, `allow_hidewall`, `wallthick`, `floorthick`, `achievement`, `group_id`, `game_id`, `mute_settings`, `ban_settings`, `kick_settings`) VALUES " +
"('private', 'VIP CADEAU: Penthouse', @username, 'Ontvang deze kamer GRATIS bij het lid worden van VIP (http://wonderhotel.nl/vip).', 11, 'open', 0, 25, 'model_i', '', 1, '', 1, 0, '', '', '0.0', '0.0', '0.0', '1', '0', '0', '0', -2, -2, 0, 0, 0, '0', '1', '1');");
dbClient.addParameter("username", Session.GetHabbo().Username);
dbClient.runQuery();
但是现在,我想从这个查询中获得新生成的'id' (= NULL
),并为它分配一个参数,以便在下面的查询中使用它作为@newid
:
dbClient.setQuery("INSERT INTO `items` (`user_id`, `room_id`, `base_item`, `extra_data`, `x`, `y`, `z`, `rot`, `wall_pos`, `rareid`) VALUES " +
"(@id, @newid, 99036, '0', 6, 6, 0.0002, 0, '', 0);");
dbClient.addParameter("id", Session.GetHabbo().Id);
dbClient.runQuery();
如何将第一个查询生成的值赋给@newid?这个解决方案在我看来是合乎逻辑的,但它不起作用:
dbClient.addParameter("roomid", dbClient.setQuery("LAST_INSERT_ID();");
错误:http://puu.sh/7GmCI/f5b6794d02.png
谢谢你的帮助!
@Tewr
dbClient.setQuery("INSERT INTO `rooms` (`id`, `roomtype`, `caption`, `owner`, `description`, `category`, `state`, `users_now`, `users_max`, `model_name`, `public_ccts`, `score`, `tags`, `icon_bg`, `icon_fg`, `icon_items`, `password`, `wallpaper`, `floor`, `landscape`, `allow_pets`, `allow_pets_eat`, `allow_walkthrough`, `allow_hidewall`, `wallthick`, `floorthick`, `achievement`, `group_id`, `game_id`, `mute_settings`, `ban_settings`, `kick_settings`) VALUES " +
"(NULL, 'private', 'VIP CADEAU: Penthouse', @username, 'Ontvang deze kamer GRATIS bij het lid worden van VIP (http://wonderhotel.nl/vip).', 11, 'open', 0, 25, 'model_i', '', 1, '', 1, 0, '', '', '0.0', '0.0', '0.0', '1', '0', '0', '0', -2, -2, 0, 0, 0, '0', '1', '1');");
dbClient.addParameter("username", Session.GetHabbo().Username);
dbClient.setQuery("SELECT LAST_INSERT_ID();");
dbClient.runQuery();
dbClient.addParameter("roomid", dbClient.getRow()[0].ToString());
之后,接下来的代码使用了我们之前定义的@roomid。
dbClient.setQuery("INSERT INTO `items` (`user_id`, `room_id`, `base_item`, `extra_data`, `x`, `y`, `z`, `rot`, `wall_pos`, `rareid`) VALUES " +
"(@id, @roomid, 99036, '0', 6, 6, 0.0002, 0, '', 0);");
dbClient.addParameter("id", Session.GetHabbo().Id);
dbClient.runQuery();
但是这会导致一个错误,说@roomid没有定义。
你的编译错误和你现有的代码给出了一些线索:
这一行不能编译,因为您在末尾缺少一个括号,并且setQuery()没有返回值:
dbClient.addParameter("roomid", dbClient.setQuery("LAST_INSERT_ID();");
用
代替dbClient.setQuery("SELECT LAST_INSERT_ID();")
dbClient.runQuery();
dbClient.addParameter("roomid", dbClient.getRow()[0].ToString());
现在你的代码中的这一行正在编译,这并不能保证它会工作…看起来您的代码应该已经工作在第一位。确保您的表正确地配置了AUTO_INCREMENT。