MiniDao 比Mybatis还灵活实用的J2EE 持久层轻量级解决方案

接口定义[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邮箱： zhangdaiscott@163.com交流群：325978980，143858350