首页>代码>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;
	}  
    
    
}
 最近下载更多
最近下载更多
                
 
                 
                 
                 最近浏览
最近浏览