Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Êý¾Ý»¥Ò×ÐÔ£¨1£©

×÷Õß Haidong Ji ·­Òë GoodKid
ÎÒÃǵ±ÖеĴ󲿷ÖÈ˹¤×÷ÔÚÒ»¸öµ¥Ò»µÄ RDBMS ϵͳÖУ¬Èç MSSQL, Oracle, or IBM DB2¡£È»¶ø£¬ÎÒÃÇÈÕÒæ¸Ð¾õµ½£¬ÎÒÃÇÕý´¦ÓÚ²»Í¬µÄÊý¾Ý¿â»·¾³µ±Öв¢ÇÒÐèÒª½â¾öÊý¾ÝµÄ»¥ÓÃÐÔÎÊÌâ¡£
¾¡¹ÜÖ÷ÒªµÄ RDBMS ³§ÉÌÊÔͼȥ×ñÑ­¹ØÏµÊý¾Ý¿âÄ£ÐÍÔ­Àí£¬²¢ÇÒÓ÷dz£Ð¡µÄ²îÒìȥʵÏÖËüÃÇ¡£ÁíÍ⣬¼¸ºõÖ÷ÒªµÄ ......

ORACLE±í¿Õ¼äµÄË鯬ÕûÀí

oracle×÷ΪһÖÖ´óÐÍÊý¾Ý¿â£¬¹ã·ºÓ¦ÓÃÓÚ½ðÈÚ¡¢Óʵ硢µçÁ¦¡¢Ãñº½µÈÊý¾ÝÍÌÍÂÁ¿¾Þ´ó£¬¼ÆËã»úÍøÂç¹ã·ºÆÕ¼°µÄÖØÒª²¿ÃÅ¡£¶ÔÓÚϵͳ¹ÜÀíÔ±À´½²£¬ÈçºÎ±£Ö¤ÍøÂç
Îȶ¨ÔËÐУ¬ÈçºÎÌá¸ßÊý¾Ý¿âÐÔÄÜ£¬Ê¹Æä¸ü¼Ó°²È«¸ßЧ£¬¾ÍÏÔµÃÓÈÎªÖØÒª¡£×÷ΪӰÏìÊý¾Ý¿âÐÔÄܵÄÒ»´óÒòËØ--Êý¾Ý¿âË鯬£¬Ó¦µ±ÒýÆðdbaµÄ×ã¹»ÖØÊÓ£¬¼°Ê±·¢ÏÖ²¢
ÕûÀíË鯬ÄËÊÇdbaÒ»Ïî ......

oracle±Ê¼Ç Ö®VI JDBCÁ¬½Ó Oracle Êý¾Ý¿â

 <%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%--
 Ê¹ÓÃJDBCÁ¬½ÓOracleÊý¾Ý¿â
--%>
<%!
 String DBDRIVER="oracle.jdbc.driver.OracleDriver";
 String URL="jdbc:oracle:thin:@localhost:1521:orcl";
 String USER="scott ......

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

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

oracle²»Í¬°æ±¾Ö®¼äµÄÇл»

¼òµ¥ÃèÊöÒ»ÏÂÔÚwindowsµÄͬһÓû§Ï£¬°²×°OracleµÄ9i¡¢10gºÍ11gµÄ·½·¨¡£
OracleÔÚwindowsƽ̨ϵݲװÊÇËùÓÐÆ½Ì¨ÖÐ×î¼òµ¥µÄ£¬»ù±¾Éϲ»ÐèÒª½øÐÐÈκζîÍâµÄ´¦Àí¾Í¿ÉÒԳɹ¦µÄ°²×°£¬¿ÉÒÔ˵ûÓÐʲô¼¼Êõº¬Á¿¡£
 
²»¹ýÔÚͬһ̨»úÆ÷µÄͬһ¸öÓû§ÉÏͬʱ°²×°Á½¸ö²»Í¬°æ±¾µÄÊý¾Ý¿â¾ÍÐèÒªÒ»¶¨µÄ¼¼ÇÉÁË¡£ÕâÀï¼òµ¥ÃèÊöÒ»ÏÂÔÚͬʱ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ