获得当前记录的上一条记录和下一条记录

 

获得当前记录的上一条记录和下一条记录

package Other;   import java.io.File; import java.io.FileInputStream; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.text.SimpleDateFormat; import java.util.Date;   public class Test {     public static void main(String[] args)     {         String sql1 = " SELECT * FROM user WHERE id=12";         String sql2 = " SELECT * FROM user WHERE id<=12 order by id desc";         String sql3 = " select * from user where id>=12 order by id";         PreparedStatement pstmt = null;         DataBaseConnection dbc = null;         dbc = new DataBaseConnection();                 try {             pstmt = dbc.getConnection().prepareStatement(sql1);             ResultSet rs = pstmt.executeQuery();             pstmt = dbc.getConnection().prepareStatement(sql2);             ResultSet r2 = pstmt.executeQuery();             pstmt = dbc.getConnection().prepareStatement(sql3);             ResultSet r3 = pstmt.executeQuery();             String pwd="";                         if(r2.next())             {                 r2.next();                 pwd=r2.getString("pwd");                                 System.out.println(pwd);             }             if(rs.next())             {                 pwd=rs.getString("pwd");                                 System.out.println(pwd);             }                         if(r3.next())             {                 r3.next();                 pwd=r3.getString("pwd");                                 System.out.println(pwd);             }         } catch (SQLException e) {             e.printStackTrace();         } finally {             dbc.close();         }     } }