public
?ActionForward?download(ActionMapping?mapping,?ActionForm?form,
????????????HttpServletRequest?request,?HttpServletResponse?response)
????????????
throws
?Exception?
{
????????????
????????
this
.initActionAttributes(request);
????????
//
System.out.println(uploadForm.getFile().getFileName()+"--size?is?--"+uploadForm.getFile().getFileSize());
????????String?tables
=
new
?String(request.getParameter(
"
TABLE_NAME
"
).getBytes(
"
ISO8859_1
"
));
????????String?table
=
new
?String(request.getParameter(
"
TABLE
"
).getBytes(
"
ISO8859_1
"
));
????????String?con
=
new
?String(request.getParameter(
"
SQL_COND
"
).getBytes(
"
ISO8859_1
"
));
????????String?col
=
new
?String(request.getParameter(
"
TITLE_CODE
"
).getBytes(
"
ISO8859_1
"
));
????????String?colName
=
new
?String(request.getParameter(
"
TITLE_NAME
"
).getBytes(
"
ISO8859_1
"
));
????????String?rowNum
=
new
?String(request.getParameter(
"
ROW_NUM
"
).getBytes(
"
ISO8859_1
"
));
????????String[]?columnName?
=
?colName.split(
"
,
"
);
????????StringBuffer?sb
=
new
?StringBuffer();
????????sb.append(
"
select?
"
).append(col).append(
"
?from?
"
).append(tables).append(
"
?where?
"
).append(con).append(
"
?order?by?(cust.BUSY_IN_CALL_DURATION?+?cust.IDLE_IN_CALL_DURATION)?desc?fetch?first?
"
+
rowNum
+
"
?rows?only
"
);
????????StringBuffer?updateSql
=
new
?StringBuffer();
????????updateSql.append(
"
update?
"
).append(table).append(
"
?set?DOWNLOAD_MARK=1,DOWNLOAD_TIME=current?Date?where?comp_product_no?in(select?cust.comp_product_no?from?DMCF_cust_ms?cust
"
).append(
"
?where?
"
).append(con).append(
"
?order?by?(cust.BUSY_IN_CALL_DURATION?+?cust.IDLE_IN_CALL_DURATION)?desc?fetch?first?
"
+
rowNum
+
"
?rows?only)
"
);
????????String?fileName?
=
?
"
CustInfo
"
?
+
????????
new
?SimpleDateFormat(
"
yyyyMMddHHmmss
"
).format(
new
????java.util.Date())?
+
?
"
.csv
"
;
?????????PrintWriter?pw?
=
?
null
;
?????????Sqlca?m_Sql?
=
?
null
;
//
???????保存到客戶機上
?????????response.setContentType(
"
application/octet-stream;?charset=gbk
"
);
?????????response.setHeader(
"
Content-disposition
"
,?
"
attachment;?filename="
"
?
+
?fileName?
+
?
"
"
"
);
?????????PrintWriter?out1?
=
?
null
;
?????????
try
?
{
?????????
?????????????pw?
=
?
new
?PrintWriter(
new
?FileOutputStream(fileName));
?????????????out1?
=
?response.getWriter();
?????????????
//
標題vector
?????????????Vector?titleVector?
=
?
new
?Vector();
?????????????
for
?(
int
?i?
=
?
0
;?i?
<
?columnName.length;?i
++
)?
{
?????????????????titleVector.add(columnName[i]);
?????????????}
?????????????
for
?(
int
?j?
=
?
0
;?j?
<
?titleVector.size();?j
++
)?
{
?????????????????out1.print(
new
?String(String.valueOf(titleVector.elementAt(j)).getBytes(
"
gbk
"
)));
?????????????????
if
?(j?
==
?titleVector.size()?
-
?
1
)
?????????????????????out1.println();
?????????????????
else
?????????????????????out1.print(
"
,
"
);
?????????????????out1.flush();
?????????????}
?????????????
?????????????m_Sql?
=
?
new
?Sqlca(
new
?ConnectionEx(Const.DATASOURCE));
?????????????m_Sql.execute(sb.toString());
?????????????String?tmpStr;
?????????????
while
?(m_Sql.next())?
{
?????????????????
?????????????????
for
?(
int
?j?
=
?
1
;?j?
<=
?titleVector.size();?j
++
)?
{
?????????????????????tmpStr?
=
?
""
?
+
?m_Sql.getString(j);
?????????????????????out1.write(
new
?String(tmpStr.getBytes(
"
gbk
"
)));
?????????????????????
if
?(j?
==
?titleVector.size())
?????????????????????????out1.println();
?????????????????????
else
?????????????????????????out1.print(
"
,
"
);
?????????????????}
?????????????????out1.flush();
?????????????}
????????????m_Sql.execute(updateSql.toString());
????????????m_Sql.commit();
????????????
?????????}
?
catch
?(Exception?exception)?
{
?????????????m_Sql.rollback();
?????????????
if
(m_Sql?
!=
?
null
)m_Sql.closeAll();
?????????????exception.printStackTrace();
?????????}
?
finally
?
{
?????????????
if
(m_Sql?
!=
?
null
)m_Sql.closeAll();
?????????????
?????????}
????????
????????
return
?mapping.findForward(
"
initAction
"
);
????}
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號聯系： 360901061
您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點擊下面給點支持吧，站長非常感激您！手機微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對您有幫助就好】元
