Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ÖÐÈ¥»Ø³µ¡¢¿Õ¸ñ¡¢TABµÄº¯Êý

update EMPLOYEE set BADGE=trim(BADGE);   // ÕâÑù¿ÉÈ¥³ý×Ö·û´®Á½±ßµÄ¿Õ¸ñ
update EMPLOYEE set BADGE=replace(BADGE,' ','');    // ÕâÑùÄÜÈ¥³ýËùÓеĿոñ
SELECT replace(string,chr(13),'')   from DUAL   ----»»ÐÐ
SELECT replace(string,chr(10),'')   fr ......

OracleÊý¾ÝÎļþµÄÌØÐÔ

ÎÒÃÇ´ó¼Ò¶¼ÖªµÀÿ¸öOracleÊý¾Ý¿â¶¼»áÓÐÒ»¸ö»òÊǶà¸öÎïÀíµÄOracleÊý¾ÝÎļþ,Êý¾Ý¿âÐÅÏ¢(½á¹¹,Êý¾Ý)µÄÖ÷Òª×÷ÓÃÊÇÀ´±£´æÔÚÕâЩÏà¹ØµÄÊý¾ÝÎļþ,¶øÇÒÖ»ÓÐÕâЩÏà¹ØµÄÎļþOracle²ÅÄܹ»½âÊÍÓë¹ÜÀíÕâЩ´æ´¢.OracleÊý¾ÝÎļþ¾ßÓÐÒÔÏÂÒ»Ð©ÌØÐÔ:
1.Ò»¸öÊý¾ÝÎļþ½ö½ö¹ØÁªÒ»¸öÊý¾Ý¿â,OracleÊý¾ÝÎļþÓëÊý¾Ý¿âÖ®¼ä¶ÔÓ¦¹ØÏµÊÇÒ»¶ÔÒ»¹ØÏµ,µ±È»· ......

Oracle For Update ÐÐËø


ת£ºhttp://hi.baidu.com/mcj0127/blog/item/111a900777db06c87b89473c.html
SELECT FOR UPDATE Ïà¹ØµÄ֪ʶ
Ò»¸öÓʼþ·¢Ë͵ÄÓ¦Óûáÿ¹ýÒ»¶¨µÄʱ¼äƬȥÊý¾Ý¿âÖÐȡδ·¢µÄÓʼþÈ»ºó·¢ËÍÓʼþ£¬³É¹¦ºó½«Êý¾Ý¿âÖÐÓʼþ±êʶδ·¢¸ÄΪÒÑ·¢¡£
Õâ¸öÓ¦Óò¿ÊðÔÚwebsphereÉÏ£¬websphere²ÉÓÃÊÇ´¹Ö±¿Ë¡£¬ÓÐ4¸öserver,µ±4¸öserver¶¼¿ªÆôµÄ ......

LinuxϵͳÏÂOracle¼à¿Ø¹¤¾ß

1£®top
topÃüÁî¿ÉʵʱµØÏÔʾLinuxϵͳµÄ½ø³Ì¡¢CPU¡¢ÄÚ´æ¡¢¸ºÔصȵÄÐÅÏ¢¡£ËüÊÇÎÒÃÇÁ˽âϵͳÕûÌå״̬×îºÃµÄ¹¤¾ß¡£
topÃüÁîµÄÔËÐÐ״̬ÊÇÒ»¸öʵʱµÄÏÔʾ¹ý³Ì£¬ÎÒÃÇ¿ÉÔÚÕâ¸ö½çÃæ¼à¿ØÏµÍ³ÔËÐÐÇé¿ö¡£ÎÒÃÇ¿Éͨ¹ý¼¸¸ö°´¼üÀ´¿ØÖÆtopÃüÁÈç°´q¿ÉÍ˳ötopÃüÁî״̬£¬°´s¿ÉÊäÈëÐÅÏ¢µÄ¸üÐÂÆµÂʵȡ£ÕâЩÃüÁî¿É°´h°ïÖú¼ü²éѯ¡£
2£®Ps ......

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ºÅ