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

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


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

linuxÏÂCÓïÑÔ¿ª·¢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 - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

Çë½ÌOracleÊÂÎñ¸ôÀë¼¶±ðÎÊÌâ - Oracle / ·Ç¼¼ÊõÇø

²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿

SQL code:

SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ