代码如下:
function createtmptable(begintime,endtime){
var conn = getConnection(getApplication());
var cs = null;
try{
var statement = conn.createStatement(Packages.java.sql.ResultSet.CONCUR_UPDATABLE);
var proced = "DROP table IF EXISTS tlk_请假统计报表";
statement.executeUpdate(proced);
proced = "CREATE TABLE tlk_请假统计报表 select * from tlk_请假申请单 where (ITEM_开始时间 <= '"+endtime+"' and ITEM_结束时间 >= '"+begintime+"') and ISTMP =0;";
statement.executeUpdate(proced);
var ResultSet = statement.executeQuery("select * from tlk_请假统计报表");
proced = "UPDATE tlk_请假统计报表 SET ITEM_结束时间 = '"+endtime+"' where ITEM_结束时间 > '"+endtime+"';";
statement.executeUpdate(proced);
proced = "UPDATE tlk_请假统计报表 SET ITEM_开始时间 = '"+begintime+"' where ITEM_开始时间 < '"+begintime+"';";
statement.executeUpdate(proced);
var time=null;
while(ResultSet.next())
{
begintime = ResultSet.getString("ITEM_开始时间");
endtime = ResultSet.getString("ITEM_结束时间");
var startday = $TOOLS.DATE_UTIL.getDateTimeStr(begintime);
var endday = $TOOLS.DATE_UTIL.getDateTimeStr(endtime);
time = getWorkingTimesCount(startday,endday);
time = Math.round (diffday*Math.pow(10,1))/Math.pow(10,1); ResultSet.updaString(time)
}
}finally{}
运行的时候提示错误: JavaScriptRunning:[Activity Action(11df-bf9d-8d207739-b70c-3b82313198c6).生成报表beforeActionScript]: Can't find method org.apache.commons.dbcp.DelegatingConnection.createStatement(number).
function createtmptable(begintime,endtime){
var conn = getConnection(getApplication());
var cs = null;
try{
var statement = conn.createStatement(Packages.java.sql.ResultSet.CONCUR_UPDATABLE);
var proced = "DROP table IF EXISTS tlk_请假统计报表";
statement.executeUpdate(proced);
proced = "CREATE TABLE tlk_请假统计报表 select * from tlk_请假申请单 where (ITEM_开始时间 <= '"+endtime+"' and ITEM_结束时间 >= '"+begintime+"') and ISTMP =0;";
statement.executeUpdate(proced);
var ResultSet = statement.executeQuery("select * from tlk_请假统计报表");
proced = "UPDATE tlk_请假统计报表 SET ITEM_结束时间 = '"+endtime+"' where ITEM_结束时间 > '"+endtime+"';";
statement.executeUpdate(proced);
proced = "UPDATE tlk_请假统计报表 SET ITEM_开始时间 = '"+begintime+"' where ITEM_开始时间 < '"+begintime+"';";
statement.executeUpdate(proced);
var time=null;
while(ResultSet.next())
{
begintime = ResultSet.getString("ITEM_开始时间");
endtime = ResultSet.getString("ITEM_结束时间");
var startday = $TOOLS.DATE_UTIL.getDateTimeStr(begintime);
var endday = $TOOLS.DATE_UTIL.getDateTimeStr(endtime);
time = getWorkingTimesCount(startday,endday);
time = Math.round (diffday*Math.pow(10,1))/Math.pow(10,1); ResultSet.updaString(time)
}
}finally{}
运行的时候提示错误: JavaScriptRunning:[Activity Action(11df-bf9d-8d207739-b70c-3b82313198c6).生成报表beforeActionScript]: Can't find method org.apache.commons.dbcp.DelegatingConnection.createStatement(number).
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货