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

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