- Java操作办公室软件的框架
a) jxl:只能对Excel进行操作,属于比较老的框架。
POI:是apache的项目,可对ms(微软)的word,Excel,PPT进行操作,包括office2003和2007。
b) POI框架学习
i. 导包
ii. 第一个demo
- EasyPOI导入导出
a) 导入easyPOI的包
<!-- easypoi的支持 -->
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-base</artifactId>
<version>3.2.0</version>
</dependency>
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-web</artifactId>
<version>3.2.0</version>
</dependency>
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-annotation</artifactId>
<version>3.2.0</version>
</dependency>
b)
在我们要进行数据操作的实体类中的属性上打上@Excel(name=”XXX”)
这里的savePath表示是图片在项目中的路径
@Excel(name = "头像",type = 2,savePath = "/images/head",height = 23)
private String headImage; //头像的导出
如果是关联对象的话在关联对象的属性上面打上@ExcelEntity
@ExcelEntity
private Department department;
c) 前台JSP页面添加按钮后台写业务逻辑,传入ModelMap,query,request作为参数,写完之后需要在Springmvc的xml配置文件中去配置扫描easypoi的一些view:视图
传入的request参数用来解决图片路径问题,request获取项目根路径与图片路径拼接。
d) 在Employee对象里面去加@Excel注解
@Entity
@Table(name="employee")
public class Employee extends BaseDomain {
@Excel(name="用户名")
private String username;
private String password;
@Excel(name="邮件",width = 25)
private String email;
@Excel(name="年纪")
private Integer age;
@Excel(name = "头像",type = 2,savePath = "/images/head",height = 23)
private String headImage; //头像
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name="department_id")
//Json Ignore(忽略) Properties(属性)
//@JsonIgnoreProperties(value={"hibernateLazyInitializer","handler","fieldHandler"})
@ExcelEntity
private Department department;
这里必须写get和set方法
}
部门有相应的关连
@Entity
@Table(name="department")
public class Department extends BaseDomain {
@Excel(name = "部门名称")
private String name;
}
e)employee.JSP 页面添加按钮
<form id="searchForm" action="/employee/download">
用户名: <input name="username" class="easyui-textbox" style="width:80px">
邮件: <input name="email" class="easyui-textbox" style="width:80px">
部门:<input name="departmentId" class="easyui-combobox" name="dept"
panelHeight="auto"
data-options="valueField:'id',textField:'name',url:'/util/dept'" />
<a href="#" class="easyui-linkbutton" data-method="search" iconCls="icon-search">查询</a>
<!-- button不加type属性就是提交 -->
<button class="easyui-linkbutton" iconCls="icon-search">导出</button>
</form>
f)EmployeeController文件下载实现
// 文件导出功能
/**
*
* @param map