org.FastData.Spring

 //service aop
 @FastServiceAop(aopType = emr.doctor.Handler.FastServiceAop.class) 
 @FastData(key = "test",cachePackageName = "com.example.Entity" ,
 codeFirstPackageName="com.example.Entity", servicePackageName = "com.example.Service",aopType=FastDataAop.class)
 key is database key 
 codeFirstPackageName is code first model
 cachePackageName is cache model
 servicePackageName is interface Service

//fastdata aop
public class FastDataAop implements IFastDataAop {
 @Override
 public void before(BeforeContext beforeContext) {
 System.out.println("before:" + beforeContext.getSql());
 }
 @Override
 public void after(AfterContext afterContext) {
 System.out.println("after:" + afterContext.getSql());
 }
 @Override
 public void mapBefore(MapBeforeContext mapBeforeContext) {
 System.out.println("mapBefore:" + mapBeforeContext.getMapName());
 }
 @Override
 public void mapAfter(MapAfterContext mapAfterContext) {
 System.out.println("mapAfter:" + mapAfterContext.getMapName());
 }
 @Override
 public void exception(ExceptionContext exceptionContext) {
 System.out.println("exception:" + exceptionContext.getName());
 }
}
//service aop
public class FastServiceAop implements IFastServiceAop {
 @Override
 public void before(BeforeContext beforeContext) { 
 beforeContext.setReturn(true);
 beforeContext.setResult("test");
 }
 @Override
 public void after(AfterContext afterContext) {
 afterContext.setResult("test");
 }
 @Override
 public void exception(ExceptionContext exceptionContext) {
 afterContext.setResult("test");
 }
}
//service aop
public interface IUserService {}
public class UserService implements IUserService{}
IUserService userService = (IUserService)new FastServiceProxy().invoke(UserService.class);

public interface TestService {
 @FastRead(sql = "select * from base_user where id=?id and orgid=?orgid",dbKey = "test")
 Map<String,Object> map(String id,String orgid);
 //Map<String,Object> map(base_user model);
 //Map<String,Object> map(Map<String,Object> map);
 @FastRead(sql = "select * from base_user where id=?id and orgid=?orgid",dbKey = "test")
 TestTable model(String id,String orgid);
 // or TestTable map(base_user model);
 // or TestTable map(Map<String,Object> map);
 @FastRead(sql = "select * from base_user where id=?id and orgid=?orgid",dbKey = "test")
 List<Map<String,Object>> listMap(StringidGH,String orgid);
 // or List<Map<String,Object>> listMap(base_user model);
 // or List<Map<String,Object>> listMap(Map<String,Object> map);
 @FastRead(sql = "select * from base_user where id=?id and orgid=?orgid",dbKey = "test")
 List<TestTable> listModel(String id,String orgid);
 // or List<TestTable> listModel(base_user model);
 // or List<TestTable> listModel(Map<String,Object> map);
 @FastWrite(sql = "update base_user set name=?name where id=?id",dbKey = "test")
 WriteReturn update(String name,String id);
 // or WriteReturn update(base_user model);
 // or WriteReturn update(Map<String,Object> map);
 
 @FastRead(sql = "select * from base_user where id=?id and orgid=?orgid",dbKey = "test",isPage = true,pageType = TestTable.class)
 PageResultImpl page1(PageModel pageModel, Map<String,Object> map);
 
 @FastRead(sql = "select * from base_user where id=?id and orgid=?orgid",dbKey = "test",isPage = true)
 PageResult page2(PageModel pageModel, Map<String,Object> map);
 
 FastXml(dbKey = "test", xml = {"<select>select a.DNAME, a.GH, a.DID from TestResult a where rownum &lt;= 15",
 "<dynamic prepend=' '>",
 "<isNotNullOrEmpty prepend=' and ' property='userName'>userName=?userName'</isNotNullOrEmpty>",
 "<isNotNullOrEmpty prepend=' and ' property='userId'>userId=?userId</isNotNullOrEmpty>",
 "</dynamic>",
 "order by a.REGISTDATE</select>"},isPage =true)
 PageResult read_MapPage(PageModel page ,Map<String, Object> item);
 
 @FastXml(dbKey = "test", xml = {"<select>select a.DNAME, a.GH, a.DID from TestResult a where rownum &lt;= 15",
 "<dynamic prepend=' '>",
 "<isNotNullOrEmpty prepend=' and ' property='userName'>userName=?userName'</isNotNullOrEmpty>",
 "<isNotNullOrEmpty prepend=' and ' property='userId'>userId=?userId</isNotNullOrEmpty>",
 "</dynamic>",
 "order by a.REGISTDATE</select>"})
 List<TestResult> read_Map(Map<String, Object> item);
}
@Resource
TestService test;
//or
var test = (TestService) iFastRepository.resolve(TestService.class, AppSeting.Key);
var param =new HashMap<String,Object>();
param.put("gh","admin");
param.put("kid",101);
var page=new PageModel();
page.setPageSize(10);
var model = test.model("admin", "101");
var map = test.map("amdin", "101");
var listMap = test.listMap("admin", "101");
var listModel = test.listModel("admin", "101");
var update = test.update("管理员", "admin", "101");
var page1 = (PageResultImpl<TestTable>)test.page1(page,param);
var page2 = test.page2(page,param);
var pageMap1 = test.read_MapPage(page,model); 
var pageMap2 = test.read_Map(model);

import Column;
import Table;
@Table(comments = "测试")
@FieldNameConstants
@Data
public class TestTable {
 @Column(isKey = true,dataType = "NVARCHAR2",length = 15,isNull = true,comments = "id")
 private String Id;
 @Column(dataType = "NUMBER",isNull = true,comments = "value")
 private Number value;
 
 @NavigateType(type = TestTable_List.class,isAdd = true,isDelete = true,isUpdate = true) //add,update by PrimaryKey,delete by PrimaryKey
 private TestTable_List list;
}
@Data
public class TestTable_List
{
 @Navigate(Name = TestTable.Fields.Id)
 private String Id;
 private Number value;
}
//@NavigateType @Navigate 导航属性
 var model = new TestTable();
 model.setId("1");
 var list = (TestTable)ifast.queryKey(model,TestTable.class,"db");
 ifast.add(model,"db");//add table TestTable and TestTable_List
 ifast.updateKey(model,"db"); //update by key table TestTable and TestTable_List
 ifast.deleteKey(model,"db"); //delete by key table TestTable and TestTable_List

 { 
 "dataConfig": [
 {
 "providerName": "oracle.jdbc.OracleDriver",
 "dbType": "Oracle",
 "user": "user",
 "passWord": "pwd",
 "connStr": "jdbc:oracle:thin:@127.0.0.1/data",
 "isOutSql": true,
 "isOutError": true,
 "key": "test",
 "designModel": "CodeFirst",
 "poolSize":50
 }
 ]
}

"SqlMap" :{"Path": [ "map/admin/Api.xml", "map/admin/Area.xml"]}

 <?xml version="1.0" encoding="utf-8" ?>
 <sqlMap>
 <select id="GetUser" log="true" db="test">
 select a.* from base_user a
 <dynamic prepend=" where 1=1">
 <isPropertyAvailable prepend=" and " property="userId">a.userId=?userId</isPropertyAvailable> 
 <isNotNullOrEmpty prepend=" and " property="isAdmin">a.isAdmin=?isAdmin</isNotNullOrEmpty>
 <if condition="areaId>8" prepend=" and " property="areaId">a.areaId=?areaId</if> 
 <choose property="userNo">
 <condition prepend=" and " property="userNo>5">a.userNo=?userNo and a.userNo=5</condition> 
 <condition prepend=" and " property="userNo>6">a.userNo=?userNo and a.userNo=6</condition>
 <other prepend=" and ">a.userNo=?userNo and a.userNo=7</other>
 </choose> 
 </dynamic>
 </select>
 
 <update id="test.Update">
 update base_user set
 <dynamic ltrim="," prepend =" ">
 <isNotNullOrEmpty prepend=" " property="Name">,name=?Name</isNotNullOrEmpty>
 <isNotNullOrEmpty prepend=" " property="Age">,age=?Age</isNotNullOrEmpty>
 <isNotNullOrEmpty prepend=" " property="Id" required="true">where id=?id</isNotNullOrEmpty>
 </dynamic>
 </update>
 </sqlMap>
 

in Interceptor
@Resource	
private org.FastData.Spring.Handler.FastApiInterceptor fastApiInterceptor;
registry.addInterceptor(this.fastApiInterceptor) is dyn http api 
 
http://127.0.0.1:8080/GetUser?userId=1

 @Resource
 IFastRepository iFast;
//database write sql param must ?name,dtabase read sql param only ?
 try (var db = new DataContext("db")) {
 var query = new HashMap<String, Object>();
 query.put("Id", "00010162");
 query.put("Name", "中1国");
 var data1 = ifast.queryMap("TestTable.info", query, db);
 var data2 = ifast.queryMap("table.info", query, TestTable.class, db);
 var pmodel = new PageModel();
 var pageList1 = ifast.pageMap(pmodel, "TestTable.info", query, db);
 var pageList2 = ifast.pageMap(pmodel, "TestTable.info", query, TestTable.class, db);
 var count = ifast.read(BASE_USER.class)).eq(BASE_USER::getORGID,1224).orderBy(BASE_USER::getORGID,true).toCount("db");
 var item = ifast.read(BASE_USER.class)).eq(BASE_USER::getORGID,1224).orderBy(BASE_USER::getORGID,true).toItem("db");
 var list = ifast.read(BASE_USER.class)).eq(BASE_USER::getORGID,1224).orderBy(BASE_USER::getORGID,true).toList("db");
 var page = ifast.read(BASE_USER.class)).eq(BASE_USER::getORGID,1224).orderBy(BASE_USER::getORGID,true).toPage(pmodel,"db"); 
 var update = ifast.write(BASE_USER.class)).eq(BASE_USER::getORGID,1224).set(BASE_USER::getORGID,111).toUpdate("db");
 var delete = ifast.write(BASE_USER.class)).eq(BASE_USER::getORGID,1224).toDelete("db");
 var field = new ArrayList<String>();
 field.add("Value");
 var update = ifast.updateKey(model, field, db);
 var del = ifast.deleteKey(model, db);
 
 db.beginTrans();
 db.submitTrans();
 db.rollbackTrans();
 }