Author Topic: Databazove systemy  (Read 109753 times)

DeNaTuReMaN

  • Sr. Member
  • ****
  • Posts: 331
  • Achab
    • View Profile
Re: Databazove systemy
« Reply #200 on: 18.11.2008, 00:10:44 »
Neviete odkial splasim subor Oracle.DataAccess.dll lebo chcem pridat referenciu k projektu vo visual studio ... a ta kniznica nebola obsiahnuta v instalacii oraclu podla moodle.
V nedelu na obed budu krky

ppt

  • Hero Member
  • *****
  • Posts: 935
    • View Profile
Re: Databazove systemy
« Reply #201 on: 18.11.2008, 00:28:03 »
Neviete odkial splasim subor Oracle.DataAccess.dll lebo chcem pridat referenciu k projektu vo visual studio ... a ta kniznica nebola obsiahnuta v instalacii oraclu podla moodle.
Ta kniznica by sa mala nachadzat aj pri tom klientovi z bodvy. Hodil som ti to sem: http://kacicka.com/~ppt/Oracle.DataAccess.dll

DeNaTuReMaN

  • Sr. Member
  • ****
  • Posts: 331
  • Achab
    • View Profile
Re: Databazove systemy
« Reply #202 on: 18.11.2008, 00:32:22 »
Vdaka za upload pomohlo ;)
V nedelu na obed budu krky

ppt

  • Hero Member
  • *****
  • Posts: 935
    • View Profile
Re: Databazove systemy
« Reply #203 on: 18.11.2008, 00:33:35 »
za malo :)

Payne

  • Sr. Member
  • ****
  • Posts: 408
    • View Profile
Re: Databazove systemy
« Reply #204 on: 18.11.2008, 01:54:31 »
Vie mi dakto povedat preco mi nejde nasledovna procedura ??? Nejde, resp sa za poslednym prikazom neukonci a akokeby som mal este nejaky ukoncovaci prikaz napisat...

Code: [Select]
CREATE OR REPLACE PROCEDURE upd_auto (ks IN NUMBER, aspz IN VARCHAR)
  IS
  BEGIN
    DECLARE cena NUMBER;
    BEGIN
      SELECT cena_sluzby INTO cena FROM sluzba WHERE kod_sluzby = ks;
      UPDATE auto SET celkova_suma = celkova_suma + cena WHERE spz = aspz;
    END;
  END upd_auto;


puq

  • Hero Member
  • *****
  • Posts: 4065
    • View Profile
Re: Databazove systemy
« Reply #205 on: 18.11.2008, 02:51:18 »
nieco tam treba dat :) ale nepamatam co :D mozno "/"

staninko

  • Jr. Member
  • **
  • Posts: 53
    • View Profile
Re: Databazove systemy
« Reply #206 on: 18.11.2008, 03:01:30 »
ked robim zadanie v php musi to byt objektovo?

lada

  • Sr. Member
  • ****
  • Posts: 319
  • life is FEI... ehm hell xD
    • View Profile
Re: Databazove systemy
« Reply #207 on: 18.11.2008, 03:09:28 »
u nas tj. ing Peter Bratru, mozme aj php(neobjektovo), ale som pocul, ze nektore skupiny musia objektovo, tak nefim

Viper_No1

  • Sr. Member
  • ****
  • Posts: 285
    • View Profile
Re: Databazove systemy
« Reply #208 on: 18.11.2008, 04:22:14 »
s LM musi byt php objektovo...
3 zasady do zivota:
"Skutocne mudry muz nikdy neskace roznozku cez chrbat jednorozca."
"Nepi rano kavu. Nebudes moct cele doobedie zaspat."
"Mylit sa je ludske, ale naozaj nieco zamotat je mozne len pomocou pocitaca."
+bonus: "Nikdy nejedz zlty sneh!"

Agamemnon

  • Hero Member
  • *****
  • Posts: 2942
  • Per aspera ad Astra
    • View Profile
Re: Databazove systemy
« Reply #209 on: 18.11.2008, 05:24:43 »
php objektové je jeden z najväčších omylov, aké kedy boli :D
All code is crap.

42

Ing. nemtom

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 7709
  • lofr dyslektik
    • View Profile
Re: Databazove systemy
« Reply #210 on: 18.11.2008, 05:26:04 »
java suxxx
brix will be shat

DeNaTuReMaN

  • Sr. Member
  • ****
  • Posts: 331
  • Achab
    • View Profile
Re: Databazove systemy
« Reply #211 on: 18.11.2008, 14:18:21 »
Vie mi dakto povedat preco mi nejde nasledovna procedura ??? Nejde, resp sa za poslednym prikazom neukonci a akokeby som mal este nejaky ukoncovaci prikaz napisat...

Code: [Select]
CREATE OR REPLACE PROCEDURE upd_auto (ks IN NUMBER, aspz IN VARCHAR)
  IS
  BEGIN
    DECLARE cena NUMBER;
    BEGIN
      SELECT cena_sluzby INTO cena FROM sluzba WHERE kod_sluzby = ks;
      UPDATE auto SET celkova_suma = celkova_suma + cena WHERE spz = aspz;
    END;
  END upd_auto;


Mne to zbehlo v takom tvare, A dal si za tym
.
run

//A ked uz pisem , tak vcera som sa nevedel vysomarit s triedami DataAdapter, DataSet, DataGridView atd, nepozna na to niekto nejaky pochopitelny material :), ide mi o to hodit kazdu tabulku do jedneho datagrid, tym bude vyrieseni jednou ranou insert,update,drop zaznamov.
« Last Edit: 18.11.2008, 14:25:00 by DeNaTuReMaN »
V nedelu na obed budu krky

sikik

  • Full Member
  • ***
  • Posts: 170
    • View Profile
Re: Databazove systemy
« Reply #212 on: 18.11.2008, 22:09:40 »
to fakt? no tak LM nebud taky. Niektory nemame este spraveny predmet objektovo-orientovane programovanie. Ako mame vediet objektovo programovat. Prosím, že stačí obyčajné php?
If you're one in a million, there are six thousand people exactly like you.

Computers make very fast, very accurate mistakes.

sikik

  • Full Member
  • ***
  • Posts: 170
    • View Profile
Re: Databazove systemy
« Reply #213 on: 18.11.2008, 22:35:49 »
To mame dnes vobec cviko ked LM sa dajak nehlasi? :j_laugh:
If you're one in a million, there are six thousand people exactly like you.

Computers make very fast, very accurate mistakes.

staninko

  • Jr. Member
  • **
  • Posts: 53
    • View Profile
Re: Databazove systemy
« Reply #214 on: 18.11.2008, 22:39:15 »
tiez by som bol radsej keby to php nemuselo byt objektovo

kOsTi

  • Hero Member
  • *****
  • Posts: 12765
    • View Profile
    • pretaktovanie.sk
Re: Databazove systemy
« Reply #215 on: 18.11.2008, 22:50:15 »
LM vravel ze musi byt a jak ho "poznam" tak to nezmeni :P
:trestac:

Agamemnon

  • Hero Member
  • *****
  • Posts: 2942
  • Per aspera ad Astra
    • View Profile
Re: Databazove systemy
« Reply #216 on: 18.11.2008, 23:27:19 »
aj keby si ten predmet mal, tak ti to s objektovým php nepomôže...

edit: imo... to je len snaha nútiť vás robiť niečo, čo je nezmysel... :) lebo pri tom, aké tam sú zadania, tak je od veci na to použiť objekty - hlavne ak je to web... na to, že tam urobím 4 easy skripty, tak na to fakt nepotrebujem objekty
« Last Edit: 18.11.2008, 23:29:34 by Agamemnon »
All code is crap.

42

Ing. nemtom

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 7709
  • lofr dyslektik
    • View Profile
Re: Databazove systemy
« Reply #217 on: 19.11.2008, 00:26:52 »
LM-a vzrusuje ked moze tyrat mladsich a potom s latkom si rozpravaju pribehy kto viac ludi dojebal
brix will be shat

Sooloni

  • Sr. Member
  • ****
  • Posts: 328
    • View Profile
Re: Databazove systemy
« Reply #218 on: 19.11.2008, 03:00:21 »
u bude zajtra pisomka s LM ci ne?

puq

  • Hero Member
  • *****
  • Posts: 4065
    • View Profile
Re: Databazove systemy
« Reply #219 on: 19.11.2008, 03:29:00 »
LM-a vzrusuje ked moze tyrat mladsich a potom s latkom si rozpravaju pribehy kto viac ludi dojebal

looooooool :D poriadna palka :D

LM

  • Hero Member
  • *****
  • Posts: 627
    • View Profile
Re: Databazove systemy
« Reply #220 on: 19.11.2008, 03:31:36 »
jasne ze nie :) v 10. tyzdni
Hardware: the parts of a computer that can be kicked.
- Jeff Pesis

   Who's General Failure and why's he reading my disk?
- Anonymous

   Internet is so big, so powerful and pointless that for some people it is a complete substitute for life.
- Andrew Brown

Matolator

  • Newbie
  • *
  • Posts: 17
    • View Profile
Re: Databazove systemy
« Reply #221 on: 20.11.2008, 05:37:00 »
nemate niekto problemy s pripojenim na databazu v c#??? UNABLE TO LOAD oraOps10.dll

diacon.mex

  • Sr. Member
  • ****
  • Posts: 331
  • davaj pozor !
    • View Profile
Re: Databazove systemy
« Reply #222 on: 20.11.2008, 05:47:21 »
nemate niekto problemy s pripojenim na databazu v c#??? UNABLE TO LOAD oraOps10.dll

asi pouzivas ine prikazy na pripojovanie... skus pozriet asi v 9. alebo 10. tyzdni na moodle-i, tam je to napojenie na databazu napisane ;)

(dost skoro to tam dali... mohli rovno v 12. tyzdni)
« Last Edit: 20.11.2008, 07:06:46 by diacon.mex »

sikik

  • Full Member
  • ***
  • Posts: 170
    • View Profile
Re: Databazove systemy
« Reply #223 on: 20.11.2008, 06:12:14 »
Takze LM. Mohol by si napisat svoje stanovisko co sa tyka php na zadanie u teba? (objektovo ci neobjektovo) Vzhladom na dost velky pocet studentov ktory OP urobene nemaju. Dakujem. :drink:  ak: :beer1:
If you're one in a million, there are six thousand people exactly like you.

Computers make very fast, very accurate mistakes.

Payne

  • Sr. Member
  • ****
  • Posts: 408
    • View Profile
Re: Databazove systemy
« Reply #224 on: 20.11.2008, 19:38:04 »
Chcem sa spytat ludi, co budu robit zadanie z DBS v Jave, resp. v prostredi NetBeans (6.1, 6.5) ci im funguje nacitanie JDBC Oracle drivera, resp. po nacitani ci sa mu ide pripojit hocikam... Bo ja to dajak stale nemozem rozbehat...