Á¬½Ó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;
²»ÖªµÀÓÐʲôÎÊÌâ?Çë¶à¶àÖ¸½Ì°¡
Çý¶¯Ã»Óаüº¬½øÀ´¡£
{{----
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÓбíA£¨barcode varchar2£¬length number£©£¬B£¨barcode varchar2£¬serial number£©ÆäÖÐbarcode¹ØÁªA:BΪ1£ºn
ÓÐÈçÏÂsqlÓï¾ä
insert into a values('b1',10)
insert into a values( ......
ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
2¸öÒ³Ãæ£º
conn.php
PHP code:
<?php
$con = oci_connect("finaltest","finaltestpw","(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 17 ......
ÕâÊÇÎÒÔÀ´Á¬½ÓSQLµÄ´òÓ¡µÄ´úÂë
Connection1.Open "Provider=MSDataShape.1;Persist Security Info=True;Data Source=mm;User ID=sa;Password=sa;Initial Catalog=lc-liuh2;Data Provider=SQLOLEDB.1"Ê ......
Èç¹ûÒ»¸ö³ÌÐòÏëÖ§³ÖsqlserverÓëoracleÊý¾Ý¿âµÄ»°¡£³ýÁËdbhelperÀàÐèÒª¸Ä±äÖ®Í⣬²ÎÊý´«µÝÒ²ÊǸöÎÊÌâ¡£
sqlserverµÄ²ÎÊýǰ׺ÊÇ ¡°@¡±£¬¶øoracleÊÇ ¡°:¡±
ÇëÎÊÓÐûÓÐʲôͨÓýâ¾ö·½·¨£¿ÎÒ²»ÏëÒ»¸öselect ......