ResultSet 的一个奇怪问题
cnlsq 2003-05-13 04:19:44 我用的是Resin服务器,数据库是oralce,为什么我在取数据时,resultset可以next(),getString()却不能rs.last()我的程序是:
<%
Context ic = new InitialContext();
DataSource ds = (DataSource) ic.lookup("java:comp/env/jdbc/test");
Connection conn = ds.getConnection();
ResultSet rs=null;
Statement stmt;
try {
stmt = conn.createStatement();
rs = stmt.executeQuery("SELECT * FROM djadwk");
rs.last()
out.print(rs.getRow());
%><h2>Brooms:</h2>
<br>
<%
while (rs.next()) { %>
<%= rs.getString(1) %>--<%=rs.getRow()%> ;
<%= rs.getString(2) %>;
<%= rs.getString(3) %>;
<%= rs.getString(4) %>;
<%= rs.getString(5) %><br>
<%}
}catch(SQLException e ){}finally{stmt.close();}
%>