为什么会出现java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]无效的描述符索引?
String sql="SELECT station_id,station_name from t_station";
Connection con = null;
PreparedStatement stat = null;
ArrayList infos = new ArrayList();
ResultSet rs = null;
try{
con = Utility.getConnection();
stat = con.prepareStatement(sql);
rs = stat.executeQuery();
while (rs.next()) {
StationInfoBO info = new StationInfoBO();
// System.out.println("station_id:" + rs.getString("STATION_ID"));
//System.out.println("station_name:" + rs.getString("station_name"));
//这里可以打印出station_id和station_name的值,但执行到下一步就取不到值了
String station_id=rs.getString("station_id");////执行到这一步的时候就出现java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]无效的描述符索引??
这是为什么??WATCH里看到的值:"expression" rs.getString("station_id") = <Exception occurred in target VM>
String station_name=rs.getString("station_name");
info.setStation_id(station_id);
info.setStation_name(station_name);
infos.add(info);
}
}catch (Exception e) {
e.printStackTrace();
infos = null;
}
查了很多类似的问题,都说是取数据的时候要按照数据库字段的顺序来取,但我已经是按顺序来取了,为什么还会出现这种问题呢??请各位高手指点一下,谢谢!
而改用jdbc的方法却怎么也联不起来,不知道为什么??
//jdbc连接数据库:
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url =
"jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=students";
con = DriverManager.getConnection(url,"sa","");
//通过jdbc-odbc连接数据库
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:students";
con =DriverManager.getConnection(url, "sa", "");