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("Á¬½Óʧ°Ü");
}
}
}
Ïà¹ØÎĵµ£º
×÷Õß Haidong Ji ·Òë GoodKid
ÎÒÃǵ±ÖеĴ󲿷ÖÈ˹¤×÷ÔÚÒ»¸öµ¥Ò»µÄ RDBMS ϵͳÖУ¬Èç MSSQL, Oracle, or IBM DB2¡£È»¶ø£¬ÎÒÃÇÈÕÒæ¸Ð¾õµ½£¬ÎÒÃÇÕý´¦ÓÚ²»Í¬µÄÊý¾Ý¿â»·¾³µ±Öв¢ÇÒÐèÒª½â¾öÊý¾ÝµÄ»¥ÓÃÐÔÎÊÌâ¡£
¾¡¹ÜÖ÷ÒªµÄ RDBMS ³§ÉÌÊÔͼȥ×ñѹØÏµÊý¾Ý¿âÄ£ÐÍÔÀí£¬²¢ÇÒÓ÷dz£Ð¡µÄ²îÒìȥʵÏÖËüÃÇ¡£ÁíÍ⣬¼¸ºõÖ÷ÒªµÄ ......
41.SYSDATE
ÓÃÀ´µÃµ½ÏµÍ³µÄµ±Ç°ÈÕÆÚ
SQL> select to_char(sysdate,dd-mm-yyyy day) from dual;
TO_CHAR(SYSDATE,
-----------------
09-05-2004ÐÇÆÚÈÕ
trunc(date,fmt)°´ÕÕ¸ø³öµÄÒªÇó½«ÈÕÆÚ½Ø¶Ï,È ......
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)(SID_DESC =
&nb ......
ÉèÁ¢·âËø»úÖÆÖ÷ÒªÊÇΪÁ˶Բ¢·¢²Ù×÷½øÐпØÖÆ£¬¶Ô¸ÉÈŽøÐзâËø£¬±£Ö¤Êý¾ÝµÄÒ»ÖÂÐÔºÍ׼ȷÐÔ¡£OracleÊý¾Ý¿â·âËø·½Ê½ÓÐÈýÖÖ£º¹²Ïí·âËø£¬¶ÀÕ¼·âËø£¬¹²Ïí¸üзâËø
¡¡¡¡ [b:8f4f63b9bb]·âËøÀàÐÍ[/b:8f4f63b9bb]
¡¡¡¡ Oracle¡¡RDBMSµÄ·âËøÀàÐͿɷÖΪÈçÏÂÈýÀࣺ
¡¡¡¡ £±¡¢ÄÚ²¿¼¶·âËø
¡¡¡¡ ÄÚ²¿¼¶·âËøÊÇÓÃÓÚ±£»¤ORACLEÄÚ²¿½á ......
ÎÊÌâ1£º ½øÈëʱÐèÒªÖ÷»úÉí·ÝÖ¤Ã÷£º ½â¾ö·½°¸£º¹ÜÀí¹¤¾ß——±¾µØ°²È«²ßÂÔ——Óû§È¨ÀûÖ¸ÅÉ——×÷ΪÅú´¦Àí×÷ÒµµÈ¼£¨×îºóÒ»Ï——Ìí¼Ó±¾»úµÄÕ˺ÅÓëÃÜÂë ......