/*

* This sample shows how to insert data in a table.

*/

// You need to import the java.sql package to use JDBC

import java.sql.*;

class InsertExample

{

public static void main (String args [])

throws SQLException

{

// Load the Oracle JDBC driver

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

String url = "jdbc:oracle:oci8:@";

try {

String url1 = System.getProperty("JDBC_URL");

if (url1 != null)

url = url1;

} catch (Exception e) {

// If there is any security exception, ignore it

}

// Connect to the database

Connection conn =

DriverManager.getConnection (url, "scott", "tiger");

// Prepare a statement to cleanup the emp table

Statement stmt = conn.createStatement ();

try

{

stmt.execute ("delete from EMP where EMPNO = 1500");

}

catch (SQLException e)

{

// Ignore an error here

}

try

{

stmt.execute ("delete from EMP where EMPNO = 507");

}

catch (SQLException e)

{

// Ignore an error here too

}

// Close the statement

stmt.close();

// Prepare to insert new names in the EMP table

PreparedStatement pstmt =

conn.prepareStatement ("insert into EMP (EMPNO, ENAME) values (?, ?)");

// Add LESLIE as employee number 1500

pstmt.setInt (1, 1500); // The first ? is for EMPNO

pstmt.setString (2, "LESLIE"); // The second ? is for ENAME

// Do the insertion

pstmt.execute ();

// Close the statement

pstmt.close();

// Close the connecion

conn.close();

}

}