资源描述:
《毕业论文格式示范》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
1、0方*<本科生毕业设计(论文)题目:开放式微聚事务处理系统设计数字媒体学院数字媒体技术专业学号0305080315学牛姓名李坡指导教师谢振平讲师二O—二年六月论文摘要以浓缩的形式概括研究课题的内容,屮文摘要在400字左右,外文摘要与屮文ABSTRACTItistheEnglishtranslationoftheChineseabstrac匚Font:TimesNewRoman,WordSize:12.(sameas"小四").Keywords:Thesis;template;criterion;figure;tableWo
2、rkingwithDatabasesThischapterdescribeshowtouseSQLstatementsinembeddedapplicationstocontroldatabases.Therearethreedatabasestatementsthatsetupandopendatabasesforaccess:SETDATABASEdeclaresadatabasehandle,associatesthehandlewithanactualdatabasefile,andoptionallyassign
3、soperationalparametersforthedatabase.SETNAMESoptionallyspecifiesthecharactersetaclientapplicationusesforCHAR,VARCHAR,andtextBlobdata.Theserverusesthisinformationtotransliteratefromadatabase'sdefaultcharactersettotheclient"scharactersetonSELECToperations,andtotrans
4、literatefromaclientapplication?scharactersettothedatabasecharactersetonINSERTandUPDATEoperations.gCONNECTopensadatabase,allocatessystemresourcesforit,andoptionallyassignsoperationalparametersforthedatabase.Alldatabasesmustbeclosedbeforeaprogramends.Adatabasecanbec
5、losedbyusingDISCONNECT,orbyappendingtheRELEASEoptiontothefinalCOMMITorROLLBACKinaprogram.DeclaringadatabaseBeforeadatabasecanbeopenedandusedinaprogram,itmustfirstbedeclaredwithSETDATABASEto:CHAPTER3WORKINGWITHDATABASES.Establishadatabasehandle.Associatethedatabase
6、handlewithadatabasefilestoredonalocalorremotenode.Adatabasehandleisaunique,abbreviatedaliasforanactualdatabasename.DatabasehandlesareusedinsubsequentCONNECT,COMMITRELEASE,andROLLBACKRELEASEstatementstospecifywhichdatabasestheyshouldaffect.ExceptindynamicSQL(DSQL)a
7、pplications,databasehandlescanalsobeusedinsidetransactionblockstoqualify,ordifferentiate,tablenameswhentwoormoreopendatabasescontainidenticallynamedtables.Eachdatabasehandlemustbeuniqueamongallvariablesusedinaprogram.Databasehandlescannotduplicatehost-languagerese
8、rvedwords,andcannotbeInterBasereservedwords.Thefollowingstatementillustratesasimpledatabasedeclaration:EXECSQLSETDATABASEDB1='employee.gdb';Thisdatabase