Guest User

Untitled

a guest
Aug 16th, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.62 KB | None | 0 0
  1. ///DecimalFormat df2 = new DecimalFormat(".##");
  2. Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/prasad","prasad","prasad");
  3. ResultSet rs=null;
  4. //String s=("select*from sbin;");
  5. Statement stmt=con.createStatement();
  6. //ResultSet rs=stmt.executeQuery(s);
  7. ArrayList<Float> grp=new ArrayList<Float>();
  8. //float[] grp=new grp[];
  9. Float one,two,three,four,five,six,seven;
  10. Float j;
  11. Float k;
  12. Float res,cal;
  13. String[] stock={"sbi","yesbank","concor","jublfood","kpit","wipro"};
  14. for(int i=0;i<stock.length;i++)
  15. {
  16. System.out.println("stock name"+ " "+stock[i]);
  17. rs=stmt.executeQuery("select * from(select * from `"+stock[i]+"` order by date desc limit 7)sub order by date;");
  18. while(rs.next())
  19. //for(;rs.next();)
  20. {
  21. j=rs.getFloat(6);
  22. k=rs.getFloat(7);
  23. //cal=j-k;
  24. res=j-k;
  25. grp.add(res);
  26. System.out.println(res);
  27. System.out.println(rs.getString(1)+" "+rs.getString(6)+" "+rs.getString(7));
  28.  
  29.  
  30. }
  31. System.out.println(grp);
  32. //for(i=0;i<=grp.size();i++)
  33. //{
  34. one=grp.get(i);
  35. two=grp.get(1);
  36. three=grp.get(2);
  37. four=grp.get(3);
  38. five=grp.get(4);
  39. six=grp.get(5);
  40. seven=grp.get(6);
  41. if(seven<=two && seven<=one && seven<=three && seven<=four && seven<=five && seven<=six)
  42.  
  43. System.out.println("nr7");
  44. grp.clear();
  45.  
  46. Exception in thread "main" java.lang.IndexOutOfBoundsException: Index: 0, Size:
  47. 0
  48. at java.util.ArrayList.rangeCheck(Unknown Source)
  49. at java.util.ArrayList.get(Unknown Source)
  50. at misc1.main(misc1.java:45)
Add Comment
Please, Sign In to add comment