`
dky_rl
  • 浏览: 67803 次
  • 性别: Icon_minigender_1
  • 来自: 黑龙江
社区版块
存档分类
最新评论

Column Index out of range

阅读更多

java.sql.SQLException: Column Index out of range, 0 > 11.

索引列超出范围

例如:

  SELECT   CardID,name     你只是查询这2个字段的值  
  但是你却用了rs.getString(3)     最多也就rs.getString(2)

分享到:
评论
3 楼 funnyone 2012-10-21  
[/b][b][/b][b]
2 楼 funnyone 2012-10-21  
引用
引用
引用
引用
引用
引用
1 楼 谭亮辉 2011-06-23  
查出来一条,我却用了rs.getString(0)

相关推荐

    CGridCtrl的InsertColumn函数数组越界中断异常解决办法.rar

    然而,在实际编程过程中,我们可能会遇到一些问题,比如在这个案例中提到的“vector subscript out of range”异常,这通常发生在尝试访问数组或容器(如std::vector)中不存在的元素时。对于CGridCtrl中的`...

    微软内部资料-SQL性能优化5

    However, if we are searching for multiple rows, such as duplicate values, or keys in a range, anything more than a small number of rows will make the nonclustered index search very inefficient. ...

    ans-matchers:rspec 匹配器扩展

    have_out_of_range_validation have_association_db_index have_executable_sql have_out_of_range_validation “对导致 sql 级别超出范围的值进行验证错误” describe Model do it { expect ( Model ) . to ...

    Array-Out-of-Bound-Example.rar_limit

    这个"Array-Out-of-Bound-Example.rar_limit"示例旨在演示当访问数组元素超出其内存分配范围时会发生什么。在C#中,数组是一种特殊类型的对象,它们在内存中连续存储相同类型的数据,具有固定的大小和索引范围。 1....

    .net导出word,word表格打印,设置word单元格两种颜色,.net导出报表word版,.net word操作

    Word.Range textRange = table.Cell(rowIndex, columnIndex).Range; textRange.Font.Color = Word.WdColor.wdColorBlack; ``` 4. **.NET导出报表Word版**: 在报表生成场景下,可能需要根据数据动态创建表格。...

    微软内部资料-SQL性能优化3

    However, the req_mode column of master.dbo.syslockinfo has lock mode code that is one less than the code values shown here. For example, value of req_mode = 3 represents the Shared lock mode rather ...

    Dundas.Chart.for.Winform.Enterprise.v7.1.0.1812.for.VS2008

    Chart .NET: Stacked Column + 3D throws an Index was out of range exception when series have a different number of data points The accumulation distribution formula is incorrect; if open and close are ...

    UE(官方下载)

    Need to restrict your search/replace to a specific column range? The column based search does just that... Compare Highlighted Text If you need to quickly compare of portions of text, rather than an ...

    Swift 3.0基础学习之下标

    assert(indexIsValid(row: row, column: column), "Index out of range") return grid[(row * columns) + column] } set { assert(indexIsValid(row: row, column: column), "Index out of range") grid[(row ...

    OutlookAttachView v2.73

    o Added 'Domain' column, which displays the domain of the from/to email address. * Version 2.25 o Added 'Message Direction' column (Incoming or Outgoing). * Version 2.20 o Added 'From Email' and...

    TMS Pack for FireMonkey2.3.0.1

    Fixed : Issue with index out of bounds in empty grid connected to dataset v2.1.0.1 Improved : NextPage and PreviousPage methods in TTMSFMXGrid Fixed : Issue compiling demo's in trial version ...

    大牛总结 MySql常见错误集锦

    6. 错误1264: Out of range value for column 类似地,当插入的数据超出了列的允许范围(如浮点数或日期时间格式),会触发此错误。修改插入的数据以适应列的定义。 7. 错误1136: Column count doesn't match value...

    Mysql查询优化器[文].pdf

    system(系统表)、const(常量表)、eq_ref(唯一或主键索引并使用'=')、ref(索引使用'=')、ref_or_null(索引使用'='且可能为NULL)、range(使用BETWEEN、IN、>=、LIKE等的索引)、index(索引全扫描)和ALL...

    本人整理的Oracle一些文档

    如`CREATE TABLE table_name (column1, column2) PARTITION BY RANGE (column1) (PARTITION part1 VALUES LESS THAN (100), PARTITION part2 VALUES LESS THAN (200))`。 11. **备份与恢复**:Oracle提供物理备份...

    C# Excel 填参并打印

    例如,`Cells[rowIndex, columnIndex] = "数据"`可以将字符串写入指定位置。 - 使用`Range`对象,可以一次性写入多行或多列数据。例如,`Range["A1:C5"].Value = dataArray`可将二维数组填入指定范围。 4. **操作...

    FastReport.v4.15 for.Delphi.BCB.Full.Source企业版含ClientServer中文修正版支持D4-XE5

    - fixed bug with truncate of font size combo-box in Windows Vista/7 in designer (lost of vertical scroll bar) - fixed bug when lost file name in inherited report - fixed bug in multi-page report with ...

    EurekaLog_7.5.0.0_Enterprise

    9)....Added: EMemLeaks._ReserveOutOfMemory to control reserve size of out of memory errors (default is 50 Mb) 10)..Added: "MinLeaksLimitObjs" option (EMemLeaks unit) 11)..Added: Fatal memory problem ...

    oracle常用语句

    - **索引**:提高查询速度,如`CREATE INDEX index_name ON table_name(column_name);` - **视图**:虚拟表,如`CREATE VIEW view_name AS SELECT ... FROM ...;` - **存储过程**:可重用的代码单元,如`CREATE ...

    【电气工控自动化】8 个 Python 高效数据分析的技巧.docx

    对于给定的列表 `x = [1,2,3,4]`,传统方式是通过 for 循环来创建新的列表,如 `out = []`,然后遍历 `x` 对每个元素应用操作。但是,你可以使用一行代码完成,比如将列表元素都乘以2:`double_list = [x * 2 for x ...

Global site tag (gtag.js) - Google Analytics