conn.login("admin","123456",false); StringBuilder sb = new StringBuilder(); sb.append("'") .append("F:"+File.separator+"dolphinDB2"+File.separator+"DolphinDB_GUI_V1.30.13"+File.separator+"workspace"+File.separator+"test1"+File.separator+"scripts"+File.separator+"GenTradeTable.txt") .append("'") ; Entity run = conn.run(sb.toString()); System.out.println("run.getString():"+run.getString());
txt
n=2000 syms=`YHOO`GE`MS`MSFT`JPM`ORCL`CISCO timestamp=09:30:00+rand(18000, n) sym=rand(syms, n) qty=100*(1+rand(100,n)) price=5.0+rand(100.0, n) t1=table(timestamp,sym,qty,price); t1
在GUI中可以看到结果如下
在Java API中只打印txt文件地址
可以这样理解,Java API的run方法的参数是字符串形式的脚本,和server的run函数不同。
正确代码如下:
DBConnection conn = new DBConnection(); conn.connect("localhost",8848,"admin","123456"); StringBuilder sb = new StringBuilder(); String script = "run(\"D:/work/GenTradeTable.txt\")"; System.out.println(script); BasicTable res = (BasicTable) conn.run(script); System.out.println("run.getString():"+res.getString());