·Ç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);
Ïà¹ØÎĵµ£º
±¾ÏµÁÐÎÄÕµ¼º½
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Ò»)--αÁÐROWNUMʹÓü¼ÇÉ
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(¶þ)--±êÁ¿×Ó²éѯ
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Èý)--PackageµÄÓŵã
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(ËÄ)--ÅúÁ¿´¦Àí
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Îå)--µ÷Óô洢¹ý³Ì·µ»Ø½á¹û¼¯
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Áù)- ......
'-------------------------------------------------------------------ÒÔÏÂÊǵǼ´úÂë
<%@ page contentType="text/html; charset=gb2312"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3 ......
ÎÊÌâÒ»£ºÈç±£¼ÓÔØJDBCÇý¶¯³ÌÐò£º
Õý³£ÎÒÃǼÓÔØÇý¶¯³ÌÐòÓÐÈý¸ö;¾¶£º
1.Class.forName(String)ÕâÏëµ±ÓÚclassLoaderÒ»¸öStringÖ¸¶¨µÄÀ࣬ÔÚ×°ÔØÊ±°Ñ¸ÃÇý¶¯³ÌÐòµÄ¾²Ì¬ÄÚÈݶ¼³õʼ»¯£¬ÆäʵÕâʱÇý¶¯³ÌÐòÀàµ÷ÓÃÁËDriverManager.registerDriver(driver)·½·¨¡£
2.ʹÓÃϵͳÊôÐÔ£ºSystem.getPro ......
ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£º
Á¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1£® ×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐ ......
Ò» ÔÚOracleÖÐÁ¬½ÓÊý¾Ý¿â
public class Test1 {
public static void main(String[] args) {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection(
&nbs ......