java读取数据库保持到Excel


package org.zbq.service.impl;

import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.zbq.bean.User;
import org.zbq.dao.UserDAO;
import org.zbq.service.UserService;

public class UserServiceImpl implements UserService {
	private UserDAO dao;

	public UserDAO getDao() {
		return dao;
	}

	public void setDao(UserDAO dao) {
		this.dao = dao;
	}

	@Override
	public void doSaveUser(User user) {
		dao.doSaveUser(user);
	}

	@Override
	public void doDeleteUser(User user) {
		dao.doDeleteUser(user);
	}

	@Override
	public void doUpdateUser(User user) {
		dao.doUpdateUser(user);
	}

	@Override
	public User findUserById(Long id) {
		return dao.findUserById(id);
	}

	@Override
	public List<User> findAllUsers() {
		return dao.findAllUsers();
	}
	
	@Override
	public InputStream getInputStream(){
		HSSFWorkbook wb = new HSSFWorkbook();
		HSSFSheet sheet = wb.createSheet("sheet1");
		
		HSSFRow row = sheet.createRow(0);
		HSSFCell cell = row.createCell(0);
		cell.setCellValue("序号");
		
		cell = row.createCell(1);
		cell.setCellValue("姓");
		
		cell = row.createCell(2);
		cell.setCellValue("名");
		
		cell = row.createCell(3);
		cell.setCellValue("年龄");
		
		List<User> list = this.findAllUsers();
		for(int i=0; i<list.size(); i++){
			User user = list.get(i);
			row = sheet.createRow(i+1);
			
			cell = row.createCell(0);
			cell.setCellValue(i+1);
			
			cell = row.createCell(1);
			cell.setCellValue(user.getFirstName());
			
			cell = row.createCell(2);
			cell.setCellValue(user.getLastName());
			
			cell = row.createCell(3);
			cell.setCellValue(user.getAge());
		}
		
		ByteArrayOutputStream baos = new ByteArrayOutputStream();
		try {
			wb.write(baos);
		} catch (IOException e) {
			e.printStackTrace();
		}
		byte[] b = baos.toByteArray();
		InputStream is = new ByteArrayInputStream(b);
		return is;
	}
}


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值