亚洲欧美乱色情图片,看亚洲a级一级毛片,亚洲资源在线视频

excel文件下載,數據庫字段datafiled檢索--JS URL傳值給servlet亂碼

1 //javascript里面加密兩次，兩次才可以的。2 var url = "servlet/getText?name=" + encodeURI(encodeURI(name));

function show()

{

var name="test";

var admin="ok";

var url = "http://localhost:7001/sosuo/ggld/fleet?reloadVessel="

+ encodeURI(encodeURI(name))+"&reloadVoyage="+ encodeURI(encodeURI(admin));

window.open(url);

}

</script>

1 //在java里面，通過指定的編碼解密即可。2 String name = URLDecoder.decode(request.getParameter("name"),"utf-8");

web.xml配置:

<servlet>  <servlet-name>fleetDataDownload</servlet-name> <servlet-class>com.cenin.util.FleetDataDownload</servlet-class> </servlet>

<servlet-mapping> <servlet-name>fleetDataDownload</servlet-name> <url-pattern>/ggld/fleet</url-pattern> </servlet-mapping>

DataDownload.java頁面:

package com.cenin.util;

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

import java.net.*;

import java.sql.*;

import org.apache.commons.digester.Digester;

import org.apache.log4j.Logger;

import com.cenin.database.DBManager;

public class DataDownload extends HttpServlet

{

private static Logger logger = Logger.getLogger(DataDownload .class);

public void init(ServletConfig config) throws ServletException

{

super.init(config);

try

{

}

catch(Exception ex)

{

logger.info(ex.getMessage());

}

public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException

{

doPost(request,response);

}

public void doDownload(HttpServletRequest request, HttpServletResponse response, String fileName, String vessel, String voyage)

{

try

{

response.reset();

response.setContentType("application/vnd.ms-excel");

response.setHeader("Content-Disposition", "inline; filename=\""+ fileName + "\"");

ServletOutputStream sos = response.getOutputStream();

String title = "數據導出";

String[] fieldTitles = {"船名", "航次", "提單號", "箱號", "鉛封號", "箱型", "貨名", "重量", "體積", "發貨人", "收貨人", "裝貨港", "卸貨港"};

String[] fieldNames = {"szVessel", "szVoyage", "szBlNo", "szCtnNo", "szSealNo", "szCtnType", "szCargoName", "fWeight", "fVolume", "szReceiver", "szSender", "szLoadPortCode", "szDischargePortCode"};

int[] widths = {100, 50, 100, 120, 120, 50, 100, 50, 50, 80, 80, 80, 80};

Connection conn = DBManager.getInstance().getConnection();

Statement stmt=conn.createStatement();

String sql = "select * from NmhContainer where szVessel='" +

vessel + "' and szVoyage='" + voyage + "'"; // and szBlNo='" + blno + "'";

ResultSet rs = stmt.executeQuery(sql);

OutputUtil.excelOutput(title, fieldTitles, fieldNames, widths, rs, sos, "ISO-8859-1", "GBK");

DBManager.getInstance().freeDBResource(rs, stmt, conn);

}

catch(Exception ex)

{

logger.info(ex.getMessage());

}

public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException

{

try

{

String vessel = request.getParameter("reloadVessel");

String voyage = request.getParameter("reloadVoyage");

//String blno = request.getParameter("reloadBlno");

String name = vessel + "_" + voyage + "_" + ".xls";

doDownload(request, response, name, vessel, voyage);

}

catch(Exception ex)

{

logger.info(ex.getMessage());

}

OutputUtil.java頁面:

package com.cenin.util;

* 輸出PDF, Excel等格式

* 2005.5.12 by chenyong@cenin

* 2005.12.19

import jxl.Workbook;

import jxl.write.*;

import com.lowagie.text.Document;

import com.lowagie.text.Rectangle;

import com.lowagie.text.Font;

import com.lowagie.text.PageSize;

import com.lowagie.text.HeaderFooter;

import com.lowagie.text.Phrase;

import com.lowagie.text.Element;

import com.lowagie.text.Table;

import com.lowagie.text.pdf.*;

import java.io.*;

import java.util.*;

import java.sql.*;

import org.apache.log4j.Logger;

public class OutputUtil

{

private static Logger logger = Logger.getLogger(OutputUtil.class);

/*******************************************************

* pdf輸出表格

* title為pdf head

* fieldtitles為表頭項目名稱數組

* filenames 為對象屬性名數組

* widths 為寬度％數組

* rs為resultset

* os 為輸出流

* codefrom , codeto 如果需要編碼轉換

*******************************************************/

public static void excelOutput(String title, String[] fieldtitles, String[] fieldnames, int[] widths, ResultSet rs, OutputStream os, String codefrom, String codeto)

{

try

{

int fieldnumber = fieldnames.length; //, cellnumber = fieldnumber*5;

if(fieldnumber!=fieldtitles.length||fieldnumber!=fieldnames.length)

return;

WritableWorkbook workbook = Workbook.createWorkbook(os);

WritableSheet sheet = workbook.createSheet(title, 0);

//add field title

for(int i=0;i<fieldnumber;i++)

{

//String temp = new String(fieldtitles[i].getBytes(codefrom), codeto);

sheet.addCell(new Label(i, 0, fieldtitles[i]));

}

//add values

int i=0;

while(rs.next())

{

for(int j=0; j<fieldnames.length; j++)

{

if(rs.getString(fieldnames[j])!=null)

{

//String temp1 = rs.getString(fieldnames[j]);

String temp = new String(rs.getString(fieldnames[j]).getBytes("ISO-8859-1"), "GBK");

sheet.addCell(new Label(j, i+1, temp));

}

else

sheet.addCell(new Label(j, i+1, ""));

}

i++;

}

//write to excel

workbook.write();

workbook.close();

}

catch(Exception e)

{

logger.info(e.toString());

}

/*例子

FileOutputStream os = new FileOutputStream("e:\\a.xls");

String[] titles = {"系統編號","員工","用戶帳號"};

String[] fieldnames = {"lsystemUserId","staff.szname","szaccount"};

int[] widths = {20,20,20};

//OutputUtil.pdfOutput("my pdf輸出", titles, fieldnames, widths,objectList,os);

//OutputUtil.excelOutput("excel輸出", titles, fieldnames, widths,objectList,os);

posted on 2012-09-20 17:04 youngturk 閱讀(450) 評論(0) 編輯收藏所屬分類: JavaScript 、JS , DHTML 、Java基礎、Flex DEV 、servlet

新用戶注冊刷新評論列表


只有注冊用戶登錄后才能發表評論。




網站導航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關文章: js post方法獲得父窗口字段值window.dialogArguments.document.getElementById("hwlxcn").value; http post 方法 js數據結構(轉) javascrip與頁面執行順序 FCKEditor2.6.3配合Java的使用步驟 (后臺文本編輯器) EL表達式不起作用原因 excel文件下載,數據庫字段datafiled檢索--JS URL傳值給servlet亂碼 flex回調js,在主頁面html中添加, js中onload調用兩種方法，先加載js再加載頁面和先加載頁面后加載js

excel文件下載,數據庫字段datafiled檢索--JS URL傳值給servlet亂碼

導航

統計

公告

常用鏈接

留言簿(6)

隨筆分類

隨筆檔案

文章分類

文章檔案

相冊

EJB學習

Flex學習

learn English

oracle

spring MVC web service

SQL

Struts

生活保健

解析文件

搜索

最新評論

閱讀排行榜

評論排行榜