Main.java Source code

Introduction

Here is the source code for Main.java

Source

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

public class Main {
    public static void main(String args[]) throws Exception {
        String connectionURL = "jdbc:mysql://localhost:3306/test";
        Class.forName("com.mysql.jdbc.Driver");
        Connection con = DriverManager.getConnection(connectionURL, "login", "password");
        Statement stmt = con.createStatement();
        stmt.execute("CREATE TRIGGER obs_update BEFORE UPDATE ON obs " //
                + "FOR EACH ROW "//
                + "BEGIN "//
                + "IF OLD.voided = 0 AND NEW.voided = 1 THEN "//
                + "   DELETE FROM emp WHERE id = OLD.obs_id; "//
                + "ELSE "//
                + "   UPDATE emp SET emp.revision_token = NOW() "//
                + "   WHERE NEW.id = emp.id; "//
                + "END IF; "//
                + "END;");
        con.close();
    }
}