SELECT ID,CONTENT FROM JC_T_QXYJXX WHERE CREATTIME BETWEEN TO_DATE('2016-08-26 00:00:00','yyyy-mm-dd hh24:mi:ss') AND TO_DATE('2016-08-26 23:59:59','yyyy-mm-dd hh24:mi:ss') ORDER BY ID DESC
这里面的这两个时间,我想变成参数,要怎么传参啊
...全文
4297打赏收藏
C# oracle怎么传参数啊
SELECT ID,CONTENT FROM JC_T_QXYJXX WHERE CREATTIME BETWEEN TO_DATE('2016-08-26 00:00:00','yyyy-mm-dd hh24:mi:ss') AND TO_DATE('2016-08-26 23:59:59','yyyy-mm-dd hh24:mi:ss') ORDER BY ID DESC 这里面的这两个时间,我想变成参数,要怎么传参啊
SELECT ID,CONTENT FROM JC_T_QXYJXX WHERE CREATTIME BETWEEN TO_DATE(:date1,'yyyy-mm-dd hh24:mi:ss') AND TO_DATE(:date1,'yyyy-mm-dd hh24:mi:ss') ORDER BY ID DESC
然后通过 OracleParameter[] pans ={。。。。。}进行传值 就OK了