SetParameter

패러미터 값을 설정합니다.

Prototype

void SetParameter(integer ParameterIndex, object ValueObject)

void SetParameter(string ParameterIndex, object ValueObject)

Parameters

Reference

오즈 서버 타입이 자바인 경우 ParameterIndex를 integer 타입으로 선언하고, 닷넷인 경우 string 타입으로 선언하여 사용합니다.

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();

}