如果其它正确的话,只是想用表格显示就这样吧?
<table>
<%
while(rs.next()){
out.print("<tr><td>ID="+rs.getString("NO")+"</td>");
out.print("<td>ID="+rs.getString("NAME")+"</td></tr>");
}
%>
</table>
<table>
<%
while(rs.next()){
out.print("<tr><td>ID="+rs.getString("NO")+"</td>");
out.print("<td>ID="+rs.getString("NAME")+"</td></tr>");
}
%>
</table>
<%
String userName = "pdm";
String password = "pdm";
String jdbcDriver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@192.168.1.13:1521:oracle8";
try{
Class.forName(jdbcDriver);
}catch(Exception e) {
System.err.println("<br> "+e.toString());
}
Connection conn = DriverManager.getConnection(url,userName,password);
Statement stmt=conn.createStatement();
String sql="select ID,NAME from supplier";
ResultSet rs=stmt.executeQuery(sql);
%><table width="100%" border="1" align="center" cellpadding="2"><%
while(rs.next()){
%>
<tr>
<td><%=rs.getString("NO")%></td>
<td><%=rs.getString("NAME")%></td>
</tr>
<%
}
rs.close();
conn.close();
%>
</BODY>
out.print("ID="+rs.getString("NAME")+"<br>");
==================================
是改成"ID"吧
out.print("ID="+rs.getString("ID")+"<br>");
out.print("ID="+rs.getString("NAME")+"<br>");
Error 500: 无法编译 JSP 类 d:\IBM\wsad\workspace\.metadata\.plugins\com.ibm.etools.server.core\tmp0\cache\localhost\server1\DefaultEAR\partquery.war\_testoracle.java:121: 没有与“catch”搭配的“try”。 } catch (Throwable t) { ^ d:\IBM\wsad\workspace\.metadata\.plugins\com.ibm.etools.server.core\tmp0\cache\localhost\server1\DefaultEAR\partquery.war\_testoracle.java:134: 没有与“try”搭配的“catch”或“finally”。 }
d:\IBM\wsad\workspace\.metadata\.plugins\com.ibm.etools.server.core\tmp0\cache\localhost\server1\DefaultEAR\partquery.war\_testoracle.java:134: 需要 '}'。 } ^ 3 个错误
请问这些错误是怎么回事呀,郁闷中