전문 번역가, 번역 회사, 웹 페이지 및 자유롭게 사용할 수 있는 번역 저장소 등을 활용합니다.
?php print "html pre"; $db = ""; $c1 = ocilogon("scott" ,"tiger",$db); $c2 = ocilogon("scott" ,"tiger",$db); function create_table($conn) {$stmt = ociparse($conn ,"create table scott.hallo (test varchar2(64))"); ociexecute($stmt); echo $conn. "tabuľka vytvorená\n\n";} function drop_table($conn) {$stmt = ociparse($conn ,"drop table scott.hallo"); ociexecute($stmt); echo $conn." tabuľka zmazaná\n\n";} function insert_data($conn) {$stmt = ociparse($conn ,"insert into scott.hallo values('$conn '_bar_ _bar_' '_bar_ _bar_ to_char(sysdate ,'dd-mon-yy hh24:mi:ss'))"); ociexecute($stmt,oci_default); echo $conn. "vložené do tabuľky hallo\n\n";} function delete_data($conn) {$stmt = ociparse($conn ,"delete from scott.hallo"); ociexecute($stmt,oci_default); echo $conn." zmazané s tabuľky hallo\n\n";} function commit($conn) {ocicommit($conn); echo $conn. "spravený commit\n\n";} function rollback($conn) {ocirollback($conn); echo $conn." spravený rollback\n\n";} function select_data($conn) {$stmt = ociparse($conn ,"select * from scott.hallo"); ociexecute($stmt,oci_default); echo $conn ."----selektovanie\n\n"; while (ocifetch($stmt)) echo $conn. "".ociresult($stmt ,"test")." \n\n"; echo $conn ."----ok\n\n";} create_table($c1); insert_data($c1); / / vložený riadok pomocou c1 insert_data($c2); / / vložený riadok pomocou c2 select_data($c1); / / vrátené sú oba vložené riadky select_data($c2); rollback($c1); / / spravený rollback pomocou c1 select_data($c1); / / oba vložené riadky boli rollback-nuté select_data($c2); insert_data($c2); / / vložený riadok pomocou c2 commit($c2); / / spravený commit pomocou c2 select_data($c1); / / výsledok je vložený riadok pomocou c2 delete_data($c1); / / zmazané všetky záznamy pomocou c1 select_data($c1); / / vrátené nie sú žiadne riadky select_data($c2); / / vrátené nie sú žiadne riadky commit($c1); / / spravený commit pomocou c1 select_data($c1); / / vrátené nie sú žiadne riadky select_data($c2); / / vrátené nie sú žiadne riadky drop_table($c1); print "/ pre / html";?
?php print "html pre"; $db = ""; $c1 = ocilogon("scott" ,"tiger",$db); $c2 = ocilogon("scott" ,"tiger",$db); function create_table($conn) {$stmt = ociparse($conn ,"create table scott.hallo (test varchar2(64))"); ociexecute($stmt); echo $conn. "created table\n\n";} function drop_table($conn) {$stmt = ociparse($conn ,"drop table scott.hallo"); ociexecute($stmt); echo $conn." dropped table\n\n";} function insert_data($conn) {$stmt = ociparse($conn ,"insert into scott.hallo values('$conn '_bar_ _bar_' '_bar_ _bar_ to_char(sysdate ,'dd-mon-yy hh24:mi:ss'))"); ociexecute($stmt,oci_default); echo $conn. "inserted hallo\n\n";} function delete_data($conn) {$stmt = ociparse($conn ,"delete from scott.hallo"); ociexecute($stmt,oci_default); echo $conn." deleted hallo\n\n";} function commit($conn) {ocicommit($conn); echo $conn. "commited\n\n";} function rollback($conn) {ocirollback($conn); echo $conn." rollback\n\n";} function select_data($conn) {$stmt = ociparse($conn ,"select * from scott.hallo"); ociexecute($stmt,oci_default); echo $conn ."----selecting\n\n"; while (ocifetch($stmt)) echo $conn. "".ociresult($stmt ,"test")." \n\n"; echo $conn ."----done\n\n";} create_table($c1); insert_data($c1); / / insertion d'une ligne avec c1 insert_data($c2); / / insertion d'une ligne avec c2 select_data($c1); / / les résultats des deux insertions sont retournés select_data($c2); rollback($c1); / / annulation avec c1 select_data($c1); / / les résultats des deux insertions sont annulés select_data($c2); insert_data($c2); / / insertion d'une ligne avec c2 commit($c2); / / validation avec using c2 select_data($c1); / / le résultat de c2 est retourné delete_data($c1); / / effacement de toutes les lignes avec c1 select_data($c1); / / aucune ligne n'est retournée select_data($c2); / / aucune ligne n'est retournée commit($c1); / / validation avec c1 select_data($c1); / / aucune ligne n'est retournée select_data($c2); / / aucune ligne n'est retournée drop_table($c1); print "/ pre / html";?