'无效的描述符索引'解决方法

[Microsoft][ODBC SQL Server Driver]无效的描述符索引 

一般出现这个问题是查询语句写为

select * from table_a

改为

select col_1,col_2,col_3 from table_a

 然后在相应的java代码里写

System.out.println(rs.getString(1);//col_1

System.out.println(rs.getString(2);//col_2

System.out.println(rs.getString(3);//col_3

注意:

1.第一列从1开始记数;

2.使用的顺序跟上面检索的顺序一致;

3.此处的1,2,3不要加引号

4.当然也可以改为rs.getString("col_1")

附ResultSet

String getString(int columnIndex) throws SQLException;

Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

Parameters:

columnIndex the first column is 1, the second is 2, ...

Returns:

the column value; if the value is SQL NULL, the value returned is null

Throws:

SQLException if a database access error occurs

String getString(String columnName) throws SQLException;

Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

Parameters:

columnName the SQL name of the column

Returns:

the column value; if the value is SQL NULL, the value returned is null

Throws:

SQLException if a database access error occurs