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

Windows»·¾³ÏÂjavaÁ¬½ÓLinux»·¾³OracleÊý¾Ý¿â³ö´í

Çë½ÌΪʲô±¾»úWindows»·¾³ÏÂjavaÁ¬½ÓLinux»·¾³ÏÂOracleÊý¾Ý¿â³ö´í£¿£¨×¢£ºÒ»Ï´úÂëÁ¬½Ó±¾»úOracleÊý¾Ý¿âÕý³££¬Çý¶¯°üΪojdbc14.jar£©


ÒÔÏÂΪjavaÁ¬½ÓOracleÊý¾Ý¿â´úÂ룬ÔÚÁ¬½Ó±¾»úOracleÊý¾Ý¿âÕý³£
Connection con = null;
PreparedStatement pst = null;
ResultSet rs = null;

public Connection getConnection() {
  try {
  Class.forName("oracle.jdbc.driver.OracleDriver");
if(con == null || con.isClosed()){
con = DriverManager.getConnection("jdbc:oracle:thin:@10.216.8.212:1521:NXDC","mw_sys","sys");
}
  } catch (Exception e) {
e.printStackTrace();
System.out.print("Á¬½Ó³öÒì³££¡");
  }
return con;
}


Á¬½Ó·þÎñÆ÷OracleÒì³£ÐÅÏ¢£¨·þÎñÆ÷ϵͳ£ºLinux£©
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
10.216.8.212:1521:NXDC

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:260)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:413)
at oracle.jdbc.driver.T4CConnection.<init>


Ïà¹ØÎÊ´ð£º

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

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

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

C/SÏîÄ¿¼Ü¹¹Éè¼Æ----ÇóÖú - Java / Java SE

±¾ÈËÕýÔÚÓÃJava×öÒ»¸öC/S¼Ü¹¹µÄÏîÄ¿£¬ 
¿ÉÊÇÓÉÓÚÏîÄ¿±È½Ï´ó£¬Ç°ÆÚ¶Ô¼Ü¹¹µÄÉè¼ÆÓÈÆäÖØÒª£¬ÒòΪºóÆÚ¿ÉÄÜËæÊ±»á¼Ó¸ö¹¦ÄÜ»òÕßÈ¥µôijЩ¹¦ÄÜ¡£ 
ËùÒÔÌØµØÑ°ÇóÈçºÎÉè¼ÆC/SµÄ¼Ü¹¹Ê¹³ÌÐò¸ü¼ÓÃæÏò¶ÔÏó¸ü¼ÓÒ×ÓÚά ......

javaʹÓôúÀí·ÃÎÊÍøÖ· - Java / Java SE

´úÂëÈçÏ £¬ÎÒÏëͨ¹ý´úÀí·ÃÎÊÒ»Ð©ÍøÖ·£¬µ«ÊDz»ÖªµÀÈçºÎ²âÊÔ´úÀí³É¹¦£¬ÎÒÏëͨ¹ý·ÃÎÊ¡°http://www.blogger.com/¡±À´¿´¿´ÊÇ·ñ´úÀí³É¹¦£¬µ«ÊÇÒ²²»ÄÜ·ÃÎÊ£¬³öÏÖÒì³£¡°Unexpected end of file from server¡±£¬µ«ÊÇÈç¹û²»Õâ ......

java xmlÎÄÌâ - Java / Java SE

<?xml version="1.0" encoding="utf-8" ?> 
- <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:orientation="vertical&q ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ