资源简介
数据库数据写入pdf导出
代码片段和文件信息
package com.rpc.route;
import java.util.linkedHashMap;
import java.util.List;
import java.util.TreeMap;
import javax.servlet.http.HttpServletResponse;
import org.json.JSONobject;
import com.rpc.baseRPC;
import com.rpc.IsExcute;
import com.rpc.RequestInfo;
import java.io.FileOutputStream;
import com.itextpdf.text.Chapter;
import com.itextpdf.text.Document;
import com.itextpdf.text.Font;
import com.itextpdf.text.PageSize;
import com.itextpdf.text.Paragraph;
import com.itextpdf.text.Phrase;
import com.itextpdf.text.Section;
import com.itextpdf.text.pdf.baseFont;
import com.itextpdf.text.pdf.PdfPCell;
import com.itextpdf.text.pdf.PdfPTable;
import com.itextpdf.text.pdf.PdfWriter;
import ywt.Core.Ioc.ServiceImplementation;
@ServiceImplementation(Name = “exportpdf“)
public class ExportPdf extends baseRPC{
private TreeMap requestParasMap = null;
private static final long serialVersionUID = 1L;
public ExportPdf(RequestInfo requestInfo HttpServletResponse response){
this.requestParasMap = requestInfo.requestParasMap;
}
@Override
public JSONobject doPut() throws Exception {
// TODO Auto-generated method stub
return null;
}
@Override
public JSONobject doGet() throws Exception {
JSONobject jo = new JSONobject();
String sql=“select a.ida.user_ida.trip_citya.is_audita.audit_sugesta.pay_commissionFROM_UNIXTIME(a.com_exa_time) as com_exa_time FROM_UNIXTIME(a.trip_stime)“
+ “ as trip_stime FROM_UNIXTIME(a.trip_etime) as trip_etimec.real_namec.mobile (select att_url from m_trip_attachment where trip_id=a.id “
+ “ and att_type =0) as gotrip_url(select att_url from m_trip_attachment where trip_id=a.id and att_type =1) as backtrip_url“
+ “ ( select sugest from m_trip_sugest where id=a.audit_type) as sugest from m_trip_info a “
+ “ left join m_user_log b on a.user_id=b.user_id left join m_user_info c on b.user_id=c.user_id where 1=1 “;
try {
ListnkedHashMap> list = sqlHelper.ExecuteDataMap(sql);
writeCharpter(list);
return IsExcute.isExceptionStr(jo 200 requestParasMap);
} catch (Exception e) {
e.printStackTrace();
}
return IsExcute.isExceptionStr(jo 300 requestParasMap);
}
@Override
public JSONobject doPost() throws Exception {
// TODO Auto-generated method stub
return null;
}
@Override
public JSONobject doDelete() throws Exception {
// TODO Auto-generated method stub
return null;
}
/**
* 添加含有章节的pdf文件
*
* @throws Exception
*/
public static void writeCharpter(ListnkedHashMap> list) throws Exception {
/* 设置中文编码 */
baseFont baseFontChinese = baseFont.create
相关资源
- java并发编程实战高清版pdf
- java并发编程实战pdf
- Java-核心技术-36-讲李运华完.pdf
- Java Generics and Collections.pdf
- rpi_DATA_2711_1p0_preliminary.pdf
- 一线大厂Java多线程面试120题.pdf
- 基于RocketMQ的MQTT消息推送服务器分布
- JAVA并发编程实战.pdf
- [Java并发编程实践].(Java.Concurrency.i
- java根据模板导出PDF详细教程(包含统
- 《Android应用程序开发与典型案例》
- PDFBOX JAR包
- The Java Programming Language.4th.Edition.Aug.
- pdf-chinese.zip
- C语言大全第4版+源码(PDF)
- Expert-One-on-one J2EE Development Without EJB
- 《Android移动应用设计与开发》PDF
- Java核心技术+卷1+基础知识+原书第9版
- 《程序员代码面试指南 》左神 高清
- Android APP渗透测试方法大全.pdf
- java生成pdf文件Demo加印章
- java html模板 itext 生成pdf 页眉页脚 合
- Spring实战第4版高清完整版PDF-
- JavaCard 智能卡程序开发三部曲 pdf版
- Android开发入门与实战 第2版 pdf
- JAVA开发实战经典(名师讲坛)].李兴
- 大话JAVA:从零基础到数据库、WEB开发
- JAVA后台面经.pdf
- 《Java 深度历险》合并修订 PDF(Mc G
- Java中使用 FreeMarker 生成pdf盖章合同文
评论
共有 条评论