Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Ëø

Ëø¶¨µÄ¸ÅÄî£ºËø¶¨ÊÇÊý¾Ý¿âÓÃÀ´¿ØÖƹ²Ïí×ÊÔ´²¢·¢²¼·ÃÎʵĻúÖÆ¡£ÔÚ¶àÓû§»·¾³Ï£¬¶à¸öÓû§¿Éͬʱ·ÃÎÊÏàͬµÄÊý¾Ý¡£Oracle Ìá¹©ËøÒÔÈ·±£ÔÚ¶àÓû§»·¾³ÏÂÊý¾ÝµÄÍêÕûÐÔºÍÒ»ÖÂÐÔ¡£ÔÚÌá½»»ò»Ø¹öÊÂÎñ֮ǰ£¬Oracle »áËø¶¨Õý±»Ð޸ĵÄÊý¾Ý¡£ÔÚÓû§Íê³É»ò»Ø¹öÊÂÎñÖ®ºó£¬Ëø»á×Ô¶¯ÊÍ·Å¡£Ö»ÓÐÔÚÌá½»»ò»Ø¹öÊÂÎïÖ®ºó£¬ÆäËûÓû§²Å¿ÉÒÔ¸üÐÂÕâЩÊý ......

ѧϰOracleÖÐBlobºÍClobÒ»µãµãÐĵÃ

BlobÊÇÖ¸¶þ½øÖÆ´ó¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄBinary Large ObjectµÄËùд£¬¶øClobÊÇÖ¸´ó×Ö·û¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄCharacter Large ObjectµÄËùд¡£Óɴ˿ɼûÕâÁ¾¸öÀàÐͶ¼ÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾Ý¶øÉè¼ÆµÄ£¬ÆäÖÐBLOBÊÇÓÃÀ´´æ´¢´óÁ¿¶þ½øÖÆÊý¾ÝµÄ£»CLOBÓÃÀ´´æ´¢´óÁ¿Îı¾Êý¾Ý¡£
ÄÇôÓÐÈ˿϶¨ÒªÎʼÈÈ»ÒѾ­ÓÐVARCHARºÍVARBINARYÁ½ÖÐÀàÐÍ£¬ÎªÊ²Ã´»¹ÒªÔÙÊ ......

oracle±äÁ¿ÀàÐÍ

 oracle±äÁ¿ÀàÐÍ
±êÁ¿ÀàÐÍ
varchar2(n)  ÓÃÓÚ¶¨Òå¿É±ä³¤¶ÈµÄ×Ö·û´®  nÓÃÓÚÖ¸¶¨×Ö·û´®µÄ×î´ó³¤¶È Æä×î´óֵΪ32767×Ö½Ú ±ØÐëÖ¸¶¨n
char(n)  ÓÃÓÚ¶¨Òå¹Ì¶¨³¤¶ÈµÄ×Ö·û´® ÆäÖÐnÓÃÓÚÖ¸¶¨×Ö·û´®µÄ×î´ó³¤¶È£¬Æä×î´óֵΪ32767  Èç¹û²»Ö¸¶¨n ĬÈÏÊÇ1
number(p,s)¸ÃÊý¾ÝÀàÐÍÓÃÓÚ¶¨Òå¹Ì¶¨³¤¶ÈµÄÕûÊýºÍ¸¡µã ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ