JDBC-Service

//사용자요청 --> Controller --> Service --> Dao --> DB
//DB 관련 없는 업무로직은 Service 에서 수행

public class EmpService {

	EmpDAO empDAO = new EmpDAO();
	
	public List<EmpDTO> SelectAllService() {
		
		
		return empDAO.selectAll();
	}

	public EmpDTO selectByIdService(int empid) {
		
		return empDAO.selectById(empid);
		
		
	}
	
	public int insertService(EmpDTO emp) {
		return empDAO.insert(emp);
	}
	
	public int updateService(EmpDTO emp) {
		return empDAO.update(emp);
	}
	
	public int deleteService(int empid) {
		return empDAO.delete(empid);
	}
	public List<EmpDTO> selectByDeptId(int deptid) {
		
		return empDAO.selectByDeptId(deptid);
		
		
	}
public List<EmpDTO> selectByJobId(String jobid) {
		
		return empDAO.selectByJobId(jobid);
		
		
	}
public List<EmpDTO> selectByEmpSalId(double salary) {
	
	return empDAO.selectBySalId(salary);
	
	
}
//여러개의 조건 의경우
public List<EmpDTO> selectByFour(Map<String , Object> empFourList) {
	
	return empDAO.selectByFour(empFourList);
	
	
}
	
}