qosaenviro.blogg.se

Here we are using Prepared statement and parameterized query that discussed in previous topic. We can insert data into table using Java application using the JDBC. ResultSet rs=s.executeQuery("select * from Student") //executing statement Now we are fetching those records using JDBC Java application.Ĭlass.forName("") Ĭonnection con = s=con.createStatement() //creating statement In the above example, we inserted two records using SQL command. Here we are inserting adam and abhi named two rows. This table has two columns: sid and sname.Ĭreate table Student(sid number(10),sname varchar2(20)) Īfter creating the table now insert two records into table using the below sql command. Use the below SQL command to create a table Student into oracle database. Let's see programs for performing simple operations like create, insert and select on database tables. For other version of Oracle you will be require to do some small changes in the Connection URL. NOTE: Here we are discussing about Oracle 10g as database.

Copy the jar file into C:\Program Files\Java\jre7\lib\ext folder.

Loading jar file: To connect your java application with Oracle, you will also need to load ojdbc14.jar file.You will also require Username and Password of your Oracle Database Server for creating connection. Create Connection: For creating a connection you will need a Connection URL.Load Driver Class: The Driver Class for oracle database is and Class.forName("") method is used to load the driver class for Oracle database.To connect a Java application with Oracle database using Thin Driver. Connecting to Access using Type-1 Driver.Method Overriding with Exception Handling.Difference between Classes And Interface.