fileName,Path,str都能取到,但是我在向数据库里面插时,提示 Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))的错误,是什么原因?程序是运行到
Connection con = DriverManager.getConnection(host, userid, password);时抛的错误,请大家帮忙,谢谢~!String sql = "INSERT INTO FILEPATH(SEQ,FILE_NAME,PATH,CONTENT) VALUES(?,?,?,?)";
String host = "jdbc:oracle:thin:@192.168.10.1:1521:TEST";
String userid = "TEST";
String password = "TEST";
Connection con = DriverManager.getConnection(host, userid, password);
PreparedStatement ps = con.prepareStatement(sql);
ps.setInt(1, sequence);
ps.setString(2, fileName);
ps.setString(3, Path);
ps.setString(4, str);
ps.executeUpdate();
ps.close();
con.close();
Connection con = DriverManager.getConnection(host, userid, password);时抛的错误,请大家帮忙,谢谢~!String sql = "INSERT INTO FILEPATH(SEQ,FILE_NAME,PATH,CONTENT) VALUES(?,?,?,?)";
String host = "jdbc:oracle:thin:@192.168.10.1:1521:TEST";
String userid = "TEST";
String password = "TEST";
Connection con = DriverManager.getConnection(host, userid, password);
PreparedStatement ps = con.prepareStatement(sql);
ps.setInt(1, sequence);
ps.setString(2, fileName);
ps.setString(3, Path);
ps.setString(4, str);
ps.executeUpdate();
ps.close();
con.close();
String host = "jdbc:oracle:thin:@192.168.10.1:1521:TEST";
String userid = "TEST";
String password = "TEST";
Connection con = DriverManager.getConnection(host, userid, password); 能执行么首先
// IF dw_list.RowCount() <= 0 THEN
// MESSAGEBOX('提示信息','没有数据可以导出,请先查询!',EXCLAMATION!)
// RETURN
// END IF
// IF dw_list.SaveAS('c:\phdr.txt',text!,false) = 1 THEN
// MESSAGEBOX('提示信息','导出成功!')
// END IF
//注意导出规则; --phdr.txt
//--goods(左对齐占20位,位数不够用空格代替)
//--bthnum(第21位起,左对齐占32位,位数不够用空格代替)
//--producer(第53位起,做对齐占12位,位数不够用空格代替)
Long Ll_FileNo,ll_length
String Ls_Text,ls_filename,ls_producer,ls_f,ls_s
String ls_goods,ls_bthnum,ref_pupdata//医保导出文件名、存放路径
Ls_filename = 'phdr'+'.txt'
Ll_FileNo = FileOpen("C:\phdr.txt", LineMode!, Write!, Shared!, Replace!)//拼成字符串:Ls_Text--
Long ll_i,ll_allLS_TEXT = '' //--导出凭证抬头部分ll_all = dw_list.RowCount() //获取dw_list行数IF dw_list.RowCount() <= 0 THEN
MESSAGEBOX('提示信息','没有数据可以导出,请先查询!',EXCLAMATION!)
RETURN
END IFFOR ll_i=1 TO ll_all
ls_goods = dw_list.object.goods[ll_i] //商品编号
ls_bthnum = dw_list.object.bthnum[ll_i] //商品批号
ls_producer= dw_list.object.producer[ll_i] //生产厂家
ref_pupdata = trim(ls_goods)
//判断ls_goods字段长度,左对齐占20位,位数不足用空格代替
ll_length = len(trim(ls_goods))
ref_pupdata += space(20 - ll_length)
//判断ls_bthnum字段长度,从21位开始,左对齐占32位,位数不足用空格代替
ll_length = len(trim(ls_bthnum))
ref_pupdata += trim(ls_bthnum)
ref_pupdata += space(32 - ll_length)
//判断ls_producer字段长度,从第53位开始,左对齐占12位,位数不足用空格代替
ll_length = len(trim(ls_producer))
IF ll_length < 12 THEN
ref_pupdata += trim(ls_producer)
ref_pupdata += space(12 - ll_length)
ELSE
ref_pupdata += mid(ls_producer,1,12)
END IF
LS_TEXT = trim(LS_TEXT) + ref_pupdata + '~r~n'
NEXTFileWrite(Ll_FileNo,LS_TEXT)
FileClose(Ll_FileNo)
MessageBox('提示信息','成功把文件:' + ls_filename + '~r~n导出到:' + 'C:\;目录下,请查看!')