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

JDBCÁ¬½ÓOracleµÄ¼òµ¥Àý×Ó

 1import java.sql.*;
 2import java.util.logging.Level;
 3import java.util.logging.Logger;
 4
 5/** *//**
 6 * Title: JDBCÁ¬½ÓÊý¾Ý¿â
 7 * Description: ±¾ÊµÀýÑÝʾÈçºÎʹÓÃJDBCÁ¬½ÓOracleÊý¾Ý¿â£¬²¢ÑÝʾÌí¼ÓÊý¾ÝºÍ²éѯÊý¾Ý.
 8 */
 9public class JDBCExample {
10
11    public static void main(String[] arg) {
12        try {
13            try {
14                //×¢²áJDBCÇý¶¯
15                Class.forName("oracle.jdbc.driver.OracleDriver");
16            } catch (ClassNotFoundException ex) {
17                Logger.getLogger(JDBCExample.class.getName()).log(Level.SEVERE, null, ex);
18            }
19            //´´½¨Êý¾Ý¿âÁ¬½Ó
20            String url = "jdbc:oracle:thin:@127.0.0.1:1521:NEW";
21            String username = "scott";
22            String password = "tiger";
23            Connection con = null;
24            try {
25                con = DriverManager.getConnection(url, username, password);
26            } catch (SQLException ex) {
27            


Ïà¹ØÎĵµ£º

oracleº¯Êý´óÈ« Êý×Ö´¦Àíº¯Êý


oracleº¯Êý´óÈ«-Êý×Ö´¦Àíº¯Êý
F.3    Êý×Öº¯Êý
º¯Êý½ÓÊÜNUMBERÀàÐ͵IJÎÊý²¢·µ»ØNUMBERÀàÐ͵ÄÊýÖµ.³¬Ô½º¯ÊýºÍÈý½Çº¯ÊýµÄ·µ»ØÖµ¾«È·µ½36λ.ACOS¡¢ASIN¡¢ATAN¡¢ATAN2µÄ½á¹û¾«È·µ½36λ.
l         ABS
Óï·¨:   ABS(x)
¹¦ÄÜ:   µÃµ½xµÄ¾ø¶ÔÖ ......

ÓÃoracle 8i Êý¾Ý¿âʱÓöµ½µÄÎÊÌâ

oracle8i Çý¶¯ ojdbc14.jar Õâ¸öÇý¶¯ÓÐÎÊÌ⣬·ÖҳʱҪÊÖ¶¯ д rownum<m ,Ëü×Ô¶¯³ÉÉúµÄ·ÖÒ³²»ÕýÈ·£¬ÓõÄmysqlµÄtop m
Null value was assigned to a property of primitive °ÑentityÖÐintÀàÐ͸ijÉInteger  ¿âÖв»ÉèÖÃnullable
number(9) µÄid ²»ÄÜÓÃInterger,µÃÓÃBigDecimal,Òª²»È»È¡idʱ»á±¨´í ......

OracleÓ¦ÓÃÌåϵ½á¹¹

OracleÓ¦ÓÃÌåϵ½á¹¹
°üº¬ÈçÏÂÖ÷Ì⣺
¡£¿Í»§¶Ë/·þÎñÆ÷Ìåϵ½á¹¹¼ò½é
¡£¶à²ãÌåϵ½á¹¹¸ÅÊö
¡£OracleÍøÂç·þÎñ¸ÅÊö
1¡£¿Í»§¶Ë/·þÎñÆ÷Ìåϵ½á¹¹¼ò½é
ÔÚOracleÊý¾Ý¿âϵͳÖУ¬Êý¾Ý¿âÓ¦ÓóÌÐòÓëÊý¾Ý¿â±»·ÖΪÁ½²¿·Ö£ºÇ°¶Ë(front-end)»ò³ÆΪ¿Í»§¶Ë(client)£¬ºǫ́(back-end)»ò³ÆΪ·þÎñ¶Ë---Õâ¾ÍÊÇ¿Í»§¶Ë/·þÎñÆ÷Ìåϵ½á¹¹Ãû×ÖµÄÓÉÀ´¡£ ......

oracle¿ª·¢ÖªÊ¶µã

1. ·ÖÇø±í
   
Oracle
½¨ÒéÈç¹ûµ¥¸ö±í³¬¹ý2G¾Í×îºÃ¶ÔÆä½øÐзÖÇø¡£
¶Ô´ó±íµÄ²éѯ¡¢Ôö¼Ó¡¢Ð޸ĵȲÙ×÷¿ÉÒԷֽ⵽±íµÄ²»Í¬·ÖÇøÀ´²¢ÐÐÖ´ÐУ¬¿ÉʹÔËÐÐËٶȸü¿ì£»
    1)
Range·ÖÇø
¡¡¡¡Range·ÖÇøÄØÊÇÓ¦Ó÷¶Î§±È½Ï¹ãµÄ±í·ÖÇø·½Ê½£¬ËüÊÇÒÔÁеÄÖµµÄ·¶Î§À´×öΪ·ÖÇøµÄ»®·ÖÌõ¼þ£¬½«¼Ç¼´æ·Åµ½ÁÐ ......

Oracle DB Link


Êý¾Ý¿âÖ®¼äµÄÁ´½Ó½¨Á¢ÔÚDATABASE LINKÉÏ¡£Òª´´½¨Ò»¸öDB LINK£¬±ØÐëÏÈÔÚÿ¸öÊý¾Ý¿â·þÎñÆ÷ÉÏÉèÖÃÁ´½Ó×Ö·û´®¡£
  
1¡¢ ÅäÖÃTNS £¬ $ORACLE_HOME/NETWORK/ADMIN/tnsname.ora
10gstandby =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = HFCC-KF-3068)(PORT = ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ