Can I execute multiple SQL statements in ibatis?

苏小苏 · Post time: 2020-2-23 21:00:01

<delete id = "deleteAssetAttachment" parameterClass = "java.lang.String">
delete from assetattachments
where AssetAttachmentId = # assetAttachmentId #
</ delete>

I also want to delete the data of other tables, how to write, can IBATS do this?

Does not seem sexual. . . .

erg124 · Post time: 2020-7-14 09:00:01

Need to rewrite one
delete

xinren1106 · Post time: 2020-7-21 15:15:01

Doesn't seem to work

Aspiration · Post time: 2020-8-13 01:45:01

With stored procedures, iBatis can call stored procedures to achieve multi-step operations.

苏小苏 · Post time: 2020-8-13 08:00:01

No need

vanne722 · Post time: 2020-8-13 18:45:01

An independent sql can only be written in one statement, ibatis is like this, you cannot write the two together.

youngfff · Post time: 2020-8-13 19:15:01

Then write another

风云无心 · Post time: 2020-8-13 20:30:01

Laziness is sometimes a new creation!

苏小苏 · Post time: 2020-8-14 10:30:01

According to my understanding, it seems that you can write a SQLmap group. I don't know if this function will be added in the future.

tulip235 · Post time: 2020-8-17 13:45:01

Use a stored procedure! Haha

		Remember me	Forgot password?
Password			Register