为什么resultset方法getString(int columnIndex)中columnIndex不能大于10??
public Company findAll() {
Company c = new Company();
String sql = "select name,phone,fax,cellphone,email,qq,address,trade "
+ "summary,technique,aboutus from company";
con = DBUtil.getConnect();
try {
ps = con.prepareStatement(sql);
rs = ps.executeQuery();
if (rs.next()) {
c.setName(rs.getString(1));
c.setPhone(rs.getString(2));
c.setFax(rs.getString(3));
c.setCellphone(rs.getString(4));
c.setEmail(rs.getString(5));
c.setQq(rs.getString(6));
c.setAddress(rs.getString(7));
c.setTrade(rs.getString(8));
c.setSummary(rs.getString(9));
c.setTechnique(rs.getString(10));
c.setAboutus(rs.getString(11));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBUtil.close(rs);
DBUtil.close(ps);
DBUtil.close(con);
}
return c;
}
MySQL 连接成功!!!
java.sql.SQLException: Column Index out of range, 11 > 10.
at com.mysql.jdbc.ResultSet.checkColumnBounds(ResultSet.java:636)
at com.mysql.jdbc.ResultSet.getNativeString(ResultSet.java:3943)
at com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:5080)
at com.mysql.jdbc.ResultSet.getString(ResultSet.java:4926)
at com.mingxuan.dao.CompanyDao.findAll(CompanyDao.java:61)
at com.mingxuan.struts.action.HomeAction.execute(HomeAction.java:30)
如果我查询的字段大于10,该这么写呢,希望高手指点一二!!!
public Company findAll() {
Company c = new Company();
String sql = "select name,phone,fax,cellphone,email,qq,address,trade "
+ "summary,technique,aboutus from company";
con = DBUtil.getConnect();
try {
ps = con.prepareStatement(sql);
rs = ps.executeQuery();
if (rs.next()) {
c.setName(rs.getString(1));
c.setPhone(rs.getString(2));
c.setFax(rs.getString(3));
c.setCellphone(rs.getString(4));
c.setEmail(rs.getString(5));
c.setQq(rs.getString(6));
c.setAddress(rs.getString(7));
c.setTrade(rs.getString(8));
c.setSummary(rs.getString(9));
c.setTechnique(rs.getString(10));
c.setAboutus(rs.getString(11));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBUtil.close(rs);
DBUtil.close(ps);
DBUtil.close(con);
}
return c;
}
MySQL 连接成功!!!
java.sql.SQLException: Column Index out of range, 11 > 10.
at com.mysql.jdbc.ResultSet.checkColumnBounds(ResultSet.java:636)
at com.mysql.jdbc.ResultSet.getNativeString(ResultSet.java:3943)
at com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:5080)
at com.mysql.jdbc.ResultSet.getString(ResultSet.java:4926)
at com.mingxuan.dao.CompanyDao.findAll(CompanyDao.java:61)
at com.mingxuan.struts.action.HomeAction.execute(HomeAction.java:30)
如果我查询的字段大于10,该这么写呢,希望高手指点一二!!!
解决方案 »
- 项目启动无错误,打开JSP页面报错
- 求教一个问题
- org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnection
- 飘浮窗口设定边界问题,。。大侠指教
- 如何得到select count(*) from 表 where name='aa'的返回值?
- 变量传递的问题
- 请教大家,做一个这样的收费管理系统用什么工具好呢?
- 各位大侠帮我参考参考是否可行,谢谢!
- 我知道某文件位于http://somesite/foo.zip,我怎么将它获取到本地?用JSP实现。
- 怎么用jsp代码实现在下拉菜单里读取数据库内容?
- java web 首页加载老是出错啊!!!!刷新一下就没事了 这是为什么
- Web Service中数据库查询问题,急等!!
String sql = "select name,phone,fax,cellphone,email,qq,address,trade,"
+ "summary,technique,aboutus from company";
大家都有分,大家辛苦了,谢谢大家了~~~~