caoze(大漠孤烟) 谢谢 我照着http://www.china-pub.com/computers/eMook/1562/info.htm 上面的脚本做了一个函数 但在执行的时候碰到这样一个错误: var fso =new ActiveXObject("Scripting.FileSystemObject"); automation 服务器不能创建对象 能告诉我原因和怎么解决这个问题吗? function createfile(){ var path ="\yesky.txt"; var fso =new ActiveXObject("Scripting.FileSystemObject"); var exist =fso.FileExists(path);//要打开的文件是否存在 if (!exist) { alert("c:\\yesky.txt"); fso.CreateTextFile(path)};//如果不存在则创建该文件,访问根本不存在的文件会出错 var ts =fso.OpenTextFile(path,2); //以写的方式打开文本文件 ts.Close(); //关闭文本 }
function createfile(){ var path ="c:\\yesky.txt";//这样页错~ var fso =new ActiveXObject("Scripting.FileSystemObject"); var exist =fso.FileExists(path);//要打开的文件是否存在 if (!exist) { alert("c:\\yesky.txt"); fso.CreateTextFile(path)};//如果不存在则创建该文件,访问根本不存在的文件会出错 var ts =fso.OpenTextFile(path,2); //以写的方式打开文本文件 ts.Close(); //关闭文本 }
java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd"); mysql2="select count(sphm) as jls, sum(sjze) as ze from sk_jksyxh"; mysql="select * from sk_jksyxh"; try{ rs2=conn.executeQuery(mysql2); rs2.next(); rs=conn.executeQuery(mysql);
你先看看,如果不行,在把你的需求说出来看看我能不能帮上忙祝你好运!
是客户端的,能给我一段源码吗?
最好服务器端的也给我一段源码,我在学习JAVA了,呵呵
我去看看log4,
需求就是把一个结果集数据,按照一定的格式,保存成一个TXT文件,存到指定的路径里帮帮忙啊~~
谢谢
我照着http://www.china-pub.com/computers/eMook/1562/info.htm
上面的脚本做了一个函数
但在执行的时候碰到这样一个错误:
var fso =new ActiveXObject("Scripting.FileSystemObject");
automation 服务器不能创建对象
能告诉我原因和怎么解决这个问题吗?
function createfile(){
var path ="\yesky.txt";
var fso =new ActiveXObject("Scripting.FileSystemObject");
var exist =fso.FileExists(path);//要打开的文件是否存在
if (!exist) {
alert("c:\\yesky.txt");
fso.CreateTextFile(path)};//如果不存在则创建该文件,访问根本不存在的文件会出错
var ts =fso.OpenTextFile(path,2); //以写的方式打开文本文件
ts.Close(); //关闭文本 }
var path ="c:\\yesky.txt";//这样页错~
var fso =new ActiveXObject("Scripting.FileSystemObject");
var exist =fso.FileExists(path);//要打开的文件是否存在
if (!exist) {
alert("c:\\yesky.txt");
fso.CreateTextFile(path)};//如果不存在则创建该文件,访问根本不存在的文件会出错
var ts =fso.OpenTextFile(path,2); //以写的方式打开文本文件
ts.Close(); //关闭文本 }
package gkgl.file;
import gkgl.database.*;
import java.io.*;
import java.sql.*;
import java.util.*;
import java.net.*;//import com.htjs.opcenter.*;
/**
* 从横向联网系统导出税票部分供国库2000接收
* @author jiadelin
* datetime 2003.7.9
* */
public class export {
public export() throws SQLException{}
/*public static void main(String[] args) throws SQLException,IOException
{
sendtax s=new sendtax();
System.out.println(s.sendgz());
}*/
public String export_tk(String hsdw) throws SQLException
{
String ret="";
String m="";
String s4="";
int jls=0;
String sql="";
LinkSQL conn=new LinkSQL();
ResultSet rs2;
try{
String mysql="select sphm,gkbm_dm,ysjc_dm,yskm_dm,fzbz,sjze,nsrsbh,tkyy_dm,jm_dm,yhzh,yhdm from sk_ttkyxh where gkhsbm_dm='"+hsdw+"'" ;
ResultSet rs=conn.executeQuery(mysql);
while(rs!=null && rs.next()){
ret="";
ret=ret+rs.getString("sphm")+","; //凭证编号
ret=ret+"1111111111,"; //征收机关代码
ret=ret+rs.getString("gkbm_dm")+",";//收款国库代码
ret=ret+rs.getString("gkbm_dm")+",";//目的国库代码
ret=ret+rs.getString("ysjc_dm")+",";//预算级次代码
ret=ret+"1,"; //预算种类编码
ret=ret+rs.getString("yskm_dm")+",";//预算科目代码
ret=ret+rs.getString("fzbz").trim()+",";//辅助标志
ret=ret+rs.getString("tkyy_dm").trim()+",";//退库原因代码
ret=ret+rs.getString("jm_dm").trim()+",";//退库依据
ret=ret+"1111111111,"; //审批机关代码
ret=ret+"0,"; //退库比例
ret=ret+"0,"; //退库总额
ret=ret+rs.getString("sjze")+",";//实缴总额
ret=ret+"0,";//退回标志
ret=ret+rs.getString("yhzh")+",";//收款帐号
ret=ret+rs.getString("nsrsbh");//收款单位代码
m=m+ret+"\r\n"; //一行明细
jls=jls+1; //记录条数
}
//组包
s4=s4+m;//明细
}
catch(SQLException ex)
{
System.out.println(ex.getMessage());
}
finally{conn.close();}
return m;
}
public String sendjks(String zt,String hsdw) throws SQLException
{
String ret="";
String m="";
String s4="";
int jls=1;
String sql="";
LinkSQL conn=new LinkSQL();
ResultSet rs2;
try{
//conn.executeUpdate(mysql);
String mysql="select sphm,gkbm_dm,ysjc_dm,yskm_dm,fzbz,sjze from sk_spxx where zt like'"+zt+"%' and gkhsbm_dm='"+hsdw+"'";
ResultSet rs=conn.executeQuery(mysql);
while(rs!=null && rs.next()){
ret="";
ret=ret+"1111111111,";//单位代码为空
ret=ret+rs.getString("gkbm_dm")+",";//目的国库代码
ret=ret+rs.getString("gkbm_dm")+",";//收款国库代码
ret=ret+"1111111111,"; //征收机关代码
ret=ret+rs.getString("sphm")+","; //凭证编号
ret=ret+"2,"; //缴款书种类编码
ret=ret+","; //开户行为空
ret=ret+rs.getString("ysjc_dm")+",";//预算级次代码
ret=ret+"1,"; //预算种类编码
ret=ret+rs.getString("yskm_dm")+",";//预算科目代码
ret=ret+rqstr(rs.getString("fzbz"))+",";//辅助标志
ret=ret+rs.getString("sjze");//实缴总额
m=m+ret+"\r\n"; //一行明细
jls=jls+1; //记录条数
}
//组包
s4=s4+m;//明细
}
catch(SQLException ex)
{
System.out.println(ex.getMessage());
}
finally{conn.close();}
//res="";
//res=com.htjs.opcenter.client.SendMsg("83.24.19.15",1780,s4,100);
return m;
}
//10日期转换为8位
public String rqzh(String rq){
if (rq=="null") {return "";}
else{
return rq.substring(0,4)+rq.substring(5,7)+rq.substring(8,10);
}
}
public String rqstr(String rq){
if (rq==null) {return "";}
else{
return rq.trim();
}
}
public static String convert(String value) {
try{
String s = new String(value.getBytes("ISO-8859-1"),"GBK");
return s;
}catch(Exception e) {return null;}
}
}3.jsp
<%@ page import="java.sql.*"%>
<%@ page import=" java.io.*"%>
<jsp:useBean id="send" scope="page" class="czgl.file.export"/>
<%
String res=send.sendjks("1606000000");
String headpath=request.getRealPath("/");
String filename = "2003070800110.txt";
File file=new File(headpath+"/tempfile/"+filename);
file.delete();
if (res!=null) {
FileWriter fw=new FileWriter(headpath+"/tempfile/"+filename,true);
String writeStr="";
writeStr=res;
fw.write(writeStr,0,writeStr.length());
fw.flush();
//fw.response;
fw.close();
response.setContentType("application/octet-stream");
response.setHeader("Content-disposition", "attachment; filename=" + filename);
BufferedInputStream bis = null;
BufferedOutputStream bos = null;
try
{
FileInputStream fis = new FileInputStream(headpath+"/tempfile/"+filename);
bis = new BufferedInputStream(fis);
bos = new BufferedOutputStream(response.getOutputStream());
byte abyte0[] = new byte[2048];
int i;
while((i = bis.read(abyte0, 0, abyte0.length)) >0)
bos.write(abyte0, 0, i);
}
catch(IOException ioexception)
{
ioexception.getMessage();
throw ioexception;
}
finally
{
if(bis != null)
bis.close();
if(bos != null)
bos.close();
file.delete();
}
}else{
out.println("<SCRIPT LANGUAGE=\"JavaScript\">");
out.println("alert('无法');");
out.println("</SCRIPT>");
}
%>
<%@ page language="java" contentType="text/html; charset=GBK" %>
<%@page language="java" import="java.sql.*" %>
<jsp:useBean id="jsp" scope="page" class="czgl.include.OutString"></jsp:useBean>
<jsp:useBean id="conn" scope="page" class="czgl.database.LinkSQL"/>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="/include/css.css" REL="stylesheet" type="text/css">
<script language="Javascript" src="/include/mydate.js"></script>
</head>
<% int i=0;
ResultSet rs=null;
ResultSet rs2=null;
String mysql="";
String mysql2="";
java.util.Date date=new java.util.Date();
java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd");
mysql2="select count(sphm) as jls, sum(sjze) as ze from sk_jksyxh";
mysql="select * from sk_jksyxh";
try{
rs2=conn.executeQuery(mysql2);
rs2.next();
rs=conn.executeQuery(mysql);
%>
<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="post" action="">
入库日期
<input type="text" name="tfrq" size="10" maxlength="10" value="<%=sdf.format(date)%>">
<input type="button" value="↓" onclick="dateShow(tfrq);"> 总记录数:
<input type="text" name="jls" size="10" maxlength="10" value="<%=rs2.getString("jls")%>">
总金额:
<input type="text" name="jls" size="10" maxlength="10" value="<%=rs2.getString("ze")%>">
<table border="1" width="98%" bordercolorlight="#000000" bordercolordark="#000000" cellspacing="0" cellpadding="0" align="center">
<tr class="tr" align="center">
<td>印刷税票号码</td>
<td>纳税人识别号</td>
<td> 税额</td>
<td> 税票种类</td>
<td>预算科目</td>
<td> 预算分配比例</td>
<td> 登记注册类型</td>
<td> 开票日期</td>
<td>所属期起</td>
<td>所属期止</td>
</tr>
<% while (rs.next()) { i=i+1; %>
<tr>
<td nowrap> <%=rs.getString("yssphm")%></td>
<td nowrap> <%=rs.getString("nsrsbh")%></td>
<td nowrap> <%=rs.getString("sjze")%></td>
<td nowrap> <%=jsp.convert(rs.getString("pz_zl_jc"))%></td>
<td nowrap> <%=jsp.convert(rs.getString("yskm_mc"))%></td>
<td nowrap> <%=jsp.convert(rs.getString("ysfpbl_mc"))%></td>
<td nowrap> <%=jsp.convert(rs.getString("djzclx_mc"))%></td>
<td nowrap> <%=rs.getDate("kprq")%></td>
<td nowrap> <%=rs.getDate("sssq_q")%></td>
<td nowrap> <%=rs.getDate("sssq_z")%></td>
</tr>
<%};
}
catch(SQLException ex)
{
out.println(ex.getMessage());
}
finally{
rs=null;
rs2=null;
conn.close();}
%>
</table>
<p align="center"><input type="button" value="导出" onclick="location.replace('export.jsp');"></p>
</form>
</body>
</html>