首页>代码>SSM+Maven+Bootstrap导入excel数据到数据库(支持XLSX,XLS格式)>/ssm Maven Webapp/src/main/java/com/java/service/iml/UserServiceiml.java
package com.java.service.iml;
import java.util.List;
import javax.annotation.Resource;
import org.springframework.stereotype.Service;
import com.java.dao.UserMapper;
import com.java.model.User;
import com.java.service.UserService;
@Service("userService")
public class UserServiceiml implements UserService {
@Resource
private UserMapper Userdao;
/**
* 根据查询条件查询出所有的记录,不用分页,用于excel导出功能
* @param userDeviceVo
* @return
*/
@Override
public List<User> getUserForExcel(User user) {
List<User> list = Userdao.getUserForExcel(user);
Integer order;
for (int i = 0; i < list.size(); i++) {
order = i + 1;
list.get(i).setOrder(order.toString());
if (list.get(i).getStudentsex().equals("1")) {
list.get(i).setStudentsex("男");
} else {
list.get(i).setStudentsex("女");
}
}
return list;
}
@Override
public int insertStudentlist(List<User> userlist) {
// TODO Auto-generated method stub
int count=Userdao.insertStudentlist(userlist);
return count;
}
}
最近下载更多

最近浏览