|
我新建了一个类,总共也就下面这么一点点代码,编译却要73秒,请问这是啥原因?
package com.SYNTHESIS;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Map;
import com.justep.system.data.KSQL;
import com.justep.system.data.Row;
import com.justep.system.data.Table;
import com.weixin.util.TuiSong;
public class commonSYN {
public static void WXMessage(String sid,String type){
String ksql="SELECT S.carNo,S.driverCode,S.driver,SS.startDate,SS.endDate,SS.leadPerson,SS.telePhone,SS.planTravelRoad,SS.startAddress,SS.endAddress FROM carApply_Detail S optional join carApply SS ON S.parentID=SS WHERE SS='"+sid+"'";
Map<String, Object> params = new HashMap<String, Object>();
Table table = KSQL.select(ksql, null, "/ERP/SYNTHESIS/car/data", null);
Iterator<Row> rows = table.iterator();
String title="";
String content="";
HashMap<Integer, String> code = new HashMap<Integer, String>();
if("new".equals(type)) {title = "您有新的行程~";}
else {title = "您的行程已取消~";}
while (rows.hasNext()) {
Row row = rows.next();
java.sql.Timestamp startDate=row.getDateTime("startDate");
java.sql.Timestamp endDate=row.getDateTime("endDate");
String carNo=row.getString("carNo");
String driverCode=row.getString("driverCode");
code.put(0, driverCode);
String driver=row.getString("driver");
String leadPerson=row.getString("leadPerson");
String telePhone=row.getString("telePhone");
String planTravelRoad=row.getString("planTravelRoad");
String startAddress=row.getString("startAddress");
String endAddress=row.getString("endAddress");
content+="\n驾驶员:"+driver;
content+="\n用车时间:"+startDate+"-"+endDate;
content+="\n车号:"+carNo+" 计划路线:"+startAddress+"-->"+planTravelRoad+"-->"+endAddress;
content+="\n领队:"+leadPerson+" 联系方式:"+telePhone;
TuiSong.getInstance().tuisongWeixinNewsMulForCar(code, content,title);
}
}
public static void WXMessageLeader(String sid,String type){
System.out.println("WXMessageLeaderWXMessageLeader");
String ksql="SELECT S.carNo,S.driverCode,S.driver,SS.startDate,SS.endDate,SS.leadPerson,S.telePhone,SS.planTravelRoad,SS.startAddress,SS.endAddress,SS.leadPerson,SS.leadPersonCode FROM carApply_Detail S optional join carApply SS ON S.parentID=SS WHERE SS='"+sid+"'";
Map<String, Object> params = new HashMap<String, Object>();
Table table = KSQL.select(ksql, null, "/ERP/SYNTHESIS/car/data", null);
Iterator<Row> rows = table.iterator();
String title="";
String content="";
HashMap<Integer, String> code = new HashMap<Integer, String>();
if("new".equals(type)) {title = "您有新的行程~";}
else {title = "您的行程已取消~";}
while (rows.hasNext()) {
Row row = rows.next();
java.sql.Timestamp startDate=row.getDateTime("startDate");
java.sql.Timestamp endDate=row.getDateTime("endDate");
String carNo=row.getString("carNo");
String driverCode=row.getString("driverCode");
String leadPerson=row.getString("leadPerson");
String leadPersonCode=row.getString("leadPersonCode");
code.put(0, leadPersonCode);
String driver=row.getString("driver");
//String leadPerson=row.getString("leadPerson");
String telePhone=row.getString("telePhone");
String planTravelRoad=row.getString("planTravelRoad");
String startAddress=row.getString("startAddress");
String endAddress=row.getString("endAddress");
content+="\n领队:"+leadPerson;
content+="\n用车时间:"+startDate+"-"+endDate;
content+="\n车号:"+carNo+" 计划路线:"+startAddress+"-->"+planTravelRoad+"-->"+endAddress;
content+="\n驾驶员:"+driver+" 联系方式:"+telePhone;
TuiSong.getInstance().tuisongWeixinNewsMulForCar(code, content,title);
System.out.println("leadPersonCode"+leadPersonCode);
System.out.println("content"+content);
System.out.println("WXMessageLeaderWXMessageLeader");
}
}
}
|
|