|
楼主 |
发表于 2014-4-16 21:58:45
|
显示全部楼层
增加执行过程的方法:
- import com
- import console;
- conn = com.CreateObject("ADODB.Connection");
- conn.ConnectionString = "Provider=OraOLEDB.Oracle;
- Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA =(SERVER=DEDICATED)(SERVICE_NAME=test_db)));
- User Id=system;Password=future;";
- try{
- conn.Open() ;
-
- //数据查询
- /*
- rs = com.CreateObject("ADODB.RecordSet")
- rs.Open("select * from privatepara order by pparaid", conn )
-
- while(!rs.eof){
- console.log(
- string.trimright( rs("pparaid").value ),
- string.trimright( rs("pparaname").value ),
- string.trimright( rs("pparavalue").value )
- )
- rs.movenext()
- }
- rs.close();
- */
-
- //执行过程
- cmd = com.CreateObject("ADODB.Command")
- cmd.ActiveConnection = conn
- cmd.CommandType = 4 //adCmdStoredProc
- //cmd.NamedParameters = true
- cmd.CommandText = "sp_1"
- cmd.Prepared=true
- cmd.Parameters.Append(cmd.CreateParameter("v1" , 200, 1, 50, "401"))//输入参数
- cmd.Parameters.Append(cmd.CreateParameter("v2" , 200, 2, 50))//输出参数
-
- cmd.Execute()
-
- console.log(cmd.Parameters(0).value)
- console.log(cmd.Parameters(1).value)
-
-
- conn.Close();
- console.log( "连接成功!" );
- }
- catch(e){
- console.log( "错误信息:",e );
- }
- /*
- "Provider=OraOLEDB.Oracle; Data Source=
- (DESCRIPTION =
- (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))
- (CONNECT_DATA = (SERVICE_NAME = oraapp))
- );User Id=testuser;Password=testuser;"
-
- */
复制代码 |
|