package MetodaSzablonowa;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
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 sql = "select * from uslugi";
            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.getString(2));


           }
             con.close();



        } catch(Exception e){
         System.out.println(e);
    }

    }

     @Override
  protected void compileToTarget() {
   System.out.println("Emerytura");
  }
}