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
{{--
Ïà¹ØÎÊ´ð£º
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
oracle not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html
Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..
cm ......
ÎÒ°´ÊéÉÏ˵µÄÆô¶¯Êý¾Ý¿â£º
ËùÓзþÎñ¶¼Í£Ö¹Ê±
£¨1£©´ò¿ª¼àÌý£ºlsnrctl start
£¨2£©£ºsqlplus /nolog
£¨3£©,connect system/password as sysdba /*ÕâÒ»²½¾Í²»ÐÐÁË£¬±¨ERROR:ORA-12560: TNS: ÐÒéÊÊÅäÆ÷´íÎ ......
ÎÒÖªµÀMysqlÀïÓÐ show database ,show tables
ÎÒÔÚOracleÀïÊäÈëÎÞЧ£¬ ÇëÎÊOricalÕâ¸öÔõôд
ÎÒÒª²é¿´OracleÀïÃæµÄËùÓÐÊý¾Ý¿âÃû×Ö
ºÇºÇºÇ£¬ÕâÀïÊÇmysqlÀïµÄÓ÷¨
mysqlÀïµÄdatabaseÀà ......
ÎÒÏÖÔÚÐèÒªËæ»ú³éÈ¡table±íµÄµÄÊý¾Ý£¬±íµÄÊý¾ÝÓÐ100Íò£¬table´æÔÚÒ»¸ö×Ö¶Îa
ÒªÇó³éÈ¡³öÀ´µÄÊý¾Ýa×ֶεÄ×ܺÍÒªµÈÓÚ1000£¬ËÓкõķ½·¨£¬Çë½ÌÁË£¡
1Â¥ÒýÓõÄÎÄÕ£¬»á·ñÖØ¸´È¡ÏàͬµÄ¼Ç¼ºÅ£¿
ÀýÈ磺
id ......