commandText语句基本用法,+号和“”号的作用
发表于:2007-07-02来源:作者:点击数:
标签:
oleInsertCommand.CommandText = "INSERT INTO GCM_SORYO ( MI SE_CD,BUMON_CD,TEI_ZOKU, " + //内是一个字符串,后接+号表明连接之后的字符串 "HAISO_CHIKU_CD,MOS_CART_CD,SORYO,KINSHI_FLG,INS_YMD, " + "INS_HMS,LST_UPDTS,UPDT_KAI,LST_UPDT_YMD,LST_UPD
oleInsertCommand.CommandText =
"INSERT INTO GCM_SORYO (
MISE_CD,BUMON_CD,TEI_ZOKU, " + //“”内是一个字符串,后接+号表明连接之后的字符串
"HAISO_CHIKU_CD,MOS_CART_CD,SORYO,KINSHI_FLG,INS_YMD, " +
"INS_HMS,LST_UPDTS,UPDT_KAI,LST_UPDT_YMD,LST_UPDT_HMS) "+
"VALUES (@#" + //“”内部还是一个完整的字符串,后接+号又连接一个字符串
argCSData.CSOprtEntityLst[0].MiseCd + "@#, @#" + //变量本身就是字符串类型,无需再加“”直接+号连接其后字符串,字符串内容是‘,’,然后继续+号,连接下一个字符串
argCSData.CSOprtEntityLst[0].BumonCd+ "@#,@#" +
argCSData.CSOprtEntityLst[0].TeiZoku + "@#, @#" +
argCSData.CSOprtEntityLst[0].HaisouCd + "@#, @#" +//
oracle中字符串类型的字段,必须加‘’号
argCSData.CSOprtEntityLst[0].MosCartCd + "@#, " +
argCSData.CSOprtEntityLst[0].Soryo + ", " +
argCSData.CSOprtEntityLst[0].KinshiFlg + "," +
"TO_CHAR(SYSDATE,@#YYYYMMDD@#),"+
"TO_CHAR(SYSDATE,@#HH24MISS@#)," + "@#" +
argCSData.CSOprtEntityLst[0].LstUpdts + "@#,1," +
"TO_CHAR(SYSDATE,@#YYYYMMDD@#)," +
"TO_CHAR(SYSDATE,@#HH24MISS@#))";//+上字符串TO_CHAR(SYSDATE,@#HH24MISS@#))
原文转自:http://www.ltesting.net