Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static int WireMonitoring(){
- int score = 0;
- Statement query = conn.createStatement();
- ResultSet rs = query.executeQuery("SELECT * FROM Transaction WHERE Amount>10000 AND TransactionType=Wire");
- int series = 0;
- for(int i=0; i<len(rs)-2; i++){
- if( datediff(rs[i].getString("CreateDate"), rs[i+1].getString("CreateDate") )==1 ){ //ไปเขียนฟังก์ชั่นบวกลบวันที่เพิ่มนะ)
- series++;
- }
- if( series==1 && datediff(rs[i].getString("CreationDate"), rs[i+2].getString("CreationDate") )==2 ){
- score = 150;
- series = 0;
- }
- }
- return score;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement