From f2f3f3bd6dfe1ddcbeb18f9d72c09f1a11c82720 Mon Sep 17 00:00:00 2001 From: Gustavo Martin Morcuende Date: Thu, 21 Apr 2016 06:52:24 +0200 Subject: [PATCH] query examples --- .../de/example/mybatis/repository/mapper/AdMapper.xml | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) diff --git a/MyBatis/MyBatis-Spring-ReuseBatchExecutor/src/main/resources/de/example/mybatis/repository/mapper/AdMapper.xml b/MyBatis/MyBatis-Spring-ReuseBatchExecutor/src/main/resources/de/example/mybatis/repository/mapper/AdMapper.xml index 14ded5d..bf0cf0b 100644 --- a/MyBatis/MyBatis-Spring-ReuseBatchExecutor/src/main/resources/de/example/mybatis/repository/mapper/AdMapper.xml +++ b/MyBatis/MyBatis-Spring-ReuseBatchExecutor/src/main/resources/de/example/mybatis/repository/mapper/AdMapper.xml @@ -49,4 +49,21 @@ flushCache="false" useCache="true" timeout="10000" statementType="PREPARED"> select * FROM ad + + + +INSERT INTO Customers + (CustomerName, ContactName, Address, City, PostalCode, Country) +VALUES ('Cardinal','Tom B. Erichsen','Skagen 21','Stavanger','4006','Norway'); + + +DELETE FROM Customers +WHERE CustomerName='Alfreds Futterkiste' AND ContactName='Maria Anders'; + + +UPDATE Customers +SET ContactName='Alfred Schmidt', City='Hamburg' +WHERE CustomerName='Alfreds Futterkiste'; + + \ No newline at end of file -- 2.1.4