| | |
| | | * @return |
| | | */ |
| | | @GetMapping("/yuc") |
| | | public R yuc(String addvcd, String time, String intv) throws ParseException { |
| | | List<Yucpptn> yucpptnList = new ArrayList<Yucpptn>(); |
| | | public R yuc(String addvcd, String time, String intv,String drp) throws ParseException { |
| | | List yucpptnList = new ArrayList<>(); |
| | | //通过行政区查询站点编码 |
| | | List<Map<String, Object>> list = mountainrainService.selectAddvcd(addvcd); |
| | | for (int i = 0; i < list.size(); i++) { |
| | |
| | | //站点编码 |
| | | String stcd = list.get(i).get("STCD").toString(); |
| | | yucpptn.setSTCD(stcd); |
| | | DateFormat sf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); |
| | | Date date = sf.parse(time); |
| | | java.sql.Date sqlDate = new java.sql.Date(date.getTime()); |
| | | yucpptn.setTM(time); |
| | | yucpptn.setDRP(drp); |
| | | yucpptn.setINTV(intv); |
| | | yucpptnList.add(yucpptn); |
| | | } |
| | |
| | | * 时间 |
| | | */ |
| | | @ApiModelProperty(value = "时间") |
| | | @JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8") |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss" ) |
| | | private Date TM; |
| | | private String TM; |
| | | |
| | | /** |
| | | * 时段降水量 |
| | |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.springblade.modules.mountainrain.entity.Mountainrain; |
| | | import org.springblade.modules.mountainrain.entity.Yucpptn; |
| | | import org.springblade.modules.mountainrain.vo.*; |
| | |
| | | void soildel(); |
| | | |
| | | //预报信息新增 |
| | | int insertYuc(List<Yucpptn> yucpptnList); |
| | | int insertYuc(@Param("list") List<Yucpptn> list); |
| | | } |
| | |
| | | <!-- 批量插入预报信息--> |
| | | <insert id ="insertYuc" parameterType="java.util.List" > |
| | | insert into sys_yucpptn |
| | | (STCD, TM, DRP, INTV) |
| | | (STCD,TM,DRP,INTV) |
| | | values |
| | | <foreach collection ="list" item="reddemCode" index= "index" separator =","> |
| | | <foreach collection ="list" item="item" index= "index" separator =","> |
| | | ( |
| | | #{reddemCode.STCD}, #{reddemCode.TM}, |
| | | #{reddemCode.DRP}, |
| | | #{reddemCode.INTV} |
| | | #{item.STCD},#{item.TM}, |
| | | #{item.DRP}, |
| | | #{item.INTV} |
| | | ) |
| | | </foreach > |
| | | </insert > |
| | |
| | | |
| | | @Override |
| | | public int insertYuc(List<Yucpptn> yucpptnList) { |
| | | return 0; |
| | | return baseMapper.insertYuc(yucpptnList); |
| | | } |
| | | |
| | | |