Oracle database connection with netbeans

                                oracle database connection 

                                           with net beans

    

let's go for database connection:

this step after installation of oracle .

step 1:-

         

         open net-beans.

step 2:-

         click on "window" see this below 

        
Step 3:-
       click on "Services"
  
Step 4:- 
        Right click on "databases"
   
Step 5:-    
        go for new connection

Step 6:- 
       click on "Driver"

Step 7:-
         click on "Oracle thin"
            
Step 8:-
          then click on "add button"

Step 9:-
         give the path of ojdbc.jar  file , you have to add

Step 10:-
         after adding go for "next button"

    Step 11:-
                fill the "username"
                      and "password"

   Step 12:-
           go for "Next button"

   Step 13:- for verification
               go on service 
                         and click on (+) sign just beside of database
                                    then you see your connection.

 see here my connection is showing......                                     enjoy with data base.





                               thank you .....best of luck

        

       

       

                   

connection of the database with oracle (right information content)

                               database connectivity

• with oracle

• with sql(structured query language)

with oracle database connectivity:

first for windows download the oracle 10g express edition   download from here

oracle site click here to download.

after the downloading the file install it in your computer.

then after we have to download the driver of the ojdbc14.jar file   driver .

download the driver from here ...click here to download.

step 1. 

after installation the oracle10g software a folder is created in the c drive:

see the pic folder is formed of name oraclexe.

step 2:-

now copy the ojdbc14 driver form the download folder ,and paste inside the oraclexe folder in c drive.see in this given pic.

step 3:-

      go to c drive:

     go to  program file:

     

      go to java folder :

     this folder is generated after installation of the jdk file .

     you see in this pic 

   

     

step 4:

1.  open java folder 
2. there is two folder name are JDK and JRE folder 
3. go to JDK
4. inside the JDK a folder whose name JRE folder
5. open "jre" inside this folder LIB folder is present
6. inside the LIB a folder is present whose name is EXT folder.
7. inside the "EXT" folder paste the OJDBC14.JAR file ..
8.  goto point 2 .
9. there are two folder jdk and jre then go to jre and 
10. then inside jre a folder lib folder are there 
11. and inside the  'lib' a "ext" folder  present 
12. ojdbc14.jar  paste inside the "ext" folder. 

goto JDK :

 goto JRE file :

in side the JRE folder one LIB  folder are present  open it:

after open the LIB folder a EXT folder are present :

inside  the EXT folder  paste the ojdbc14 inside the folder ....

THEN go back to  java and there in A jre folder and jdk folder ,

go for jre , and inside the jre LIB folder are there which contain EXT folder then paste the ojdbc14 inside the EXT folder;

now see the path of the folder:

C:\Program Files\Java\jre1.8.0_60\lib\ext;

inside the EXT folder paste the ojdbc14;

this is over to set the path of the oracle data base in window ,

for next post we will go for program to run the database see how to get value from the users