Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 staawka = javaapplication4.MyServerForm.stawka;
- String okreees = javaapplication4.MyServerForm.okres;
- 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 umowa"); //
- ResultSet rss = stt.executeQuery(sql3);
- Integer sqlmax=0;
- while(rss.next()){
- sqlmax=rss.getInt(1);
- }
- sqlmax+=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");
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement