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

JDBCÁ¬½ÓoracleÊý¾Ý¿âÎÊÌâ

Java code:
import java.sql.*;


class xt{

public static void main(String in[]){


try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(ClassNotFoundException cnfe){
System.out.println("can not found!");
}

try{
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@192.168.5.160:1521:orcl","system","manager");

Statement stat=con.createStatement();

//ResultSet res=stat.executeQuery("select * from students;"); //#

//res.next();
//System.out.println(res.getString(1));

}catch(SQLException sqle){
System.out.println("sql error");
}

}
}



ÒÔÉÏ´úÂëÖ´ÐÐ䱨ÈκÎÒì³£.
µ«Ö»ÒªÖ´ÐÐ×¢ÊÍΪ#µÄÄǾä,¾Í»á´òÓ¡"sql error",

Õâô¿´À´,Á¬½ÓÃ²ËÆÃ»ÎÊÌâ,ΪºÎÒ»Ö´ÐÐsqlÓï¾ä¾Í±¨´íÄØ?

Çë¸÷λ°ïæ¿´¿´,лл!

Java code:

¿´´úÂëûʲô´í°É. Êý¾Ý¿â·þÎñÆô¶¯ÁËô?±í´æÔÚô? ǰºóSystem´òÓ¡Ï¿´¿´ ÄľäÈÓµÄÒì³£.



Java code
{{--


Ïà¹ØÎÊ´ð£º

ORACLEÊý¾Ý¿âÖÐµÄ group by Óï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

Oracle Æô¶¯µÄÎÊÌâ

oracle not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html

Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..

cm ......

oracleÃüÁîÆô¶¯

ÎÒ°´ÊéÉÏ˵µÄÆô¶¯Êý¾Ý¿â£º
ËùÓзþÎñ¶¼Í£Ö¹Ê±
£¨1£©´ò¿ª¼àÌý£ºlsnrctl start
£¨2£©£ºsqlplus /nolog
£¨3£©,connect system/password as sysdba /*ÕâÒ»²½¾Í²»ÐÐÁË£¬±¨ERROR:ORA-12560: TNS: ЭÒéÊÊÅäÆ÷´íÎ ......

OracleÓÐshow databaseÂð

ÎÒÖªµÀMysqlÀïÓÐ show database ,show tables
ÎÒÔÚOracleÀïÊäÈëÎÞЧ£¬  ÇëÎÊOricalÕâ¸öÔõôд

ÎÒÒª²é¿´OracleÀïÃæµÄËùÓÐÊý¾Ý¿âÃû×Ö

ºÇºÇºÇ£¬ÕâÀïÊÇmysqlÀïµÄÓ÷¨

mysqlÀïµÄdatabaseÀà ......

ORACLEËæ»ú¼Ç¼³éÈ¡

ÎÒÏÖÔÚÐèÒªËæ»ú³éÈ¡table±íµÄµÄÊý¾Ý£¬±íµÄÊý¾ÝÓÐ100Íò£¬table´æÔÚÒ»¸ö×Ö¶Îa
ÒªÇó³éÈ¡³öÀ´µÄÊý¾Ýa×ֶεÄ×ܺÍÒªµÈÓÚ1000£¬Ë­Óкõķ½·¨£¬Çë½ÌÁË£¡


1Â¥ÒýÓõÄÎÄÕ£¬»á·ñÖØ¸´È¡ÏàͬµÄ¼Ç¼ºÅ£¿
ÀýÈ磺
id ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ