ÈçÏÂ,ÎÒÔÚÊý¾Ý¿âÀï²é³öÁËÒ»ÁÐÖµ£¬
creator(×Ö¶ÎÃû)
zhangsan
lisi
wangwu
ÎÒÏë°Ñ²é³öÀ´µÄÕâÈý¸öֵͨ¹ýsqlÓï¾äת»»Îª zhangsan,lisi,wangwu ÕâÑùÒ»¸ö×ֶεÄÐÎʽ£¬²»ÖªµÀÐв»ÐУ¬Çë¸÷λ¸ßÊִͽ̣¬Ð»Ð»£¡
Êý¾Ý¿âÊÇʲô°æ±¾£¿
Oracle ÐÐÁÐת»»
http://blog.csdn.net/tianlesoftware/archive/2009/ ......
table1:
uID uName
1 СÀî
2 СÕÅ
table2:
pID uID type
1 1 H1
2 2 H2
table3:
uID teamID
1 T1
1 ......
Çë½Ì¸÷λ´óÏÀÁ½¸öÎÊÌâ:
£¨1£©ÇëÎÊoracleÊÇ·ñÓо«¼ò°æÏÂÔØ£¿ÍêÕû°æ»ú×ÓʵÔÚÊÇÅܲ»¶¯£¬
¶øÇÒһЩ¹¦ÄÜÒ²Óò»ÉÏ£¬²»ÖªµÀÊÇ·ñÓо«¼ò°æ¡£
£¨2£©ÓÃoracle½øÐпª·¢ÐèÒª°²×°¿Í»§¶ËÂð£¿
лл£¡
º¹£¬Ã»ÈË
1.¾«¼ò°æÒ»Ëµ,ûÌý˵¹ý.
2.Òª°²×°client ¶Ë°æ±¾ oracle.Ò»°ã¿ª·¢»¹Ðè°²×°plsql»òtoad
ÂÌÉ ......
Java code:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class JDBCTest {
/**
* @param args
*/
private Connection con = null;
static{
try{
Class.forName ("oracle.jdbc.driver.OracleDriver&qu ......
ÇëÎÊORACLEÊÇ·ñÓÐÀàËÆSQL SERVER 2008ÖеÄSQL Server ProfilerÕâÑùµÄ½ØÈ¡Ö´Ðе½·þÎñÆ÷µÄÔËÐнű¾µÄ¹¤¾ß»ò¹¦ÄÜ£¿
лÀ²¡£
ûÓÐÈËÖªµÀÂð£¿
²»Çå³þ..
½ØÈ¡Ö´Ðе½·þÎñÆ÷µÄÔËÐнű¾£¿ÊÇʲôÒâ˼£¿
¾ÍÊÇ¿ÉÒÔ²éѯµ½ÄÄЩÈËÖ´ÐÐÁËÄÄЩ²éѯÓï¾äµ½·þÎñÆ÷ÁË¡£
ÔÙ¶¥
ÔÙ¶¥
oracleÌṩ¶¯Ì¬ÊÓͼ¼Ç¼Óû§Ö´Ðйý ......
window ce ϵͳÏÂÔõô·ÃÎÊ pc»úÉϵÄoracleÊý¾Ý¿â£¡ÎÒÓõÄÊÇvs2008£¬poketpcÊÇwindows mobile 5.0£¬²»ÖªÄÇλ¸ßÈËÄܸø½â¾ö¡£
Ö±½Ó·¢Êý¾Ýµ½PCÉÏ.
È»ºóPC´¦Àí..
²»ÓÃÁª°É
³ýÁËÕâ¸öÕæµÄûÓиüºÃµÄ½â¾ö°ì·¨ÁËÂð£¿
ÏëÎÞÏßÖ±½ÓÁ¬£¬£¬£¬£¬Õâ¸öºÃÏñÓеãÄѶȣ¡
¾ÍËãÁ¬ÉϺó²»Ò²¾ÍÊÇ·¢·¢Êý¾ÝÂð£¿ÔÀíÊÇÒ»ÑùµÄ£¡
......