mysql - 如何在准备好的语句中将此值添加为查询？

Question

Public void aMethod(String itemName, String theUsersName){  

preparedStatement = conn.prepareStatement("INSERT INTO items  (Owner_ID, Name, State)               VALUES         (?,?,?) ");
preparedStatement.setString(1, "(SELECT id FROM users WHERE username     = ' "+theUsersName+"')");
preparedStatement.setString(2, itemName); 
preparedStatement.setString(3, state);
preparedStatement.executeUpdate();

}

用户名表包含用户名和ID在这里，我得到了 theUsersName 并想找到该用户名的 ID，以设置 Item 表中新项目的 Owner_ID = theUsername 的 ID。

Answer 1

如果它没有抛出异常，请尝试一下，(否则我将删除它)

String query =  "INSERT INTO items  (Owner_ID, Name, State) " +
                "SELECT ID, ? AS Name, ? AS State " +
                "FROM   users " +
                "WHERE  userName = ? " 
preparedStatement = conn.prepareStatement(query);
preparedStatement.setString(1, itemName);
preparedStatement.setString(2, state); 
preparedStatement.setString(3, theUsersName);
preparedStatement.executeUpdate();