/*
 * 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 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();
            String Id = "'43060070090"; //to jest pesel i mi go przesylasz


                 String sql3 = ("select max(id) from dane_osobowe"); //
                 //int foo = Integer.parseInt(sql3);
                 String sqlmax = sql3 +1;
                 System.out.println(sqlmax);
                 Random rand = new Random();
                 int  n = rand.nextInt(100) + 1;
                 String dane_osobid= ("select Id from dane_osobowe WHERE pesel= "+Id);
                 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('"sql3"','"+dane_osobid+"',"+n+","+uslugaid+","+wyplacanakwota+","+n+",'22-05-12','11-09-14')";

            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");
  }
}