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("Á¬½Óʧ°Ü");
}
}
}
Ïà¹ØÎĵµ£º
×÷Õß: ÈýÊ®¶øÁ¢Ê±¼ä£º2009Äê11ÔÂ08ÈÕ 8:59:25Çë×ðÖØÔ´´×÷Æ·¡£×ªÔØÇë±£³ÖÎÄÕÂÍêÕûÐÔ,²¢ÒÔ³¬Á´½ÓÐÎʽעÃ÷Ôʼ×÷Õß¡°inthirties£¨ÈýÊ®¶øÁ¢£©¡±ºÍ³ö´¦¡±http://blog.csdn.net/inthirties/archive/2009/11/08/4785106.aspx¡±,ÉîÈëÌÖÂÛ¿ÉÒÔÁªÏµinthirties@gmail.com¡£ Êý¾Ý×ֵ䣬µÚÒ»´ÎÌýµ½Õâ¸ö´ÊµÄʱºò£¬»¹ÊǸոÕ̤½øITÐÐÒµ£¬ ......
Ëø¶¨µÄ¸ÅÄî£ºËø¶¨ÊÇÊý¾Ý¿âÓÃÀ´¿ØÖƹ²Ïí×ÊÔ´²¢·¢²¼·ÃÎʵĻúÖÆ¡£ÔÚ¶àÓû§»·¾³Ï£¬¶à¸öÓû§¿Éͬʱ·ÃÎÊÏàͬµÄÊý¾Ý¡£Oracle Ìá¹©ËøÒÔÈ·±£ÔÚ¶àÓû§»·¾³ÏÂÊý¾ÝµÄÍêÕûÐÔºÍÒ»ÖÂÐÔ¡£ÔÚÌá½»»ò»Ø¹öÊÂÎñ֮ǰ£¬Oracle »áËø¶¨Õý±»Ð޸ĵÄÊý¾Ý¡£ÔÚÓû§Íê³É»ò»Ø¹öÊÂÎñÖ®ºó£¬Ëø»á×Ô¶¯ÊÍ·Å¡£Ö»ÓÐÔÚÌá½»»ò»Ø¹öÊÂÎïÖ®ºó£¬ÆäËûÓû§²Å¿ÉÒÔ¸üÐÂÕâЩÊý ......
OracleÊý¾Ý¿âµÄÆô¶¯Óõ½Á˳õʼ»¯²ÎÊý£¬Ò»°ãÇé¿öÏ¿ÉÒÔÔÚsqlplusÀïÓÃshow parameter À´»ñµÃ¡£¶øOracleÊý¾Ý¿âΪÁËdebug »òÕß½â¾öÒ»Ð©ÌØÊâµÄÎÊÌ⣬»¹ÌṩÁËһЩÒÔ“_”¿ªÍ·µÄÒþº¬²ÎÊý¡£ ÍøÂçÉÏÓÐһЩscript¿ÉÒÔÈÃÎÒÃÇÇáËɼì²éÕâЩÒþº¬²ÎÊý. ÏÂÃæÎÒÃÇÀ´Ïêϸ½éÉÜÒ»ÏÂÈçºÎÖ±½ÓÔÚsqlplus ÓÃshow parameterÀ´»ñÈ¡Òþº¬²ÎÊý ......
BlobÊÇÖ¸¶þ½øÖÆ´ó¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄBinary Large ObjectµÄËùд£¬¶øClobÊÇÖ¸´ó×Ö·û¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄCharacter Large ObjectµÄËùд¡£Óɴ˿ɼûÕâÁ¾¸öÀàÐͶ¼ÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾Ý¶øÉè¼ÆµÄ£¬ÆäÖÐBLOBÊÇÓÃÀ´´æ´¢´óÁ¿¶þ½øÖÆÊý¾ÝµÄ£»CLOBÓÃÀ´´æ´¢´óÁ¿Îı¾Êý¾Ý¡£
ÄÇôÓÐÈ˿϶¨ÒªÎʼÈÈ»ÒѾÓÐVARCHARºÍVARBINARYÁ½ÖÐÀàÐÍ£¬ÎªÊ²Ã´»¹ÒªÔÙÊ ......