Sql View last record

If you want to view the last record of database table, then use rs.last() method:

import java.sql.*;
    class RetrieveData{
        public static void main(String[] args){
            try{
                Class.forName("com.mysql.jdbc.Driver");
               Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
               Statement st=con.createStatement();
               ResultSet rs=st.executeQuery("select * from data");
               if(rs.last()){
                   System.out.println(rs.getString("name")+" "+rs.getString("address"));
               }
            }
            catch(Exception e){
            }
        }
    }