SetParameter

Sets the parameter value.

Prototype

void SetParameter(integer ParameterIndex, object ValueObject)

void SetParameter(string ParameterIndex, object ValueObject)

Parameters

Reference

Declare ParameterIndex as integer for Java OZ server and as string for .NET OZ server.

Example 1

function OZJSPreparedStatementSample(){

  //OZ Server Type = Java

  var con = OZCreator.GetBuiltInObject(OZBuiltInObject.DBCONNECTION);

  con.SetAlias("ozcar");

  con.Connect(true);

  var pstmt = con.PrepareStatement("select * from car where Maker = ? ");

  pstmt.SetMaxRows(2);

  pstmt.SetParameter(1, "HYUNDAI");

  var rs = pstmt.ExecuteQuery();

  var meta = rs.GetMetaData();

  for(var i=0; i<meta.GetColumnCount(); i++) {

      _DEBUG(i+"= column Name="+meta.GetColumnName(i+1)+"type="+meta.GetColumnType(i+1));

  }

  while(rs.Next()) {

      var data = "";

      for(var i=0; i<meta.GetColumnCount(); i++) {

          data = data + rs.GetString(i+1) + ",    ";

      }

      _DEBUG(data);

  }

  rs.Close();

  pstmt.Close();

}

Example 2

function OZJSPreparedStatementSample(){

  //OZ Server Type = .Net

  var con = OZCreator.GetBuiltInObject(OZBuiltInObject.DBCONNECTION);

  con.SetAlias("ozcar");

  con.Connect(true);

  var pstmt = con.PrepareStatement("select * from car where Maker = @1");

  pstmt.SetMaxRows(2);

  pstmt.SetParameter("@1", "HYUNDAI");

  var rs = pstmt.ExecuteQuery();

  var meta = rs.GetMetaData();

  for(var i=0; i<meta.GetColumnCount(); i++) {

      _DEBUG(i+"= column Name="+meta.GetColumnName(i+1)+"type="+meta.GetColumnType(i+1));

  }

  while(rs.Next()) {

      var data = "";

      for(var i=0; i<meta.GetColumnCount(); i++) {

          data = data + rs.GetString(i+1) + ",    ";

      }

      _DEBUG(data);

  }

  rs.Close();

  pstmt.Close();

}