Qhov wikiHow qhia koj yuav ua li cas txuas rau Oracle Database hauv Java. Txhawm rau txuas mus rau Java database, koj xub xav tau chav kawm tsav tsheb, URL rau oracle database, thiab tus username thiab password.
Cov kauj ruam
Kauj Ruam 1. Rub tawm chav kawm tsav tsheb los ntawm Oracle lub vev xaib
Koj tuaj yeem rub tawm "ojdbc6.jar" lossis "ojdbc7.jar".
Kauj Ruam 2. Ntaus cov cai hauv qab no:
Txoj cai no teev cov txheej txheem Java yuav hla mus. Ua ntej nws yuav tshawb rau chav kawm tsav tsheb, tom qab ntawd nws yuav txuas mus rau Oracle database URL, tom qab ntawd nws yuav txuas rau lub database.
ntshuam java.sql. DriverManager; ntshuam java.sql. Connection; ntshuam java.sql. SQLException;
Kauj Ruam 3. Teem chav kawm
Ntaus cov cai hauv qab no los teeb tsa chav kawm.
chav kawm OracleConnection {
Kauj Ruam 4. Tsim kab lus ntawm kab lus
Txoj cai no yuav pib kab lus ntawm kab lus uas yuav qhia rau tus neeg siv paub tias txoj haujlwm tau tshawb nrhiav rau chav kawm tsav tsheb, thiab tom qab ntawd yuav qhia rau tus neeg siv paub yog pom chav kawm tsav tsheb, lossis tsis pom chav kawm tsav tsheb. Ntaus cov cai hauv qab no:
pej xeem zoo li qub tsis muaj qhov tseem ceeb (Txoj hlua argv) {
Kauj Ruam 5. Tsim Cov Lus Tshawb Nrhiav
Cov cai hauv qab no yuav qhia rau tus neeg siv paub qhov program tau tshawb nrhiav rau chav kawm tsav tsheb. Qhov "System.out.println ();" yog siv los tsim cov nqe lus. Ntaus cov cai hauv qab no.
System.out.println ("Tshawb nrhiav rau Oracle JDBC tus tsav tsheb …");
Kauj Ruam 6. Tshawb nrhiav Java database tsav tsheb
Cov cai hauv qab no yuav qhia rau txoj haujlwm txhawm rau tshawb nrhiav tus tsav tsheb.
sim {Class.forName ("oracle.jdbc.driver. OracleDriver"); }
Kauj Ruam 7. Tsim cov lus xa rov qab yog tias tsis muaj tus tsav tsheb database
Yog tias qhov program tsis tuaj yeem nrhiav tus tsav tsheb database, cov cai hauv qab no yuav tsim cov lus uas qhia rau tus neeg siv paub tias lawv xav tau tus tsav tsheb database. Ntaus cov cai hauv qab no:
ntes (ClassNotFoundException e) {System.out.println ("Oracle JDBC tus tsav tsheb tsis pom!"); e.printStackTrace (); rov qab; }
Kauj Ruam 8. Tsim cov lus hais rov qab yog pom cov tsav tsheb hauv database
Cov cai hauv qab no yuav qhia rau tus neeg siv paub qhov program tau nyob ntawm tus tsav tsheb database.
System.out.println ("Oracle JDBC Tsav Tsheb Sau Npe.");
Kauj Ruam 9. Txuas mus rau Oracle database
Cov cai hauv qab no yuav pib txheej txheem ntawm kev txuas mus rau Oracle database.
Kev sib txuas sib txuas = tsis muaj dab tsi;
Kauj ruam 10. Ntxiv URL database, lub npe siv, thiab tus password
Cov cai hauv qab no yuav nkag mus rau lub hauv paus URL, lub npe siv thiab tus password. Koj yuav tsum sau cov txiaj ntsig no kom raug hauv cov cai. Ib qhov url yog "jdbc: oracle: nyias: @localhost: 1521: xe". Lub npe siv yog "system" los ntawm lub neej ntawd, thiab tus password tau teeb tsa los ntawm tus neeg siv thaum koj teeb tsa lub oracle database. Ntaus cov cai hauv qab no nrog qhov tseeb raug:
sim {txuas = DriverManager.getConnection ("jdbc: oracle: nyias: @localhost: 1521: xe", "username", "password"); }
Kauj Ruam 11. Rov qab cov lus yuam kev yog lub npe siv thiab tus lej zais tsis raug
Ntaus cov cai hauv qab no kom rov xa cov lus yuam kev yog tias URL, lub npe siv, lossis tus lej zais tsis raug.
ntes (SQLException e) {System.out.println ("Kev Txuas Tsis Tau! Txheeb xyuas lub npe thiab tus lej zais"); e.printStackTrace (); rov qab; }
Kauj Ruam 12. Tsim cov ntaub ntawv txuas cov ntaub ntawv sib txuas
Ntaus cov cai hauv qab no kom qhia rau tus neeg siv paub thaum kev txuas mus rau lub database tau ua tiav:
yog (kev sib txuas! = tsis muaj) {System.out.println ("Kev sib txuas rau cov ntaub ntawv ua tiav"); }
Kauj Ruam 13. Tsim cov lus yuam kev txuas
Yog tias qhov program tsis tuaj yeem txuas rau lub database vim li cas, cov cai hauv qab no yuav rov qab cov lus uas qhia rau tus neeg siv paub tias muaj qhov ua yuam kev. Ntaus cov cai hauv qab no:
lwm tus {System.out.println ("Tsis tuaj yeem txuas rau lub database."); }
Kauj Ruam 14. Kaw txoj hlua
Ntaus tus "}" ntawm kab kawg kom kaw txoj kab lus.
Kauj Ruam 15. Kaw chav kawm
Ntaus qhov kawg "}" hauv qab ntawm nplooj ntawv kom kaw cov khoom hauv chav kawm. Qhov no xaus qhov chaws. Koj tag nrho cov cai yuav tsum zoo li qhov no:
ntshuam java.sql. DriverManager; ntshuam java.sql. Connection; ntshuam java.sql. SQLException; chav kawm OracleConnection {pej xeem zoo li qub tsis muaj qhov tseem ceeb (Txoj hlua argv) {System.out.println ("Tshawb nrhiav rau Oracle JDBC tus tsav tsheb …")); sim {Class.forName ("oracle.jdbc.driver. OracleDriver"); } ntes (ClassNotFoundException e) {System.out.println ("Oracle JDBC tus tsav tsheb tsis pom!"); e.printStackTrace (); rov qab; } System.out.println ("Oracle JDBC Driver tau sau npe."); Kev sib txuas sib txuas = tsis muaj dab tsi; sim {txuas = DriverManager.getConnection ("jdbc: oracle: nyias: @localhost: 1521: xe", "username", "password"); } ntes (SQLException e) {System.out.println ("Kev sib txuas tsis tau tiav! Txheeb xyuas lub npe thiab tus password"); e.printStackTrace (); rov qab; } yog (kev sib txuas! = null) {System.out.println ("Kev sib txuas rau cov ntaub ntawv ua tiav"); } lwm {System.out.println ("Tsis tuaj yeem txuas rau lub database."); }}}