Advertisement
Guest User

Untitled

a guest
Jun 24th, 2018
34
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.63 KB | None | 0 0
  1. public static int WireMonitoring(){
  2.     int score = 0;
  3.     Statement query = conn.createStatement();
  4.     ResultSet rs = query.executeQuery("SELECT * FROM Transaction WHERE Amount>10000 AND TransactionType=Wire");
  5.    
  6.     int series = 0;
  7.    
  8.     for(int i=0; i<len(rs)-2; i++){
  9.         if( datediff(rs[i].getString("CreateDate"), rs[i+1].getString("CreateDate") )==1 ){ //ไปเขียนฟังก์ชั่นบวกลบวันที่เพิ่มนะ)
  10.             series++;
  11.         }
  12.  
  13.         if( series==1 && datediff(rs[i].getString("CreationDate"), rs[i+2].getString("CreationDate") )==2 ){
  14.             score = 150;
  15.             series = 0;
  16.         }
  17.     }
  18.  
  19.     return score;
  20.  
  21. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement