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
'JAVA > Java' 카테고리의 다른 글
java list<map<string,object>>에서 키값 value값 찾기 (0) | 2022.05.24 |
---|---|
java list에서 key값 뽑기, list를 map으로 만들기 (0) | 2022.05.24 |
Restful API 개발 (3) dataType별(json,xml) 출력하기, controller에서 xml json변환하기 (0) | 2022.03.28 |
Restful API 개발 (2) 정보 조회 (0) | 2022.03.25 |
Restful API 개발 (1) 데이터 저장 api개발 및 api테스트 사이트 (0) | 2022.03.25 |
댓글