求助:这个方法是不是有问题?

我的bbs编辑回复功能忘记作了,昨天想把它补上,可是本以为很简单的事却总也弄不好,我不知是哪里出了问题,请学长们指教。

//这个是我的得到回复的方法
public Re getOneRe(int TID,int ReID) throws SQLException
{
 sh.loadMyDriver();
 sh.setMyConnection();
 sh.createMyStatement();
 ResultSet rs=sh.executeMyQuery("select * from Re where TID=" + TID + "AND ReID=" + ReID );
 Re r=null;
 while(rs.next())
 {
  r = new Re();
     r.setTID(rs.getInt("TID"));
     r.setReID(rs.getInt("ReID"));
     r.setReText(rs.getString("ReText"));
     r.setReAuthor(rs.getString("ReAuthor"));
     r.setReDate(rs.getString("ReDate"));
 }
 rs.close();
 sh.closeMyStatement();
 sh.closeMyConnection();
 return r;
 
}



//这个是我在editre.jsp中的一段代码,希望实现从数据库调出具体某一条回复的功能,但是总是报错....
<body>
<%ReEdit re = new ReEdit();
Re r=re.getOneRe(Integer.parseInt(request.getParameter("TID")),Integer.parseInt(request.getParameter("ReID")));%>
</body>
</html>





//这个是报错的内容

exception

org.apache.jasper.JasperException: javax.servlet.ServletException: java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]无效的描述符索引
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:541)
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 cause

javax.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.editre_jsp._jspService(editre_jsp.java:125)
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 cause

java.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)
classes.ReEdit.getOneRe(ReEdit.java:87)
org.apache.jsp.editre_jsp._jspService(editre_jsp.java:110)
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)


希望学长们能指教。
原文地址:https://www.cnblogs.com/xiaoao808/p/1026458.html