how to retrive the data of the last row in the table ?

[munjal upadhyay]

import java.sql.*;


public class DatabaseDemo

{

   
    public static void main(String[] args)
    
    {
       Connection c= null;

        
        ResultSet result;

        try
        {
              Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");                  
              c = DriverManager.getConnection("jdbc:odbc:MyApplication");
              Statement  state = c.createStatement();                           
            
              result =state.executeQuery("Select ID from Table1");
               

       /*
              result.last();
	      result.previous();
              int i =     result.getRow();
              System.out.print(i);
                //System.out.print("User id :" + result.getInt("id"));
         */     

             
  
        
  
 
                 
                   result.next();
                   result.last();


  
                   int i = result.getInt("ID");

      		   System.out.println(i + "\t\t" );

                  }


              




              result.close(); 
              state.close();
              c.close();
            


              
        }
        catch(ClassNotFoundException e)
       {
            System.out.println("unable to load JDBC ODBC driver..."+e.getMessage());
            
        }
        catch(SQLException e)
        {
            System.out.println("table already exists.."+e.getMessage());
            
        }        
                
        catch(Exception e)
        {
            System.out.println("somthing going wrong...");
        }
    }
}

[munjal upadhyay]

please do not consider compilation error
because I had cut a part of the program from the hole program...

[munjal upadhyay]

I think its of the jdbc type .

[Jeanne Boyarsky]

As you haven't sorted the query, the "last" row doesn't really have meaning. It's an artifact of how the data is stored. The easiest way to get the last row is to make it the first row. For example query
Select ID from Table1 order by ID desc.

Then you can call if ( rs.next() ) and rs.getString(1).

[munjal upadhyay]

Jeanne Boyarsky wrote:As you haven't sorted the query, the "last" row doesn't really have meaning. It's an artifact of how the data is stored. The easiest way to get the last row is to make it the first row. For example query
Select ID from Table1 order by ID desc.

can you please tell me , how to get the data of a perticular row ?
(write a querry if possible)

[Sharath Upadhya]

If you want to fetch only the last row, you can use 'limit', like this

SELECT [ID or *] FROM Table1 ORDER BY ID DESC LIMIT 1

.with this query, you can fetch the whole record. if you want to fetch only the last ID, you can try using aggregate function. like this

SELECT MAX(ID) FROM Table1

assuming the column is an integer

[Vic Hood]

You could use result.last(), to point to the last row and then get its values

[munjal upadhyay]

I got the last row now ,

but the priblem is that I am not getting the data of the perticular row..

my Table names Table1 has three fields -> ID,Name,SName

I write the querry
result =state.executeQuery(" SELECT * FROM Table1 WHERE ID=3 ");
then I print that

System.out.println("Name is "+result.getString("UserName"));
System.out.println("SName is "+result.getString("Surname"));

but,,
the exception dispayed as follows...

[Microsoft][ODBC Driver Manager] Invalid cursor state

I have already 15 data in the Table1.
so , what happening ?

[munjal upadhyay]

Vic Hood wrote:You could use result.last(), to point to the last row and then get its values

the result.last() only not work
I got it..

we have to change

Statement state = c.createStatement();
to
Statement state = c.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);