ÅäÖÃweblogicÁ¬½ÓoracleµÄÊý¾ÝÔ´
Name:JDBC-DEV1
JNDI Name:jdbc.datasource.DS1
AdminServer
Row Prefetch Size: 48
Stream Chunk Size:256
URL:jdbc:oracle:thin:@192.168.0.118:1521:AAT
Driver Class Name:oracle.jdbc.OracleDriver
Á¬½Óoracle¼°postgresqlµÄÁ¬½Ó×Ö·û´®
package com.lwf.eus.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
public class ConnectionManager {
public static Connection getConnectionOracle(){
Connection conn = null;
String url = "jdbc:oracle:thin:@192.168.0.118:1521:AAT";
String userName = "xxx";
String pwd = "xxx";
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
conn = DriverManager.getConnection(url,userName,pwd);
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (InstantiationException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (Exception e){
e.printStackTrace();
}
return conn;
}
public static Connection getConnection(){
Connection conn = null;
String url = "jdbc:postgresql://192.168.0.180/getseus";
String userName = "xxx";
String pwd = "xxx";
try {
Class.forName("org.postgresql.Driver").newInstance();
conn = DriverManager.getConnection(url,userName,pwd);
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (InstantiationException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (Exception e){
e.printStackTrace();
}
return conn;
}
public static Connecti
Ïà¹ØÎĵµ£º
1.oralceɾ³ýÃüÁî
1.1.ɾ³ýÓû§
drop user username cascade;
1.2.ɾ³ý±í¿Õ¼ä
DROP TABLESPACE dataspace INCLUDING CONTENTS AND DATAFILES;
2.´´½¨±í¿Õ¼ä
2.1.½¨Á¢±í¿Õ¼ä
CREATE TABLESPACE dataspace
DATAFILE '/Ŀ¼/dataspace.dbf' SIZE 500M
UNIFORM SIZE 128k; //Ö¸¶¨Çø³ß´çΪ128k,Èç²»Ö¸¶¨£¬Çø³ß´çĬÈÏÎ ......
1. ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2. CHR
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ×Ö·û;
SQL> select chr(54740) zhao,chr(65) chr65 from dual;
ZH C
-- ......
ÒÔ ÏÂÆßÖÖÊý¾Ýµ¼Èë·½·¨Äĸö×îÊÊÓÃÐèÒªÕë¶Ô¾ßÌåÇé¿ö¾ßÌå·ÖÎö£¬ÎÒÒ²¸½´øÁоÙÁËÓ°Ïìµ¼ÈëËٶȵĸ÷ÖÖÒòËØ¹©Õå×á£ÎªÁ˱Ƚϸ÷ÖÖÊý¾Ýµ¼Èë·½·¨µÄЧ¹û£¬ÎÒ´´½¨ÁËʾÀý±í ºÍÊý¾Ý¼¯£¬²¢Óø÷ÖÖ·½·¨µ¼ÈëʾÀýÊý¾Ý¼¯À´¼ÆËã×ÜÌåµ¼Èëʱ¼äºÍµ¼Èë½ø³ÌÕ¼Óà CPU ʱ¼ä£¬ÕâÀïµÃ³öµÄʱ¼ä½ö¹©²Î¿¼¡£ÐèҪ˵Ã÷µÄÊÇ£¬½¨ÒéÄãʹÓà Oracle 9i ÆóÒµ°æÊý¾Ý¿â£¬ ......
±¾»úµçÄÔÉÏÓа²×°ORACLE10GµÄ¿Í»§¶Ë£¬ºóÀ´ÓÉÓÚÐèÒªÍæÁËÒ»ÏÂODAC£¬ºóÀ´ÓÖÐ¶ÔØµôÁË¡£½á¹û£¬Ê¹ÓÃC#½øÐÐÁ¬½ÓµÄʱºò±¨£º
δÔÚ±¾µØ¼ÆËã»ú×¢²á“OraOLEDB.Oracle.1”Ìṩ³ÌÐò
È»ºó£¬Ð½¨Ò»¸öUDL½øÐвâÊÔ£¬·¢ÏÖOracle Provider & ......