这里面包含了一百多个JAVA源文件

源代码在线查看: e269. moving the cursor in a scrollable result set.txt

软件大小: 551 K
上传用户: maple_78
关键词: JAVA
下载地址: 免注册下载 普通下载 VIP

相关代码

				This example demonstrates the various methods for moving the cursor in a scrollable result set. 
				    try {
				        // Create a scrollable result set
				        Statement stmt = connection.createStatement(
				            ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
				        ResultSet resultSet = stmt.executeQuery("SELECT * FROM my_table");
				    
				        // Move cursor forward
				        while (resultSet.next()) {
				            // Get data at cursor
				            String s = resultSet.getString(1);
				        }
				    
				        // Move cursor backward
				        while (resultSet.previous()) {
				            // Get data at cursor
				            String s = resultSet.getString(1);
				        }
				    
				        // Move cursor to the first row
				        resultSet.first();
				    
				        // Move cursor to the last row
				        resultSet.last();
				    
				        // Move cursor to the end, after the last row
				        resultSet.afterLast();
				    
				        // Move cursor to the beginning, before the first row.
				        // cursor position is 0.
				        resultSet.beforeFirst();
				    
				        // Move cursor to the second row
				        resultSet.absolute(2);
				    
				        // Move cursor to the last row
				        resultSet.absolute(-1);
				    
				        // Move cursor to the second last row
				        resultSet.absolute(-2);
				    
				        // Move cursor down 5 rows from the current row.  If this moves
				        // cursor beyond the last row, cursor is put after the last row
				        resultSet.relative(5);
				    
				        // Move cursor up 3 rows from the current row.  If this moves
				        // cursor beyond the first row, cursor is put before the first row
				        resultSet.relative(-3);
				    } catch (SQLException e) {
				    }
				
							

相关资源