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]

@MiniDao
public interfACE EmployeeDao {
 @Arguments("employee")
 public ListgetAllEmployees(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();
    Listlist =  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"));
    }
}
}