| | |
| | | </resultMap> |
| | | |
| | | <select id="query" resultMap="WeatherResult"> |
| | | select * from weather |
| | | select * from yssh_weather |
| | | <where> |
| | | <if test="begin != null and begin != ''"> |
| | | and Time >= #{begin} |
| | |
| | | </select> |
| | | |
| | | <select id="getAll" resultMap="WeatherResult"> |
| | | select * from weather |
| | | select * from yssh_weather |
| | | </select> |
| | | |
| | | <insert id="insert" parameterType="com.yssh.entity.Weather"> |
| | | insert into weather ( |
| | | insert into yssh_weather ( |
| | | time, wind_speed, wind_direction, weather_condition, temperature |
| | | ) |
| | | values ( |
| | |
| | | ) |
| | | </insert> |
| | | <delete id="delete"> |
| | | delete from weather where id = #{id} |
| | | delete from yssh_weather where id = #{id} |
| | | </delete> |
| | | </mapper> |