Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

·Ç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³ÌÐòÉè¼Æ(Îå)

±¾ÏµÁÐÎÄÕµ¼º½
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Ò»)--αÁÐROWNUMʹÓü¼ÇÉ
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(¶þ)--±êÁ¿×Ó²éѯ
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Èý)--PackageµÄÓŵã
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(ËÄ)--ÅúÁ¿´¦Àí
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Îå)--µ÷Óô洢¹ý³Ì·µ»Ø½á¹û¼¯
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Áù)- ......

jsp Á´½ÓOracleµÄÁ¬½Ó³ØºÍ²éÑ¯Ìø×ª´úÂ루´øµÇ¼£©

'-------------------------------------------------------------------ÒÔÏÂÊǵǼ´úÂë
<%@ 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 ......

ÔÚOracleÏ¿ª·¢Java³ÌÐòµÄ¾­µäÎÊÌâ½â´ð

 
ÎÊÌâÒ»£ºÈç±£¼ÓÔØJDBCÇý¶¯³ÌÐò£º
 
Õý³£ÎÒÃǼÓÔØÇý¶¯³ÌÐòÓÐÈý¸ö;¾¶£º
 
1.Class.forName(String)ÕâÏëµ±ÓÚclassLoaderÒ»¸öStringÖ¸¶¨µÄÀ࣬ÔÚ×°ÔØÊ±°Ñ¸ÃÇý¶¯³ÌÐòµÄ¾²Ì¬ÄÚÈݶ¼³õʼ»¯£¬ÆäʵÕâʱÇý¶¯³ÌÐòÀàµ÷ÓÃÁËDriverManager.registerDriver(driver)·½·¨¡£
 
2.ʹÓÃϵͳÊôÐÔ£ºSystem.getPro ......

MYSQLºÍORACLEµÄһЩ²Ù×÷Çø±ð

ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£º
Á¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1£® ×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐ ......

Á¬½Óoracle£¬sqlserverÖÐÊý¾Ý¿âµÄʾÀý´úÂë

Ò» ÔÚOracleÖÐÁ¬½ÓÊý¾Ý¿â
public class Test1 {
 public static void main(String[] args) {
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver");
   Connection conn = DriverManager.getConnection(
       &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ