C#方法重载分辨率不选择具体的泛型覆盖(C# Method overload resolution not selecting concrete generic override)
这个完整的C#程序说明了这个问题:
public abstract class Executor<T> { public abstract void Execute(T item); } class StringExecutor : Executor<string> { public void Execute(object item) { // why does this method call back into itself instead of binding // to the more specific "string" overload. this.Execute((string)item); } public override void Execute(string item) { } } class Program { static void Main(string[] args) { object item = "value"; new StringExecutor() // stack overflow .Execute(item); } }
我碰到一个StackOverlowException,我追溯到这个调用模式,我试图将呼叫转移到更具体的重载。 令我吃惊的是,调用并没有选择更具体的重载,而是回调本身。 它显然与基本类型是通用的有关,但我不明白为什么它不会选择Execute(string)重载。
有人有任何洞察力吗?
上面的代码被简化为显示模式,实际结构有点复杂,但问题是一样的。
This complete C# program illustrates the issue:
public abstract class Executor<T> { public abstract void Execute(T item); } class StringExecutor : Executor<string> { public void Execute(object item) { // why does this method call back into itself instead of binding // to the more specific "string" overload. this.Execute((string)item); } public override void Execute(string item) { } } class Program { static void Main(string[] args) { object item = "value"; new StringExecutor() // stack overflow .Execute(item); } }
I ran into a StackOverlowException that I traced back to this call pattern where I was trying to forward calls to a more specific overload. To my surprise, the invocation was not selecting the more specific overload however, but calling back into itself. It clearly has something to do with the base type being generic, but I don't understand why it wouldn't select the Execute(string) overload.
Does anyone have any insight into this?
The above code was simplified to show the pattern, the actual structure is a bit more complicated, but the issue is the same.
原文:https://stackoverflow.com/questions/43105763
最满意答案
请参阅: http : //ca3.php.net/manual/en/mysqli.prepare.php
...[prepared statements] are not allowed for identifiers (such as table or column names)...
如果您正在为包含列名的ORDER BY子句使用
mysqli_real_escape_string
准备语句,因为您希望通过用户输入确定顺序,那么看起来您需要验证用户输入和/或使用mysqli_real_escape_string
。:)
See: http://ca3.php.net/manual/en/mysqli.prepare.php
...[prepared statements] are not allowed for identifiers (such as table or column names)...
If you're using prepared statements for the ORDER BY clause, which contains column names, because you expect the order to be determined by user input then it looks like you need to validate the user input and/or use
mysqli_real_escape_string
.:)
相关问答
更多-
请参阅: http : //ca3.php.net/manual/en/mysqli.prepare.php ...[prepared statements] are not allowed for identifiers (such as table or column names)... 如果您正在为包含列名的ORDER BY子句使用mysqli_real_escape_string准备语句,因为您希望通过用户输入确定顺序,那么看起来您需要验证用户输入和/或使用mysqli_real_escape_ ...
-
好的,假设您有3个具有相同结构的表,您希望在一个查询中将表联合在一起,并在WHERE子句中使用一个条件。 // UNION query to combine all three tables. // The union is wrapped in a subquery to apply the single WHERE clause // to the whole thing... $sql = " SELECT email FROM ( SELECT email FROM parents ...
-
代码已经过测试,现在可以使用了 首先创建表并插入记录 create table sectona_product(id int primary key auto_increment, hs varchar(100), nv varchar(80),vsa varchar(86)); insert into sectona_product(hs,nv,vsa) values('jon','gab','secunda');
是否可以将mysqli预处理语句与多个插入组合?(Is it possible to combine mysqli prepared statement with multiple inserts?)[2023-11-22]
$stmt = $mysqli->stmt_init(); if($stmt->prepare("INSERT INTO `activity` (`id`, `name`, `type`) VALUES (?, ?, ?)")) { $stmt->bind_param('iss', $_id, $_name, $_type); for($i=0;$i<$limit;$i++) { $_id = $id[$i]; $_name = $name[$i]; ...您可能会发现以下使用答案: MySql:使用.NET / Connector,使用Prepared语句调用存储过程会更快吗? 此外: GRANT只执行权限,因此您的应用程序级用户只能CALL存储过程。 这样,您的应用程序用户只能通过您的存储过程API与数据库交互,它们不能直接: select, insert, delete, update, truncate, drop, describe, show etc. 没有比这更安全。 唯一的例外是如果你在存储过程中使用了动态sql,我会不惜一切代价避免 - ...如何使用mySQLi准备语句更新多个表?(How do I update multiple tables using prepared statements with mySQLi?)[2022-11-18]
这是一个答案,所以读这个问题的人会看到它,而不是在你上面的评论中找到它。 我会标记这个CW,所以我没有得到任何积分。 UPDATE photos LEFT JOIN photographers ON photos.photographer_id = photographers.photographer_id SET photos.photo_title = ?, photographers.photographer_name = ? WHERE photos.photo_id = ? FWIW, ...是和否:有必要再次检查$field变量white-list - 这是防止sql注入的唯一方法 - 但是在$field变量上使用mysqli_real_escape_string是没有意义的。 如果您的列名是保留字或以例如数字开头,则应在反引号中引用它,但就是这样。 您仍然应该为$search变量使用mysqli_real_escape_string准备语句,尽管mysqli_real_escape_string也会这样做(而不是准备好的语句,而不是两者)。 Yes and no: It is necessa ...直接离开mysqli页面: http : //php.net/manual/en/mysqli.commit.phpMySQL准备语句混乱(MySQL Prepared statement confusion)[2023-12-27]
可能你需要的一切: class Database { private static $mysqli; 连接到DB: public static function connect(){ if (isset(self::$mysqli)){ return self::$mysqli; } self::$mysqli = new mysqli("DB_HOST", "DB_USER", "DB_PASS", "DB_NAME"); if (mysqli_c ...你应该用 mysqli_insert_id($link); 由于您在PHP手册中提到了这一说明,因此我们提到了 mysqli_stmt_insert_id 应该注意的是,使用mysqli_stmt-> insert_id不会导致为每次执行准备好的insert语句返回唯一ID。 实际上,似乎返回了第一个插入ID。 如果您使用相同的预准备语句执行多个插入(一次调用mysqli_stmt :: prepare以及对给定语句多次调用mysqli_stmt :: execute()),并且需要为每个插入保留唯一ID ...相关文章
更多- Java 重写(Override)与重载(Overload)
- Solr Cache使用介绍及分析,包括LRUCache、filterCache、queryResultCache、documentCache、Generic Caches
- 研磨设计模式之工厂方法模式(Factory Method)-模式讲解1
- 研磨设计模式之工厂方法模式(Factory Method)-模式讲解2
- 研磨设计模式之工厂方法模式(Factory Method)-场景问题
- 研磨设计模式之工厂方法模式(Factory Method)-模式讲解3
- 研磨设计模式之工厂方法模式(Factory Method)-解决方案
- 微信开发者-主动请求-准备工作-(1)发送get、post请求,上传文件(C#)
- C#微信公众平台开发者模式开启代码
- Hadoop master connection reset by peer resolution
最新问答
更多- 获取MVC 4使用的DisplayMode后缀(Get the DisplayMode Suffix being used by MVC 4)
- 如何通过引用返回对象?(How is returning an object by reference possible?)
- 矩阵如何存储在内存中?(How are matrices stored in memory?)
- 每个请求的Java新会话?(Java New Session For Each Request?)
- css:浮动div中重叠的标题h1(css: overlapping headlines h1 in floated divs)
- 无论图像如何,Caffe预测同一类(Caffe predicts same class regardless of image)
- xcode语法颜色编码解释?(xcode syntax color coding explained?)
- 在Access 2010 Runtime中使用Office 2000校对工具(Use Office 2000 proofing tools in Access 2010 Runtime)
- 从单独的Web主机将图像传输到服务器上(Getting images onto server from separate web host)
- 从旧版本复制文件并保留它们(旧/新版本)(Copy a file from old revision and keep both of them (old / new revision))
- 西安哪有PLC可控制编程的培训
- 在Entity Framework中选择基类(Select base class in Entity Framework)
- 在Android中出现错误“数据集和渲染器应该不为null,并且应该具有相同数量的系列”(Error “Dataset and renderer should be not null and should have the same number of series” in Android)
- 电脑二级VF有什么用
- Datamapper Ruby如何添加Hook方法(Datamapper Ruby How to add Hook Method)
- 金华英语角.
- 手机软件如何制作
- 用于Android webview中图像保存的上下文菜单(Context Menu for Image Saving in an Android webview)
- 注意:未定义的偏移量:PHP(Notice: Undefined offset: PHP)
- 如何读R中的大数据集[复制](How to read large dataset in R [duplicate])
- Unity 5 Heighmap与地形宽度/地形长度的分辨率关系?(Unity 5 Heighmap Resolution relationship to terrain width / terrain length?)
- 如何通知PipedOutputStream线程写入最后一个字节的PipedInputStream线程?(How to notify PipedInputStream thread that PipedOutputStream thread has written last byte?)
- python的访问器方法有哪些
- DeviceNetworkInformation:哪个是哪个?(DeviceNetworkInformation: Which is which?)
- 在Ruby中对组合进行排序(Sorting a combination in Ruby)
- 网站开发的流程?
- 使用Zend Framework 2中的JOIN sql检索数据(Retrieve data using JOIN sql in Zend Framework 2)
- 条带格式类型格式模式编号无法正常工作(Stripes format type format pattern number not working properly)
- 透明度错误IE11(Transparency bug IE11)
- linux的基本操作命令。。。