mysql触发器java,Java由MySQL触发器运行

I am trying to create some MySQL code that will invoke a Java program from a trigger.

Here is what I have so far:

CREATE TRIGGER trig_name after insert ON studentinfo

FOR EACH ROW

BEGIN

END

The trigger content would then call the Java program. Is this possible?

解决方案

A direct answer: no you can't call a java method from a mysql trigger. If you had an oracle database you could, but not mysql.

To do what you want to do with mysql you can

make the code that updates the database also notify the swing application. Or you can

make the trigger accumulate data on pending operations in a separate table that you read periodically from the swing app.