給一個我調的給你看看:Connection conn = null;
Statement stmt = null;
String[][] strReturn = null;
conn = DataConnection.getConnection("lh.order.server.dba.report.ordershipmentweekly.DBA_OrderShipmentWeekly.dealWithData()",
dbInfo);
stmt = conn.createStatement();
String strDateCon = GClass.getFieldCompareStr(args[2], args[3],"TRANS_DATE", 1);
String strCustomerNoCon = GClass.getFieldCompareStr(args[0], args[1],"TYPE_NO", 1);
String strSaleBillCon = GClass.getFieldCompareStr(args[4], args[5],"TYPE_NO", 1);
String strSql = " exec ordershipmentweekly "
+ GClass.getSqlString(strCompId)+","
+ GClass.getSqlString(strDateCon) + ","
+ GClass.getSqlString(strCustomerNoCon) + ","
+ GClass.getSqlString(strSaleBillCon) + ","
+ GClass.getSqlString(args[6]) + ","
+ GClass.getSqlString(args[7]);
stmt.execute(strSql);
ResultSet reset = stmt.getResultSet();
if(reset==null||!reset.last())
return strReturn;
int nRows = reset.getRow();
int nMasterColumns = COL_AMOUNT;
strReturn = new String[nRows][nMasterColumns];
reset.beforeFirst();
int nIndex = 0;
while(reset.next())
{
for(int i = 0;i < nMasterColumns;i++)
{
strReturn[nIndex][i] = GClass.filtNull(reset.getString(i+1)).trim();
}
nIndex++;
}//end of while
stmt.close();
conn.close();
Statement stmt = null;
String[][] strReturn = null;
conn = DataConnection.getConnection("lh.order.server.dba.report.ordershipmentweekly.DBA_OrderShipmentWeekly.dealWithData()",
dbInfo);
stmt = conn.createStatement();
String strDateCon = GClass.getFieldCompareStr(args[2], args[3],"TRANS_DATE", 1);
String strCustomerNoCon = GClass.getFieldCompareStr(args[0], args[1],"TYPE_NO", 1);
String strSaleBillCon = GClass.getFieldCompareStr(args[4], args[5],"TYPE_NO", 1);
String strSql = " exec ordershipmentweekly "
+ GClass.getSqlString(strCompId)+","
+ GClass.getSqlString(strDateCon) + ","
+ GClass.getSqlString(strCustomerNoCon) + ","
+ GClass.getSqlString(strSaleBillCon) + ","
+ GClass.getSqlString(args[6]) + ","
+ GClass.getSqlString(args[7]);
stmt.execute(strSql);
ResultSet reset = stmt.getResultSet();
if(reset==null||!reset.last())
return strReturn;
int nRows = reset.getRow();
int nMasterColumns = COL_AMOUNT;
strReturn = new String[nRows][nMasterColumns];
reset.beforeFirst();
int nIndex = 0;
while(reset.next())
{
for(int i = 0;i < nMasterColumns;i++)
{
strReturn[nIndex][i] = GClass.filtNull(reset.getString(i+1)).trim();
}
nIndex++;
}//end of while
stmt.close();
conn.close();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货