word或excel导出

来源：互联网发布：帽子买什么牌子好知乎编辑：程序博客网时间：2024/04/28 07:51

说明：实现的功能是checkBox选择多个订单对象，然后由word或excel导出

Jsp页面

<a href="javascript:exportOrders('excel')">批量导出订单(excel)</a>

<a href="javascript:exportOrders('word')">批量导出订单(word)</a>

--------------------------------------------------------------

Js文件

* 批量导出订单

*将要导出数据id进行拼接

function exportOrders(model) {

//messageId是checkbox的id

var messageIds = document.getElementsByName("messageId");

var orderIds = "";

var checkedCount = 0;

for ( var i = 0; i < messageIds.length; i++) {

if (messageIds[i].checked) {

checkedCount++;

}

if (checkedCount <= 0) {

alert("请至少选择一条数据!");

return;

} else {

for ( var i = 0; i < messageIds.length; i = i + 1) {

if (messageIds[i].checked) {

orderIds += ("'"+messageIds[i].value + "';");

}

document.getElementById("orderIds").value = orderIds;

document.getElementById("model").value = model;

var action = document.myForm.action;// 记录之前的Action，用完之后，恢复原状

document.myForm.action = "order/exportOrders/";

document.myForm.submit();

document.myForm.action = action;

}

--------------------------------------------------------------

Struts.xml文件

<actionname="exportOrders"method="exportOrders" class="com.cloudsoar3c.action.OrderAction">

<result name="excel">/WEB-INF/order/exportOrdersExcel.jsp

</result>

<result name="word">/WEB-INF/order/exportOrdersWord.jsp

</result>

<interceptor-ref name="securityStack"></interceptor-ref>

</action>

--------------------------------------------------------------

Action文件

/**

* 批量导出订单信息(excel/word)

* @return

public String exportOrders(){

String stringOrderIds = this.request.getParameter("orderIds");

String model = this.request.getParameter("model");

String orderIds = Util.charReplacement(stringOrderIds, ";", ",");

Util.log(orderIds);

List<TOrder> orderList = this.orderBiz.getOrderListByIds(orderIds);

Util.log("导出的订单集合大小："+orderList.size());

super.request.setAttribute("orderList", orderList);

return "excel".equals(model.trim()) ? "excel" : "word";

}

--------------------------------------------------------------

/**

* 拆分字符串(将"A#B#C#D#E#F#"格式的字符串转换为"A,B,C,D,E,F"),并输出 */

public static String charReplacement(String sourceStr, String sourceChar,

String targetChar) {

String result = "";

// 将需要处理的字符串中含有的sourceChar,全部替换为targetChar

String temp = sourceStr.replaceAll(sourceChar, targetChar);

// 截取字符串中最后一个字符;

int len = temp.length();

result = temp.substring(0, len - 1);

return result;

}

-------------------------------------------------------------------

导出Excel的返回页面 exportOrdersExcel.jsp

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>

<%@ page contentType="text/html; charset=GBK" %>

<%@taglib uri="/struts-tags" prefix="s"%>

<%@page import="java.util.*"%>

<%@page import="java.text.SimpleDateFormat"%>

<% response.setContentType("application/vnd.ms-excel;charset=GBK"); %>

<HTML>

<body>

request.setCharacterEncoding("GBK");

SimpleDateFormat sf=new SimpleDateFormat("yyyy-MM-dd_HH_mm_ss");

response.setHeader("Content-Disposition", "attachment;filename=order_"+sf.format(new Date())+".xls");

<td>实际需付金额（元）</td>

<td>订单完成时间</td>

</tr>

<s:iterator value="#request.orderList" var="order" status="st">

<td style="mso-number-format:'\@';">${st.count }</td>

</td>

</tr>

</s:iterator>

</table>

</body>

</HTML>

-------------------------------------------------------------------

导出word的返回页面 exportOrdersWord.jsp

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>

<%@ page contentType="text/html; charset=GBK"%>

<%@taglib uri="/struts-tags" prefix="s"%>

<%@page import="java.util.*"%>

<%@page import="java.text.SimpleDateFormat"%>

response.setContentType("application/vnd.ms-word;charset=GBK");

<HTML>

<head>

</head>

<body>

request.setCharacterEncoding("GBK");

SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd_HH_mm_ss");

response.setHeader("Content-Disposition",

"attachment;filename=order_" + sf.format(new Date())

+ ".doc");

<td>实际需付金额（元）</td>

<td>订单完成时间</td>

</tr>

<s:iterator value="#request.orderList" var="order" status="st">

<td style="mso-number-format:'\@';">${st.count }</td>

<td style="mso-number-format:'\@';"> <s:property

value="#order.orderId" />

</td>

<td style="mso-number-format:'\@';"> <s:property

value="#order.price" />

</td>

<td style="mso-number-format:'\@';"> <s:property

value="#order.buyCount" />

</td>

<td style="mso-number-format:'\@';"> <s:property

value="%{@com.cloudsoar3c.tools.Util@getTotalPriceByOrder(#order.totalPrice)}" />

</td>

<td style="mso-number-format:'\@';"> <s:property

value="#order.preferentialPrice" /></td>

<td style="mso-number-format:'\@';"> <s:property

value="%{@com.cloudsoar3c.tools.Util@getActualPayByOrder(#order.totalPrice,#order.preferentialPrice)}" />

</td>

<td style="mso-number-format:'\@';"> <s:date

name="#order.orderTime" format="yyyy-MM-dd HH:mm:dd" />

</td>

<td style="mso-number-format:'\@';"> <s:date

name="#order.completeTime" format="yyyy-MM-dd HH:mm:dd" />

</td>

<s:property value="#order.TClient.email" />

</td>

<td style="mso-number-format:'\@';"> <s:property

value="#order.TServerHostLicense.hostName" /> </td>

<td style="mso-number-format:'\@';"> <s:property

value="%{#order.TStatusTypeContent.statusTypeContent}" />

</td>

</tr>

</s:iterator>

</table>

</body>

</HTML>

=================================================================================

------------------------------------------------------------------------------------------------------------------------------------------

Txt导出与上部分完全没关系

------------------------------------------------------------------------------------------------------------------------------------------=================================================================================

Isp页面值

<a href="javascript:exportCustomers('telphone')">导出客户手机号码(txt)</a>

<a href="javascript:exportCustomers('email')">导出客户Email(txt)</a>

</div>

------------------------------------------------------------------------------------------------------------------------------------------

Js文件

* 批量导出电话或Email

function exportCustomers(model) {

//messageId是checkbox的id

var messageIds = document.getElementsByName("messageId");

var customerIds = "";

var checkedCount = 0;

for ( var i = 0; i < messageIds.length; i++) {

if (messageIds[i].checked) {

checkedCount++;

}

if (checkedCount <= 0) {

alert("请至少选择一条数据!");

return;

} else {

//将要导出数据id进行拼接

for ( var i = 0; i < messageIds.length; i = i + 1) {

if (messageIds[i].checked) {

customerIds += (""+messageIds[i].value + ";");

}

document.getElementById("customerIds").value = customerIds;

document.getElementById("model").value = model;

var action = document.main.action;// 记录之前的Action，用完之后，恢复原状

document.main.action = "customer/exportCustomer/";

document.main.submit();

document.main.action = action;

}

------------------------------------------------------------------------------------------------------------------------------------------

Struts文件与原来一样

------------------------------------------------------------------------------------------------------------------------------------------

Action文件

//导出电话和 email

public String exportCustomer(){

//保存选择的id

String stringCustomerIds = this.request.getParameter("customerIds");

//保存导出类型 tell还是email

String model = this.request.getParameter("model");

String customerIds = Util.charReplacement(stringCustomerIds, ";", ",");

String[] ids=customerIds.split(",");

try {

HttpServletResponse response = ServletActionContext.getResponse();

response.setContentType("application/octet-stream;charset=UTF-8");

response.setHeader("Content-Disposition","attachment;filename=\"data.txt\"");

PrintWriter writer = new PrintWriter(response.getOutputStream());

if(model.equals("email")){

for (int i = 0; i < ids.length; i++) {

TCustomerInfo c=customerInfoBiz.findById(Integer.parseInt(ids[i]));

if(StringUtils.hasText(c.getEmail())){

writer.write(""+c.getEmail()+";\r\r\n");

}

}else{//telphone

for (int i = 0; i < ids.length; i++) {

TCustomerInfo c=customerInfoBiz.findById(Integer.parseInt(ids[i]));

if(StringUtils.hasText(c.getTelephone())){

writer.write(""+c.getTelephone()+";\r\r\n");

}

writer.close();

} catch (IOException e) {

e.printStackTrace();

}

return null;

}

0 0