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

標籤：java   mysql   jdbc   

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

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