·ÇTO_DATE·½Ê½ ÏòORACLEÖвåÈë DATEÀàÐÍ
ÔÚJS²Ù×÷ OracleÊý¾Ý¿âʱ£¬ÓÉÓÚ¿ò¼ÜÔÒò²»ÄÜʹÓà to_dateÃüÁһ³ïĪչ£¬¿´Á˺öà×ÊÁÏ¡£·¢ÏÖÁËÍ»ÆÆ¿Ú¡£
ORACLEÖÐ ÎÞÂÛʲôµ«Èý·½Èí¼þ ¶¼ÊÇÒÔ“Ò»¸ö»á»°(session)”Ϊ»ù´¡½øÐÐһϵÁвÙ×÷µÄ£¬Ö»Òª¹Ø±ÕÕâ¸ö´°¿Ú£¬´Ë»á»°½«±»È¡Ïû/¹Ø±Õ¡£
Òò´ËÏëµ½£¬
alter session set nls_date_format ="yyyy/MM/dd hh24:mi:ss";
Õâ¸öÃüÁîÖ»¶ÔÒ»´Î»á»°ÓÐЧ£¬²¢²»ÊÇÓÀ¾ÃÉúЧ¡£
ÄÇô ¾ÍÔÚ ¿ªÆôÊÂÎñÒÔºó£¬ Ö´ÐÐINSERT֮ǰ£¬Ö´ÐÐÕâÌõÃüÁ
DatabaseManager.beginTransaction();
//½ñ»Ø¤Î¥È¥é¥ó¥¶¥¯¥·¥ç¥ó¤ÎÈÕ¸¶¤ò¥Õ¥©ー¥Þー¥È
var sessionDate = "alter session set nls_date_format = 'yyyy/MM/dd HH24:mi:ss'";
DatabaseManager.execute(sessionDate);
DatabaseManager.insert("tablename",objData);
Ïà¹ØÎĵµ£º
ÎÊÌâÒ»£ºÈç±£¼ÓÔØJDBCÇý¶¯³ÌÐò£º
Õý³£ÎÒÃǼÓÔØÇý¶¯³ÌÐòÓÐÈý¸ö;¾¶£º
1.Class.forName(String)ÕâÏëµ±ÓÚclassLoaderÒ»¸öStringÖ¸¶¨µÄÀ࣬ÔÚ×°ÔØÊ±°Ñ¸ÃÇý¶¯³ÌÐòµÄ¾²Ì¬ÄÚÈݶ¼³õʼ»¯£¬ÆäʵÕâʱÇý¶¯³ÌÐòÀàµ÷ÓÃÁËDriverManager.registerDriver(driver)·½·¨¡£
2.ʹÓÃϵͳÊôÐÔ£ºSystem.getPro ......
ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£º
Á¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1£® ×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐ ......
ÓÉÓÚÒÔǰ¶¼ÊÇÔÚsqlserver 2005´¦Àí£¬ÏÖÔÚ¿Í»§ÒªÇóoracleÊý¾Ý¿â·þÎñÆ÷£¬
×î³õµÄ´úÂëΪ£º
allRecordSize = (Integer) rs1.getObject(1); //Integer allRecordSize=0;
µ±Ö´ÐеÄʱºò±¨£ºBigDecimalÎÞ·¨×ª»¯ÎªIntegerÀàÐÍ
ΪÁ˼æÈÝÁ½ÕßÐ޸ĺóµÄ´úÂëΪ£º
Object o = rs1.getObject(1);
&nbs ......