forked from jeecgboot/MiniDao
-
Notifications
You must be signed in to change notification settings - Fork 0
Commit
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
- Loading branch information
Showing
70 changed files
with
4,003 additions
and
3,731 deletions.
There are no files selected for viewing
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Original file line number | Diff line number | Diff line change |
|---|---|---|
| @@ -1,93 +1,93 @@ | ||
| MiniDao | ||
| ======= | ||
|
|
||
|
|
||
| MiniDao简介及特征 | ||
|
|
||
| MiniDao是Jeecg自己的持久化解决方案，集成了Hibernate实体维护和Mybaits SQL分离的两大优势。 具有以下特征: | ||
|
|
||
| * 1.O/R mapping不用设置xml，零配置便于维护 | ||
| * 2.不需要了解JDBC的知识 | ||
| * 3.SQL语句和java代码的分离 | ||
| * 4.可以自动生成SQL语句 | ||
| * 5.接口和实现分离，不用写持久层代码，用户只需写接口，以及某些接口方法对应的sql 它会通过AOP自动生成实现类 | ||
| * 6.支持自动事务处理和手动事务处理 | ||
| * 7.支持与hibernate轻量级无缝集成 | ||
| * 8.MiniDao整合了Hibernate+mybatis的两大优势，支持实体维护和SQL分离 | ||
| * 9.SQL支持脚本语言 | ||
|
|
||
| ※向下兼容Hibernate实体维护方式,实体的增删改查SQL自动生成 | ||
|
|
||
|
|
||
|
|
||
|
|
||
| ###接口和SQL文件对应目录 | ||
|  | ||
|
|
||
|
|
||
|
|
||
| ### 接口定义[EmployeeDao.java] | ||
|
|
||
| public interface EmployeeDao { | ||
| @Arguments("employee") | ||
| public List<Map> getAllEmployees(Employee employee); | ||
|
|
||
| @Arguments("empno") | ||
| Employee getEmployee(String empno); | ||
|
|
||
| @Arguments({"empno","name"}) | ||
| Map getMap(String empno,String name); | ||
|
|
||
| @Sql("SELECT count(*) FROM employee") | ||
| Integer getCount(); | ||
|
|
||
| @Arguments("employee") | ||
| int update(Employee employee); | ||
|
|
||
| @Arguments("employee") | ||
| void insert(Employee employee); | ||
| } | ||
|
|
||
|
|
||
|
|
||
| ### SQL文件[EmployeeDao_getAllEmployees.sql] | ||
| SELECT * FROM employee where 1=1 | ||
| <#if employee.age ?exists> | ||
| and age = '${employee.age}' | ||
| </#if> | ||
| <#if employee.name ?exists> | ||
| and name = '${employee.name}' | ||
| </#if> | ||
| <#if employee.empno ?exists> | ||
| and empno = '${employee.empno}' | ||
| </#if> | ||
|
|
||
|
|
||
|
|
||
| ### 测试代码 | ||
| public class Client { | ||
| public static void main(String args[]) { | ||
| BeanFactory factory = new ClassPathXmlApplicationContext( | ||
| "applicationContext.xml"); | ||
| EmployeeDao employeeDao = (EmployeeDao) factory.getBean("employeeDao"); | ||
| Employee employee = new Employee(); | ||
| List<Map> list = employeeDao.getAllEmployees(employee); | ||
| for(Map mp:list){ | ||
| System.out.println(mp.get("id")); | ||
| System.out.println(mp.get("name")); | ||
| System.out.println(mp.get("empno")); | ||
| System.out.println(mp.get("age")); | ||
| System.out.println(mp.get("birthday")); | ||
| System.out.println(mp.get("salary")); | ||
| } | ||
| } | ||
| } | ||
|
|
||
|
|
||
| 技术交流 | ||
| ----------------------------------- | ||
| * 作者： 张代浩 | ||
| * 技术论坛：[www.jeecg.org](http://www.jeecg.org) | ||
| * 邮箱： zhangdaiscott@163.com | ||
| * 交流群：325978980，143858350 | ||
| MiniDao | ||
| ======= | ||
|
|
||
|
|
||
| MiniDao简介及特征 | ||
|
|
||
| MiniDao是Jeecg自己的持久化解决方案，集成了Hibernate实体维护和Mybaits SQL分离的两大优势。 具有以下特征: | ||
|
|
||
| * 1.O/R mapping不用设置xml，零配置便于维护 | ||
| * 2.不需要了解JDBC的知识 | ||
| * 3.SQL语句和java代码的分离 | ||
| * 4.可以自动生成SQL语句 | ||
| * 5.接口和实现分离，不用写持久层代码，用户只需写接口，以及某些接口方法对应的sql 它会通过AOP自动生成实现类 | ||
| * 6.支持自动事务处理和手动事务处理 | ||
| * 7.支持与hibernate轻量级无缝集成 | ||
| * 8.MiniDao整合了Hibernate+mybatis的两大优势，支持实体维护和SQL分离 | ||
| * 9.SQL支持脚本语言 | ||
|
|
||
| ※向下兼容Hibernate实体维护方式,实体的增删改查SQL自动生成 | ||
|
|
||
|
|
||
|
|
||
|
|
||
| ###接口和SQL文件对应目录 | ||
|  | ||
|
|
||
|
|
||
|
|
||
| ### 接口定义[EmployeeDao.java] | ||
|
|
||
| public interface EmployeeDao { | ||
| @Arguments("employee") | ||
| public List<Map> getAllEmployees(Employee employee); | ||
|
|
||
| @Arguments("empno") | ||
| Employee getEmployee(String empno); | ||
|
|
||
| @Arguments({"empno","name"}) | ||
| Map getMap(String empno,String name); | ||
|
|
||
| @Sql("SELECT count(*) FROM employee") | ||
| Integer getCount(); | ||
|
|
||
| @Arguments("employee") | ||
| int update(Employee employee); | ||
|
|
||
| @Arguments("employee") | ||
| void insert(Employee employee); | ||
| } | ||
|
|
||
|
|
||
|
|
||
| ### SQL文件[EmployeeDao_getAllEmployees.sql] | ||
| SELECT * FROM employee where 1=1 | ||
| <#if employee.age ?exists> | ||
| and age = '${employee.age}' | ||
| </#if> | ||
| <#if employee.name ?exists> | ||
| and name = '${employee.name}' | ||
| </#if> | ||
| <#if employee.empno ?exists> | ||
| and empno = '${employee.empno}' | ||
| </#if> | ||
|
|
||
|
|
||
|
|
||
| ### 测试代码 | ||
| public class Client { | ||
| public static void main(String args[]) { | ||
| BeanFactory factory = new ClassPathXmlApplicationContext( | ||
| "applicationContext.xml"); | ||
| EmployeeDao employeeDao = (EmployeeDao) factory.getBean("employeeDao"); | ||
| Employee employee = new Employee(); | ||
| List<Map> list = employeeDao.getAllEmployees(employee); | ||
| for(Map mp:list){ | ||
| System.out.println(mp.get("id")); | ||
| System.out.println(mp.get("name")); | ||
| System.out.println(mp.get("empno")); | ||
| System.out.println(mp.get("age")); | ||
| System.out.println(mp.get("birthday")); | ||
| System.out.println(mp.get("salary")); | ||
| } | ||
| } | ||
| } | ||
|
|
||
|
|
||
| 技术交流 | ||
| ----------------------------------- | ||
| * 作者： 张代浩 | ||
| * 技术论坛：[www.jeecg.org](http://www.jeecg.org) | ||
| * 邮箱： zhangdaiscott@163.com | ||
| * 交流群：325978980，143858350 |
Oops, something went wrong.