java.sql.SQLException:Column Index out of range,01

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));”

，都可以…孔子的,老子的. 孙子的…都可以