@Mapper support like query@

webjoin · webjoin · commit 36c8b7c3af8a · 2020-10-27T23:05:06.000+04:00
diff --git a/build.gradle b/build.gradle
@@ -19,4 +19,5 @@ dependencies {
     compile 'org.mybatis:mybatis-spring:2.0.0'
     compile 'org.springframework:spring-jdbc:5.1.5.RELEASE'
     compile 'mysql:mysql-connector-java:6.0.5'
+    annotationProcessor "org.projectlombok:lombok:1.16.8"
 }
diff --git a/src/main/java/cn/iwuliao/ds/controller/HeloController.java b/src/main/java/cn/iwuliao/ds/controller/HeloController.java
@@ -3,8 +3,11 @@
 import cn.iwuliao.ds.service.HeloService;
 import org.springframework.web.bind.annotation.PathVariable;
 import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RequestParam;
 import org.springframework.web.bind.annotation.RestController;
 
+import java.util.List;
+
 /**
  * @author tangyu
  * @since 2019-04-22 20:30
@@ -48,4 +51,10 @@ public String tx(@PathVariable("commit") String commit) {
         return "i am tx ";
     }
 
+
+    @RequestMapping("/like")
+    public List<String> like(@RequestParam(name = "name") String name) {
+        return heloService.likeQry(name);
+    }
+
 }
diff --git a/src/main/java/cn/iwuliao/ds/mapper/dba/AMapper.java b/src/main/java/cn/iwuliao/ds/mapper/dba/AMapper.java
@@ -4,6 +4,8 @@
 import org.apache.ibatis.annotations.Param;
 import org.apache.ibatis.annotations.Select;
 
+import java.util.List;
+
 /**
  * @author tangyu
  * @since 2019-04-22 22:25
@@ -19,4 +21,7 @@ public interface AMapper {
     Integer insert(@Param("id") int id);
 
 
+    List<String> likeQry(@Param("name") String name);
+
+
 }
diff --git a/src/main/java/cn/iwuliao/ds/service/HeloService.java b/src/main/java/cn/iwuliao/ds/service/HeloService.java
@@ -3,6 +3,8 @@
 import cn.iwuliao.ds.core.DsScannerConfigurer;
 import org.springframework.transaction.annotation.Transactional;
 
+import java.util.List;
+
 /**
  * @author tangyu
  * @since 2019-04-23 00:55
@@ -18,4 +20,6 @@ public interface HeloService {
     Integer rollback();
 
     Integer hib();
+
+    List<String> likeQry(String name);
 }
diff --git a/src/main/java/cn/iwuliao/ds/service/HeloServiceImpl.java b/src/main/java/cn/iwuliao/ds/service/HeloServiceImpl.java
@@ -7,6 +7,8 @@
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
 
+import java.util.List;
+
 /**
  * @author tangyu
  * @since 2019-04-23 00:56
@@ -48,4 +50,9 @@ public Integer hib() {
         return id;
     }
 
+    @Override
+    public List<String> likeQry(String name) {
+        return aMapper.likeQry(name);
+    }
+
 }
diff --git a/src/main/resources/mybatis/dba/AMapper.xml b/src/main/resources/mybatis/dba/AMapper.xml
@@ -1,4 +1,10 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 <mapper namespace="cn.iwuliao.ds.mapper.dba.AMapper">
+
+    <select id="likeQry" resultType="string">
+        SELECT name from a where name like
+          <bind name="pattern" value="'%' + _parameter.name + '%'" />
+        #{pattern}
+    </select>
 </mapper>

Original file line number	Diff line number	Diff line change
`@@ -19,4 +19,5 @@ dependencies {`
`19`	`19`	`compile 'org.mybatis:mybatis-spring:2.0.0'`
`20`	`20`	`compile 'org.springframework:spring-jdbc:5.1.5.RELEASE'`
`21`	`21`	`compile 'mysql:mysql-connector-java:6.0.5'`
	`22`	`+ annotationProcessor "org.projectlombok:lombok:1.16.8"`
`22`	`23`	`}`