我是一个jsp初学者,请问专家我这个语句有什么问题吗?语句如下:
String sqlmax="select max(one_serial_nbr) from bill.user_complain_t";
ResultSet rs_max=stmt_second2.executeQuery(sqlmax);
int int_serial_nbr=rs_max.getInt(1)+1;
out.print(rs_max.getInt(1));执行是老报错,报错信息为:org.apache.jasper.JasperException: String index out of range: 5
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:370)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
String sqlmax="select max(one_serial_nbr) from bill.user_complain_t";
ResultSet rs_max=stmt_second2.executeQuery(sqlmax);
int int_serial_nbr=rs_max.getInt(1)+1;
out.print(rs_max.getInt(1));执行是老报错,报错信息为:org.apache.jasper.JasperException: String index out of range: 5
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:370)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
if(rs.next()){ // 加上这个才行
int int_serial_nbr=rs_max.getInt(1)+1;
...你的错误和这段代码没有任何关系,我没看懂....呵呵!
是不是这个语句int int_serial_nbr=rs_max.getInt(1)+1;有问题,我加上if()也不行,报同样的错误