读数据库的问题??? 请教!!!

<%@ include file="../member/header.inc"%>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="workM" scope="page" class="test.conn" />

<%!
public String getStr(String str)
{
try
{
String temp_p=str;
byte[] temp_t=temp_p.getBytes("GBK");
String temp=new String(temp_t,"ISO8859_1");
return temp;
}
catch(Exception e)
{

}
return "null";
}
%>
<TABLE border=0 cellPadding=0 cellSpacing=0 width=760 align="center">
  <TBODY>
  <tr><td align="left" height=25>当前位置：<a href="../index.jsp">首页</a> -> <a href="index.jsp">论坛</a>   </td>  </tr>
  <TR bgColor=#3399ff>
    <TD height=1 colspan="2"><IMG height=1 src="images/spacer.gif"
  width=16></TD></TR>
  <tr><td height=10 colspan="2"><IMG height=1 src="images/spacer.gif"
  width=16></td></tr>
  </TBODY></TABLE>  <table align="center" border="0" width="760" cellspacing="0" cellpadding="0" height="355">
<tr>
<td width="150" height="355" valign="top">
<%@ include file="../member/table.inc"%>

</td>
<td width="10" height="100%"></td>
<td width="1" height="100%" bgcolor="#3399ff"></td>
<td width="10" height="100%"></td>
<td width="589" height="331" valign="top" background="images/bg1.gif">
        <table border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td colspan="3" width="100%" height="20" bgcolor="#3399ff"> <font color="#ffffff">论坛  -> 详细查看</font>
</td>
  </tr>
  <tr>

  <td align="center" colspan='3' valign="top">
<%
String id;
id=request.getParameter("id");
String strSQL="select * from topic where id ="+id;
ResultSet RSa = workM.executeQuery(strSQL);
//out.println(strSQL);

while (RSa.next()) {
String a_author;
int topic_id;
topic_id=RSa.getInt("id");
a_author=getStr(RSa.getString("author"));
out.println("<br><b><font color=red>"+getStr(RSa.getString("title"))+"</font></b><br>"+a_author+" "+RSa.getDate("date")+"<br><br></td></tr><tr><td colspan='3' align='right'>");
if(a_author.equals(session.getValue("username")))
{
out.println("<a href=edit.jsp?mode=topic&id="+topic_id+">编  辑</a>  <a href=delete.jsp?mode=topic&id="+topic_id+">删  除</a>   ");
}
out.println("<a href=reply.jsp?id="+id+">回  复</a>   <a href=index.jsp>返回</a></td></tr><tr><td colspan='3' height='1' bgcolor='#3399ff'></td></tr><tr><td width='5%'></td>");
out.println("<td><br>作者："+a_author+"<br><br>");
out.println(getStr(RSa.getString("content"))); }
RSa.close(); %>
</td>
<td width="5%"></td>
  </tr>

   <%
// String id;
// id=request.getParameter("id");
String strRe="SELECT * FROM reply where topicID="+id;
ResultSet RSr = workM.executeQuery(strRe);
//out.println(strSQL);

while (RSr.next()) {
%>

<%
String a_author,t_id;
t_id=RSr.getString("id");
a_author=getStr(RSr.getString("author"));
out.println("<tr><td colspan='3' height='1' bgcolor='#3399ff'></td></tr>");
out.println("<tr><td colspan='3' align='right'>");
if(a_author.equals(session.getValue("username")))
{
out.print("<a href=edit.jsp?mode=reply&id="+t_id+">编  辑</a>  <a href=delete.jsp?mode=reply&id="+t_id+">删  除</a>   ");
}
out.print("<a href=reply.jsp?id="+id+">回  复</a>   <a href=index.jsp>返回</a></td></tr>");
out.println("<tr><td align=center colspan='3' valign=top>");
out.print("<br><b>"+getStr(RSr.getString("title"))+"</b><br>"+a_author+" "+RSr.getDate("date")+"<br><br></td></tr>");
out.print("<tr><td width='5%'></td>");
out.print("<td><br>作者："+a_author+"<br><br>");
out.print(getStr(RSr.getString("content")));
%>
</td>
<td width="5%"></td>
</tr>
<%
}
RSr.close(); %>

        </table>
        </td>
    </tr>
  </table>
<%@ include file="../member/footer.inc"%>
这就是源代码请帮忙看看!
谢谢了

把test.conn的源码贴出来，可能是数据库连接错误！！

换成第四类jdbc驱动吧？jdbc-odbc桥很落后的！！！！

http://search.csdn.net/Expert/topic/1619/1619032.xml?temp=.5700647
http://search.csdn.net/Expert/topic/858/858207.xml?temp=.0789606http://search.csdn.net/Expert/topic/1041/1041290.xml?temp=.948208哈哈，我把你的问题搜索出一个直接的答案来了
====
这句话也是贴的人家的。
已在另外那个帖子里给出了答案。呵呵，你应该多用用CSDN的“搜索”，我就是用“无效的描述符索引”来搜索论坛，才知道答案的。

调试易

读数据库的问题??? 请教!!!

解决方案 »