运行报错，帮忙下谢谢

Question

报这个错，是什么意思呢？
exceptionorg.apache.jasper.JasperException: An exception occurred processing JSP page /message.jsp at line 7673:           String username=rs.getString("m_name");
74:           String topic=rs.getString("m_title");
75:    String time=rs.getString("m_date");
76:           String email=rs.getString("m_email");
77:           String masinfo=rs.getString("m_info");
78:           if(masinfo==null) masinfo="";
79:           if(color==""){
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:524)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root causejavax.servlet.ServletException: java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]无效的描述符索引
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:850)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.message_jsp._jspService(message_jsp.java:226)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root causejava.sql.SQLException: [Microsoft][ODBC SQL Server Driver]无效的描述符索引
sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(Unknown Source)
sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(Unknown Source)
sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)
sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)
org.apache.jsp.message_jsp._jspService(message_jsp.java:138)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
这个是我的前部分代码~~帮下忙
  <%
    String query_type=request.getParameter("select");//获取查询类别
  if(query_type==null)  query_type="";
  String query_content=request.getParameter("query");//获取查询关键字，查询为模糊查询
   if(query_content==null)  query_content="";
String sqli=" SELECT * FROM message ORDER BY id DESC";
if(query_content!=null&&query_type!=null){
  query_content=(new String(query_content.getBytes("ISO-8859-1"))).trim();
  query_type=new String(query_type.getBytes("ISO-8859-1"));
if(query_type.equals("m_name"))
 sqli="Select * from message where m_name like '"+query_content+"%'";
  else if(query_type.equals("m_title"))
 sqli="Select * from message where m_title like '"+query_content+"%'";
  //else
 //odbcQuery="Select * from Student where  class like '"+query_content+"%'";
}
  //else
     // odbcQuery="Select * from Student";
ResultSet rs=con.executeQuery(sqli);
String color="";
String strpages=(String)request.getParameter("pages");
int pages=0;
if(strpages==null){
      pages=0;
}else{
              pages=Integer.parseInt(strpages);
}
rs.last();
int sqan=4,i=0,fcount=0;
int count=rs.getRow();
int countpage=count/sqan;
if(count%sqan>0) countpage=countpage+1;
if(pages<0) pages=0;
if(pages>countpage-1) pages=countpage-1;
fcount=pages*sqan+1;
int fpage=(count-fcount)/sqan+1;
out.print(fpage);
rs.absolute(fcount);
rs.previous();
while(rs.next()){
          int id=rs.getInt("id");
          String username=rs.getString("m_name");
          String topic=rs.getString("m_title");
          String time=rs.getString("m_date");
          String email=rs.getString("m_email");
          String masinfo=rs.getString("m_info");
          if(masinfo==null) masinfo="";
          if(color==""){
                        color="#ffffff";
}else{
                              color="";
}
%>

Answer 1

有~~~  String email=rs.getString("m_email");
  String masinfo=rs.getString("m_info");
这两行都会错，但我数据库里面都有这两列

Answer 2

如果LZ实在找不出，就到翻译好的java文件里面看一看吧

Answer 3

你的字段名字错了 。一般都 不用select * 的 ，速度慢，有时候字段还不清楚是什么。 你就 根据要要查询的字段 一个个的写在sql语句中

Answer 4

是不是你的数据类型不匹配  
String email=rs.getString("m_email");
  String masinfo=rs.getString("m_info");
  数据库里存储的是字符串形式么

Answer 5

select * 改下，改成
select m_name,m_title,m_date,m_email,m_info
然后rs.getString(4),rs.getString(5)看看

Answer 6

看下你的SQL语句和数据库里面的字段定义有没有写错。