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
{{--
Ïà¹ØÎÊ´ð£º
ÈÕÇ°ÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?
2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......
ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿
¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼
Ö麣ÄDZßËƺõûÉîÛÚºÃ.
Èç¹ûÊÇÎҵĻ°,Ê×ÏÈÊÇÒª±ÈÏ ......
ÎÒ°´ÊéÉÏ˵µÄÆô¶¯Êý¾Ý¿â£º
ËùÓзþÎñ¶¼Í£Ö¹Ê±
£¨1£©´ò¿ª¼àÌý£ºlsnrctl start
£¨2£©£ºsqlplus /nolog
£¨3£©,connect system/password as sysdba /*ÕâÒ»²½¾Í²»ÐÐÁË£¬±¨ERROR:ORA-12560: TNS: ÐÒéÊÊÅäÆ÷´íÎ ......