苍穹外卖学习记录（仅供个人学习使用）

前后端搭建出现问题：

1.需要先把后端工程的maven仓库改为自己的仓库地址

2.jdk版本为17

3.lombok版本号改为1.18.30

4.在yml文件中把数据库账号密码改成自己的

自定义注解：

1.先自定义注解

2.再自定义切面类（切入点@PointCut()、通知@annotation()）

        2.1.通知中获取方法签名中的注解对象时需要导入的包是：（不要导错）

        import org.aspectj.lang.reflect.MethodSignature;

3.最后在mapper接口中使用自定义注解

Day4 套餐模块实现

使用xml在插入语句中获取主键值并返回给对象

1. 当插入套餐表（setmeal）时我们需要mybatis给我们返回主键也就是套餐id值给对象，然后将该套餐id赋值给套餐对应菜品对象再插入到套餐菜品表(setmeal_dish)

        1.1.在xml文件的插入语句中使用如下代码

<!--    通过useGeneratedKeys="true"获得生成的主键值，再使用keyProperty="id"返回到Setmeal对象封装的id-->
<insert id="insert" useGeneratedKeys="true" keyProperty="id">略</insert>

Redis安装与使用

windows安装地址：

Releases · microsoftarchive/redis · GitHubhttps://github.com/microsoftarchive/redis/releases

Linux安装地址：

Index of /releases/ (redis.io)https://download.redis.io/releases/

启动redis服务：

       一：命令行启动（注意不能直接点击.exe文件启动，否则密码配置不正确无法进入客户端）

        1.在命令行启动服务端：redis-server.exe redis.windows.conf

                                               ctrl+c   退出服务

        2.在新的命令行启动客户端：redis-cli.exe

              连接指定客户端端口号：redis-cli.exe -h localhost -p 6379

                                                      exit  退出服务

        3.指定redis密码：

                3.1.记事本打开配置文件redis.windows.conf,  然后 ctrl+f 搜索 pass   

找到# requirepass foobared这一行注释，去掉注释并修改密码：requirepass root

                3.2.密码启动客户端：redis-cli.exe -h localhost -p 6379 -a root

                3.3.使用命令 keys * 检查是否连接成功

        二：图形化界面启动

        1.下载地址：（windows选择.exe文件下载）Releases · qishibo/AnotherRedisDesktopManager (github.com)https://github.com/qishibo/AnotherRedisDesktopManager/releases        2.安装启动（需要先启动服务端和客户端）

在Java中操作Redis

        一：使用Spring Data Redis

                1.1 导入Spring Data Redis的maven坐标

<dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-redis</artifactId>
</dependency>

                1.2 配置Redis数据源(默认使用0号数据库)

spring: 
  redis:
    host: localhost
    port: 6379
    password: root
    database: 0

                1.3 编写配置类，创建RedisTemplate对象

@Configuration
@Slf4j
public class RedisConfiguration {
    @Bean
    public RedisTemplate redisTemplate(RedisConnectionFactory redisConnectionFactory){
        log.info("开始创建redis模板对象...");
        RedisTemplate redisTemplate = new RedisTemplate();
        //设置redis的连接工厂对象
        redisTemplate.setConnectionFactory(redisConnectionFactory);
        //设置redis key的序列化器
        redisTemplate.setKeySerializer(new StringRedisSerializer());
        return redisTemplate;
    }
}

                1.4 通过RedisTemplate对象操作Redis （单元测试所有指令）

@SpringBootTest
public class SpringDataRedisTest {

    @Autowired
    private RedisTemplate redisTemplate;

    @Test
    public void testRedisTemplate(){
        System.out.println(redisTemplate);
        ValueOperations valueOperations = redisTemplate.opsForValue();
        HashOperations hashOperations = redisTemplate.opsForHash();
        ListOperations listOperations = redisTemplate.opsForList();
        SetOperations setOperations = redisTemplate.opsForSet();
        ZSetOperations zSetOperations = redisTemplate.opsForZSet();
    }

    /**
     * 操作字符串类型的数据
     */
    @Test
    public void testString(){
        //set get setex setnx
        redisTemplate.opsForValue().set("city","北京");
        String city =(String) redisTemplate.opsForValue().get("city");
        System.out.println(city);
        redisTemplate.opsForValue().set("code","1234",3, TimeUnit.MINUTES);//设置三分钟有效
        redisTemplate.opsForValue().setIfAbsent("lock","1");
        redisTemplate.opsForValue().setIfAbsent("lock","2");
    }

    /**
     * 操作哈希类型的数据
     */
    @Test
    public void testHash(){
        //hset hget hdel hkeys hvals
        HashOperations hashOperations = redisTemplate.opsForHash();

        hashOperations.put("100","name","tome");
        hashOperations.put("100","age","20");

        String name = (String)hashOperations.get("100", "name");
        System.out.println(name);

        Set keys = hashOperations.keys("100");
        System.out.println(keys);

        List values = hashOperations.values("100");
        System.out.println(values);

        hashOperations.delete("100","age");
    }

    /**
     * 操作列表类型的数据
     */
    @Test
    public void testList(){
        //lput lrange rpop llen
        ListOperations listOperations = redisTemplate.opsForList();
        
        listOperations.leftPushAll("mylist","a","b","c");
        listOperations.leftPush("mylist","d");
        
        List mylist = listOperations.range("mylist",0,-1);
        System.out.println(mylist);
        
        listOperations.rightPop("mylist");
        
        Long size = listOperations.size("mylist");
        System.out.println(size);
    }

    /**
     * 操作集合类型的数据
     */
    @Test
    public void testSet(){
        //sadd smembers scard sinter sunion srem
        SetOperations setOperations = redisTemplate.opsForSet();
        
        setOperations.add("set1","a","b","c","d");
        setOperations.add("set2","a","b","x","y");
        
        Set member = setOperations.members("set1");
        System.out.println(member);
        
        Long size = setOperations.size("set1");
        System.out.println(size);

        Set intersect = setOperations.intersect("set1", "set2");
        System.out.println(intersect);

        Set union = setOperations.union("set1", "set2");
        System.out.println(union);
        
        setOperations.remove("set1","a","b");
    }

    /**
     * 操作有序集合类型的数据
     */
    @Test
    public void testZset(){
        //zadd zrange zincrby zrem
        ZSetOperations zSetOperations = redisTemplate.opsForZSet();
        
        zSetOperations.add("zset1","a",10);
        zSetOperations.add("zset2","b",12);
        zSetOperations.add("zset3","c",9);

        Set zset1 = zSetOperations.range("zset1", 0, -1);
        System.out.println(zset1);
        
        zSetOperations.incrementScore("zset1","c",10);//为有序集合zset1的c加上10分
        
        zSetOperations.remove("zset1","a","b");
    }

    /**
     * 通用命令
     */
    @Test
    public void testCommmon(){
        //keys exists type det
        Set keys = redisTemplate.keys("*");//*号表示获得所有key
        System.out.println(keys);

        Boolean name = redisTemplate.hasKey("name");
        Boolean set1 = redisTemplate.hasKey("set1");

        for (Object key : keys) {
            DataType type = redisTemplate.type(key);
            System.out.println(type);
        }
        
        redisTemplate.delete("mylist");
    }
}

引入HttpClient（阿里云oss的依赖包已经引入了该依赖，无需再次引入）

        如果需要显示引入如下：

<dependency>
            <groupId>org.apache.httpcomponents</groupId>
            <artifactId>httpcore</artifactId>
            <version>4.5.13</version>
</dependency>

        封装完成的HttpClient工具类

import com.alibaba.fastjson.JSONObject;
import org.apache.http.NameValuePair;
import org.apache.http.client.config.RequestConfig;
import org.apache.http.client.entity.UrlEncodedFormEntity;
import org.apache.http.client.methods.CloseableHttpResponse;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.client.methods.HttpPost;
import org.apache.http.client.utils.URIBuilder;
import org.apache.http.entity.StringEntity;
import org.apache.http.impl.client.CloseableHttpClient;
import org.apache.http.impl.client.HttpClients;
import org.apache.http.message.BasicNameValuePair;
import org.apache.http.util.EntityUtils;

import java.io.IOException;
import java.net.URI;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

/**
 * Http工具类
 */
public class HttpClientUtil {

    static final  int TIMEOUT_MSEC = 5 * 1000;

    /**
     * 发送GET方式请求
     * @param url
     * @param paramMap
     * @return
     */
    public static String doGet(String url,Map<String,String> paramMap){
        // 创建Httpclient对象
        CloseableHttpClient httpClient = HttpClients.createDefault();

        String result = "";
        CloseableHttpResponse response = null;

        try{
            URIBuilder builder = new URIBuilder(url);
            if(paramMap != null){
                for (String key : paramMap.keySet()) {
                    builder.addParameter(key,paramMap.get(key));
                }
            }
            URI uri = builder.build();

            //创建GET请求
            HttpGet httpGet = new HttpGet(uri);

            //发送请求
            response = httpClient.execute(httpGet);

            //判断响应状态
            if(response.getStatusLine().getStatusCode() == 200){
                result = EntityUtils.toString(response.getEntity(),"UTF-8");
            }
        }catch (Exception e){
            e.printStackTrace();
        }finally {
            try {
                response.close();
                httpClient.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }

        return result;
    }

    /**
     * 发送POST方式请求
     * @param url
     * @param paramMap
     * @return
     * @throws IOException
     */
    public static String doPost(String url, Map<String, String> paramMap) throws IOException {
        // 创建Httpclient对象
        CloseableHttpClient httpClient = HttpClients.createDefault();
        CloseableHttpResponse response = null;
        String resultString = "";

        try {
            // 创建Http Post请求
            HttpPost httpPost = new HttpPost(url);

            // 创建参数列表
            if (paramMap != null) {
                List<NameValuePair> paramList = new ArrayList();
                for (Map.Entry<String, String> param : paramMap.entrySet()) {
                    paramList.add(new BasicNameValuePair(param.getKey(), param.getValue()));
                }
                // 模拟表单
                UrlEncodedFormEntity entity = new UrlEncodedFormEntity(paramList);
                httpPost.setEntity(entity);
            }

            httpPost.setConfig(builderRequestConfig());

            // 执行http请求
            response = httpClient.execute(httpPost);

            resultString = EntityUtils.toString(response.getEntity(), "UTF-8");
        } catch (Exception e) {
            throw e;
        } finally {
            try {
                response.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }

        return resultString;
    }

    /**
     * 发送POST方式请求
     * @param url
     * @param paramMap
     * @return
     * @throws IOException
     */
    public static String doPost4Json(String url, Map<String, String> paramMap) throws IOException {
        // 创建Httpclient对象
        CloseableHttpClient httpClient = HttpClients.createDefault();
        CloseableHttpResponse response = null;
        String resultString = "";

        try {
            // 创建Http Post请求
            HttpPost httpPost = new HttpPost(url);

            if (paramMap != null) {
                //构造json格式数据
                JSONObject jsonObject = new JSONObject();
                for (Map.Entry<String, String> param : paramMap.entrySet()) {
                    jsonObject.put(param.getKey(),param.getValue());
                }
                StringEntity entity = new StringEntity(jsonObject.toString(),"utf-8");
                //设置请求编码
                entity.setContentEncoding("utf-8");
                //设置数据类型
                entity.setContentType("application/json");
                httpPost.setEntity(entity);
            }

            httpPost.setConfig(builderRequestConfig());

            // 执行http请求
            response = httpClient.execute(httpPost);

            resultString = EntityUtils.toString(response.getEntity(), "UTF-8");
        } catch (Exception e) {
            throw e;
        } finally {
            try {
                response.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }

        return resultString;
    }
    private static RequestConfig builderRequestConfig() {
        return RequestConfig.custom()
                .setConnectTimeout(TIMEOUT_MSEC)
                .setConnectionRequestTimeout(TIMEOUT_MSEC)
                .setSocketTimeout(TIMEOUT_MSEC).build();
    }

}

使用cpolar(使用内网穿透工具获取临时域名)

Spring Task（定时任务）

在线Cron表达式生成器

Cron - 在线Cron表达式生成器 (ciding.cc)https://cron.ciding.cc/

调用百度地图接口(Day09作业)

          

代码开发（答案）

        1. application.yml

        2. OrderServiceImpl

改造OrderServiceImpl，注入上面的配置项： 

 @Value("${sky.shop.address}")
 private String shopAddress;

 @Value("${sky.baidu.ak}")
 private String ak;

在OrderServiceImpl中提供校验方法：

/**
     * 检查客户的收货地址是否超出配送范围
     * @param address
     */
    private void checkOutOfRange(String address) {
        Map map = new HashMap();
        map.put("address",shopAddress);
        map.put("output","json");
        map.put("ak",ak);

        //获取店铺的经纬度坐标
        String shopCoordinate = HttpClientUtil.doGet("https://api.map.baidu.com/geocoding/v3", map);

        JSONObject jsonObject = JSON.parseObject(shopCoordinate);
        if(!jsonObject.getString("status").equals("0")){
            throw new OrderBusinessException("店铺地址解析失败");
        }

        //数据解析
        JSONObject location = jsonObject.getJSONObject("result").getJSONObject("location");
        String lat = location.getString("lat");
        String lng = location.getString("lng");
        //店铺经纬度坐标
        String shopLngLat = lat + "," + lng;

        map.put("address",address);
        //获取用户收货地址的经纬度坐标
        String userCoordinate = HttpClientUtil.doGet("https://api.map.baidu.com/geocoding/v3", map);

        jsonObject = JSON.parseObject(userCoordinate);
        if(!jsonObject.getString("status").equals("0")){
            throw new OrderBusinessException("收货地址解析失败");
        }

        //数据解析
        location = jsonObject.getJSONObject("result").getJSONObject("location");
        lat = location.getString("lat");
        lng = location.getString("lng");
        //用户收货地址经纬度坐标
        String userLngLat = lat + "," + lng;

        map.put("origin",shopLngLat);
        map.put("destination",userLngLat);
        map.put("steps_info","0");

        //路线规划
        String json = HttpClientUtil.doGet("https://api.map.baidu.com/directionlite/v1/driving", map);

        jsonObject = JSON.parseObject(json);
        if(!jsonObject.getString("status").equals("0")){
            throw new OrderBusinessException("配送路线规划失败");
        }

        //数据解析
        JSONObject result = jsonObject.getJSONObject("result");
        JSONArray jsonArray = (JSONArray) result.get("routes");
        Integer distance = (Integer) ((JSONObject) jsonArray.get(0)).get("distance");

        if(distance > 5000){
            //配送距离超过5000米
            throw new OrderBusinessException("超出配送范围");
        }
    }

在OrderServiceImpl的submitOrder方法中调用上面的校验方法：

注意事项

1.微信前端后端联调太久会加载失败，取消断点即可