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接口配置
<!-- 注册MiniDao接口 -->
<bean class="org.jeecgframework.minidao.factory.MiniDaoBeanFactory">
<property name="packagesToScan">
<list>
<value>examples.dao.*</value>
</list>
</property>
</bean>
测试代码
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"));
}
}
}
评论