/*

• 오라클 employees 전체 조회 */

@Override public List<Map> selectEmployeesBasic(Map param) { return sampleDao.selectEmployeesBasic(param); }

// 오라클 employees 특정 상세 조회 — 이거 필요 없다!!! @Override public List<Map> selectEmployeesNameId(Map param) { return sampleDao.selectEmployeesNameId(param); }

=====================================

매퍼네. 쿼리. 매퍼는 쿼리.

<select id="selectEmployeesBasic" resultType="Map" parameterType="Map"> SELECT EMPL_ID, FULL_NAME, HIRE_DATE, MARRIED, SALARY, GENDER, DEPT_ID, EMPL_MEMO FROM employees <where> <if test="combobox == 'FULL_NAME' and text1 != null and text1 !=''"> AND FULL_NAME LIKE CONCAT('%', #{text1}, '%') </if>

<if test="combobox == 'EMPL_ID' and text1 != null and text1 != ''"> AND EMPL_ID LIKE CONCAT('%', #{text1}, '%') </if> </where>

ORDER BY EMPL_ID

</select>

==============================================

스크립트

scwin.bt_search_onclick = function(e) { var type = combobox.getValue(); var contents = text1.getValue();

dma_dataMap1.set("combobox", type); // 콤보박스 값 dma_dataMap1.set("text1", contents); // 검색어 값

$p.executeSubmission(overall_search);

};

========================================

// 오라클 employees 전체 조회 @RequestMapping("/sample/searchEmployeesBasic") public @ResponseBody Map<String, Object> searchEmployeesBasic(@RequestBody Map<String, Object> param) { Result result = new Result(); try { result.setData("dlt_dataList1", sampleService.selectEmployeesBasic((Map) param.get("dma_dataMap1"))); result.setStatusMsg(result.STATUS_SUCESS, "인시기본관리 리스트가 조회되었습니다."); } catch (Exception ex) { ex.printStackTrace(); result.setMsg(result.STATUS_ERROR, "인사기본관리 리스트를 가져오는 도중 오류가 발생하였습니다."); } return result.getResult(); }