如何在Firefox中使用XUL创建底部停靠面板？(How to create a bottom-docked panel with XUL in Firefox?)

 您需要调用ResultSet#next()以将光标从当前位置向前移动一行。 由于您期望从查询中返回单个行，因此您可以在if语句中调用它，如下所示： 
 
public Position extractData(ResultSet rs) throws SQLException,
            DataAccessException {
        Position p = new Position();
        if(rs.next()) {
            p.setId(rs.getString("id"));
            p.setPositionName(rs.getString("position_name"));
            p.setDescription(rs.getString("description"));
        }
        return p;
}
 
 如果您期望处理多个结果并返回某种类型的集合，那么您可以while(rs.next())进行处理，并在循环的每次迭代中处理一行。 
 
 另外，当你使用JdbcTemplate你可以考虑使用RowMapper ，它可能会稍微简化你的实现。 

You need to call ResultSet#next() to "move the cursor forward one row from its current position." As you are expecting a single row to be returned from your query, you can call this in an if statement as shown below:
 
public Position extractData(ResultSet rs) throws SQLException,
            DataAccessException {
        Position p = new Position();
        if(rs.next()) {
            p.setId(rs.getString("id"));
            p.setPositionName(rs.getString("position_name"));
            p.setDescription(rs.getString("description"));
        }
        return p;
}
 
If you were expecting to process multiple results and return a collection of some sort, you would do while(rs.next()) and process a row on each iteration of the loop.
 
Also, as you are using JdbcTemplate you could consider using a RowMapper instead which may simplify your implementation slightly.