1,小明,2010-10-10
2,小王,2010-5-15
3,小白,2010-2-18
/*建立 Vars()*/
loadVars_1 = new LoadVars();
/*載入完成時所執行的程式*/
loadVars_1.onData = function(thedata:String) {
if (thedata == undefined) {
trace('資料載入失敗'); return;
}
/*以換行符號(\n)切割字串*/
var rows:Array = thedata.split("\n");
for(i=0; i<rows.length; i++){
/*以垂直符號(|)切割字串*/
rows[i]=rows[i].split(",");
}
trace(rows);/*顯示載入的資料*/
};
/*開始載入 load_vars.txt*/
loadVars_1.load("load_vars.txt");
<a name="fb_share" type="button_count" share_url="data:post.url" href="http://www.facebook.com/sharer.php">分享</a>
<script src="http://static.ak.fbcdn.net/connect.php/js/FB.Share" type="text/javascript"></script>
<a name="fb_share" type="button_count" expr:share_url="data:post.url" href="http://www.facebook.com/sharer.php" title="分享至 Facebook">分享</a>
<script src="http://static.ak.fbcdn.net/connect.php/js/FB.Share" type="text/javascript"></script>
-- 建立資料表
CREATE TABLE table_name(
column1 NUMBER,
column2 CHAR,
column3 VARCHAR2,
column4 DATE,
-- 主鍵(PRIMARY KEY)
CONSTRAINT pk_table_name PRIMARY KEY(column1,column2),
-- 唯一鍵(UNIQUE KEY)
CONSTRAINT unique_table_name UNIQUE(column1,column2),
-- 外來鍵(FOREIGN KEY)
CONSTRAINT fk_table_name_column1
FOREIGN KEY(column1, column2)
REFERENCES parent_table(column1, column2)
[ON DELETE [CASCADE|SET NULL]]
-- 當參考鍵刪除時，相對應做的處理：
-- 預設 UPDATE No Action & DELETE No Action
-- ON DELETE CASCADE： 刪除參考鍵時連同刪除
-- ON DELETE SET NULL： 刪除參考鍵時將外鍵設為 NULL
);
-- 為資料表標示註釋
COMMENT ON TABLE table_name IS '資料表註釋';
-- 為資料欄位標示註釋
COMMENT ON COLUMN table_name.column1 IS '資料欄位註釋';
-- 附加主鍵(PRIMARY KEY)
ALTER TABLE table_name
ADD CONSTRAINT pk_table_name PRIMARY KEY(column1,column2);
-- 附加唯一鍵(UNIQUE KEY)
ALTER TABLE table_name
ADD CONSTRAINT unique_table_name UNIQUE(column1,column2);
-- 附加外來鍵(FOREIGN KEY)
ALTER TABLE table_name
ADD CONSTRAINT fk_table_name_column1
FOREIGN KEY(column1, column2)
REFERENCES parent_table(column1, column2)
[ON DELETE [CASCADE|SET NULL]];
-- 建立索引(Index)
CREATE [UNIQUE] INDEX idx_table_name ON table_name(column1, column2);
CREATE USER user_name IDENTIFIED BY user_password; -- 建立使用者
GRANT dba TO user_name; -- 授與最大權力
vars=1|小明|2010-10-10
2|小王|2010-5-15
3|小白|2010-2-18
/*建立 Vars()*/
loadVars_1 = new LoadVars();
/*載入完成時所執行的程式*/
loadVars_1.onLoad = function() {
/*以換行符號(\n)切割字串*/
var rows = this.vars.split("\n");
for(i=0; i<rows.length; i++){
/*以垂直符號(|)切割字串*/
rows[i]=rows[i].split("|");
}
trace(rows);/*顯示載入的資料*/
};
/*開始載入 load_vars.txt*/
loadVars_1.load("load_vars.txt");
<!-- load_1.xml -->
<?xml version="1.0" encoding="UTF-8"?>
<xmltest>
<parentnode>
<id>1</id>
<name>小明</name>
<date>2010-10-10</date>
</parentnode>
<parentnode>
<id>2</id>
<name>小王</name>
<date>2010-5-15</date>
</parentnode>
</xmltest>
/*建立 XML()*/
LoadXml_1 = new XML();
/*捨棄只包含空白字元的文字節點*/
LoadXml_1.ignoreWhite=true;
/*載入完成時所執行的程式*/
LoadXml_1.onLoad = function(){
articleList = this.firstChild.childNodes;
var txt = "";
for (i=0; i<articleList.length; i++) {
elementList = articleList[i].childNodes;
for (j=0; j<elementList.length; j++) {
elementTag = elementList[j];
switch(elementTag.nodeName){
case "id":
txt += elementTag.firstChild.nodeValue+',';
break;
case "name":
txt += elementTag.firstChild.nodeValue+',';
break;
case "date":
txt += elementTag.firstChild.nodeValue+',';
break;
}
}
txt += '\n';
}
trace(txt); /*顯示載入的資料*/
}
/*開始載入 load_1.xml*/
LoadXml_1.load("load_1.xml");
<!-- load_2.xml -->
<?xml version="1.0" encoding="utf-8"?>
<xmltest>
<parentnode id="1" name="小明" date="2010-10-10" />
<parentnode id="2" name="小王" date="2010-5-15" />
</xmltest>
/*建立 XML()*/
LoadXml_2 = new XML();
/*捨棄只包含空白字元的文字節點*/
LoadXml_2.ignoreWhite=true;
/*載入完成時所執行的程式*/
LoadXml_2.onLoad = function(success) {
var articleList = this.firstChild.childNodes;
var txt = "";
for (i=0; i<articleList.length; i++){
txt += articleList[i].attributes.id+','
+articleList[i].attributes.name+','
+articleList[i].attributes.call+','
+articleList[i].attributes.channel+"\n";
}
trace(txt);/*顯示載入的資料*/
};
/*開始載入 load_2.xml*/
LoadXml_2.load("load_2.xml");