一 EmployeeDao
package org.fkit.hrm.dao;
import java.util.List;
import java.util.Map;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.One;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.SelectProvider;
import org.apache.ibatis.mapping.FetchType;
import org.fkit.hrm.dao.provider.EmployeeDynaSqlProvider;
import org.fkit.hrm.domain.Employee;
import static org.fkit.hrm.util.common.HrmConstants.EMPLOYEETABLE;
public interface EmployeeDao {
// 根据参数查询员工总数
@SelectProvider(type=EmployeeDynaSqlProvider.class,method="count")
Integer count(Map<String, Object> params);
// 根据参数动态查询员工
@SelectProvider(type=EmployeeDynaSqlProvider.class,method="selectWhitParam")
@Results({
@Result(id=true,column="id",property="id"),
@Result(column="CARD_ID",property="cardId"),
@Result(column="POST_CODE",property="postCode"),
@Result(column="QQ_NUM",property="qqNum"),
@Result(column="BIRTHDAY",property="birthday",javaType=java.util.Date.class),
@Result(column="CREATE_DATE",property="createDate",javaType=java.util.Date.class),
@Result(column="DEPT_ID",property="dept",
one=@One(select="org.fkit.hrm.dao.DeptDao.selectById",
fetchType=FetchType.EAGER)),
@Result(column="JOB_ID",property="job",
one=@One(select="org.fkit.hrm.dao.JobDao.selectById",
fetchType=FetchType.EAGER))
})
List<Employee> selectByPage(Map<String, Object> params);
// 动态插入员工
@SelectProvider(type=EmployeeDynaSqlProvider.class,method="insertEmployee")
void save(Employee employee);
// 根据id删除员工
@Delete(" delete from "+EMPLOYEETABLE+" where id = #{id} ")
void deleteById(Integer id);
// 根据id查询员工
@Select("select * from "+EMPLOYEETABLE+" where ID = #{id}")
@Results({
@Result(id=true,column="id",property="id"),
@Result(column="CARD_ID",property="cardId"),
@Result(column="POST_CODE",property="postCode"),
@Result(column="QQ_NUM",property="qqNum"),
@Result(column="BIRTHDAY",property="birthday",javaType=java.util.Date.class),
@Result(column="CREATE_DATE",property="createDate",javaType=java.util.Date.class),
@Result(column="DEPT_ID",property="dept",
one=@One(select="org.fkit.hrm.dao.DeptDao.selectById",
fetchType=FetchType.EAGER)),
@Result(column="JOB_ID",property="job",
one=@One(select="org.fkit.hrm.dao.JobDao.selectById",
fetchType=FetchType.EAGER))
})
Employee selectById(Integer id);
// 动态修改员工
@SelectProvider(type=EmployeeDynaSqlProvider.class,method="updateEmployee")
void update(Employee employee);
}
二 EmployeeDynaSqlProvider
package org.fkit.hrm.dao.provider;
import java.util.Map;
import org.apache.ibatis.jdbc.SQL;
import org.fkit.hrm.domain.Dept;
import static org.fkit.hrm.util.common.HrmConstants.DEPTTABLE;
public class DeptDynaSqlProvider {
// 分页动态查询
public String selectWhitParam(Map<String, Object> params){
String sql = new SQL(){
{
SELECT("*");
FROM(DEPTTABLE);
if(params.get("dept") != null){
Dept dept = (Dept) params.get("dept");
if(dept.getName() != null && !dept.getName().equals("")){
WHERE(" name LIKE CONCAT ('%',#{dept.name},'%') ");
}
}
}
}.toString();
if(params.get("pageModel") != null){
sql += " limit #{pageModel.firstLimitParam} , #{pageModel.pageSize} ";
}
return sql;
}
// 动态查询总数量
public String count(Map<String, Object> params){
return new SQL(){
{
SELECT("count(*)");
FROM(DEPTTABLE);
if(params.get("dept") != null){
Dept dept = (Dept) params.get("dept");
if(dept.getName() != null && !dept.getName().equals("")){
WHERE(" name LIKE CONCAT ('%',#{dept.name},'%') ");
}
}
}
}.toString();
}
// 动态插入
public String insertDept(Dept dept){
return new SQL(){
{
INSERT_INTO(DEPTTABLE);
if(dept.getName() != null && !dept.getName().equals("")){
VALUES("name", "#{name}");
}
if(dept.getRemark() != null && !dept.getRemark().equals("")){
VALUES("remark", "#{remark}");
}
}
}.toString();
}
// 动态更新
public String updateDept(Dept dept){
return new SQL(){
{
UPDATE(DEPTTABLE);
if(dept.getName() != null){
SET(" name = #{name} ");
}
if(dept.getRemark() != null){
SET(" remark = #{remark} ");
}
WHERE(" id = #{id} ");
}
}.toString();
}
}