service中:
List<Map<String, Object>> DataCompare(Map<String, Object> map);
mapper中:
<select id="DataCompare" parameterType="java.util.Map" resultType="java.util.Map" statementType="CALLABLE"> {call DataCompare(#{AreaCode,mode=IN,jdbcType=VARCHAR},#{AreaUnits,mode=IN,jdbcType=VARCHAR}, #{BeginTime,mode=IN,jdbcType=VARCHAR},#{EndTime,mode=IN,jdbcType=VARCHAR})} </select>
java中调用:
Map<String, Object> map = new HashMap<>(); map.put("AreaCode",areacode); map.put("AreaUnits",areaunits); map.put("BeginTime",begindate); map.put("EndTime",enddate); tStationInfoMapper.DataCompare(map);