Subversion Repositories SmartDukaan

Rev

Rev 25300 | Rev 25652 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 25300 Rev 25640
Line 5... Line 5...
5
import java.util.Set;
5
import java.util.Set;
6
 
6
 
7
import javax.swing.SortOrder;
7
import javax.swing.SortOrder;
8
 
8
 
9
import org.springframework.stereotype.Repository;
9
import org.springframework.stereotype.Repository;
-
 
10
import org.springframework.util.MultiValueMap;
10
 
11
 
11
@Repository
12
@Repository
12
public interface GenericRepository {
13
public interface GenericRepository {
13
	public final String IS_NULL="IS_NULL";
14
	public final String IS_NULL = "IS_NULL";
14
	public final String IS_NOT_NULL="IS_NOT_NULL";
15
	public final String IS_NOT_NULL = "IS_NOT_NULL";
-
 
16
 
15
	public <T> void persist(Object object);
17
	public <T> void persist(Object object);
-
 
18
 
16
	public <T> void delete(Object object);
19
	public <T> void delete(Object object);
-
 
20
 
17
	public <T> List<T> selectAllOrderByDesc(Class<T> clazz, String orderByDescKey);
21
	public <T> List<T> selectAllOrderByDesc(Class<T> clazz, String orderByDescKey);
18
	
22
 
19
	public <T> long selectCount(Class<T> clazz);
23
	public <T> long selectCount(Class<T> clazz);
-
 
24
 
20
	public <T> long selectCountByNotNull(Class<T> clazz, String notNullKey);
25
	public <T> long selectCountByNotNull(Class<T> clazz, String notNullKey);
-
 
26
 
21
	public <T> long selectCountByEqual(Class<T> clazz, String key, Object value);
27
	public <T> long selectCountByEqual(Class<T> clazz, String key, Object value);
-
 
28
 
22
	public <T> long selectCountByEquals(Class<T> clazz, Map<String, Object> objectParams);
29
	public <T> long selectCountByEquals(Class<T> clazz, Map<String, Object> objectParams);
-
 
30
 
23
	public <T> long selectCountByIn(Class<T> clazz, String key, List<?> in);
31
	public <T> long selectCountByIn(Class<T> clazz, String key, List<?> in);
-
 
32
 
24
	public <T> long selectCountByEqualBetween(Class<T> clazz, String key, Object value, String betweenKey, Object betweenValue1, Object betweenValue2);
33
	public <T> long selectCountByEqualBetween(Class<T> clazz, String key, Object value, String betweenKey,
-
 
34
			Object betweenValue1, Object betweenValue2);
25
	
35
 
26
	//public <T> List<T> selectAllPaginated(Class<T> clazz, int offset, int limit);
36
	// public <T> List<T> selectAllPaginated(Class<T> clazz, int offset, int limit);
27
	public <T> List<T> selectAllOrderByDescPaginated(Class<T> clazz, String orderByDescKey, int offset, int limit);
37
	public <T> List<T> selectAllOrderByDescPaginated(Class<T> clazz, String orderByDescKey, int offset, int limit);
-
 
38
 
28
	public <T> List<T> selectAllNotNullOrderByDescPaginated(Class<T> clazz, String notNullKey, String orderByDescKey, int offset, int limit);
39
	public <T> List<T> selectAllNotNullOrderByDescPaginated(Class<T> clazz, String notNullKey, String orderByDescKey,
-
 
40
			int offset, int limit);
-
 
41
 
29
	public <T> List<T> selectAllNotNullOrderByDesc(Class<T> clazz, String notNullKey, String orderByDescKey);
42
	public <T> List<T> selectAllNotNullOrderByDesc(Class<T> clazz, String notNullKey, String orderByDescKey);
30
	
43
 
31
	public <T> T selectById(Class<T> clazz, int id);
44
	public <T> T selectById(Class<T> clazz, int id);
32
	
45
 
33
	public <U, T> List<U> selectAllDistinctOrderByDesc(Class<T> clazz, Class<U> selector, String selectorKey, String orderByDescKey);
46
	public <U, T> List<U> selectAllDistinctOrderByDesc(Class<T> clazz, Class<U> selector, String selectorKey,
-
 
47
			String orderByDescKey);
-
 
48
 
34
	public <U, T> List<U> selectAllDistinctByNotInOrderByDesc(Class<T> clazz, Class<U> selector, String selectorKey, Map<String, List<?>> listParams, String orderByDescKey);
49
	public <U, T> List<U> selectAllDistinctByNotInOrderByDesc(Class<T> clazz, Class<U> selector, String selectorKey,
-
 
50
			Map<String, List<?>> listParams, String orderByDescKey);
35
	
51
 
36
	public <T> List<T> selectAllByInsOrderByDesc(Class<T> clazz, Map<String, List<?>> listMap, String orderByDescKey);
52
	public <T> List<T> selectAllByInsOrderByDesc(Class<T> clazz, Map<String, List<?>> listMap, String orderByDescKey);
-
 
53
 
37
	public <U, T> List<U> selectAllByInsOrderByDesc(Class<T> clazz, Class<U> selector, String selectorKey, Map<String, List<?>> listMap, String orderByDescKey);
54
	public <U, T> List<U> selectAllByInsOrderByDesc(Class<T> clazz, Class<U> selector, String selectorKey,
-
 
55
			Map<String, List<?>> listMap, String orderByDescKey);
38
	
56
 
39
	public <T> List<T> selectAllByInOrderByDesc(Class<T> clazz, String key, List<?> in, String orderByDescKey);
57
	public <T> List<T> selectAllByInOrderByDesc(Class<T> clazz, String key, List<?> in, String orderByDescKey);
-
 
58
 
40
	public <T> List<T> selectAllByInOrderByDescPaginated(Class<T> clazz, String key, List<?> in, String orderByDescKey, int offset, int limit);
59
	public <T> List<T> selectAllByInOrderByDescPaginated(Class<T> clazz, String key, List<?> in, String orderByDescKey,
-
 
60
			int offset, int limit);
41
	
61
 
42
	public <U, T> List<U> selectAllByInOrderByDesc(Class<T> clazz, Class<U> selector, String selectorKey, String inKey, List<?> in, String orderByDescKey);
62
	public <U, T> List<U> selectAllByInOrderByDesc(Class<T> clazz, Class<U> selector, String selectorKey, String inKey,
-
 
63
			List<?> in, String orderByDescKey);
43
	
64
 
44
	public <T> List<T> selectAllByEqualsOrderByDesc(Class<T> clazz, Map<String, Object> objectMap, String orderByDescKey);
65
	public <T> List<T> selectAllByEqualsOrderByDesc(Class<T> clazz, Map<String, Object> objectMap,
-
 
66
			String orderByDescKey);
-
 
67
 
45
	public <U, T> List<U> selectAllByEqualsOrderBy(Class<T> clazz, Class<U> selector, String selectorKey, Map<String, Object> objectMap, String orderByKey, SortOrder sortOrder);
68
	public <U, T> List<U> selectAllByEqualsOrderBy(Class<T> clazz, Class<U> selector, String selectorKey,
-
 
69
			Map<String, Object> objectMap, String orderByKey, SortOrder sortOrder);
46
	
70
 
47
	public <T> List<T> selectAllByEqualOrderByDesc(Class<T> clazz, String key, Object value, String orderByDescKey);
71
	public <T> List<T> selectAllByEqualOrderByDesc(Class<T> clazz, String key, Object value, String orderByDescKey);
48
	
72
 
49
	public <T> List<T> selectAllByNotNull(Class<T> clazz, String notNullParams);
73
	public <T> List<T> selectAllByNotNull(Class<T> clazz, String notNullParams);
50
	
74
 
51
	public <T> T selectByNotNull(Class<T> clazz, String notNullKey);
75
	public <T> T selectByNotNull(Class<T> clazz, String notNullKey);
-
 
76
 
52
	public <T> T selectByEqualNotNull(Class<T> clazz, String key, Object value, String notNullKey);
77
	public <T> T selectByEqualNotNull(Class<T> clazz, String key, Object value, String notNullKey);
53
	
-
 
54
	//public <T> List<T> selectAllByEqualGtOrderByDesc(Class<T> clazz, String key, Object value, String gtKey, Object gtValue, String orderByDescKey);
-
 
55
	
-
 
56
	public <T> List<T> selectAllByEqualOrderByDescPaginated(Class<T> clazz, String key, Object value, String orderByDescKey, int offset, int limit);
-
 
57
	public <T, U> List<U> selectAllByEqualOrderByDescPaginated(Class<T> clazz, Class<U> selector, String selectorKey, String key, Object value, String orderByDescKey, int offset, int limit);
-
 
58
	
-
 
59
	
-
 
60
	public <U, T> List<U> selectAllByEqualOrderByDesc(Class<T> clazz, Class<U> selector, String selectorKey, String key, Object value, String orderByDescKey);
-
 
61
	
-
 
62
	public <T> List<T> selectAllByInsEqualsOrderBy(Class<T> clazz, Map<String, List<?>> listMap, Map<String, Object> objectMap, String orderByKey, SortOrder sortOrder);
-
 
63
	public <T> List<T> selectAllByInsEqualsGtOrderBy(Class<T> clazz, Map<String, List<?>> listMap, Map<String, Object> objectMap, String gtKey, Object gtValue,String orderByKey, SortOrder sortOrder);
-
 
64
	public <U, T> List<U> selectAllByInsEqualsOrderByDesc(Class<T> clazz, Class<U> selector, String selectorKey, Map<String, List<?>> listMap, Map<String, Object> objectMap, String orderByDescKey);
-
 
65
	
-
 
66
	public <T> List<T> selectAllByInEqualOrderByDesc(Class<T> clazz, String inKey, List<?> in, String key, Object value, String orderByDescKey);
-
 
67
	public <U, T> List<U> selectAllByInEqualOrderByDesc(Class<T> clazz, Class<U> selector, String selectorKey, String inKey, List<?> in, String key, Object value, String orderByDescKey);
-
 
68
	
-
 
69
	public <T> List<T> selectAllByInEqualOrderBysDesc(Class<T> clazz, String inKey, List<?> in, String key, Object value, Set<String> orderBysDesc);
-
 
70
	
-
 
71
	public <T> List<T> selectAllByEqualGtOrderByDesc(Class<T> clazz, String key, Object value, String gtKey, Object gtValue, String orderByDescKey);
-
 
72
 
78
 
-
 
79
	// public <T> List<T> selectAllByEqualGtOrderByDesc(Class<T> clazz, String key,
-
 
80
	// Object value, String gtKey, Object gtValue, String orderByDescKey);
-
 
81
 
-
 
82
	public <T> List<T> selectAllByEqualOrderByDescPaginated(Class<T> clazz, String key, Object value,
-
 
83
			String orderByDescKey, int offset, int limit);
-
 
84
 
-
 
85
	public <T, U> List<U> selectAllByEqualOrderByDescPaginated(Class<T> clazz, Class<U> selector, String selectorKey,
-
 
86
			String key, Object value, String orderByDescKey, int offset, int limit);
-
 
87
 
73
    public <T, U> List<U> selectAllByEqualGtOrderByDesc(Class<T> clazz, Class<U> selector, String selectorKey, String key, Object value, String gtKey, Object gtValue, String orderByDescKey);
88
	public <U, T> List<U> selectAllByEqualOrderByDesc(Class<T> clazz, Class<U> selector, String selectorKey, String key,
-
 
89
			Object value, String orderByDescKey);
-
 
90
 
-
 
91
	public <T> List<T> selectAllByInsEqualsOrderBy(Class<T> clazz, Map<String, List<?>> listMap,
-
 
92
			Map<String, Object> objectMap, String orderByKey, SortOrder sortOrder);
-
 
93
 
-
 
94
	public <T> List<T> selectAllByInsEqualsGtOrderBy(Class<T> clazz, Map<String, List<?>> listMap,
-
 
95
			Map<String, Object> objectMap, String gtKey, Object gtValue, String orderByKey, SortOrder sortOrder);
-
 
96
 
-
 
97
	public <U, T> List<U> selectAllByInsEqualsOrderByDesc(Class<T> clazz, Class<U> selector, String selectorKey,
-
 
98
			Map<String, List<?>> listMap, Map<String, Object> objectMap, String orderByDescKey);
-
 
99
 
-
 
100
	public <T> List<T> selectAllByInEqualOrderByDesc(Class<T> clazz, String inKey, List<?> in, String key, Object value,
-
 
101
			String orderByDescKey);
-
 
102
 
-
 
103
	public <U, T> List<U> selectAllByInEqualOrderByDesc(Class<T> clazz, Class<U> selector, String selectorKey,
-
 
104
			String inKey, List<?> in, String key, Object value, String orderByDescKey);
-
 
105
 
-
 
106
	public <T> List<T> selectAllByInEqualOrderBysDesc(Class<T> clazz, String inKey, List<?> in, String key,
-
 
107
			Object value, Set<String> orderBysDesc);
-
 
108
 
-
 
109
	public <T> List<T> selectAllByEqualGtOrderByDesc(Class<T> clazz, String key, Object value, String gtKey,
-
 
110
			Object gtValue, String orderByDescKey);
74
	
111
 
-
 
112
	public <T, U> List<U> selectAllByEqualGtOrderByDesc(Class<T> clazz, Class<U> selector, String selectorKey,
-
 
113
			String key, Object value, String gtKey, Object gtValue, String orderByDescKey);
75
    
114
 
76
    public <T> List<T> selectAllByInsEqualsNullsOrderByDesc(Class<T> clazz, Map<String, List<?>> listMap, Map<String, Object> objectMap, Set<String> nullParams, String orderByDescKey);
115
	public <T> List<T> selectAllByInsEqualsNullsOrderByDesc(Class<T> clazz, Map<String, List<?>> listMap,
-
 
116
			Map<String, Object> objectMap, Set<String> nullParams, String orderByDescKey);
77
    
117
 
78
	public <T> List<T> selectAllByEqualsNullNotNullGeLeOrderByDesc(Class<T> clazz, Map<String, Object> objectMap, Set<String> nullParams, Set<String> notNullParams, Map<String, Object> geParams, Map<String, Object> leParams, String orderByDescKey);
118
	public <T> List<T> selectAllByEqualsNullNotNullGeLeOrderByDesc(Class<T> clazz, Map<String, Object> objectMap,
-
 
119
			Set<String> nullParams, Set<String> notNullParams, Map<String, Object> geParams,
-
 
120
			Map<String, Object> leParams, String orderByDescKey);
79
	
121
 
80
	public <T> T selectByNullNotNull(Class<T> clazz, String nullKey, String notNullKey);
122
	public <T> T selectByNullNotNull(Class<T> clazz, String nullKey, String notNullKey);
-
 
123
	// public <T> List<T> selectAllByInsEqualsNullNotNullGtGeLtLe(Class<T> clazz,
81
	//public <T> List<T> selectAllByInsEqualsNullNotNullGtGeLtLe(Class<T> clazz, Map<String, List<?>> listMap, Map<String, Object> objectMap, Set<String> nullParams, Set<String> notNullParams, Map<String, Object> gtParams, Map<String, Object> geParams, Map<String, Object> ltParams, Map<String, Object> leParams);
124
	// Map<String, List<?>> listMap, Map<String, Object> objectMap, Set<String>
-
 
125
	// nullParams, Set<String> notNullParams, Map<String, Object> gtParams,
-
 
126
	// Map<String, Object> geParams, Map<String, Object> ltParams, Map<String,
-
 
127
	// Object> leParams);
82
	
128
 
83
	public <T> List<T> selectAllByEqualBetweenOrderByDesc(Class<T> clazz, String key, Object value, String betweenKey, Object betweenValue1, Object betweenValue2, String orderByDescKey);
129
	public <T> List<T> selectAllByEqualBetweenOrderByDesc(Class<T> clazz, String key, Object value, String betweenKey,
-
 
130
			Object betweenValue1, Object betweenValue2, String orderByDescKey);
84
	
131
 
85
	public <T> long selectCountByEqualsBetween(Class<T> clazz, Map<String, Object> objectParams, String betweenKey, Object betweenValue1, Object betweenValue2);
132
	public <T> long selectCountByEqualsBetween(Class<T> clazz, Map<String, Object> objectParams, String betweenKey,
-
 
133
			Object betweenValue1, Object betweenValue2);
86
	
134
 
87
	public <T> double selectSumByEqualBetween(Class<T> clazz, String sumKey, Map<String, Object> objectParams,
135
	public <T> double selectSumByEqualBetween(Class<T> clazz, String sumKey, Map<String, Object> objectParams,
88
			String betweenKey, Object betweenValue1, Object betweenValue2);
136
			String betweenKey, Object betweenValue1, Object betweenValue2);
89
	
137
 
90
	public <T> List<T> selectAllByEqualBetweenOrderByDescPaginated(Class<T> clazz, String key, Object value, String betweenKey, Object betweenValue1, Object betweenValue2, String orderByDescKey, int offset, int limit);
138
	public <T> List<T> selectAllByEqualBetweenOrderByDescPaginated(Class<T> clazz, String key, Object value,
-
 
139
			String betweenKey, Object betweenValue1, Object betweenValue2, String orderByDescKey, int offset,
-
 
140
			int limit);
91
	
141
 
-
 
142
	// public <U, T> List<U> selectAllByParams(Class<T> clazz, Class<U> selector,
-
 
143
	// String selectorKey, Map<String, List<?>> listMap, Map<String, Object>
-
 
144
	// objectMap, Set<String> nullParams, Set<String> notNullParams, Map<String,
92
	//public <U, T> List<U> selectAllByParams(Class<T> clazz, Class<U> selector, String selectorKey, Map<String, List<?>> listMap, Map<String, Object> objectMap, Set<String> nullParams, Set<String> notNullParams, Map<String, Object> gtParams, Map<String, Object> geParams, Map<String, Object> ltParams, Map<String, Object> leParams);
145
	// Object> gtParams, Map<String, Object> geParams, Map<String, Object> ltParams,
-
 
146
	// Map<String, Object> leParams);
93
	public <T> List<T> selectAllByInBetweenOrderByDesc(Class<T> clazz, String key, List<?> values, String betweenKey, Object betweenValue1, Object betweenValue2, String orderByDescKey);
147
	public <T> List<T> selectAllByInBetweenOrderByDesc(Class<T> clazz, String key, List<?> values, String betweenKey,
-
 
148
			Object betweenValue1, Object betweenValue2, String orderByDescKey);
94
	
149
 
95
	public <T> T selectByEquals(Class<T> clazz, Map<String, Object> objectMap);
150
	public <T> T selectByEquals(Class<T> clazz, Map<String, Object> objectMap);
96
	
151
	
-
 
152
	public <T> T selectFirstByEquals(Class<T> clazz, Map<String, Object> objectMap);
-
 
153
 
-
 
154
	// public <T> List<T> selectAllByEqualsWithOrOrderByDescPaginated(Class<T>
97
	//public <T> List<T> selectAllByEqualsWithOrOrderByDescPaginated(Class<T> clazz, Map<String, Object> objectMap, String orderByDescKey, int offset, int limit);
155
	// clazz, Map<String, Object> objectMap, String orderByDescKey, int offset, int
-
 
156
	// limit);
98
	
157
 
99
	public <T> List<T> selectAllByEqualsWithOrOrderByPaginated(Class<T> clazz, Map<String, Object> objectMap, String orderByDescKey, SortOrder sortOrder, int offset, int limit);
158
	public <T> List<T> selectAllByEqualsWithOrOrderByPaginated(Class<T> clazz, Map<String, Object> objectMap,
-
 
159
			String orderByDescKey, SortOrder sortOrder, int offset, int limit);
100
	
160
 
101
	public <T> List<T> selectAllByEqualsOrderByPaginated(Class<T> clazz, Map<String, Object> objectMap, String orderByDescKey, SortOrder sortOrder, int offset, int limit);
161
	public <T> List<T> selectAllByEqualsOrderByPaginated(Class<T> clazz, Map<String, Object> objectMap,
-
 
162
			String orderByDescKey, SortOrder sortOrder, int offset, int limit);
102
	
163
 
103
	public <T> T selectByEqual(Class<T> clazz, String key, Object value);
164
	public <T> T selectByEqual(Class<T> clazz, String key, Object value);
104
 
165
 
105
	public <T> List<T> selectByInEqualNullNotNull(Class<T> clazz, String inKey, List<?> inList, String equalKey, Object equalValue, String nullKey, String notNullKey);
166
	public <T> List<T> selectByInEqualNullNotNull(Class<T> clazz, String inKey, List<?> inList, String equalKey,
-
 
167
			Object equalValue, String nullKey, String notNullKey);
106
	
168
 
107
	public <T> T selectByBetween(Class<T> clazz, String key, Object value1, Object value2);
169
	public <T> T selectByBetween(Class<T> clazz, String key, Object value1, Object value2);
-
 
170
 
108
	public <U, T> U selectByBetween(Class<T> clazz, Class<U> selector, String selectorKey, String key, Object value1, Object value2);
171
	public <U, T> U selectByBetween(Class<T> clazz, Class<U> selector, String selectorKey, String key, Object value1,
-
 
172
			Object value2);
109
	
173
 
110
	public <T> T selectByGeLe(Class<T> clazz, String geKey, Object geValue, String leKey, Object leValue);
174
	public <T> T selectByGeLe(Class<T> clazz, String geKey, Object geValue, String leKey, Object leValue);
-
 
175
 
111
	public <U, T> U selectByGeLe(Class<T> clazz, Class<U> selector, String selectorKey, String geKey, Object geValue, String leKey, Object leValue);
176
	public <U, T> U selectByGeLe(Class<T> clazz, Class<U> selector, String selectorKey, String geKey, Object geValue,
-
 
177
			String leKey, Object leValue);
112
	
178
 
-
 
179
	// public <T> T selectByParams(Class<T> clazz, Map<String, Object> objectMap,
-
 
180
	// Set<String> nullParams, Set<String> notNullParams, Map<String, Object>
-
 
181
	// gtParams, Map<String, Object> geParams, Map<String, Object> ltParams,
-
 
182
	// Map<String, Object> leParams);
-
 
183
	// public <U, T> U selectByParams(Class<T> clazz, Class<U> selector, String
-
 
184
	// selectorKey, Map<String, Object> objectMap, Set<String> nullParams,
113
	//public <T> T selectByParams(Class<T> clazz, Map<String, Object> objectMap, Set<String> nullParams, Set<String> notNullParams, Map<String, Object> gtParams, Map<String, Object> geParams, Map<String, Object> ltParams, Map<String, Object> leParams);
185
	// Set<String> notNullParams, Map<String, Object> gtParams, Map<String, Object>
114
	//public <U, T> U selectByParams(Class<T> clazz, Class<U> selector, String selectorKey, Map<String, Object> objectMap, Set<String> nullParams, Set<String> notNullParams, Map<String, Object> gtParams, Map<String, Object> geParams, Map<String, Object> ltParams, Map<String, Object> leParams);
186
	// geParams, Map<String, Object> ltParams, Map<String, Object> leParams);
115
	
187
 
116
	public <T> List<T> selectAllByBetweenOrderByDesc(Class<T> clazz, String betweenKey, Object betweenValue1, Object betweenValue2, String orderByDescKey);
188
	public <T> List<T> selectAllByBetweenOrderByDesc(Class<T> clazz, String betweenKey, Object betweenValue1,
-
 
189
			Object betweenValue2, String orderByDescKey);
117
	
190
 
118
	public <T> boolean isExistById(Class<T> clazz, int id);
191
	public <T> boolean isExistById(Class<T> clazz, int id);
-
 
192
 
119
	public <T> boolean isExistByEqual(Class<T> clazz, String key, Object value);
193
	public <T> boolean isExistByEqual(Class<T> clazz, String key, Object value);
-
 
194
 
120
	public <T> boolean isExistByEquals(Class<T> clazz, Map<String, Object> objectMap);
195
	public <T> boolean isExistByEquals(Class<T> clazz, Map<String, Object> objectMap);
121
	
196
 
122
	public <U, T> List<U> selectAllOrderByDesc(Class<T> clazz, Class<U> selector, String selectorKey, String orderByDescKey);
197
	public <U, T> List<U> selectAllOrderByDesc(Class<T> clazz, Class<U> selector, String selectorKey,
-
 
198
			String orderByDescKey);
-
 
199
 
123
	public <U, T> List<U> selectAllOrderByDescPaginated(Class<T> clazz, Class<U> selector, String selectorKey, String orderByDescKey, int offset, int limit);
200
	public <U, T> List<U> selectAllOrderByDescPaginated(Class<T> clazz, Class<U> selector, String selectorKey,
-
 
201
			String orderByDescKey, int offset, int limit);
124
	
202
 
125
	public <T, V> List<T> selectAllByEqualBetweenWithJoinEqualOrderByDescPaginated(Class<T> clazz, String key, Object value, String betweenKey, Object betweenValue1, Object betweenValue2, String clazzJoinKey, String joinClazzKey, Class<V> joinClazz, String joinKey, Object joinValue, String orderByDescKey, int offset, int limit);
203
	public <T, V> List<T> selectAllByEqualBetweenWithJoinEqualOrderByDescPaginated(Class<T> clazz, String key,
-
 
204
			Object value, String betweenKey, Object betweenValue1, Object betweenValue2, String clazzJoinKey,
-
 
205
			String joinClazzKey, Class<V> joinClazz, String joinKey, Object joinValue, String orderByDescKey,
-
 
206
			int offset, int limit);
126
	
207
 
127
	public <T, V> V selectByEqualsWithJoinEqual(Class<T> clazz, Map<String, Object> objectParams, String clazzJoinKey, String joinClazzKey, Class<V> joinClazz, String joinKey, Object joinValue);
208
	public <T, V> V selectByEqualsWithJoinEqual(Class<T> clazz, Map<String, Object> objectParams, String clazzJoinKey,
-
 
209
			String joinClazzKey, Class<V> joinClazz, String joinKey, Object joinValue);
128
	
210
 
129
	public <T, V, X> List<T> selectAllByEqualBetweenWithJoinJoinEqualOrderByDescPaginated(Class<T> clazz, String equalKey, Object equalValue, String betweenKey,
211
	public <T, V, X> List<T> selectAllByEqualBetweenWithJoinJoinEqualOrderByDescPaginated(Class<T> clazz,
-
 
212
			String equalKey, Object equalValue, String betweenKey, Object betweenValue1, Object betweenValue2,
130
			Object betweenValue1, Object betweenValue2, String clazzJoinKey, String joinClazzKey, Class<V> joinClazz1,
213
			String clazzJoinKey, String joinClazzKey, Class<V> joinClazz1, String joinClazz1Key, String joinClazz2Key,
131
			String joinClazz1Key, String joinClazz2Key, Class<X> joinClazz2, String join2Key, Object join2Value, String orderByDescKey, int offset, int limit);
214
			Class<X> joinClazz2, String join2Key, Object join2Value, String orderByDescKey, int offset, int limit);
132
	
-
 
133
	
215
 
-
 
216
	public <T, V> List<T> selectAllByEqualBetweenWithJoinLikesOrderByDescPaginated(Class<T> clazz, String key,
-
 
217
			Object value, String betweenKey, Object betweenValue1, Object betweenValue2, String clazzJoinKey,
134
	public <T, V> List<T> selectAllByEqualBetweenWithJoinLikesOrderByDescPaginated(Class<T> clazz, String key, Object value, String betweenKey, Object betweenValue1, Object betweenValue2, String clazzJoinKey, String joinClazzKey, Class<V> joinClazz, Map<String, String> joinLikes, String orderByDescKey, int offset, int limit);
218
			String joinClazzKey, Class<V> joinClazz, Map<String, String> joinLikes, String orderByDescKey, int offset,
-
 
219
			int limit);
135
	
220
 
136
	public <T, V> List<T> selectAllByEqualWithJoinLikesOrderByDescPaginated(Class<T> clazz, String key, Object value, String clazzJoinKey, String joinClazzKey, Class<V> joinClazz, Map<String, String> joinLikes, String orderByDescKey, int offset, int limit);
221
	public <T, V> List<T> selectAllByEqualWithJoinLikesOrderByDescPaginated(Class<T> clazz, String key, Object value,
-
 
222
			String clazzJoinKey, String joinClazzKey, Class<V> joinClazz, Map<String, String> joinLikes,
-
 
223
			String orderByDescKey, int offset, int limit);
137
	
224
 
138
	public <T, V> List<T> selectAllByEqualGtWithJoinLikesOrderByDescPaginated(Class<T> clazz, String key, Object value, String gtKey, Object gtValue, String clazzJoinKey, String joinClazzKey, Class<V> joinClazz, Map<String, String> joinLikes, String orderByDescKey, int offset, int limit);
225
	public <T, V> List<T> selectAllByEqualGtWithJoinLikesOrderByDescPaginated(Class<T> clazz, String key, Object value,
-
 
226
			String gtKey, Object gtValue, String clazzJoinKey, String joinClazzKey, Class<V> joinClazz,
-
 
227
			Map<String, String> joinLikes, String orderByDescKey, int offset, int limit);
139
	
228
 
140
	public <T, V> long selectCountByEqualBetweenWithJoinEqual(Class<T> clazz, String key, Object value, String betweenKey,
229
	public <T, V> long selectCountByEqualBetweenWithJoinEqual(Class<T> clazz, String key, Object value,
141
			Object betweenValue1, Object betweenValue2, String clazzJoinKey, String joinClazzKey, Class<V> joinClazz,
230
			String betweenKey, Object betweenValue1, Object betweenValue2, String clazzJoinKey, String joinClazzKey,
142
			String joinKey, Object joinValue);
231
			Class<V> joinClazz, String joinKey, Object joinValue);
-
 
232
 
143
	public <T, V, X> long selectCountByEqualBetweenWithJoinJoinEqual(Class<T> clazz, String equalKey, Object equalValue, String betweenKey,
233
	public <T, V, X> long selectCountByEqualBetweenWithJoinJoinEqual(Class<T> clazz, String equalKey, Object equalValue,
144
			Object betweenValue1, Object betweenValue2, String clazzJoinKey, String joinClazzKey, Class<V> joinClazz1,
234
			String betweenKey, Object betweenValue1, Object betweenValue2, String clazzJoinKey, String joinClazzKey,
145
			String joinClazz1Key, String joinClazz2Key, Class<X> joinClazz2, String join2Key, Object join2Value);
235
			Class<V> joinClazz1, String joinClazz1Key, String joinClazz2Key, Class<X> joinClazz2, String join2Key,
-
 
236
			Object join2Value);
146
	
237
 
147
	public <T, V> long selectCountByEqualBetweenWithJoinLikes(Class<T> clazz, String key, Object value,
238
	public <T, V> long selectCountByEqualBetweenWithJoinLikes(Class<T> clazz, String key, Object value,
148
			String betweenKey, Object betweenValue1, Object betweenValue2, String clazzJoinKey, String joinClazzKey,
239
			String betweenKey, Object betweenValue1, Object betweenValue2, String clazzJoinKey, String joinClazzKey,
149
			Class<V> joinClazz, Map<String, String> joinLikes);
240
			Class<V> joinClazz, Map<String, String> joinLikes);
150
	
241
 
151
	public <T, V> long selectCountByEqualWithJoinLikes(Class<T> clazz, String key, Object value, String clazzJoinKey, String joinClazzKey, Class<V> joinClazz, Map<String, String> joinLikes);
242
	public <T, V> long selectCountByEqualWithJoinLikes(Class<T> clazz, String key, Object value, String clazzJoinKey,
-
 
243
			String joinClazzKey, Class<V> joinClazz, Map<String, String> joinLikes);
152
	
244
 
153
	public <T, V> long selectCountByEqualGtWithJoinLikes(Class<T> clazz, String key, Object value, String gtKey, Object gtValue, String clazzJoinKey, String joinClazzKey, Class<V> joinClazz, Map<String, String> joinLikes);
245
	public <T, V> long selectCountByEqualGtWithJoinLikes(Class<T> clazz, String key, Object value, String gtKey,
-
 
246
			Object gtValue, String clazzJoinKey, String joinClazzKey, Class<V> joinClazz,
-
 
247
			Map<String, String> joinLikes);
154
	
248
 
155
	public <T, V> V selectByEqualWithJoin(Class<T> clazz, String key, Object value, String clazzJoinKey, String joinClazzKey, Class<V> joinClazz);
249
	public <T, V> V selectByEqualWithJoin(Class<T> clazz, String key, Object value, String clazzJoinKey,
-
 
250
			String joinClazzKey, Class<V> joinClazz);
156
	
251
 
157
	public <T, U, V> List<U> selectAllByEqualWithJoinOrderByDesc(Class<T> clazz, String key, Object value, String clazzJoinKey, String joinClazzKey, Class<V> joinClazz, Class<U> selector, String selectorKey, String orderByDescKey);
252
	public <T, U, V> List<U> selectAllByEqualWithJoinOrderByDesc(Class<T> clazz, String key, Object value,
-
 
253
			String clazzJoinKey, String joinClazzKey, Class<V> joinClazz, Class<U> selector, String selectorKey,
-
 
254
			String orderByDescKey);
-
 
255
	// public <T, V> List<T> selectAllByEqualsWithJoin(Class<T> clazz, Map<String,
158
	//public <T, V> List<T> selectAllByEqualsWithJoin(Class<T> clazz, Map<String, Object> clazzObjectParams, String clazzJoinKey, String joinClazzKey, Class<V> joinClazz, Map<String, Object> joinClazzObjectParams);
256
	// Object> clazzObjectParams, String clazzJoinKey, String joinClazzKey, Class<V>
-
 
257
	// joinClazz, Map<String, Object> joinClazzObjectParams);
159
	
258
 
160
	public <T> int deleteById(Class<T> clazz, int id);
259
	public <T> int deleteById(Class<T> clazz, int id);
-
 
260
 
161
	public <T> int deleteByEquals(Class<T> clazz, Map<String, Object> objectMap);
261
	public <T> int deleteByEquals(Class<T> clazz, Map<String, Object> objectMap);
-
 
262
 
162
	public <T> int deleteByEqual(Class<T> clazz, String key, Object value);
263
	public <T> int deleteByEqual(Class<T> clazz, String key, Object value);
163
	
264
 
164
	public <T> int updateById(Class<T> clazz, String key, Object value, int id);
265
	public <T> int updateById(Class<T> clazz, String key, Object value, int id);
-
 
266
 
165
	public <T> int updateByEquals(Class<T> clazz, String key, Object value, Map<String, Object> objectParams);
267
	public <T> int updateByEquals(Class<T> clazz, String key, Object value, Map<String, Object> objectParams);
-
 
268
 
166
	public <U, T> List<U> selectAllDistinctByEqualsIns(Class<T> clazz, Class<U> selector, String selectorKey, Map<String, Object> eqParams, Map<String, List<?>> inParams, String orderByKey, SortOrder sortOrder);
269
	public <U, T> List<U> selectAllDistinctByEqualsIns(Class<T> clazz, Class<U> selector, String selectorKey,
-
 
270
			Map<String, Object> eqParams, Map<String, List<?>> inParams, String orderByKey, SortOrder sortOrder);
167
 
271
 
168
	public <T> List<T> selectAllByFoFoId(Class<T> clazz, String key, Object value, String orderByDescKey);
272
	public <T> List<T> selectAllByFoFoId(Class<T> clazz, String key, Object value, String orderByDescKey);
169
 
273
 
170
	public <T> List<T> selectAllByEqualGtOrderByAsc(Class<T> clazz, String key, Object value, String gtKey, Object gtValue,
274
	public <T> List<T> selectAllByEqualGtOrderByAsc(Class<T> clazz, String key, Object value, String gtKey,
171
			String orderByDescKey);
275
			Object gtValue, String orderByDescKey);
172
	
276
 
173
	public <T> List<T> selectAllByNullAndNotNull(Class<T> clazz, String nullKey, String notNullKey);
277
	public <T> List<T> selectAllByNullAndNotNull(Class<T> clazz, String nullKey, String notNullKey);
174
 
278
 
175
	public <T> List<T> selectAllByEqualsOrderByAsc(Class<T> clazz, Map<String, Object> objectMap, String orderByDescKey);
279
	public <T> List<T> selectAllByEqualsOrderByAsc(Class<T> clazz, Map<String, Object> objectMap,
-
 
280
			String orderByDescKey);
176
 
281
 
177
	public <X extends Comparable<? super X>, T> X selectMaxFieldValue(Class<T> class1, Class<X> class2, String field);
282
	public <X extends Comparable<? super X>, T> X selectMaxFieldValue(Class<T> class1, Class<X> class2, String field);
178
	
283
 
179
	public <T, V> List<V> selectGroupBySum(Class<T> class1, Class<V> class2, Map<String, Object> equalsParam, String groupByField, String aggregateField);
284
	public <T, V> List<V> selectGroupBySum(Class<T> class1, Class<V> class2, Map<String, Object> equalsParam,
-
 
285
			String groupByField, String aggregateField);
180
	
286
 
181
	public <T> List<T> selectAllByLikesOrderBy(Class<T> class1, int count, String sortKey, SortOrder sortOrder, Map<String,String> ...andLikesMap);
287
	public <T> List<T> selectAllByLikesOrderBy(Class<T> class1, int count, String sortKey, SortOrder sortOrder,
-
 
288
			Map<String, String>... andLikesMap);
-
 
289
 
182
	<T> List<T> selectDuplicate(Class<T> class1, List<String> groupBy, Map<String, ?> paramsMap);
290
	<T> List<T> selectDuplicate(Class<T> class1, List<String> groupBy, Map<String, ?> paramsMap);
183
	
291
 
184
	<T> List<T> selectAllByInEqualOrderByDescForUpdate(Class<T> clazz, String inKey, List<?> in, String key, Object value,
292
	<T> List<T> selectAllByInEqualOrderByDescForUpdate(Class<T> clazz, String inKey, List<?> in, String key,
185
			String orderByDescKey);
293
			Object value, String orderByDescKey);
-
 
294
 
186
	<T> List<T> selectAllByInsEqualsOrderByForUpdate(Class<T> clazz, Map<String, List<?>> listMap,
295
	<T> List<T> selectAllByInsEqualsOrderByForUpdate(Class<T> clazz, Map<String, List<?>> listMap,
187
			Map<String, Object> objectMap, String orderByDescKey, SortOrder sortOrder);
296
			Map<String, Object> objectMap, String orderByDescKey, SortOrder sortOrder);
-
 
297
 
188
	public <T> T selectByIdForUpdate(Class<T> class1, int id);
298
	public <T> T selectByIdForUpdate(Class<T> class1, int id);
-
 
299
 
189
	<T> List<T> selectAllByEqualsForUpdate(Class<T> clazz, Map<String, Object> objectMap);
300
	<T> List<T> selectAllByEqualsForUpdate(Class<T> clazz, Map<String, Object> objectMap);
-
 
301
 
-
 
302
	public <T> List<T> selectAllByEqualsOrOrderBy(Class<T> clazz, MultiValueMap<String, Object> equalMap, String orderByDescKey,
-
 
303
			SortOrder sortOrder);
190
}
304
}