java.sql.SQLException:Column Index out of range,0<1
来源:互联网 发布:淘宝买近视眼镜靠谱吗 编辑:程序博客网 时间:2024/05/16 17:43
public static void main(String[] args) { Connection conn = null; ResultSet rs = null; try { Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost:3306/demo"; String user = "root"; String password = "root"; conn = DriverManager.getConnection(url,user,password); rs = conn.createStatement().executeQuery("select * from emp"); //获得列数 int len = rs.getMetaData().getColumnCount(); System.out.println(len); while(rs.next()){//遍历行 //遍历列 for(int i=0; i<len; i++){ System.out.print(rs.getString(i)); if(i<len){ System.out.print(", "); } } System.out.println();//换行 } } catch (ClassNotFoundException | SQLException e) { e.printStackTrace(); }finally{ try { if(rs!=null) rs.close(); if(conn!=null) conn.close(); } catch (SQLException e) { e.printStackTrace(); } } }
由于rs.next()遍历查询结果时,下标是从“1”开始,而这里循环打印是从“0”开始,导致出错
修改方法:
阅读全文
0 0
- java.sql.SQLException:Column Index out of range,0<1
- java.sql.SQLException:Column Index out of range,0<1
- java.sql.SQLException: Column Index out of range, 2 > 1.
- java.sql.SQLException: Column Index out of range, 2 > 1.
- java.sql.SQLException: Parameter index out of range (0 < 1 )
- java.sql.SQLException: Parameter index out of range (0 < 1 ).
- java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
- Mybatis java.sql.SQLException: Parameter index of 2 is out of range (1, 0) 错误原因
- java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)
- java.sql.SQLException: Parameter index out of range
- java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
- BIRT出现java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)的问题
- Caused by: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0
- Caused by: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0
- 造成原因java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 0).
- 从数据库中读取信息时抛出异常java.sql.SQLException: Parameter index out of range (1 > number of parameter
- Caused by: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1
- 更新数据库表信息时抛异常java.sql.SQLException: Parameter index out of range (1 > number of parameter
- 从别的机器clone git
- 自定义属性
- RSA加密
- jeecg条件查询出错
- python-------------三级菜单
- java.sql.SQLException:Column Index out of range,0<1
- 猜数字
- cxf+spring自定义restful接口返回消息
- Eureka 源码解析 —— Eureka-Client 初始化(三)之 EurekaClient
- python 虚拟环境[virtualenv/virtualenvwrapper]设置
- android网络之URLconnection
- IIS 7 为 URL Rewrite 模块创建重写规则
- [随笔] 停止mysql正在执行的sql
- Eureka 源码解析 —— Eureka-Server 启动(一)之 ServerConfig