首页javastatementJava JDBC - 如何在Oracle中通过具有CLOB绑定的JDBC执行sql语句...

Java JDBC - 如何在Oracle中通过具有CLOB绑定的JDBC执行sql语句...

我们想知道如何在Oracle中通过具有CLOB绑定的JDBC执行sql语句。...
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();
  }
}