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
Ïà¹ØÎÊ´ð£º
Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃ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 ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......