导出数据（高版本）-CSDN博客

本文链接：https://blog.csdn.net/weixin_44540505/article/details/118274193

该博客介绍了如何使用Java实现从数据库导出数据到Excel文件。从DAO层到Servlet层，详细展示了如何构建SQL查询、处理查询结果、创建Excel工作簿、设置样式并最终导出数据。涉及到的技术包括JDBC、PreparedStatement、ArrayList、SXSSFWorkbook以及Apache POI库。

摘要由CSDN通过智能技术生成

一、创建dao层
1、List selectForExport(String customerNumber, String customerName, String contact, Integer whetherEnable);
二、创建daoImpl层
1、查询出要到出数据名称
2、 private static final String SelectForExport=“SELECT sys_customer.gmt_create,sys_customer.id,sys_customer.customer_name,sys_customer.customer_number,sys_customer.customer_category_id,sys_customer.user_id,sys_customer.supplier_id,sys_customer.whether_enable,sys_customer.picture,sys_customer.contact,sys_customer.contact_phone_number,sys_customer.contact_address,sys_customer.wechat,sys_customer.qq,sys_customer.unit_phone,sys_customer.fax,sys_customer.email,sys_customer.codeee,sys_customer.note,sys_customer.initial_arrears,sys_customer_category.customer_ategory_name,sys_user.user_name,sys_supplier.supplier_name FROM sys_customer INNER JOIN sys_customer_category ON sys_customer.customer_category_id = sys_customer_category.id INNER JOIN sys_user ON sys_customer.user_id = sys_user.id INNER JOIN sys_supplier ON sys_customer.supplier_id = sys_supplier.id WHERE sys_customer.is_deleted=0 AND sys_customer.customer_number LIKE ? AND sys_customer.customer_name LIKE ? AND sys_customer.contact LIKE ? #1#”;
3、获取查询的值
4、 public List selectForExport(String customerNumber, String customerName, String contact, Integer whetherEnable) {
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
List rList=new ArrayList<>();
CustomerVo customerVo=null;
try {
String strQuerySql=SelectForExport;
if (whetherEnable != null){
strQuerySql = strQuerySql.replace("#1#",“AND sys_customer.whether_enable=” + whetherEnable);
}else {strQuerySql = strQuerySql.replace("#1#","");}
conn= JdbcUtils.getConnection();
ps=conn.prepareStatement(strQuerySql);
if (customerNumbernull) customerNumber="";
if (customerNamenull) customerName="";
if (contactnull) contact="";
//-设置参数
ps.setString(1,"%"+customerNumber+"%");
ps.setString(2,"%"+customerName+"%");
ps.setString(3,"%"+contact+"%");
//-执行查询
SysCustomer customer;
rs=ps.executeQuery();
while (rs.next()){
customerVo = new CustomerVo();
//-取值
customerVo.setId(rs.getInt(“id”));
customerVo.setCustomerName(rs.getStri