JSP页面调试问题,请帮助解决...
public class Test{
public static String sbDome(){
java.sql.Connection conn =null;
java.sql.Statement stmt = null;
java.sql.ResultSet rs = null;
StringBuffer sbHtml = new StringBuffer();
String sDBdriver = "oracle.jdbc.driver.OracleDriver";
String DBUrl = "jdbc:oracle:thin:@192.168.4.72:1521:orcl";
String UserName = "XXX";
String PassWord = "XXX";
try{
Class.forName(sDBdriver);
conn =java.sql.DriverManager.getConnection(DBUrl,UserName,PassWord);
stmt = conn.createStatement();
rs = stmt.executeQuery("Select * from table_BM");
sbHtml.append("<table border=\"1\" width=\"100%\">\n");
while (rs.next()) {
sbHtml.append(" <tr>\n");
sbHtml.append(" <td width=\"50%\">"+rs.getString("BM_DM")+"</td>\n");
sbHtml.append(" <td width=\"50%\">"+rs.getString("BM_MC")+"</td>\n");
sbHtml.append(" </tr>\n");
}
sbHtml.append("</table>");
}catch (java.lang.Exception ex) {
System.out.print(ex.getMessage());
}
conn.close;
stmt.close;
rs.close;
return (sbHtml.toString());
}
public static String sbTest(){
StringBuffer sbHtml = new StringBuffer();
sbHtml.append("<table border=\"1\" width=\"100%\">");
sbHtml.append(" <tr>");
sbHtml.append(" <td width=\"33%\">"+"asdfdafadsf"+"</td>");
sbHtml.append(" <td width=\"33%\">"+"sadfasdfdsf"+"</td>");
sbHtml.append(" <td width=\"34%\">"+"fasdfasdfad"+"</td>");
sbHtml.append(" </tr>");
sbHtml.append(" <tr>");
sbHtml.append(" <td width=\"33%\">hkhjkhj</td>");
sbHtml.append(" <td width=\"33%\">bjkhjk</td>");
sbHtml.append(" <td width=\"34%\">hjkhjk</td>");
sbHtml.append(" </tr>");
sbHtml.append("</table>");
return sbHtml.toString();
}
}
我在JSP页面调用如下:
<%
Test sbT = new Test();
out.print(sbT.sbDome());
%>
页面为什么没有内容可以显示????
而调用 sbTest()会有内容显示??sbDome方法和sbTest方法有什么吗?为什么效果会不一样??
在 main()方法中
out.println(sbDome());
是有结果如下:
<table border="1" width="100%">
<tr>
<td width="50%">10</td>
<td width="50%">经理办公室</td>
</tr>
<tr>
<td width="50%">20</td>
<td width="50%">网络部</td>
</tr>
<tr>
<td width="50%">30</td>
<td width="50%">市场部</td>
</tr>
<tr>
<td width="50%">40</td>
<td width="50%">财务部</td>
</tr>
<tr>
<td width="50%">50</td>
<td width="50%">技术部</td>
</tr>
</table>
为什么(sbDome())在JSP页面表格无法显示?sbTest()方法却可以显示。