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
Ïà¹ØÎĵµ£º
ÓÃQt¿ª·¢Oracle³ÌÐòʱ£¬³£»áÓöµ½QOCIÇý¶¯ÎÊÌ⣬Ö÷Òª±íÏÖΪ³ÌÐòÔËÐÐʱ³öÏÖÏÂÃæµÄ´íÎó¡£
QOCI driver not loaded
available drivers: QSQLITE QODBC3 QODBC
Õâ˵Ã÷ûÓа²×°QtÖ§³ÖOracleµÄÇý¶¯¡£
.
ÒªÏë±ÜÃâÕâ¸öÎÊÌ⣬µÚÒ»ÖÖ·½·¨ÊÇʹÓÃЧÂʵÍϲ¢ÇÒ·ÑʵÄODBC£»µÚ¶þÖÖ·½·¨¾ÍÊÇ°²×°QOCIÇý¶¯¿©~
.
Ҫ˵һϵÄÊÇ£ºQOCIÔÚqt ......
CHAR ¹Ì¶¨³¤¶È×Ö·û´® ×î´ó³¤¶È2000 bytes
VARCHAR2 ¿É±ä³¤¶ÈµÄ×Ö·û´® ×î´ó³¤¶È4000 bytes ¿É×öË÷ÒýµÄ×î´ó³¤¶È749
NCHAR ¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´® ×î´ó³¤¶È2000 bytes
NVARCHAR2 ¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¿É±ä³¤¶È×Ö·û´® ×î´ó³¤¶È4000 bytes
DATE ÈÕÆÚ£ ......
OracleÓ¦ÓÃÌåϵ½á¹¹
°üº¬ÈçÏÂÖ÷Ì⣺
¡£¿Í»§¶Ë/·þÎñÆ÷Ìåϵ½á¹¹¼ò½é
¡£¶à²ãÌåϵ½á¹¹¸ÅÊö
¡£OracleÍøÂç·þÎñ¸ÅÊö
1¡£¿Í»§¶Ë/·þÎñÆ÷Ìåϵ½á¹¹¼ò½é
ÔÚOracleÊý¾Ý¿âϵͳÖУ¬Êý¾Ý¿âÓ¦ÓóÌÐòÓëÊý¾Ý¿â±»·ÖΪÁ½²¿·Ö£ºÇ°¶Ë(front-end)»ò³ÆΪ¿Í»§¶Ë(client)£¬ºǫ́(back-end)»ò³ÆΪ·þÎñ¶Ë---Õâ¾ÍÊÇ¿Í»§¶Ë/·þÎñÆ÷Ìåϵ½á¹¹Ãû×ÖµÄÓÉÀ´¡£ ......
רÓ÷þÎñÆ÷£ºÒ»¸ö¿Í»§¶ËÁ¬½Ó¶ÔÓ¦Ò»¸ö·þÎñÆ÷½ø³Ì
¹²Ïí·þÎñÆ÷£º¶à¸ö¿Í»§¶ËÁ¬½Ó¶ÔÓ¦Ò»¸ö·þÎñÆ÷½ø³Ì£¬·þÎñÆ÷¶Ë´æÔÚÒ»¸ö½ø³Ìµ÷¶ÈÆ÷À´¹ÜÀí¡£
OracleȱʡÓõÄÊÇרÓ÷þÎñÆ÷ģʽ£¬Oracle¿ÉÒÔͬʱ֧³Ö¹²Ïí·þÎñÆ÷ºÍרÓ÷þÎñÆ÷ģʽ£¬¿ÉÒÔÖ¸¶¨Ò»¸ö»á»°Ê¹ÓÃרÓ÷þÎñÆ÷£¬ÁíÒ»¸ö»á»°Ê¹Óù²Ïí·þÎñÆ÷¡£
¹²Ïí·þÎñÆ÷¾ßÓÐÒÔÏÂһЩȱµã£º
1)¹² ......
1. ´´½¨ÆÕͨÓû§
>create user username identified by username;
>grant create tablespace, resource ,connect to username;
2. ´´½¨±í¿Õ¼äºÍÓû§
2.1 ´´½¨ÁÙʱ±í¿Õ¼ä
>create temporary tablespace DB_TEMP
tempfile '/opt/oracle/oradata/mydb/t ......