[es] - Citanje iz Baze Podataka napravljene preko SQL

Neshonee
Nebojsa Dzinic
radnik,Duel

Član broj: 164701
Poruke: 41
*.uns.ac.rs.

Profil

Citanje iz Baze Podataka napravljene preko SQL

^{04.07.2011. u 15:42 - pre 155 meseci}

Ljudi imam problem znam solidno c++ ali samo skolski nivo, Sad sam dobio projekat ali sam se uvalio u velike probleme :/ . Naime treba da napravim tabele u SQL-u a zatim preko c++ da procitam neke podatke. Napravio sam tabele i ok je sve radi moze li mi neko pomoci samo da napise deo koda C++ preko kog se citaju odredjeni delovi iz tabela na osnovu ulaza.

Kod SQL za kreiranje tabela

Code:

create table deonica
(
    iddeonica int not null,
    duzina real,
    Vn real,
    tip_voda int,
    presek real,
    Rd real,
    Ri real,
    Ro real,
    Xd real,
    Xi real,
    Xo real,
    Bd real,
    Bi real,
    Bo real,
    Gd real,
    Gi real,
    Go real,
    pocetak int,
    kraj int,

    constraint deonica_pk primary key (iddeonica)
)

create table sabirnica
(
     idsabirnica int not null,
     Vn real,
     idcvora int

     constraint sabirnica_pk primary key (idsabirnica)
)

create table potrosac
(
    idpotrosaca int not null,
    tip int,
    Vn real,
    S real,
    maksigraf real,
    dijagram real,
    idcvora int,

    constraint potrosac_pk primary key (idpotrosaca)
)

create table transformator_s
(
    idtrans_s int not null,
    S real,
    Vp real,
    Vs real,
    uk12 real,
    Pcu real,
    Pfe real,
    Jfe real,
    idcvora int

    constraint idtrans_s_pk primary key (idtrans_S)
)

create table transformator_V
(
   idtrans_v int not null,
   Sp real,
   Ss real,
   St real,
   Vp real,
   Vs real,
   Vt real,
   Pcups real,
   Pcupt real,
   Pcust real,
   Pfe real,
   Jfe real,
   uk12 real,
   uk13 real,
   uk23 real,
   idcvora int,

   constraint idtrans_v_pk  primary key (idtrans_v)
)

create table rasklopna_oprema
(
    idoprema int not null,
    Vn real,
    tip_opreme int,
    idcvora int,

    constraint sklp_opr_pk primary key (idoprema)
)

Kod za popunjavanje gore kreirane Tabele

Code:

insert into deonica (iddeonica,duzina,Vn,tip_voda,presek,Rd,Ri,Ro,Xd,Xi,Xo,Bd,Bi,Bo,Gd,Gi,Go,pocetak,kraj)
values (4001,1,20,2,null,0.209,0.209,0.75,0.117,0.117,0.112,0.116,0.116,0.695,0,0,0,2001,5001)

insert into deonica (iddeonica,duzina,Vn,tip_voda,presek,Rd,Ri,Ro,Xd,Xi,Xo,Bd,Bi,Bo,Gd,Gi,Go,pocetak,kraj)
values (4002,2,20,2,null,0.209,0.209,0.75,0.117,0.117,0.112,0.116,0.116,0.695,0,0,0,5001,5002)

insert into deonica (iddeonica,duzina,Vn,tip_voda,presek,Rd,Ri,Ro,Xd,Xi,Xo,Bd,Bi,Bo,Gd,Gi,Go,pocetak,kraj)
values (4003,2.5,20,2,null,0.209,0.209,0.75,0.117,0.117,0.112,0.116,0.116,0.695,0,0,0,5002,5007)

insert into deonica (iddeonica,duzina,Vn,tip_voda,presek,Rd,Ri,Ro,Xd,Xi,Xo,Bd,Bi,Bo,Gd,Gi,Go,pocetak,kraj)
values (4004,2,20,2,null,0.209,0.209,0.75,0.117,0.117,0.112,0.116,0.116,0.695,0,0,0,2001,5003)

insert into deonica (iddeonica,duzina,Vn,tip_voda,presek,Rd,Ri,Ro,Xd,Xi,Xo,Bd,Bi,Bo,Gd,Gi,Go,pocetak,kraj)
values (4005,3,20,2,null,0.209,0.209,0.75,0.117,0.117,0.112,0.116,0.116,0.695,0,0,0,5003,5004)

insert into deonica (iddeonica,duzina,Vn,tip_voda,presek,Rd,Ri,Ro,Xd,Xi,Xo,Bd,Bi,Bo,Gd,Gi,Go,pocetak,kraj)
values (4006,3,20,2,null,0.209,0.209,0.75,0.117,0.117,0.112,0.116,0.116,0.695,0,0,0,5004,5007)

insert into deonica (iddeonica,duzina,Vn,tip_voda,presek,Rd,Ri,Ro,Xd,Xi,Xo,Bd,Bi,Bo,Gd,Gi,Go,pocetak,kraj)
values (4007,2.5,20,2,null,0.209,0.209,0.75,0.117,0.117,0.112,0.116,0.116,0.695,0,0,0,2001,5005)

insert into deonica (iddeonica,duzina,Vn,tip_voda,presek,Rd,Ri,Ro,Xd,Xi,Xo,Bd,Bi,Bo,Gd,Gi,Go,pocetak,kraj)
values (4008,1,20,2,null,0.209,0.209,0.75,0.117,0.117,0.112,0.116,0.116,0.695,0,0,0,5005,5006)

insert into deonica (iddeonica,duzina,Vn,tip_voda,presek,Rd,Ri,Ro,Xd,Xi,Xo,Bd,Bi,Bo,Gd,Gi,Go,pocetak,kraj)
values (4009,1,20,2,null,0.209,0.209,0.75,0.117,0.117,0.112,0.116,0.116,0.695,0,0,0,5006,5007)

insert into deonica (iddeonica,duzina,Vn,tip_voda,presek,Rd,Ri,Ro,Xd,Xi,Xo,Bd,Bi,Bo,Gd,Gi,Go,pocetak,kraj)
values (4010,1,20,2,null,0.209,0.209,0.75,0.117,0.117,0.112,0.116,0.116,0.695,0,0,0,5005,5004)

insert into sabirnica (idsabirnica,Vn,idcvora)
values (1,20,2001)

insert into sabirnica (idsabirnica,Vn,idcvora)
values (2,20,2001)

insert into sabirnica (idsabirnica,Vn,idcvora)
values (3,20,5001)

insert into sabirnica (idsabirnica,Vn,idcvora)
values (4,0.4,5001)

insert into sabirnica (idsabirnica,Vn,idcvora)
values (5,20,5002)

insert into sabirnica (idsabirnica,Vn,idcvora)
values (6,0.4,5002)

insert into sabirnica (idsabirnica,Vn,idcvora)
values (7,20,5003)

insert into sabirnica (idsabirnica,Vn,idcvora)
values (8,0.4,5003)

insert into sabirnica (idsabirnica,Vn,idcvora)
values (9,20,5004)

insert into sabirnica (idsabirnica,Vn,idcvora)
values (10,0.4,5004)

insert into sabirnica (idsabirnica,Vn,idcvora)
values (11,20,5005)

insert into sabirnica (idsabirnica,Vn,idcvora)
values (12,0.4,5005)

insert into sabirnica (idsabirnica,Vn,idcvora)
values (13,20,5006)

insert into sabirnica (idsabirnica,Vn,idcvora)
values (14,0.4,5006)

insert into sabirnica (idsabirnica,Vn,idcvora)
values (15,20,5007)

insert into sabirnica (idsabirnica,Vn,idcvora)
values (16,0.4,5007)

insert into potrosac(idpotrosaca,tip,Vn,S,maksigraf,dijagram,idcvora)
values (1,2,0.4,null,null,null,5001)

insert into potrosac(idpotrosaca,tip,Vn,S,maksigraf,dijagram,idcvora)
values (2,2,0.4,null,null,null,5002)

insert into potrosac(idpotrosaca,tip,Vn,S,maksigraf,dijagram,idcvora)
values (3,1,0.4,null,null,null,5003)

insert into potrosac(idpotrosaca,tip,Vn,S,maksigraf,dijagram,idcvora)
values (4,1,0.4,null,null,null,5004)

insert into potrosac(idpotrosaca,tip,Vn,S,maksigraf,dijagram,idcvora)
values (5,2,0.4,null,null,null,5005)

insert into potrosac(idpotrosaca,tip,Vn,S,maksigraf,dijagram,idcvora)
values (6,2,0.4,null,null,null,5006)

insert into potrosac(idpotrosaca,tip,Vn,S,maksigraf,dijagram,idcvora)
values (7,1,0.4,null,null,null,5007)

insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6001,1000,20,0.4,5,8.55,2.2,0.8,5001)

insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6002,1000,20,0.4,5,8.55,2.2,0.8,5001)

insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6003,1000,20,0.4,5,8.55,2.2,0.8,5002)

insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6004,1000,20,0.4,5,8.55,2.2,0.8,5003)

insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6005,1000,20,0.4,5,8.55,2.2,0.8,5003)

insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6006,1000,20,0.4,5,8.55,2.2,0.8,5003)

insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6007,1000,20,0.4,5,8.55,2.2,0.8,5003)

insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6008,1000,20,0.4,5,8.55,2.2,0.8,5004)

insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6009,1000,20,0.4,5,8.55,2.2,0.8,5004)

insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6010,1000,20,0.4,5,8.55,2.2,0.8,5005)

insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6011,1000,20,0.4,5,8.55,2.2,0.8,5006)

insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6012,1000,20,0.4,5,8.55,2.2,0.8,5007)

insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6013,1000,20,0.4,5,8.55,2.2,0.8,5007)

insert into transformator_v (idtrans_v,Sp,Ss,St,Vp,Vs,Vt,Pcups,Pcupt,Pcust,Pfe,Jfe,uk12,uk13,uk23,idcvora)
values (3001,31500,31500,10500,110,20,10,131,0,0,40,0.4,12.7,9.19,2.4,2001)

insert into transformator_v (idtrans_v,Sp,Ss,St,Vp,Vs,Vt,Pcups,Pcupt,Pcust,Pfe,Jfe,uk12,uk13,uk23,idcvora)
values (3002,31500,31500,10500,110,20,10,131,0,0,40,0.4,12.7,9.19,2.4,2001)

insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (1,20,1,2001)

insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (2,20,1,2001)

insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (3,20,1,2001)

insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (4,20,1,2001)

insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (5,20,2,5001)

insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (6,20,2,5001)

insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (7,20,2,5002)

insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (8,20,2,5002)

insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (9,20,2,5003)

insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (10,20,2,5003)

insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (11,20,2,5004)

insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (12,20,2,5004)

insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (13,20,2,5004)

insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (14,20,2,5007)

insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (15,20,2,5007)

insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (16,20,2,5007)

insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (17,20,2,5005)

insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (18,20,2,5005)

insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (19,20,2,5005)

insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (20,20,2,5006)

insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (21,20,2,5006)

E sad moj zadatak je skoro celi da napravim ovo sto sam napravio. I to funkcionise. Ja sada treba da jos napisem kod u C++ koji na osnovu unetog ID deonice (Na osnovu deonice treba da odredim prvo spojno polje, tacnije pocetak ). Ako neko moze da pomogne bio bi mu zahvalan moram to do prekosutra da zavrsim. Ja bi znao da je cist C++ ali ne znam kako da poveze ovu tabelu .

Hvala svima

Odgovor na temu