bbossgroups 31SQLEecutor组件ap使用实例.docx

Java代码bbossgroups3.1SQLExecutor组件api使用实例

Java代码

1./*

2. * Copyright2008biaoping.yin3. *

* LicensedundertheApacheLicense,Version2.0(theLicense);

* youmaynotusethisfileexceptincompliancewiththeLicense.

* YoumayobtainacopyoftheLicenseat7. *

8. * /licenses/LICENSE-2.09. *

* Unlessrequiredbyapplicablelaworagreedtoinwriting,software

* distributedundertheLicenseisdistributedonanASISBASIS,

* WITHOUTWARRANTIESORCONDITIONSOFANYKIND,eitherexpressorimplied.

* SeetheLicenseforthespecificlanguagegoverningpermissionsand

* limitationsundertheLicense.15.*/

16.packageorg.frameworkset.spi.mvc;17.

18.importjava.sql.SQLException;19.importjava.util.ArrayList;20.importjava.util.List;

21.

22.importorg.junit.Test;23.

24.importmon.poolman.Record;25.importmon.poolman.SQLExecutor;

importmon.poolman.handle.NullRowHandler;

importmon.poolman.handle.RowHandler;28.importcom.frameworkset.util.ListInfo;

29.

publicclassSimpleApiTest{

@Test

publicvoidinsertOpera()throwsSQLException

33. {

ListBeanlb=newListBean();

lb.setFieldLable(tttt);

lb.setFieldName(testttt);

lb.setFieldType(int);

lb.setIsprimaryKey(false);

lb.setRequired(true);

lb.setSortorder(ppp);

lb.setFieldLength(20);

lb.setIsvalidated(6);43.

//用List存放Bean，在某特定的连接池中进行crud操作

ListListBeanbeans=newArrayListListBean();

beans.add(lb);47.

Stringsql=insertintoLISTBEAN(ID,FIELDNAME,FIELDLABLE,FIELDTYPE,SORTORDER,ISPRIMARYKEY,REQUIRED,FIELDLENGTH,ISVALIDATED)+

values(#[id],#[fieldName],#[fieldLable],#[fieldType],#[sortorder],+

#[isprimaryKey],#[required],#[fieldLength],#[isvalidated]);

SQLExecutor.insertBeans(mysql,sql,beans);52.

53.

54.

55. SQLExecutor.insertBean(mysql,sql,lb);56.

57. SQLExecutor.insertBeans(mysql,sql,beans);58.

59.

60.

61. SQLExecutor.insertBean(sql,lb);62.

63.

64.

65.sql=insertintoLISTBEAN(ID,FIELDNAME,FIELDLABLE,FIELDTYPE)+

66. values(?,?,?,?);

67.// SQLExecutor.insert(sql,122,