Cute Happy Ghost
본문 바로가기
JAVA/Java

java, mybatis resulttype=hashmap, map형태로 데이터 받기

by JENN_tech7 2022. 5. 19.
728x90
SMALL
@Controller
@SuppressWarnings({"all"})
public class DevController extends BaseController {

    @Resource(name="DevService")
    protected DevService devService;
    
    @RequestMapping(value="/dev/downloadExcel.do")
    public void downloadExcel(HttpServletRequest request, HttpServletResponse response,@RequestParam Map<String, Object> paramMap) throws IOException {
    	List<Map<String, Object>>  list = devService.selectDevData(paramMap);	
    	.....
    }

controller

@SuppressWarnings("all")
public interface DevService {

	//데이터 조회
	List selectDevData(Map<String, Object> paramMap);

}

service

@Service("DevService")
@SuppressWarnings({"all"})
public class DevServiceImpl extends BaseService implements DevService {
    @Resource(name = "DevDAO")
    private DevDAO devDAO;

    @Autowired
    private DevService self;

    @Autowired
    protected UserInfo userInfo;


	//데이터 조회
	@Override
	public List selectDevData(Map<String, Object> paramMap) {
		return devDAO.selectDevData(paramMap);
	}

  
}

serviceimpl

@Repository("DevDAO")
public class DevDAO extends BaseDAO {

	public List selectDevData(Map<String, Object> paramMap) {
		return selectList("devDAO.selectDevData", paramMap);
	}
}

dao

	<select id="selectDevData"  resultType="java.util.HashMap" >
   		SELECT 
			msur_info_1101_sn
		   , msur_loc_cd
		   , dev_cd
		   , msur_hour
		   , bacteria
		   , fungi
		   , virus
		   , tmprt
		   , hmdt
		   , TO_CHAR(reg_date, 'YYYY-MM-DD HH24:MI:SS')		AS "reg_date"
   		FROM msur_info_1101 
   		//
    </select>

mapper

728x90
LIST

댓글