oracleÈçºÎÁ¬½Ójdbc
ÏÈ˵һÏÂÎÒµÄÕûÌå»·¾³£ºoracle11g,myeclipse6.5,tomcat5.0,j2sdk1.4.2_19
ÏÖÔÚÒª×öµÄÊÇÓÃoracleÁ¬½Ójdbc£¬ÍøÉϲéÁ˺ܶ࣬˵Ҫoracle°²×°Ä¿Â¼ÏµÄÒ»¸öclasses12.jar,¿ÉÊÇÎҵݲװĿ¼ÏÂûÓÐÕâ¸ö°ü£¬°²×°Ä¿Â¼ÖÐE:\app\Administrator\product\11.1.0\db_1\jdbc\libÏÂÖ»ÓÐojdbc5.jar£¬ojdbc5_g.jar,ojdbc6_g.jar,ojdbc6.jar,
ÎÒÒ²´ÓÍøÉÏÏÂÁËclasses12.jar,ÇëÎÊÒªÁ¬½Ójdbc£¬Ó¦¸ÃÔõô×öÄØ£¬´úÂëÎÒÖªµÀÔõôд£¬Ö÷ÒªÊdzýÁË´úÂëÒÔÍâÓ¦¸ÃÈçºÎÅäÖã¬Çë¸÷λָ½Ì£¬ÍøÉÏ¿´Á˺ܶ໹ÊÇû۳ɹ¦£¬Ï£Íû»Ø´ðÄܹ»Ïêϸµã£¬Ð»Ð»£¡
oracle11g¿ÉÄÜ»¹ÒªÒ»¸öobject14.jar£¨À©Õ¹×÷Óã©
°Ñobject14.jar£¬class12.jar·ÅÔÚjdk/jre/lib/extÏÂÃæ
¹¤³ÌÀïweb-info/libÏÂÃæ×îºÃÒ²·ÅÒ»·Ý
Ïȵ¹°ü
È»ºó×öÒ»¸ö³ÌÐò
Class.forname ¼ÓÔØÒ»ÏÂÇý¶¯ È»ºóÁ¬½Ó ¾ÍºÃÁË
Java code:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBCon {
public static String driver="oracle.jdbc.driver.OracleDriver";
public static String url="jdbc:oracle:thin:@192.168.0.174:1521:ORCL";
public static String user="scott";
public static String pwd="tiger";
public static Connection getConnection(){
try {
Class.forName(driver);
Connection con=Drive
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿
SQL code:
SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......