ÈçºÎ×öSQLServer·¢²¼ºÍOracle¶©ÔĵÄÎÊÌâ
oracle·¢²¼£¬sqlserver¶©ÔÄÎÒ×ö³É¹¦ÁË
µ«ÊÇsqlserver·¢²¼oracle¶©ÔÄÎÒʼÖÕʧ°Ü
Âé·³×ö¹ýµÄÅóÓÑÖ¸½ÌÒ»ÏÂ
ûµÃÈ˹Ø×¢Ñ½
²»ÊÇûµÃÈ˹Ø×¢.
ÊÇÁ½ÖÖ²»Í¬µÄ¿â,ÄãÕâô¸ãʵÔÚÌ«ÄÑÁË,°ï¶¥.
ÕâÒ²ÊÇÒ»¸öÑо¿ÐÔÎÊÌâ
ÒòΪÖÜΧûµÃÈË»á
ÎÒ¿´µ½csdnÉÏÓÐÈË×ö¹ýµÄ
µ«ÊÇÕÒ²»µ½ÄǸöÈ˵ÄÁªÏµ·½Ê½ÁË
ºÃÏñûÓйٷ½Ö§³Ö
Ïà¹ØÎÊ´ð£º
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
´ó¼ÒºÃ£¬ÎÒ×î½üά»¤Ò»¸öÏîÄ¿£¬100¶à¸ö±í
Ö»ÄÜÓÃjdbcÖ±Á¬
Óöµ½Á˶à¸ö±í ¹ØÁª ²éѯµÄÇé¿ö Çë´ó¼ÒÖ¸½Ì
±ÈÈç
student(studentid,classid)
class(classid,classname)
class_teacher(classid,teacherid)Õâ¸öÊÇÖмä±í ......