/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package MetodaSzablonowa;
import static java.lang.Integer.parseInt;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Random;
import javaapplication4.MyServerForm;
import static javaapplication4.MyServerForm.send;
/**
 *
 * @author Kamil
 */

public class Emerytura extends Umowa{
     String login = javaapplication4.MyServerForm.login_baza;
     String haslo = javaapplication4.MyServerForm.haslo_baza;
     @Override
     protected void collectSource() {
         
         try{
            Class.forName("oracle.jdbc.OracleDriver");
            Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe",login,haslo);  
            
            Statement st = con.createStatement();
            Statement stt = con.createStatement();
            String Id = "'43060070090'"; //to jest pesel i mi go przesylasz
            
           
                 String sql3 = ("select max(id) from dane_osobowe"); //
                 ResultSet rss = stt.executeQuery(sql3);
                 Integer sqlmax=0;
                 
                while(rss.next()){
                 sqlmax=rss.getInt(1);
                }
                 //int foo = Integer.parseInt(sql3);
                 //Integer sqlmax = Integer.parseInt(sql3) +1;
                 System.out.println(sqlmax.toString());
                 Random rand = new Random();
                 int  n = rand.nextInt(100) + 1;
                 String dane_osobid= ("select Id from dane_osobowe WHERE pesel="+Id);
                 ResultSet rsss = stt.executeQuery(dane_osobid);
                 Integer id_osob=0;
                 
                while(rsss.next()){
                 id_osob=rsss.getInt(1);
                }
                System.out.println(id_osob.toString());
                
                 //Integer chuj=Integer.parseInt(dane_osobid);
                 // teraz robimy konto id - trzeba oddzielic to 
                 int uslugaid = 1; //tu jest opcja emerytura wiec to jest stale
                 int wyplacanakwota = rand.nextInt(10000) + 1;
              //INSERT INTO umowa (Id,dane_osobowe_id,konto_id,uslugi_id,wyplacana_kwota,ilosc_wyplat,data_podpisania,data_konca) VALUES ('6','61','1','4','57248','76','22-05-12','11-09-14');
                
                
//String sql =  "INSERT INTO umowa (Id,dane_osobowe_id,konto_id,uslugi_id,wyplacana_kwota,ilosc_wyplat,data_podpisania,data_konca) VALUES('103','2','3','4','5','6','22-05-12','11-09-14')";
String sql =  "INSERT INTO umowa (Id,dane_osobowe_id,konto_id,uslugi_id,wyplacana_kwota,ilosc_wyplat,data_podpisania,data_konca) VALUES("+sqlmax+","+id_osob+","+n+","+uslugaid+","+wyplacanakwota+","+n+",'22-05-12','11-09-14')";
System.out.println(sql);
            ResultSet rs = st.executeQuery(sql);
            
            while(rs.next()){
              // send(IP,"U-"+rs.getInt(1)+ "-"+rs.getString(2));
               // Thread.sleep(100);
              System.out.println(rs.getInt(1)+rs.getInt(2)+rs.getInt(3)+rs.getInt(4)+rs.getInt(5)+rs.getInt(6)+rs.getInt(7)+rs.getInt(8));

         
           } 
             con.close();
              
        } catch(Exception e){
         System.out.println(e);
    }
    }
  
     @Override
  protected void compileToTarget() {
   System.out.println("Emerytura");
  }
}