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

java´úÂëÁ¬½Óµ½oracleÊý¾Ý¿â

package com.deng.oracle;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class TestOracle {
public static void main(String[] args) {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
//System.out.println("ÓÐÊý¾Ý¿âÇý¶¯");
String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
Connection conn;
try {
conn = DriverManager.getConnection(url, "scott", "tiger");
Statement stmt = conn.createStatement();
String sql = "select * from emp";
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
System.out.println("ENAME: " + rs.getString(2));
}
} catch (SQLException e) {
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
}

Ê×ÏÈ, ÔÚclasspath»·¾³±äÁ¿Ï¼ÓÔØoracleµÄÊý¾Ý¿âÇý¶¯: classes12.jar»òÕßÊÇojdbc14.jar, È»ºó¼ÓÔØ¸÷¸öSQLµÄÀà, ±àдurl, Õâ¸öurlÊÇjdbc:oracle:thin:@127.0.0.1:1521:orcl, ÆäÖÐ1521ÊǶ˿ںÅ, orclÊÇÊý¾Ý¿âµÄSID, Õâ¸öSID¿ÉÒÔÔÚ×¢²á±íÖв鿴µÃµ½, cmdà regedit, ÔÚ×¢²á±íÖÐHKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0¼üÖµORACLE_SID¿ÉÒÔ¿´µ½Õâ¸öSID: orcl.


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

Oracle±í¿Õ¼ä¹ÜÀí

extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î»      --segment    management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......

javaÓÅ»¯Õ¼ÓÃÄÚ´æµÄ·½·¨(Ò»)

java×öµÄϵͳ¸øÈ˵ÄÓ¡ÏóÊÇʲô£¿Õ¼Äڴ棡˵µÀÕâ¾ä»°¾Í»áÓÐN¶àÈËÕ¾³öÀ´Îªjava±ç»¤£¬²¢¾Ù³öÒ»¶ÑµÄÐÔÄܲâÊÔ±¨¸æÀ´Ö¤Ã÷ÕâÒ»µã¡£Æäʵ´ÓÀíÂÛÉÏÀ´½²java×öµÄϵͳ²¢²»±ÈÆäËûÓïÑÔ¿ª·¢³öÀ´µÄϵͳ¸üÕ¼ÓÃÄڴ棬ÄÇôΪʲôȴÓÐÕâôN¶àÀíÓÉÀ´Ö¤Ã÷ËüȷʵռÄÚ´æÄØ£¿Á½¸ö×Ö£¬ÂªÏ°¡£
£¨1£©±ðÓÃnew Boolean()¡£
Ôںܶೡ¾°ÖÐBooleanÀàÐÍÊDZØÐ ......

javaÓÅ»¯Õ¼ÓÃÄÚ´æµÄ·½·¨(¶þ)


À¬»øÊÕ¼¯¼¸ºõÊÇÿ¸ö¿ª·¢ÈËÔ±¶¼Ï²°®µÄÒ»¸ö Java™ Æ½Ì¨ÌØÐÔ£¬Ëü¼ò»¯ÁË¿ª·¢£¬Ïû³ýÁËËùÓÐÖÖÀàµÄDZÔÚ´úÂë´íÎ󡣿ɾ¡¹ÜÀ¬»øÊÕ¼¯Ò»°ãÀ´Ëµ¿ÉÒÔÈÃÄúÎÞÐè½øÐÐ×ÊÔ´¹ÜÀí£¬ÓÐʱºòÄú»¹ÊDZØÐë×Ô¼º½øÐÐһЩÄÚÎñ´¦Àí¡£
ÏÔʽµØÊÍ·Å×ÊÔ´
Java ³ÌÐòÖÐʹÓõľø´ó¶àÊý×ÊÔ´¶¼ÊǶÔÏó£¬À¬»øÊÕ¼¯ÔÚÇåÀí¶ÔÏó·½Ãæ×öµÃºÜºÃ¡£Òò´Ë£¬Äú¿ÉÒÔʹÓÃÈÎ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ