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

最新推荐文章于 2024-08-06 21:58:53 发布

原创最新推荐文章于 2024-08-06 21:58:53 发布 · 4.8k 阅读

8 ·

CC 4.0 BY-SA版权

文章标签：

#JavaScript #Java #SpringMVC #MyBatis

Java 专栏收录该内容

9 篇文章

订阅专栏

本文介绍了如何在MyBatis和SpringMVC框架下，从数据库获取数据并传递到前端的过程。首先通过Mapper映射生成与数据库表对应的Java文件，然后创建Service和Controller层。在Service层，利用Map存储查询参数，调用Dao层执行SQL。Controller层接收Service返回的数据，通过@RequestMapping指定视图。最后，前端JavaScript通过Ajax请求Controller接口，接收JSON数据并展示在HTML页面上。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

首先映射生成数据库中表对应的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"表示可以传进参数

resultType="java.util.Map"表示可以传出传出数据。其类型为Map类型。

Service层中

import com.asiainfo.aikcm.complaint.entity.WarningIndexDetail;
import com.asiainfo.system.base.service.impl.IServiceImpl;
import org.springframework.stereotype.Service;
import com.asiainfo.aikcm.complaint.entity.ComplainIndexTotal;
import com.asiainfo.aikcm.complaint.entity.ComplainIndexTotalExample;

import java.sql.*;
import java.sql.Date;
import java.util.*;

import org.springframework.beans.factory.annotation.Autowired;
import com.asiainfo.system.base.dao.IDAO;
/**
 * Created by fumw on 2017/8/10.
 * 投诉指标数据表的业务层
 */
@Service
public class ComplainIndexTotalService extends IServiceImpl<ComplainIndexTotal, ComplainIndexTotalExample, Long> {
    @Autowired
    private IDAO<ComplainIndexTotal,ComplainIndexTotalExample,String> dao;
/**
 * @Description: 获取数据库中index_order为1的指标的最大时间
 * @return
 */
public List<Map<String,Object>> queryComplianIndexMax(Map<String,Object> dimTime){
    Map<String,Object> map=new HashMap<String,Object>();
    map.put("dimTime",dimTime.get("dimTime"));
    List<Map<String,Object>> resultList = dao.selectListByMap("queryComplianIndexMinuteMax", map);
    return resultList;
}

/**
 * @Description: 获取数据库中时间维度为实时的上月信息
 * @return
 */
public List<Map<String,Object>> queryComplianIndexLastMinute(){
    Map<String,Object> map=new HashMap<String,Object>();
    Map<String,Object> dimTime =new HashMap<String,Object>();
    dimTime.put("dimTime",1);
    List<Map<String,Object>> resultTime = queryComplianIndexMax(dimTime);
    Calendar calendar = Calendar.getInstance();
    calendar.setTime((java.util.Date)resultTime.get(0).get("MAX(index_time)"));
    calendar.add(Calendar.MONTH, -1);
    map.put("calendar",calendar.getTime());
    List<Map<String,Object>> resultList = dao.selectListByMap("queryComplianIndexLastMinute", map);
    return resultList;
}
/**
 * @Description: 获取数据库中时间维度为实时的本月信息
 * @return
 */
public List<Map<String,Object>> queryComplianIndexNowMinute(){
    Map<String,Object> map=new HashMap<String,Object>();
    Map<String,Object> dimTime =new HashMap<String,Object>();
    dimTime.put("dimTime",1);
    List<Map<String,Object>> resultTime = queryComplianIndexMax(dimTime);
    Calendar calendar = Calendar.getInstance();
    calendar.setTime((java.util.Date)resultTime.get(0).get("MAX(index_time)"));
    map.put("now",calendar.getTime());
    List<Map<String,Object>> resultList = dao.selectListByMap("queryComplianIndexNowMinute", map);
    return resultList;
}

在service层中

Map<String,Object>map=new HashMap<String,Object>();
新创建一个Map类型的变量map

map.put("now",calendar.getTime());

给map赋值。

List<Map<String,Object>>resultList = dao.selectListByMap("queryComplianIndexNowMinute", map);

将map传给mapper内方法后获取查询后的数据赋值给resultList，每一条数据为一个元素。

Controller层

import com.asiainfo.aikcm.complaint.entity.*;
import com.asiainfo.aikcm.complaint.service.ComplainIndexTotalService;
import com.asiainfo.aikcm.complaint.service.DimWarningIndexService;
import com.asiainfo.aikcm.complaint.service.WarningIndexDetailService;
import com.asiainfo.system.base.web.BaseController;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import javax.servlet.http.HttpServletRequest;
import javax.xml.crypto.Data;
import java.math.BigDecimal;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;

/**
 * Created by asus on 2017/7/31.
 */

@Controller
@RequestMapping("/ComplaintHotness")
public class ComplaintHotnessController extends BaseController {

    @Autowired
    private DimWarningIndexService DIMwarningservice;
    @Autowired
    private ComplainIndexTotalService ComplainService;

    @Autowired
    private WarningIndexDetailService WIDService;

    @Autowired
    private DimWarningIndexService DWIService;

    @Autowired
    private ComplainIndexTotalService CITService;




/**
     *
     * @Description: 查询指标数据
     * @return
     */
    @RequestMapping(value = "/traceComplainIndexTotal", method = RequestMethod.GET )
    @ResponseBody
    public  Object  traceComplainIndexTotal(@RequestParam Map<String, String> paramMap) throws ParseException {

        List<Map<String, Object>> result = new ArrayList<>();
        List<Map<String,Object>> result1 = new ArrayList<>();
        List<Map<String,Object>> result2 = new ArrayList<>();
        if(paramMap.get("time_dim_id1").equals("4")) {
            result1 = CITService.queryComplianIndexLastDay();
            result2 = CITService.queryComplianIndexNowDay();
        }
        if(paramMap.get("time_dim_id1").equals("1")) {
            result1   = CITService.queryComplianIndexLastMinute();
            result2   = CITService.queryComplianIndexNowMinute();

        }
        Map<Object,Map> map=new HashMap<>();
      for(int j=0;j<result1.size();j++){
           map.put(result1.get(j).get("index_id"),result1.get(j));
      }
        for(int i = 0; i < result2.size(); i++){
            Map<String,Object> timeNow=new HashMap<>();
            timeNow.put("index_order",result2.get(i).get("index_order"));
            timeNow.put("ID",result2.get(i).get("ID"));
            timeNow.put("index_value",result2.get(i).get("index_value"));
            timeNow.put("index_name",result2.get(i).get("index_name"));
            timeNow.put("index_id",result2.get(i).get("index_id"));
            if(map.get(result2.get(i).get("index_id")) !=null){
                timeNow.put("compare_value",Math.round(Double.parseDouble(result2.get(i).get("index_value") + "")/Double.parseDouble(map.get(result2.get(i).get("index_id")).get("index_value")+ "")* 100) / 100.00 );
            }

            result.add(timeNow);
        }


        return result;
    }

@RequestMapping("/ComplaintHotness")为前端页面名

Controller层将Service传过来的数据进行接受并处理，指定好需要上传的view。

@RequestParam Map<String, String> paramMap是从前端页面传回来的值。

Js层

function getComplainIndexTotal(time_dim_id)
{
    var params = {"time_dim_id1":time_idNow};

    var url = "/ComplaintHotness/traceComplainIndexTotal"  ;
    $.ajax({
        type : "GET",
        url : url,
        dataType : "html",
        data:params,
        cache : false,
        success : function(data) {
            var obj = eval('(' + data + ')');
            complaintIndexObj = obj;
            getDimWarningIndex();
            for(var p = 1;p<7;p++){
                document.getElementById("number_con" + p).innerHTML =0;
                document.getElementById("div" +p).setAttribute('cid', 0);
                document.getElementById("pernumber" + p ).innerHTML =
                    "<i class = 'iconfont icon-up-copy'>  </i>  <span >  " +"0" +"%" + "</span>";

            }
            if(obj == null|| obj.length ==0){

            }else {
                for(var x = 0;x<obj.length;x++){
                    for(var y = 1;y<7;y++){
                        if(obj[x].index_order == y ){
                            document.getElementById("number_con" + y).innerHTML =obj[x].index_value;
                            document.getElementById("div" +y).setAttribute('cid', obj[x].index_id);
                            if (obj[x].compare_value - 1 >= 0) {
                                document.getElementById("pernumber" + y ).innerHTML =
                                    "<i class = 'iconfont icon-up-copy'>  </i>  <span >  " + Math.round(Math.abs(obj[x].compare_value - 1) * 100 * 100) / 100 + "</span>%";
                            } else if(obj[x].compare_value - 1 < 0){
                                document.getElementById("pernumber" + y ).innerHTML =
                                    "<i class = 'iconfont icon-down'>  </i>  <span >  " + Math.round(Math.abs(obj[x].compare_value - 1) * 100 * 100) / 100 + "</span>%";
                            }
                            break;
                        }

                    }
                }
            }
            getWarningDetailsColor();
        },
        error : function(data, textstatus) {
            alert("ComplainIndexTotal操作失败.");
        }
    });
}

URL即为Controller层设定好的两个值。Obj为传过来的list

最后在HTML界面内导入该js

dataType: "html",
转换成dataType：”json”可以省去

var obj = eval('(' + data + ')');
而直接用data代替obj