java导出txt文件的例子

本文介绍了一个简单的Servlet实现,用于导出配置文件比对结果到TXT文件。该Servlet接收设备ID和时间戳参数,从数据库中获取差异数据,并将其以UTF-8编码格式返回给客户端。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

代码很简单就一个servlet,如下:
package com.eastcom.servlet;

import java.io.BufferedOutputStream;
import java.io.IOException;
import java.net.URLEncoder;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.HashMap;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.eastcom.jdbc.JdbcFactory;

public class ExportConstractTxt extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/plain");
String fileName = URLEncoder.encode("配置文件比对结果", "UTF-8");
response.setHeader("Content-Disposition","attachment; filename=" + fileName + ".txt");
String device_id=request.getParameter("device_id");
String time_tamp=request.getParameter("time_tamp");
// result =new String(result.getBytes("iso-8859-1"), "utf-8");
String result=getDIFF(device_id,time_tamp);
//result =new String(result.getBytes("iso-8859-1"), "gbk");
System.out.println(result);
BufferedOutputStream buff = null;
StringBuffer write = new StringBuffer();
String enter = "\r\n";
ServletOutputStream outSTr = null;
try {
outSTr = response.getOutputStream(); // 建立
buff = new BufferedOutputStream(outSTr);
write.append(result.replaceAll("\n", enter));
buff.write(write.toString().getBytes("UTF-8"));
buff.flush();
buff.close();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
buff.close();
outSTr.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
private String getDIFF(String deviceID,String time){
String result="";
Connection Conn=null;
ResultSet rSet=null;
Statement stmt=null;
try {
Conn = JdbcFactory.getInstance().getConnection();
stmt = Conn.createStatement();
String sql ="select diff "+
" from rm.RM_CONF_FILE_DIFF "+
" where device_id = '"+deviceID+"' and to_char(time_stamp, 'yyyy-mm-dd hh24:mi:mm') = '"+time+"' ";
System.out.println("getDIFF sql >"+sql);
rSet=stmt.executeQuery(sql);
while(rSet.next()){
result=rSet.getString("diff");
}
} catch (Exception e) {
e.printStackTrace();
}finally{
if(stmt!=null){
try {
stmt.close();
} catch (Exception e) {
}
}
if(Conn!=null){
try {
Conn.close();
} catch (Exception e) {
}
}
}
return result;
}
}
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值