对不起,我把错误加错地方了。正确如下
代码如下:
<%
String Q_id="1";
String Q_num="1";
String sql2="select A_num,count(A_num) as counta from answered where Q_id='"+Q_id+"' and Q_num='"+Q_num+"'group by A_num";
ResultSet rs=db.executeQuery(sql2);
int count=0;
int counta=0;
while(rs.next()){
counta=rs.getInt("counta");//不加这行 ,没问题!!
count=rs.getInt("count");//不加这行 ,也没问题!!
int A_num=rs.getInt("A_num");
%>
<%=A_num%>
<%=count%>
<%=counta%>
<%
}
rs.close();
%>错误如下:
javax.servlet.ServletException: Column not found
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:471)
at org.apache.jsp.a$jsp._jspService(a$jsp.java:124)
代码如下:
<%
String Q_id="1";
String Q_num="1";
String sql2="select A_num,count(A_num) as counta from answered where Q_id='"+Q_id+"' and Q_num='"+Q_num+"'group by A_num";
ResultSet rs=db.executeQuery(sql2);
int count=0;
int counta=0;
while(rs.next()){
counta=rs.getInt("counta");//不加这行 ,没问题!!
count=rs.getInt("count");//不加这行 ,也没问题!!
int A_num=rs.getInt("A_num");
%>
<%=A_num%>
<%=count%>
<%=counta%>
<%
}
rs.close();
%>错误如下:
javax.servlet.ServletException: Column not found
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:471)
at org.apache.jsp.a$jsp._jspService(a$jsp.java:124)
String Q_id="1";
String Q_num="1";
String sql2="select A_num,count(A_num) as counta from answered where Q_id='"+Q_id+"' and Q_num='"+Q_num+"'group by A_num";
ResultSet rs=db.executeQuery(sql2);
int A_num=0;
int counta=0;
while(rs.next()){
A_num=rs.getInt("A_num");
counta=rs.getInt("counta");
%>
<%=A_num%>
<%=counta%>
<%
}
rs.close();
%>
帮帮忙!!谢谢
counta=rs.getInt(2);
对不起 ,麻烦你写的详细点,我看不懂。1、2是什么?
错误如下:
javax.servlet.ServletException: [Microsoft][ODBC SQL Server Driver]无效的描述符索引
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:471)
at org.apache.jsp.a$jsp._jspService(a$jsp.java:125)
......
谢了
给分