Ӧо
APPLICATION RESEARCH OF COMPUTERS
2000 Vol.17 No.3 P.76-77




Lotus Notesݿʽӿģ
ƾ³
ժҪLotus NotesݿӿģDBLSXơʵּӦãģLotus LSXӿڣһ·ʽݿ⡣
ؼʣLotus LSX  ݿӿ
1
Lotus Notes/DominoȽͨŴȺƷȫʵ˶ԷǽṹݵĹ͹ΪϢĴȡģǰȫɿĻʩںǿĹInternetIntranetϡ
Lotus NotesһĵݿϵͳNotesݿԪؾĵĵɱ壬͵Notesĵ԰ṹݺͷǽṹݣNotesûṩ˴õĹǽṹݵĹߡ
(1)ʽı/ý壺NotesɸЧ洢͹Ϣ񡢸ʽıHTMLıͼΡͼƵƵźŵȡ
(2)ȫļNotes棬Զĵȫļ
(3)汾ƣΪ¼ͬûĵ޸ģNotesṩ汾ƹܣĵ޸ĿɱΪԭĵӦ
(4)ĵӣNotesĵпɰָĵ(NotesĵWWWҳ)ָ롣Ӷһڳıϵͳ
NotesݿͨODBCʽODBC΢ƶһݿӿڱ׼ODBCǰ˳ݲѯ󣬽佻ضݿODBC򣬽͸ݿϵͳ󽫲ѯ㷵ءODBCʽȱЧʵͣھݿNotesӦODBCʽҪΪˣǿNotesݿӿDBLSXӿʽNotes LSX(Lotus Script Extension)Notes LSXӦLotus ScriptԻNotesӦÿͨNotes ScriptЧʹϵݿ⡣
2Notes LSX
Դ70ĩSmalltalkԵĵѸٷչ죬췽Ϊƣӽṹģ͹磬봫ͳṹȾõĿɹԡԺͿɸԡģͰϵͳĽṹϣڵĶݺΪķװԼӿʵֵķʹʺϳ䵱ֲµĻͨŵԪ
Ĺ֮һǹ𣬹ǿõģ飬װضĹ߼ԱڿٶƿͻӦáλִУΪṩӦġ塢ĵWebҳ̶ǵ͵ĹģͶ˹ӿڡԼ֮໥ʽ֤˲ͬƷװһӦáӿڹ淶OMGCORBA淶Ϊ㷺ܣCORBAϵͳһӿԼЭı׼ĲƷ淶΢COM/DCOMIBMSOM/DSOMOSFDCECORBA֮ͬЩģ֧˶ڱԺͲϵͳƽ̨ķֲʽĺ㣬Щģ͵ĹӦĿӦֻ轫öعʵϸڣӶڣ˴ϵͳĸԡ
Lotus ScriptLotusƽ̨ͨñԣűȽ걸ⲢûLotus(Notes LSX)LSXϵͳƿļ(DLL)ʹCOM CLSID(Class ID)Ψһ־ӦLotus Scriptƽ̨LSXԡ¼ҪأLSXʹ֮ǰעᵽLotus ScriptϵͳעLSXһLotusһʹáLotus ScriptͨLSXģ鷢ϢLSX֪ͨLSXʼȡLSXԡ䷽ȣLSXʵһϢ(ص)Ϣ̸Lotus ScriptϢNotes LSXڿNotes LSXҪLSXĽӿڼԡ¼LSX WizardLSXĽӿڶC++ܣڳмԡ¼ʵִ뼴ɱLSXģ顣LSXLotus Scriptƽ̨ⲿԴݿȡ
3DBLSXʵ
ΪNotesݿЧʣǲֱӴȡݿķLSXݿLSXSQL䷢͸̨ݿ⣬ݶ뻺Уȡͼ1ʾݿʹ̡

ͼ1Lotus LSXݿʾͼ
3.1ģ͵
ΪݿӿģӦ¼㣺
1)ЧЧǹĳ㡣
2)ݿ޹أݿӿӦͬʽ칹ݿ⡣
3)̷㣺ģӦṩԱܷı̽ӿڡ
4)ֲӦѭͨõĹӿģͣӦڶԺͿƽ̨
5)׿ڸӵģͲʹãҲ׿
ΪˣǲοODBC/JDBCDAO/RDAOOLE DBݿӿģͣODBCǶӦóݿķʽõݿԣԱӦóԲͬݿʹòͬAPIͨODBCʹݿĸı÷ǳףΪӦó˵ֻĻһJDBCһJavaCLIʵϾһϵضݿJava⣬ԴODBCϵṹDAO/RDAO΢ӻϵп߲õݽӿڣĶνΪӣҪȱֻʹODBCΪײݿӿڡOLE DBһCOMӿڣΪӦóʱڲͬϢԴеṩͳһķʷЩϢԴǹϵ͵ģҲǷǹϵ͵ġЩӿִ֧ӦԴDBMSܣʹԴܹݡ
Lotusƽ̨صԼӦԼ򵥵ĶΣҪΪ
1)ỰSessionάһϵݿӡ
2)ConnectionӵԶݿ⣬¼Ϣ
3)Transactionݿȷϡعȡ
4)ѯQueryݿⷢͲѯ
5)ResultSetѯĻ塣
6)Errorʹ̵д
һε͵ݿʹ̿±룺
conn = new Connection
qry = new Query
res = new ResultSet
if conn.ConnectTo 'ORACLE', 'scott', 'tiger' <> 0 then
MsgBox Error.Msg
End if
qry.Connection = conn
qry.Result = res
qry.Sql ='Select * from emp'
qry.Execute
res.Open
' Fetch some data
res.Close
res.Delete
qry.Delete
conn.CloseConnection
conn.Delete
3.2͵ӳ
Notes֧BooleanIntegerLongSingleDoubleStringDatetimeCurrencyVariantͣݿϵͳḻö࣬ǶݿͺNotesӳ䣬Ҫʱͽǿת
3.3ַת
Lotusƽ̨UNICODEַַ˫ֽڱ룬ݿϵͳܲöַ뷽ʽַתתLSXṩַCԱַת
3.4ʵ
Windowsƽ̨Visual C++дDBLSXĴ룬Ŀǰֵ֧ݿϵͳOracleSybaseMicrosoft SQL ServerȻԴֻҪԼ޸ļMacintoshOS/2HP-UNIXƽ̨
4DBLSXӦ
DBLSXLotus Scriptƽ̨ȿLotusǰ̨ҲڱдLotus DominoķűLotus Notes 4.5Ͼ̨Ŀ칫ԶϵͳУNotesǰ̨ҪȡSybase System 11ݿе¼Ϣ(ʮԼ200300MB)DBLSXģ鱻Notesǰ̨Sybase System 11ݿ⣬ODBCʽȣDBLSXЧ˴ȵߣʵ֤ȫϵͳҪ󣬴Ӷؼӿ˵̨ĹЧʡ
Ļ863߿ƼĿ
ĻȻѧ
(Ͼѧѧ뼼ϵ Ͼ 210093)
ƾ(Ͼѧѧ뼼ϵ Ͼ 210093)
³(Ͼѧѧ뼼ϵ Ͼ 210093)
(Ͼѧѧ뼼ϵ Ͼ 210093)
ο
1 Lotus Notes Release 4.5: A Developer's Handbook. Lotus/IBM Corporation. Nov. l996
2 Oracle 7.3ֲ. Oracle Corporation
3 Microsoft DCOM Specification. Microsoft Corporation
ոڣ1999101
