多线程调用VC - JAVA - 编程开发网

String in =id.get(s)+ "--" +time.get(z)
+ "--" + zhan.get(y) + "--" + "--" + zhan.get(i)
+ ".txt";
String out = "temp--" + in;

data.GenerateFile(in, out);
xx++;
System.out.println(xx + "\t" + out);
System.gc();
}
}
}
}
}
}

static class GetData extends Thread {
private List id, time, zhan, data1, data2;
private boolean flag;
private Data data;
private int xx = 0; // 上行
private int yy = 0;// 下行

public GetData(List id, List time, List zhan,
Data data) {
this.id = id;
this.time = time;
this.zhan = zhan;
this.data = data;
}

//上行
public void getsql(List data1){

List nullList = new ArrayList();
List datalist = new ArrayList();
int xx = 1;
for (int y = 0; y < zhan.size(); y++) {
String sql = "INSERT INTO T_ODKLTJSCB (BOARD_STATION, ARRIVAL_STATION1,ARRIVAL_STATION2,ARRIVAL_STATION3, ARRIVAL_STATION4, ARRIVAL_STATION5,"+
" ARRIVAL_STATION6,ARRIVAL_STATION7,ARRIVAL_STATION8,ARRIVAL_STATION9,ARRIVAL_STATION10, ARRIVAL_STATION11,"+

" ARRIVAL_STATION12,ARRIVAL_STATION13,ARRIVAL_STATION14,ARRIVAL_STATION15,ARRIVAL_STATION16,ARRIVAL_STATION17,"+
"ARRIVAL_STATION18,ARRIVAL_STATION19, ARRIVAL_STATION20,ARRIVAL_STATION21)VALUES( ";
for (int i = 0; i < zhan.size(); i++) {

if (y < i) {
// 上行
datalist.add("a");
} else {
nullList.add(null);
}
if (y == i) {
for(int g=0;g sql=sql+nullList.get(g)+",";
}
}
}
for(int v=0;v sql=sql+datalist.get(v)+",";
}
sql= sql.substring(0,sql.length()-1);
sql=sql+" );";
// System.out.println("插入 sql:" +sql +"\t" + xx);
// xx++;
datalist.clear();
nullList.clear();
}
}

//下行
public void getsql2(List data2){

List nullList = new ArrayList();
List datalist = new ArrayList();
int xx = 1;
for (int y = 0; y < zhan.size(); y++) {
String sql = "INSERT INTO T_ODKLTJSCB (BOARD_STATION, ARRIVAL_STATION1,ARRIVAL_STATION2,ARRIVAL_STATION3, ARRIVAL_STATION4, ARRIVAL_STATION5,"+
" ARRIVAL_STATION6,ARRIVAL_STATION7,ARRIVAL_STATION8,ARRIVAL_STATION9,ARRIVAL_STATION10, ARRIVAL_STATION11,"+
" ARRIVAL_STATION12,ARRIVAL_STATION13,ARRIVAL_STATION14,ARRIVAL_STATION15,ARRIVAL_STATION16,ARRIVAL_STATION17,"+
"ARRIVAL_STATION18,ARRIVAL_STATION19, ARRIVAL_STATION20,ARRIVAL_STATION21)VALUES( ";

多线程调用VC(二)