mybatis和Springmvc系统将数据从数据库传送到前台的总流程

首先映射生成数据库中表对应的mapper和表名相同的java文件和表名后加个Example的java文件后。再创建一个表名+service和一个页面名+controller 的java文件。

首先在Mapper中

<select id="queryComplianIndexLastMinute" parameterType="java.util.Map" resultType="java.util.Map">
  select * from (
  (SELECT * FROM dim_warning_index)dim right join
  (SELECT * FROM complain_index_total  WHERE index_time BETWEEN DATE_SUB(#{calendar},INTERVAL 10 MINUTE) AND #{calendar}
  AND time_dim_id = 1)total
  ON dim.index_id=total.index_id
  )
  WHERE dim.index_type = 2
  ORDER BY dim.index_order DESC
</select>
<select id="queryComplianIndexNowMinute" parameterType="java.util.Map" resultType="java.util.Map">
  select * from (
  (SELECT * FROM dim_warning_index)dim right join
  (SELECT * FROM complain_index_total  where index_time > DATE_SUB(#{now},INTERVAL 10 MINUTE)
  AND time_dim_id = 1)total
  ON dim.index_id=total.index_id
  )
  WHERE dim.index_type = 2
  ORDER BY dim.index_order DESC
</select>

Select内是SQL语句，从数据库中查出表数据parameterType="java.util.Map"表示可以传进参数