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·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
Ò»¸öJSPÒ³Ãæ½ÓÊÕÆäËûÒ³ÃæÌá½»¹ýÀ´µÄFORM±íµ¥£¬µ«ÊÇÒªÇóÖ»½ÓÊÕµ±Ç°Õ¾µã¼°Æä×ÓÕ¾µãÌá½»¹ýÀ´µÄFORM±íµ¥£¬ÆäËûÕ¾µãÌá½»¹ýÀ´µÄ±íµ¥²»½ÓÊÕ£¬Õâ¸öÔõôÉèÖã¿
ÓùýÂËÆ÷
filter
½«µ±Ç°Õ¾µã¼°Æä×ÓÕ¾µã·ÅÒ»¸öĿ¼
È» ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔõôÔÚ¿ØÖÆÌ¨ÖÐÊäÈëÀàËÆÏÂÃæµÄÐÅÏ¢£º
s1234 50
s1235 80
s1234 90
s1234 40
s1236 90
ÿµ±»Ø³µÊ± ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......