Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

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Ò²²»¿É ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ