=================
SQLJ 蟆曙れ蠍
=================
~ 願碓 谿 螻企... 朱襷殊 螳 覓詞 襷語..＜;
願襷 螳覃...讌讀る曙企...
.... 螳 螻蟇磯 螻 豺蟲...覿 螻讌 襷蠍...
襾殊...JDK襯 蟾 蟆譯??? 覯 JDK 1.2.2_008 覯 螻 給...
願碓 蟆曙れ 伎殊蟲...
蠏碁伎 蟆 れ 朱れ...
classes[ver].zip
translator.zip
runtime[ver].zip
...
朱れ 蟆曙磯 E:\oracle\ora90\sqlj\lib <--- 蟆暑 企..
[ver] 覩碁 JDK 覯 覩誤...JDK 1.2 覯伎 [ver] 12螳 れ願 蟆
谿場朱 ...
谿場殊?? 谿場殊朱 覦 CLASSPATH襯 れ伎 蟆螻 螳... 瑚 殊
CLASSPATH れ 譴...
譯殊 蟆...SYSTEM 覲 讌蠍 覲 CLASSPATH襯 れ伎殊伎 る
蟆... SYSTEM 覲襷 れ螻襴 豌 螻給...蟇 覈磯殊襴.......
覦 覈襯企 企一 り...~ 覓伎 蠍磯擦企...
蠏碁磯...蠏 蠍一危襦 螻給 蟆 蠍磯 ~ 蠖蠖...
蟆曙れ 曙??? 覲願鍵覲企 曙企...
蟆曙れ 襷豺る れ るゼ ろ 企..
import java.sql.*;
import sqlj.runtime.ref.DefaultContext;
import oracle.sqlj.runtime.Oracle;
#sql iterator MyIter (String ename, int empno, float sal);
public class MyExample
{
public static void main (String args[]) throws SQLException
{
Oracle.connect
("jdbc:oracle:thin:@IP 譯殊:1521:orcl9i", " scott", "tiger"); // 蟆曙 襷豢 覦蠑語 譯殊語...
#sql { insert into emp (ename, empno, sal)
values ('SALMAN', 32, 20000) };
MyIter iter;
#sql iter={ select ename, empno, sal from emp };
while (iter.next()) {
System.out.println
(iter.ename()+" "+iter.empno()+" "+iter.sal());
}
}
}
====
蟆郁骸
====
F:\myjava>sqlj MyExample.sqlj
F:\myjava>javac MyExample.java
F:\myjava>java MyExample
SMITH 7369 800.0
ALLEN 7499 1600.0
WARD 7521 1250.0
JONES 7566 2975.0
MARTIN 7654 1250.0
BLAKE 7698 2850.0
CLARK 7782 2450.0
SCOTT 7788 3000.0
KING 7839 5000.0
TURNER 7844 1500.0
ADAMS 7876 1100.0
JAMES 7900 950.0
FORD 7902 3000.0
MILLER 7934 1300.0
MILLER 1111 1300.0
SALMAN 32 20000.0
F:\myjava>