从mysql拿值放进redis并且进行异步请求

最新推荐文章于 2023-08-04 12:21:23 发布

冷------

最新推荐文章于 2023-08-04 12:21:23 发布

阅读量135

点赞数

本文链接：https://blog.csdn.net/ykyzsya/article/details/108108730

版权

jsp页面

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<select name="deptno" id="deptno">
    <option value="0">请选择省份</option>
</select>
</body>
</html>
<!--部署jq -->
<script type="application/javascript" src="js/jquery-1.11.2.min.js"></script>
<script type="application/javascript">
    //文档加载就执行该函数
    $(function () {
        $.ajax({
            //请求地址是/pro/list 请求方式是get 数据类型是json
            url:'/pro/list',
            type:'get',
            dataType:'json',
            //data名字随意
            success:function (data) {
                $.each(data,function (i,e) {//表示下标 e表示对象
                    //用id获取下拉框追加值
                    $("#deptno").append("<option value='"+e.id+"'>"+e.name+"</option>");
                })
            }
        });

    });

</script>

controller层

package com.ly.redires.controller;
import com.ly.redires.service.ProvinceSer;
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.ResponseBody;
@Controller
@RequestMapping("/pro")
public class ProvinceCon {
    @Autowired
    private ProvinceSer provinceSer;

    @RequestMapping("/list")
    @ResponseBody
    public String findProvinces(){
        String json=provinceSer.findProvinces();
        System.out.println(json);
        return json;
    }
}

service层实现层

package com.ly.redires.service;
import com.alibaba.druid.util.StringUtils;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.ly.redires.bean.Province;
import com.ly.redires.mapper.Provincemapper;
import com.ly.redires.utiles.RedisUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.redis.core.RedisTemplate;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class ProvinceSerImpl implements ProvinceSer{
    @Autowired
    //mapper层接口
    private Provincemapper provincemapper;
    @Autowired
    private RedisTemplate template;
    @Autowired
    private RedisUtil redisUtil;
    @Override
    public String findProvinces() {
        String json= (String) template.opsForValue().get("province");
        List<Province> list=null;
        if (StringUtils.isEmpty(json)){//如果json为空，表示需要联网获取
            list=provincemapper.findProvinces();
            ObjectMapper objectMapper=new ObjectMapper();
            try {
                json=objectMapper.writeValueAsString(list);
            }catch (Exception e){
                e.printStackTrace();
            }
            redisUtil.set("province",json);
        }else {//若不为空则直接使用缓存数据
            System.out.println("直接使用缓存数据！");
        }
        return json;
    }
}

冷------

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
从mysql拿值放进redis并且进行异步请求

jsp页面<%@ page contentType="text/html;charset=UTF-8" language="java" %><html><head> <title>Title</title></head><body><select name="deptno" id="deptno"> <option value="0">请选择省份</option&gt
复制链接

扫一扫