为什么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,该这么写呢,希望高手指点一二!!!