Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ///DecimalFormat df2 = new DecimalFormat(".##");
- Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/prasad","prasad","prasad");
- ResultSet rs=null;
- //String s=("select*from sbin;");
- Statement stmt=con.createStatement();
- //ResultSet rs=stmt.executeQuery(s);
- ArrayList<Float> grp=new ArrayList<Float>();
- //float[] grp=new grp[];
- Float one,two,three,four,five,six,seven;
- Float j;
- Float k;
- Float res,cal;
- String[] stock={"sbi","yesbank","concor","jublfood","kpit","wipro"};
- for(int i=0;i<stock.length;i++)
- {
- System.out.println("stock name"+ " "+stock[i]);
- rs=stmt.executeQuery("select * from(select * from `"+stock[i]+"` order by date desc limit 7)sub order by date;");
- while(rs.next())
- //for(;rs.next();)
- {
- j=rs.getFloat(6);
- k=rs.getFloat(7);
- //cal=j-k;
- res=j-k;
- grp.add(res);
- System.out.println(res);
- System.out.println(rs.getString(1)+" "+rs.getString(6)+" "+rs.getString(7));
- }
- System.out.println(grp);
- //for(i=0;i<=grp.size();i++)
- //{
- one=grp.get(i);
- two=grp.get(1);
- three=grp.get(2);
- four=grp.get(3);
- five=grp.get(4);
- six=grp.get(5);
- seven=grp.get(6);
- if(seven<=two && seven<=one && seven<=three && seven<=four && seven<=five && seven<=six)
- System.out.println("nr7");
- grp.clear();
- Exception in thread "main" java.lang.IndexOutOfBoundsException: Index: 0, Size:
- 0
- at java.util.ArrayList.rangeCheck(Unknown Source)
- at java.util.ArrayList.get(Unknown Source)
- at misc1.main(misc1.java:45)
Add Comment
Please, Sign In to add comment