1.xml文件
<select id="exportBfhtreswExcel" resultType="com.icbc.icbc.entity.Bfhtresw">
select
<include refid="Base_Column_List" />
from T_BFHTRESW
</select>
2.Mapper
List<Bfhtresw> exportBfhtreswExcel();
3.实现类接口
List<Bfhtresw> exportBfhtreswExcel();
4.实现类
/**
* 导出数据表
* @return
*/
@Override
public List<Bfhtresw> exportBfhtreswExcel() {
return iBfhtreswDao.exportBfhtreswExcel();
}
5.controller
public void exportBfhtresw(HttpServletRequest request, HttpServletResponse response, String fileName) throws Exception {
List<Bfhtresw> bfhtreswList = iBfhtreswService.exportBfhtreswExcel();
// 创建工作簿
HSSFWorkbook workbook = new HSSFWorkbook();
// 创建表
HS