Skip to content

Commit bc2fdb6

Browse files
author
wangyibing
committed
add code
1 parent d51f666 commit bc2fdb6

5 files changed

Lines changed: 71 additions & 2 deletions

File tree

‎04spring/jdbc/pom.xml‎

Lines changed: 12 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -7,6 +7,18 @@
77
<groupId>jdbc</groupId>
88
<artifactId>jdbc-demo</artifactId>
99
<version>1.0-SNAPSHOT</version>
10+
<build>
11+
<plugins>
12+
<plugin>
13+
<groupId>org.apache.maven.plugins</groupId>
14+
<artifactId>maven-compiler-plugin</artifactId>
15+
<configuration>
16+
<source>7</source>
17+
<target>7</target>
18+
</configuration>
19+
</plugin>
20+
</plugins>
21+
</build>
1022
<dependencies>
1123
<dependency>
1224
<groupId>mysql</groupId>

‎05data/data-demo3/src/main/java/org/database/demo/dao/OrderDao.java‎

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -3,8 +3,15 @@
33
import org.database.demo.entity.Order;
44
import org.springframework.stereotype.Repository;
55

6+
import java.util.HashMap;
7+
import java.util.List;
8+
69
@Repository
710
public interface OrderDao {
811

912
int insertOne(Order order);
13+
14+
List<HashMap<String, Object>> query(HashMap<String, Object> condition);
15+
16+
int update(Order order);
1017
}

‎05data/data-demo3/src/main/resources/mapper/OrderMapper.xml‎

Lines changed: 25 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,32 @@
11
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
22
<mapper namespace="org.database.demo.dao.OrderDao">
33

4+
<sql id="sql_model">
5+
id,user_id
6+
</sql>
47
<insert id="insertOne">
58
insert into t_order (id,user_id) values (#{id},#{userId})
69
</insert>
10+
<update id="update">
11+
update t_order set
12+
<trim suffixOverrides="where id = #{id}" suffix=",">
13+
<if test = "id!= null">
14+
id = #{id}
15+
</if>
16+
<if test = "user_id!= null">
17+
and user_id = #{user_id}
18+
</if>
19+
</trim>
20+
</update>
21+
<select id="query" resultType = "java.util.HashMap">
22+
select <include refid = "sql_model"></include> from t_order
23+
<trim prefix="where" prefixOverrides="AND |OR">
24+
<if test = "id!= null">
25+
id = #{id}
26+
</if>
27+
<if test = "user_id!= null">
28+
and user_id = #{user_id}
29+
</if>
30+
</trim>
31+
</select>
732
</mapper>

‎05data/data-demo3/src/test/java/org/database/demo/dao/OrderTest.java‎

Lines changed: 13 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -4,11 +4,15 @@
44
import org.database.demo.entity.Order;
55
import org.junit.jupiter.api.Test;
66
import org.junit.jupiter.api.extension.ExtendWith;
7+
import org.mockito.internal.matchers.Or;
78
import org.mybatis.spring.annotation.MapperScan;
89
import org.springframework.beans.factory.annotation.Autowired;
910
import org.springframework.boot.test.context.SpringBootTest;
1011
import org.springframework.test.context.junit.jupiter.SpringExtension;
1112

13+
import java.util.HashMap;
14+
import java.util.List;
15+
1216
@SpringBootTest
1317
@ExtendWith(SpringExtension.class)
1418
@MapperScan(basePackages = "org.database.demo.dao")
@@ -19,7 +23,14 @@ public class OrderTest {
1923

2024
@Test
2125
public void test(){
22-
Order order = new Order(1, 1);
23-
int num = orderDao.insertOne(order);
26+
// Order order = new Order(1, 2);
27+
// int num = orderDao.insertOne(order);
28+
29+
HashMap<String, Object> condition = new HashMap<>(1);
30+
condition.put("user_id",1);
31+
List<HashMap<String, Object>> list = orderDao.query(condition);
32+
list.forEach(System.out::println);
33+
Order order = new Order(1, 3);
34+
int num1 = orderDao.update(order);
2435
}
2536
}

‎05data/data-demo3/target/classes/mapper/OrderMapper.xml‎

Lines changed: 14 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,21 @@
11
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
22
<mapper namespace="org.database.demo.dao.OrderDao">
33

4+
<sql id="sql_model">
5+
id,user_id
6+
</sql>
47
<insert id="insertOne">
58
insert into t_order (id,user_id) values (#{id},#{userId})
69
</insert>
10+
<select id="query" resultType = "java.util.HashMap">
11+
select <include refid = "sql_model"></include> from t_order
12+
<trim prefix="where" prefixOverrides="AND |OR">
13+
<if test = "id!= null">
14+
id = #{id}
15+
</if>
16+
<if test = "user_id!= null">
17+
and user_id = #{user_id}
18+
</if>
19+
</trim>
20+
</select>
721
</mapper>

0 commit comments

Comments
 (0)