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

JDBC ¼òµ¥µÄOracleÁ¬½Ó

/*Ö÷ÒªÊÇΪÁË¿´ÇåÁ¬½ÓÂß¼­£¬ËùÒÔ°ÑÒì³£Exception*/
import java.sql.*;
public class TestJDBC {
    public static void main(String[] args) throws Exception {
        ResultSet rs = null;
        Statement stmt = null;
        Connection conn = null;
       
            Class.forName("oracle.jdbc.driver.OracleDriver");//ÒªÒýÈëOracleµÄclass12.jar
            //new oracle.jdbc.driver.OracleDriver();
            conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.1:1521:demo", "scott", "tiger");
            stmt = conn.createStatement();
            rs = stmt.executeQuery("select * from dept");
            while(rs.next()) {
                System.out.println(rs.getString("deptno"));
                System.out.println(rs.getInt("deptno"));
            }
        rs.close();
        stmt.close();
        conn.close();
        }
}


Ïà¹ØÎĵµ£º

Oracle¶àÐмǼºÏ²¢/Á¬½Ó/¾ÛºÏ×Ö·û´®µÄ¼¸ÖÖ·½·¨

ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name     Type          Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y       &nb ......

Oracle ½Å±¾£¨ÊÊÓ¦¸÷ÖÖÒµÎñÐèÒª£©


1. È¡A±íµÄÊý¾Ý£¬¸üÐÂB±í×Ö¶Î
update  m_build b
set b.district_id=(
  select d.district_id
  from 
    bjhouse.d_district d
  where
    b.build_name_jq=d.district_name)
where exists
  (select 1
  from ......

Oracle ADDM ×Ô¶¯Õï¶Ï¼àÊÓ¹¤¾ß ½éÉÜ


Oracle AWR ½éÉÜ(AWR -- Automatic Workload Repository)
http://blog.csdn.net/tianlesoftware/archive/2009/10/17/4682300.aspx
Ò». ADDM¸ÅÊö
 ADDM(Automatic Database Diagnostic Monitor) ÊÇÖ²ÈëOracleÊý¾Ý¿âµÄÒ»¸ö×ÔÕï¶ÏÒýÇæ.ADDM Í¨¹ý¼ì²éºÍ ......

oracle ½âËøÓû§ÒÔ¼°ÖØÐÂÉèÖÃÓû§ÃÜÂë

ÔÚ°²×°ÍêOracle 10gÖ®ºó£¬Ïë´ò¿ªsql*plusÀ´Ñ§Ï°£¬È»ºó°´ÕÕÊéÉϵIJ½ÖèÓÃscottÓû§À´Á¬½ÓÊý¾Ý¿â£¬¿ÉÊäÁ˺ü¸´Î¶¼Ìáʾһ¸ö´íÎó¡£
¡¡¡¡error£º the account is locked
¡¡¡¡È»ºóÉÏÍø²éÁËÒ»ÏÂÖ®ºó·¢ÏÖÕâ¸öÓû§±»Ëø¶¨ÁË£¬ÖÁÓÚËüΪʲô±»Ëø¶¨£¬¿ÉÄÜÊÇÏÂÃæ¼¸¸öÔ­Òò¡£
¡¡¡¡1.³¢ÊÔ¶à´ÎµÇ¼δ³É¹¦.(¿ÉÄÜÃÜÂë²»ÕýÈ·)
¡¡¡¡2.´ËÓû§±»¹ ......

win7 32bitϰ²×°oracle 10g

oracle ÖÁ½ñûÓÐÍÆ³öÕë¶Ôwin7µÄ°æ±¾£¬ÎÞÄÎ֮ϲéÑ¯ÍøÂç£¬ÍøÉÏ´óϺ±íʾÐÞ¸Ärefhost.xmlÎļþ¼´¿É¡£
½øÈë×Ô¼ºÊµÕ½½×¶Î£¬´Óoracle¹Ù·½ÏÂÔØoracle 10g for vista and windows2K8 x86°æ(for windowsÊÇÖ§³ÖvistaÄں˵ģ¬win7µÄÄÚºËÓë2008ÒÔ¼°vistaµÄÄÚºËÊÇÒ»Ñù)¡£
Ïȵã»÷°²×°£¬ÔÚ°²×°µÄ°æ±¾¼ì²âʱÌáʾĿǰoracle²»Ö§³ÖversionΪ6 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ