Exec SQL IN AX（self）
Class:(一定要配 Run On Server)
resultSet TestDirectSQLTwo()
{ connection con=new connection();
statement stm=con.createStatement();
SqlStatementExecutePermission sqlStatementExecutePermission;
ResultSET R,R1; str 10000 SQL,SQL1;
int i;
itemId itemId;
qty _qty;
;
i = 0; SQL = "select * from inventtable ";
sqlStatementExecutePermission = new SqlStatementExecutePermission(sql);
sqlStatementExecutePermission.assert();
con.ttsbegin(); R = stm.executeQuery(SQL);
return R;
// while( R.next())
// {
//
// ItemID = R.getString(1);
// info(Itemid);
// }con.ttscommit();
// pause;
} JOB static void TestDirectSQLTwo(Args _args)
{
AACdltllDemoBcnClass AACdltllDemoBcnClass = new AACdltllDemoBcnClass();
ResultSet rset;
ItemId itemid;
;
rset = AACdltllDemoBcnClass.TestDirectSQLTwo();
while( rset.next())
{ ItemID = Rset.getString(1);
//ItemID = Rset.getString(1);
ItemID = Rset.getString(20);
print Itemid;
}
pause;
} 优质内容筛选与推荐>>
1、30款css3实现的鼠标经过图片显示描述特效
2、非常完善的SQL安全过滤函数
3、jquery.validate.js 1.7 的BUG
4、10个你不是百万富翁的原因
5、java上传组件commons-fileupload的一些使用方法
{ connection con=new connection();
statement stm=con.createStatement();
SqlStatementExecutePermission sqlStatementExecutePermission;
ResultSET R,R1; str 10000 SQL,SQL1;
int i;
itemId itemId;
qty _qty;
;
i = 0; SQL = "select * from inventtable ";
sqlStatementExecutePermission = new SqlStatementExecutePermission(sql);
sqlStatementExecutePermission.assert();
con.ttsbegin(); R = stm.executeQuery(SQL);
return R;
// while( R.next())
// {
//
// ItemID = R.getString(1);
// info(Itemid);
// }con.ttscommit();
// pause;
} JOB static void TestDirectSQLTwo(Args _args)
{
AACdltllDemoBcnClass AACdltllDemoBcnClass = new AACdltllDemoBcnClass();
ResultSet rset;
ItemId itemid;
;
rset = AACdltllDemoBcnClass.TestDirectSQLTwo();
while( rset.next())
{ ItemID = Rset.getString(1);
//ItemID = Rset.getString(1);
ItemID = Rset.getString(20);
print Itemid;
}
pause;
} 优质内容筛选与推荐>>
1、30款css3实现的鼠标经过图片显示描述特效
2、非常完善的SQL安全过滤函数
3、jquery.validate.js 1.7 的BUG
4、10个你不是百万富翁的原因
5、java上传组件commons-fileupload的一些使用方法