JDBC - Update

In this tutorial, you will learn how to use JDBC to execute an UPDATE statement. Refer to the JDBC programming order to complete the main method of UpdateNamecard.java. Our goal is to execute the following SQL statement.

UPDATE NAMECARD SET EMAIL ='alison@ggmail.org' WHERE NO = 1
  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
NamecardUpdate.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 NamecardUpdate {
	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 = "UPDATE NAMECARD " +
			"SET EMAIL ='alison@ggmail.org' " +
			"WHERE NO = 1";
		
		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();
			}
		}
	}

}