java sql SQLException Column Index out of range 0 1

分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.csdn.net/jiangjunshow

也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！

               

1、错误描述

java.sql.SQLException:Column Index out of range,0<1

2、错误原因

try { Class.forName("com.mysql.jdbc.Driver"); Connection conn = null; Statement stat = null; ResultSet rs = null; try  {  conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/school", "root", "root");  stat = conn.createStatement();  rs = stat.executeQuery(" select * from teacher ");  while(rs.next())  {   System.out.println(rs.getInt(0)+"-----"+rs.getString(1)+"-----"+rs.getInt(2)+"-----"+rs.getString(3));  } }  catch (SQLException e)  {  e.printStackTrace(); }   } catch (ClassNotFoundException e) { e.printStackTrace();}

由于rs.next()遍历查询结果时，下标是从“1”开始，而这里打印是从“0”开始，导致出错

3、解决办法

    将遍历打印“System.out.println(rs.getInt(0)+"-----"+rs.getString(1)+"-----"+rs.getInt(2)+"-----"+rs.getString(3));”修改为“System.out.println(rs.getInt(1)+"-----"+rs.getString(2)+"-----"+rs.getInt(3)+"-----"+rs.getString(4));”

           

给我老师的人工智能教程打call！http://blog.csdn.net/jiangjunshow