【正文】 getFirstSqlResultValue() index, intindex, intbooleanisSuccess()返回操作是否成功Retruns:boolean7．樣例程序　本樣例程序主要是針對數(shù)據(jù)庫中的一張名為＂studenttest＂表進行增，刪，改，查以及對CLOB的操作，對事務(wù)的操作等．將配置文件保存為E:\,源文件放到j(luò)builder中就可以運行．下面介紹一下表結(jié)構(gòu)：　表主要有以下幾個字段：XH號),NAME,SEX）,ADDRESS（語文）,SX學(xué)）,YY英語）,PY語）．其中PY為CLOB字段．表創(chuàng)建語句為：CREATE TABLE STUDENTTEST(XH VARCHAR2(10) NOT NULL,NAME VARCHAR2(10) NOT NULL, SEX VARCHAR2(2), AGE NUMBER(2),ADDRESS VARCHAR2(100) ,YW NUMBER(2),SX NUMBER(2), YY NUMBER(2),PY CLOB,PRIMARY KEY(XH))．配置文檔?xml version= encoding=GBK?ROOT DATABASE dbcharset= appcharset= NAMEJdlsPool/NAME CONNECT_CHANNELjdbc/CONNECT_CHANNEL! [jdbc,appserver,jdls] DRIVER/DRIVER URLjdbc:oracle:thin::1521:jdlsdy/URL USERjdls/USER PASSWORD123/PASSWORD DATA_SOURCEjdls/DATA_SOURCE JDLS_CONNECTION_POOLJdlsPool/JDLS_CONNECTION_POOL DESCRIPTION/DESCRIPTION /DATABASE TASK NAMEselectTest/NAME DATABASE_NAMEJdlsPool/DATABASE_NAME TYPEselect/TYPE BATCHfalse/BATCH TRANSACTIONfalse/TRANSACTION EXECUTOR/EXECUTOR DESCRIPTION樣例程序的查看測試/DESCRIPTION SQL NAMEselectTest/NAME TYPEquery/TYPE ! ure CLAUSEselect xh,name,sex,age,address,yw,sx,yy,py from studenttest where xh=?/CLAUSE PARAMETER_TYPE_LIST/PARAMETER_TYPE_LIST DESCRIPTION查看測試/DESCRIPTION /SQL /TASK TASK NAMEinsertTest/NAME DATABASE_NAMEJdlsPool/DATABASE_NAME TYPEinsert/TYPE BATCHfalse/BATCH TRANSACTIONfalse/TRANSACTION EXECUTOR/EXECUTOR DESCRIPTION樣例程序的插入測試/DESCRIPTION SQL NAMEinsertTest/NAME TYPEupdate/TYPE ! ure CLAUSEinsert into studenttest (xh,name,sex,age,address,yw,sx,yy)values(?,?,?,?,?,?,?,?) /CLAUSE PARAMETER_TYPE_LIST/PARAMETER_TYPE_LIST DESCRIPTION插入測試/DESCRIPTION /SQL /TASK TASK NAMEdeleteTest/NAME DATABASE_NAMEJdlsPool/DATABASE_NAME TYPEdelete/TYPE BATCHfalse/BATCH TRANSACTIONfalse/TRANSACTION EXECUTOR/EXECUTOR DESCRIPTION樣例程序的插入測試/DESCRIPTION SQL NAMEdeleteTest/NAME TYPEupdate/TYPE ! ure CLAUSEdelete from studenttest where xh=? /CLAUSE PARAMETER_TYPE_LIST/PARAMETER_TYPE_LIST DESCRIPTION刪除測試/DESCRIPTION /SQL /TASK TASK NAMEupdateTest/NAME DATABASE_NAMEJdlsPool/DATABASE_NAME TYPEupdate/TYPE BATCHfalse/BATCH TRANSACTIONfalse/TRANSACTION EXECUTOR/EXECUTOR DESCRIPTION樣例程序的插入測試/DESCRIPTION SQL NAMEupdateTest/NAME TYPEupdate/TYPE ! ure CLAUSEupdate studenttest set name=? where xh=? /CLAUSE PARAMETER_TYPE_LIST/PARAMETER_TYPE_LIST DESCRIPTION修改測試/DESCRIPTION /SQL /TASK TASK NAMEclobTest/NAME DATABASE_NAMEJdlsPool/DATABASE_NAME TYPEupdate/TYPE BATCHfalse/BATCH TRANSACTIONfalse/TRANSACTION EXECUTOR/EXECUTOR DESCRIPTION樣例程序的CLOB測試/DESCRIPTION SQL NAMEclobTest/NAME TYPEupdate/TYPE ! ure CLAUSE UPDATE_CLAUSEinsert into studenttest (xh,name,sex,age,address,yw,sx,yy,py)values(?,?,?,?,?,?,?,?,?)/UPDATE_CLAUSE SELECT_CLAUSEselect py from studenttest where xh=? for update/SELECT_CLAUSE /CLAUSE PARAMETER_TYPE_LIST [STRING,STRING,STRING,INTEGER,STRING,INTEGER,INTEGER,INTEGER,CLOB,STRING]/PARAMETER_TYPE_LIST DESCRIPTIONCLOB測試/DESCRIPTION /SQL /TASK TASK NAMErepeatTest/NAME DATABASE_NAMEJdlsPool/DATABASE_NAME TYPEinsert/TYPE BATCHflase/BATCH TRANSACTIONfalse/TRANSACTION EXECUTOR/EXECUTOR DESCRIPTIONrepeat插入測試/DESCRIPTION SQL NAMErepeatTest/NAME TYPEupdate/TYPE ! ure CLAUSE repeat=true insert into studenttest(xh,name)values(?,?) /CLAUSE PARAMETER_TYPE_LIST/PARAMETER_TYPE_LIST DESCRIPTION修改測試/DESCRIPTION /SQL /TASK TASK NAMEmultiSqlTest/NAME DATABASE_NAMEJdlsPool/DATABASE_NAME TYPEselect/TYPE BATCHflase/BATCH TRANSACTIONfalse/TRANSACTION EXECUTOR/EXECUTOR DESCRIPTION多SQL測試/DESCRIPTION SQL NAMEmultiSqlTest/NAME TYPEquery/TYPE ! ure CLAUSE select xh,name from studenttest where xh=? /CLAUSE PARAMETER_TYPE_LIST/PARAMETER_TYPE_LIST DESCRIPTION修改測試/DESCRIPTION /SQL SQL NAMEmultiSqlTest/NAME TYPEquery/TYPE ! ure CLAUSE select xh,name,address from studenttest where xh=? /CLAUSE PARAMETER_TYPE_LIST/PARAMETER_TYPE_LIST DESCRIPTION修改測試/DESCRIPTION /SQL /TASK TASK NAMEdataSet/NAME DATABASE_NAMEJdlsPool/DATABASE_NAME TYPEselect/TYPE BATCHfalse/BATCH TRANSACTIONfalse/TRANSACTION EXECUTOR/EXECUTOR DESCRIPTION樣例程序的dataSetandDataRow測試/DESCRIPTION SQL NAMEdataSet/NAME TYPEquery/TYPE ! ure CLAUSEselect xh,name,sex,age,address。col) 獲取第一條SQL的某行某列的結(jié)果Parameters：Row－行，col－列g(shù)etFirstSqlResultFirstCell() taskName, pageParaList(分頁顯示參數(shù)) DAOResultselectByDatabase(taskName, taskName, sqlClause, intcurpage)執(zhí)行SQL語句select分頁操作Parameters: taskName 任務(wù)名稱sqlClause SQL語句page_record－每頁行數(shù)curpage－當(dāng)前頁號DAOResultexecuteSelectSqlClauseByDatabase(param) 執(zhí)行delete業(yè)