Á¬½ÓOracleÊý¾Ý¿â,À§ÈÅ
ÔÚEclipseÀï±àдµÄÒ»¸öJAVA³ÌÐò,Á¬½ÓÊý¾Ý¿â,È´×ÜÁ¬²»ÉÏ,³ÌÐòΪ:
import java.sql.*;
public class as {
public static void main(String args[])throws Exception
{
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:oral";
Connection conn = DriverManager.getConnection(url, "scott", "tiger");
System.out.println(conn.isClosed());
if(!conn.isClosed())
conn.isClosed();
}
}
ÔËÐкó,×ÜÊÇÓÐÒÔÏÂÎÊÌâ
Exception in thread "main" java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at as.main(as.java:5)
ÎÒµÄclasspathΪ.;C:\Program Files\Java\jdk1.6.0_13\lib;F:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar;
²»ÖªµÀÓÐʲôÎÊÌâ?Çë¶à¶àÖ¸½Ì°¡
Çý¶¯Ã»Óаüº¬½øÀ´¡£
{{----
Ïà¹ØÎÊ´ð£º
2¸öÒ³Ãæ£º
conn.php
PHP code:
<?php
$con = oci_connect("finaltest","finaltestpw","(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 17 ......
Conn.phpÒ³Ãæ£º
[code=php]
<?php
$con = oci_connect("finaltest","finaltestpw","(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = ( ......
orcle Óï¾ä create table book1(name, price) as select book_name, price form book;
¶ÔÓ¦µÄMySQLµÄÓï¾äÊÇʲô
create table book1 as select book_name, price form book; ÕâÑùÔÚMySQLÀï¿ÉÒÔ£¬µ«ÊÇÈ´² ......
VBÓÐûÓÐÀàËÆÏñJDBCµÄ·½·¨»òÕßÊÇÖмä¼þÁ¬½ÓORACLEÊý¾Ý¿â£¬ÍøÉϵĸ÷ÖÖÀý×Ó¶¼ÐèÒª°²×°¿Í»§¶Ë£¬»òÕßÊÇÅäÊý¾ÝÔ´¡£
ûÓÐÆäËû·½·¨£¬Äã±ØÐëÒª°²×°Çý¶¯µÄ
ORACLEÊý¾Ý¿âÊÇ»ùÓÚ°²È«ÐԵĿ¼ÂÇ,¿Í»§¶Ë¶¼ÐèÒª°²×°,ºÃÏóûÓбðµÄ ......
delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î
http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö
ÒýÓÃ
vStream := TMemorySt ......