注解版 Mybatis 3.1.1 不支持 <script> 标签解决方案
批量查询
/**
* 批量查询指定用户
*
* @param userIds
* 用户ID
* @return 用户
*/
@SelectProvider(type = UserMapperProvider.class,method = "batchSearchUsers")
List<UserDto> batchSearchUsers(@Param("userIds") List<String> userIds);
批量插入
/**
* 批量插入
*
* @param users
* 用户信息
* @return 用户
*/
@InsertProvider(type = UserMapperProvider.class,method = "batchAddUsers")
int batchAddUsers(@Param("users")List<UserDto> users);
UserMapperProvider.java
public class UserMapperProvider{
/**
* 获取指定用户
*
* @param map
* 参数信息
* @return 查询sql
*/
public String batchSearchUsers(Map<String, Object> map) {
@SuppressWarnings("unchecked")
List<String> results = (List<String>) map.get("userIds");
StringBuilder sb = new StringBuilder();
sb.append("select * from users where del_flag = 0 and user_id in (");
MessageFormat mf = new MessageFormat("#'{'userIds[{0}]}");
for (int i = 0; i < results.size(); i++) {
sb.append(mf.format(new Object[]{i}));
if (i < results.size() - 1) {
sb.append(",");
}
}
sb.append(")");
return sb.toString();
}
/**
* 批量插入用户信息
*
* @param map
* 参数
* @return 插入sql
*/
public String batchAddUsers(Map<String, Object> map) {
@SuppressWarnings("unchecked")
List<UserDto> results = (List<UserDto>) map.get("users");
StringBuilder sb = new StringBuilder();
sb.append("insert into users values ");
MessageFormat mf = new MessageFormat("(null, #'{'users[{0}].name},#'{'users[{0}].age},#'{'users[{0}].gender},#'{'users[{0}].address}, null, now(), 0)");
for (int i = 0; i < results.size(); i++) {
sb.append(mf.format(new Object[]{i}));
if (i < results.size() - 1) {
sb.append(",");
}
}
return sb.toString();
}
}
注：暂不支持批量更新
