Advertisement
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","scott", "tiger");
Statement stmt = con.createStatement();
int count = stmt.executeUpdate(query);
con.close();
Advertisement
//Inserting values in database table using JDBC
import java.sql.*;
class A
{
public static void main(String... ar)
{
try
{
String query1 = "INSERT INTO MyTable (ID, FirstName, LastName, Age)"
+ "VALUES ('1', 'Tom', 'Hanks', '61 ')";
String query2 = "INSERT INTO MyTable (ID, FirstName, LastName, Age)"
+ "VALUES ('2', 'Johnny', 'Depp', '54')";
String query3 = "INSERT INTO MyTable (ID, FirstName, LastName, Age)"
+ "VALUES ('3', 'Leo', 'Dicaprio', '42')";
//Loading and registering Oracle database thin driver
Class.forName("oracle.jdbc.driver.OracleDriver");
//Creating a connection between Java program and Oracle database.
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","scott", "tiger");
//Creating a Statement object to excute SQL statements
Statement stmt = con.createStatement();
//Executing a SQL INSERT query using executeUpdate() method of Statement object.
int count = stmt.executeUpdate(query1);
System.out.println("Number of rows updated in database = " + count);
//Executing next SQL INSERT query using executeUpdate() method of Statement object.
count = stmt.executeUpdate(query2);
System.out.println("Number of rows updated in database = " + count);
//Executing next SQL INSERT query using executeUpdate() method of Statement object.
count = stmt.executeUpdate(query3);
System.out.println("Number of rows updated in database = " + count);
}
catch(Exception e)
{
System.out.println(e);
}
}//main() defintion ends
}//class definition ends
Number of rows updated in database = 1
Number of rows updated in database = 1
Number of rows updated in database = 1
ID | FirstName | LastName | Age |
---|---|---|---|
1 | Tom | Hanks | 61 |
2 | Johnny | Depp | 54 |
3 | Brad | Pitt | 53 |
Advertisement
Advertisement
Please check our latest addition
C#, PYTHON and DJANGO
Advertisement