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

MyeclipseÖÐÁ¬½ÓOracleµÄ¾­µä´úÂë

 package cn.edu.bit.test;
import java.sql.*;
public class Jdbc {
 public static void main(String[] args)
 {
     try{ 
      Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
     System.out.println("×¢²á³É¹¦");    
     String URL = "jdbc:oracle:thin:localhost:1521:orcl";
      String user = "username";  //Á¬½ÓÊý¾Ý¿âµÄÓû§Ãû
      String password = "password";//Á¬½ÓÊý¾Ý¿âµÄÃÜÂë
      Connection conn = DriverManager.getConnection(URL, user, password); 
     System.out.println("Á¬½Ó³É¹¦"); 
      Statement st;
       st = conn.createStatement(); 
     ResultSet rs; 
       rs = st.executeQuery("select * from scott.project"); 
    while(rs.next()){ 
       System.out.println(rs.getString("time")); 
     } 
       }catch(Exception e)
     {     e.printStackTrace();    
    
     System.out.println("Á¬½Óʧ°Ü");    
   } 
      } 
}


Ïà¹ØÎĵµ£º

OracleÓëSQL ServerÊý¾Ý»¥ÓÃÐÔ£¨3£©

 ×÷Õß Haidong Ji  ·­Òë GoodKid
ÔÚÎҵĹØÓÚOracleºÍSQL Server »¥ÓÃÐÔµÄϵÁÐÎÄÕ part 1 ºÍ part 2 µ±ÖУ¬ÎÒÌÖÂÛÁËOracleºÍSQL Server µÄһЩ²»Í¬µãµÄ»°ÌâÒÔ¼°OracleÇý¶¯µÄ¿ÉÑ¡ÐÔ¡£ÔÚ±¾Ö÷ÌâÖУ¬ÎÒ½«ÌÖÂÛÒ»¸öÀ´×ÔOracle 10gµÄй¤¾ß£¬Oracle¼´Ê±¿Í»§¶Ë¡£
¶ÔÓÚOracle 10gÒÔǰµÄ°æ±¾£¬Èç¹ûÏ뽨Á¢ºÍOracleµÄÁ¬½Ó£¬ ......

×ß½üOracleÊý¾Ý×Öµä

×÷Õß: ÈýÊ®¶øÁ¢Ê±¼ä£º2009Äê11ÔÂ08ÈÕ 8:59:25Çë×ðÖØÔ­´´×÷Æ·¡£×ªÔØÇë±£³ÖÎÄÕÂÍêÕûÐÔ,²¢ÒÔ³¬Á´½ÓÐÎʽעÃ÷ԭʼ×÷Õß¡°inthirties£¨ÈýÊ®¶øÁ¢£©¡±ºÍ³ö´¦¡±http://blog.csdn.net/inthirties/archive/2009/11/08/4785106.aspx¡±,ÉîÈëÌÖÂÛ¿ÉÒÔÁªÏµinthirties@gmail.com¡£ Êý¾Ý×ֵ䣬µÚÒ»´ÎÌýµ½Õâ¸ö´ÊµÄʱºò£¬»¹ÊǸոÕ̤½øITÐÐÒµ£¬ ......

110¸öoracle³£Óú¯Êý×ܽá(3)

 41.SYSDATE
    ÓÃÀ´µÃµ½ÏµÍ³µÄµ±Ç°ÈÕÆÚ
    SQL> select to_char(sysdate,dd-mm-yyyy day) from dual;
    TO_CHAR(SYSDATE,
  -----------------
    09-05-2004ÐÇÆÚÈÕ
    trunc(date,fmt)°´ÕÕ¸ø³öµÄÒªÇó½«ÈÕÆÚ½Ø¶Ï,È ......

½øÈë oracle enterprise managerment ³öÏÖÎÊÌâ

    ÎÊÌâ1£º ½øÈëʱÐèÒªÖ÷»úÉí·ÝÖ¤Ã÷£º ½â¾ö·½°¸£º¹ÜÀí¹¤¾ß——±¾µØ°²È«²ßÂÔ——Óû§È¨ÀûÖ¸ÅÉ——×÷ΪÅú´¦Àí×÷ÒµµÈ¼£¨×îºóÒ»Ï——Ìí¼Ó±¾»úµÄÕ˺ÅÓëÃÜÂë ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ