mysql query using jdbc

Posted by S.PRATHIBA on Stack Overflow See other posts from Stack Overflow or by S.PRATHIBA
Published on 2010-04-23T08:09:16Z Indexed on 2010/04/23 8:13 UTC
Read the original article Hit count: 825

Filed under:

mysql-query

Hi all,

   I need to retrieve the last 20 values from my database.For example I have the following table

Service_ID Service_Type consumer_feedback | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 36 | Printer | 1 | | 36 | Printer | 0 | | 37 | Printer | 0 | | 39 | Printer | -1 | | 39 | Printer | 0 | | 40 | Printer | 0 |

I need to retrieve last 10 values from the table.I need to do the operation using jdbc.I have attached the sample code.Kindly help me.

import java.io.; import java.sql.;

public class CountRows2

{ public static void main(String[] args)

{ System.out.println("Count number of rows in a specific table!");

Connection con = null;

int count = 0;

try{


  Class.forName("com.mysql.jdbc.Driver");

  con = DriverManager.getConnection

("jdbc:mysql://localhost:3306/prathi","root","mysql"); try{ Statement st = con.createStatement();

     ResultSet res1 = st.executeQuery("SELECT  COUNT(*) FROM  consumer1" );

      while (res1.next()){
      count = res1.getInt(1);

}

System.out.println("Number of column:"+count);

  }
  catch (SQLException s){
    System.out.println("SQL statement is not executed!");
  }
}
catch (Exception e){
  e.printStackTrace();
}

try{ Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection ("jdbc:mysql://localhost:3306/prathi","root","mysql");

try{ Statement st = con.createStatement();

     ResultSet res1 = st.executeQuery("SELECT  * FROM  consumer1   LIMIT  count-10,10");


      while (res1.next()){
      int Service = res1.getInt(1);
       String s1 = res1.getString(2);
       int feedback=res1.getInt(3);

}

System.out.println("Service" + " " +"s1" + " " +"feedback");

  }


  catch (SQLException s){
    System.out.println("SQL statement is not executed!");
  }

}

catch (Exception e){
  e.printStackTrace();
}

} }

I am getting the output as:

C:>javac CountRows2.java

C:>java CountRows2 Count number of rows in a specific table! Number of column:558 SQL statement is not executed!

Thanks a lot....

Developer IT