NumberMapper.java
2.33 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
package com.uccc.number.mapper;
import org.apache.ibatis.annotations.Param;
import com.uccc.number.domain.Number;
import org.apache.ibatis.annotations.Update;
import java.util.List;
public interface NumberMapper {
List<Number> getNumbers(@Param("currentPage") int currentPage, @Param("pageSize") int pageSize);
int getNumbersCount();
static final String NUMBERS = "numbers";
@Update({
"<script>",
"UPDATE " + NUMBERS + " SET uts = now()",
"<when test='number.seller!=null'>",
",seller = #{number.seller}" ,
"</when>",
"<when test='number.introduce!=null'>",
",introduce = #{number.}" ,
"</when>",
"<when test='number.price!=null'>",
",price = #{number.price}" ,
"</when>",
"<when test='number.basePrice!=null'>",
",base_price = #{number.basePrice}" ,
"</when>",
"<when test='number.cardBalance!=null'>",
",card_balance = #{number.cardBalance}" ,
"</when>",
"<when test='number.cardProvider!=null'>",
",card_provider = #{number.cardProvider}" ,
"</when>",
"<when test='number.city!=null'>",
",city = #{number.city}" ,
"</when>",
"<when test='number.province!=null'>",
",province = #{number.province}" ,
"</when>",
"<when test='number.status!=null'>",
",status = #{number.status}" ,
"</when>",
"<when test='number.service!=null'>",
",service = #{number.service}" ,
"</when>",
"<when test='number.agentPrice!=null'>",
",agent_price = #{number.agentPrice}" ,
"</when>",
"<when test='number.tags!=null'>",
",tags = #{number.tags}" ,
"</when>",
"<when test='number.virtualService!=null'>",
",virtual_service = #{number.virtualService}" ,
"</when>",
"<when test='number.isDelete!=null'>",
",is_delete = #{number.isDelete}" ,
"</when>",
"<when test='number.batch!=null'>",
",batch = #{number.batch}" ,
"</when>",
"</script>"
})
int updateNumber(@Param("number") Number number);
}