JDBC - Insert

This chapter demonstrates how to insert records into the NAMECARD table using JDBC. Our goal is to execute the following insert statement.

INSERT INTO NAMECARD VALUES
(
  SEQ_NAMECARD_NO.NEXTVAL,
  'Alison',
  '011-0000-0000',
  'alison@ggmail.org',
  'Google Inc'
);

Complete the main method of NamecardInsert.java by referring to the following JDBC programming order.

  1. Loading a JDBC Driver
  2. Getting a Connection
  3. Execute SQL
  4. [If the SQL statement is a select statement, use a ResultSet to process the data.]
  5. Returning Resources
NamecardInsert.java
package net.java_school.jdbc.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class NamecardInsert {
	static final String URL = "jdbc:oracle:thin:@127.0.0.1:1521:XE";
	static final String USER = "scott";
	static final String PASS = "tiger";
	
	public static void main(String[] args) {
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		
		Connection con = null;
		Statement stmt = null;
		String sql = "INSERT INTO NAMECARD VALUES " +
			"(SEQ_NAMECARD_NO.NEXTVAL," +
			"'Alison'," +
			"'011-0000-0000'," +
			"'alison@ggmail.org'," +
			"'Google Inc')";

		try {
			con = DriverManager.getConnection(URL, USER, PASS);
			stmt = con.createStatement();
			stmt.executeUpdate(sql);
		} catch (SQLException e) {
			e.printStackTrace();
			System.out.println(sql);
		} finally {
			try {
				stmt.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
			try {
				con.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}

Once you have run it, check in SQL*PLUS that the data has been inserted.