命名SQL
命名SQL定义在app/sqls
目录中。
Example :
创建app/sqls/demo.sql
文件:
#selectOneFromDual
select 1 from dual;
#cascadeDeleteOrg
--delete the user(s) in the org first.
delete from user where user.orgId = :id;
--now we can safe delete the org.
delete from org where id = :id;
在这个文件里定义了两个SQL命令,产生的key是:
demo.selectOneFromdual
demo.cascadeDeleteOrg
在数据访问代码中可以通过上面的key
执行SQL。