51Testing软件测试论坛

标题: 关于获取数据库sql语句的 [打印本页]

作者: liaoxj 时间: 2007-2-7 13:27
标题: 关于获取数据库sql语句的
oracle数据库获取的信息,他的VALUES都是如下,如何设置参数化!如果直接参数化,通不过!

lrd_ora8_stmt(OraStm1, "INSERT INTO \"ZY_BQYZ\" ( \"YZMC\", \"YCJL\", \"YCSL\", \"SYPC\", \""
      "YPDJ\", \"YSGH\", \"TZSJ\", \"TZYS\", \"KSSJ\", \"MRCS\", \""
      "XMLX\", \"YPLX\", \"SYBZ\", \"ZFPB\", \"CZGH\", \"SRKS\", \""
      "QRSJ\", \"YPXH\", \"ZYH\", \"JLXH\", \"YJZX\", \"ZXKS\", \""
      "FHGH\", \"YPYF\", \"YZZH\", \"YEPB\", \"BZXX\", \"FYSX\", \""
      "YFSB\", \"LSYZ\", \"YZPB\", \"LSBZ\", \"JFBZ\", \"TJHM\", \""
      "HYXM\", \"FYFS\", \"TPN\", \"YSBZ\", \"FYTX\", \"YPCD\" ) "
      "VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, "
      ":13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, "
      ":25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, "
      ":37, :38, :39, :40 )", 1, 0, 0);

作者: Tony.Xu 时间: 2007-2-7 16:27
这是什么协议录的？

作者: liaoxj 时间: 2007-2-8 14:20
oracle协议了

欢迎光临 51Testing软件测试论坛 (http://bbs.51testing.com/)