MiniDao-PE精简版

MiniDao-PE 简介及特征

MiniDao-PE 是一种持久化解决方案，类似mybatis的持久层解决方案，可以轻松集成入Hibernate工程，事务统一管理，解决了Hibernate工程想支类mybaits的功能问题。具有以下特征:

1.O/R mapping不用设置xml，零配置便于维护

2.不需要了解JDBC的知识

3.SQL语句和java代码的分离

4.接口和实现分离，不用写持久层代码，用户只需写接口，以及某些接口方法对应的sql 它会通过AOP自动生成实现类

5.支持自动事务处理和手动事务处理

6.支持与hibernate轻量级无缝集成

7.SQL支持脚本语言

接口和SQL文件对应目录

接口定义[EmployeeDao.java]

@MiniDaopublic interface EmployeeDao { @Arguments("employee") public List 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 employee.name ?exists>and name = :employee.name
    <#if employee.empno ?exists>and empno = :employee.empno

MiniDao接口配置


    
        
             
                  
       
        examples.dao.*

测试代码

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 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"));    }}}