• 基于springboot+mybatis+thymeleaf+redis+html实现的农村在线交易平台项目（含支付模块）

    最近几周挺忙的，又要准备面试又要参加学校的实习什么的，而且还要准备web课的结课项目，说是老师帮助我们优秀的项目组申请软件著作权，所以这个在线支付的项目我还是比较重视的，在功能的实现上面下了比较多的功夫，因为不会真的上线有的功能能模拟就模拟了。算是比较满意的了，平时成绩100，结课项目评委分数92（说是前端页面不够美观，不然能给95加吧），综合成绩96，还行，不辜负我整个大三下的自学，大四即将到来，实习单位也找到了，七月份正式上班，最近几天能划水就划划水吧。

    本次采取的开发框架还是比较容易上手的微服务springboot开发框架，因为涉及到支付，采用另一个微服务负责支付端的响应。

    数据库设计（对应实体类）

    商品实体类

    1. @Data
    2. public class Good{
    3.     private int goodId;
    4.     private String goodName;
    5.     private int goodInPrice;
    6.     private int goodOutPrice;
    7.     private int goodReserve;
    8.     private String goodProduct;
    9.     private String goodExTime;
    10.     private int goodShopId;
    11. }

    订单实体类

    1. @Data
    2. public class Older implements Serializable {
    3.     private int olderId;
    4.     private int olderUserId;
    5.     private int olderGoodId;
    6.     private int olderShopId;
    7.     private int olderGoodNumber;
    8.     private String olderAddress;
    9.     private String olderGoHomeTime;
    10.     private boolean olderState;
    11.     private String olderDate;
    12. }

    商家实体类

    1. @Data
    2. public class Shop {
    3.     private int shopId;
    4.     private String shopNickname;
    5.     private String shopAddress;
    6.     private String shopOwner;
    7.     private String shopPhone;
    8.     private String shopInfo;
    9.     private String password;
    10. }

    用户实体类

    1. @Data
    2. public class User {
    3.     private int userId;
    4.     private String userNickname;
    5.     private char userSex;
    6.     private String userHead;
    7.     private String userBrith;
    8.     private String userAddress;
    9.     private String userRegister;
    10.     private String userPhone;
    11.     private String password;
    12. }

    dao层（分为两个角色，分别是商家与用户，所以对应的操作也应该不同，当然管理员的角色我也有配置，这个就看大家自己加了，毕竟不是重点）

    shopMapper

    1. @Mapper
    2. public interface ShopMapper extends BaseMapper<Good> {
    3.  
    4.     @Select("SELECT * FROM ncds.shop WHERE shopPhone=#{shopPhone} AND password=#{password}")
    5.     boolean loginShop(@Param("shopPhone") String shop_phone, @Param("password") String password);
    6.  
    7.  
    8.     @Insert("INSERT INTO ncds.shop (shopPhone,password) VALUE (#{shopPhone},#{password})")
    9.     boolean registerShop(@Param("shopPhone") String shopPhone, @Param("password") String password);
    10.  
    11.  
    12.     @Update("UPDATE ncds.shop SET shopNickname=#{shopNickname},shopAddress=#{shopAddress},shopOwner=#{shopOwner},shopInfo=#{shopInfo} WHERE shopId=#{shopId}")
    13.     boolean refineShop(@Param("shopNickname") String shopNickname, @Param("shopAddress") String shopAddress, @Param("shopOwner") String shopOwner, @Param("shopInfo") String shopInfo, @Param("shopId") int shopId);
    14.  
    15.  
    16.     @Update("UPDATE ncds.shop SET password=#{password} WHERE shopId=#{shopId}")
    17.     boolean updateShopPassword(@Param("shopId") int shopId, @Param("password") String password);
    18.  
    19.  
    20.     @Select("SELECT * FROM ncds.good WHERE goodId=#{goodId}")
    21.     List<Good> findHostGood(@Param("goodId") int goodId);
    22.  
    23.  
    24.     @Insert("INSERT INTO ncds.good (goodName,goodInPrice,goodOutPrice,goodReserve,goodExTime,goodProduct,goodShopId) " +
    25.             "VALUE (#{goodName},#{goodInPrice},#{goodOutPrice},#{goodReserve},#{goodExTime},#{goodProduct},#{goodShopId})")
    26.     boolean saveGood(@Param("goodName") String goodName, @Param("goodInPrice") int goodInPrice, @Param("goodOutPrice") int goodOutPrice,
    27.                      @Param("goodReserve") int goodReserve, @Param("goodExTime") String goodExTime, @Param("goodProduct") String goodProduct, @Param("goodShopId") int goodShopId);
    28.  
    29.     @Delete("DELETE FROM ncds.good WHERE goodId=#{goodId}")
    30.     boolean deleteGood(@Param("goodId") int goodId);
    31.  
    32.     @Update("UPDATE ncds.good SET goodReserve=#{goodNumber} WHERE goodId=#{goodId} AND goodName=#{goodName}")
    33.     boolean addGood_number(@Param("goodId") int goodId, @Param("goodNumber") int goodNumber, @Param("goodName") String goodName);
    34.  
    35.     @Update("UPDATE ncds.good SET goodOutPrice=#{price} WHERE goodId=#{goodId}")
    36.     boolean inSuPriceByGood_id(@Param("goodId") int goodId, @Param("price") int price);
    37.  
    38.  
    39.     @Select("SELECT * FROM ncds.older WHERE olderShopId=#{olderShopId}")
    40.     List<Older> findOlderByShopId(int olderShopId);
    41.  
    42.     @Select("SELECT * FROM ncds.older WHERE olderUserId=#{userId}")
    43.     List<Older> findOlderByUserId(int userId);
    44.  
    45.  
    46.     @Select("SELECT * FROM ncds.shop WHERE shopId=#{shopId}")
    47.     Shop findShopById(@Param("shopId") int shopId);
    48.  
    49.  
    50.     @Select("SELECT * FROM ncds.good WHERE goodShopId=#{goodShopId}")
    51.     List<Good> findGoodByShopId(int goodShopId);
    52.  
    53.  
    54.     @Select("SELECT shopId FROM ncds.shop WHERE shopPhone=#{shopPhone}")
    55.     int findShopIdByShopPhone(String shopPhone);
    56.  
    57.  
    58.     @Select("SELECT goodShopId FROM ncds.good WHERE goodId=#{goodId}")
    59.     int findShopIdByGoodId(@Param("goodId") int goodId);
    60.  
    61.     @Select("SELECT shopPhone FROM ncds.shop WHERE shopId=#{shopId}")
    62.     String findShopPhoneByShopId(@Param("shopId") int shopId);
    63.  
    64. }

    userMapper

    1. @Mapper
    2. public interface UserMapper {
    3.     /*1.登录*/
    4.     @Select("SELECT * FROM ncds.user WHERE userPhone=#{userPhone} AND password=#{password}")
    5.     boolean loginUser(@Param("userPhone") String userPhone, @Param("password") String password);
    6.  
    7.     /*2.注册*/
    8.     @Insert("INSERT INTO ncds.user(userPhone,password) VALUE (#{userPhone},#{password})")
    9.     boolean registerUser(@Param("userPhone") String userPhone, @Param("password") String password);
    10.  
    11.     /*补全信息（最开始注册仅仅按照电话与id以及密码 注册）*/
    12.  
    13.     /**
    14.      * @param userId
    15.      * @param userNickname
    16.      * @param userSex
    17.      * @param userHead     采取的是longblob的mysql数据库格式，利用load_file(文件磁盘路径)的方式
    18.      *                     只需要传入一个路径参数即可实现图片或者视频的存储。我们规定文件路径为D:/ncds/img/...
    19.      * @param userBrith
    20.      * @param userAddress
    21.      * @param userRegister
    22.      * @return boolean
    23.      */
    24.     @Update("UPDATE ncds.user SET userNickname=#{userNickname},userSex=#{userSex},userHead=load_file(#{userHead}),userBrith=#{userBrith},userAddress=#{userAddress},userRegister=#{userRegister},password=#{password} WHERE userId=#{userId}")
    25.     boolean refineUser(@Param("userId") int userId, @Param("userNickname") String userNickname, @Param("userSex") char userSex,
    26.                        @Param("userHead") String userHead, @Param("userBrith") String userBrith, @Param("userAddress") String userAddress, @Param("userRegister") String userRegister, @Param("password") String password);
    27.  
    28.  
    29.     /*4.查看热门商品(需要redis数据库查询返回的id排序)*/
    30.     @Select("SELECT * FROM ncds.good WHERE goodId=#{goodId}")
    31.     Good findHostGood(int goodId);
    32.  
    33.     /*5.搜素商家(分为两种，按照id查与按照name查)*/
    34.     @Select("SELECT * FROM ncds.shop WHERE shopId=#{shopId}")
    35.     Shop findShopById(int shopId);
    36.  
    37.     @Select("SELECT * FROM ncds.shop WHERE shopNickname=#{shopNickname}")
    38.     Shop findShopByName(String shopNickname);
    39.     /*6.模糊查询，搜索商品(可能不为一个商品)*/
    40.  
    41.     /**
    42.      * @param goodName 注意测试时需要将传入的参数拼接为“%${goodName}%”的形式
    43.      * @return List<Good>
    44.      */
    45.     @Select("SELECT * FROM ncds.good WHERE goodName LIKE #{goodName}")
    46.     List<Good> findGoodByName(String goodName);
    47.  
    48.     @Insert("INSERT INTO ncds.older (olderUserId,olderGoodId,olderGoodNumber,olderAddress,olderGoHomeTime,olderState,olderDate,olderShopId)" +
    49.             "VALUE (#{olderUserId},#{olderGoodId},#{olderGoodNumber},#{olderAddress},#{olderGoHomeTime},#{olderState},#{olderDate},#{olderShopId})")
    50.     boolean saveOlder(@Param("olderUserId") int olderUserId, @Param("olderGoodId") int olderGoodId, @Param("olderGoodNumber") int olderGoodNumber, @Param("olderAddress") String olderAddress, @Param("olderGoHomeTime") String olderGoHomeTime, @Param("olderState") boolean olderState, @Param("olderDate") String olderDate, @Param("olderShopId") int olderShopId);
    51.  
    52.     /*8.支付*/
    53.     @Update("UPDATE ncds.older SET olderState=TRUE WHERE olderId=#{olderId}")
    54.     boolean updateOlderState(@Param("older_id") int olderId);
    55.  
    56.     /*9.退货处理（就是删除订单,商家的货物退还,计算退款资金）*/
    57.     @Select("SELECT olderUserId FROM ncds.older WHERE olderId=#{olderId}")
    58.     int findUserIdByOlderId(@Param("olderId") Integer olderId);
    59.  
    60.     @Delete("DELETE FROM ncds.older WHERE olderId=#{olderId}")
    61.     boolean deleteOlder(int olderId);
    62.  
    63.     @Update("UPDATE ncds.good SET goodReserve=goodReserve+#{olderGoodNumber} WHERE goodShopId=#{shopId}")
    64.     boolean addGood(int shopId, int olderGoodNumber);
    65.  
    66.     /*11.查询个人信息*/
    67.     @Select("SELECT userPhone FROM ncds.user WHERE userId=#{userId}")
    68.     String findUserPhoneByUserId(@Param("userId") Integer userId);
    69.  
    70.     @Select("SELECT * FROM ncds.user WHERE userId=#{userId}")
    71.     User findUserById(@Param("userId") int userId);
    72.  
    73.     @Select("SELECT userId FROM ncds.user WHERE userPhone=#{userPhone}")
    74.     int findUserIdByUserPhone(@Param("userPhone") String userPhone);
    75.  
    76.     /*13.查询全部商品*/
    77.     @Select("SELECT * FROM ncds.good")
    78.     List<Good> findAllGood();
    79. }

    serveice层（基本就是老样子）

    shopService与其实现类（service层是redis中间件操作注入层，我姑且是这么叫的）

    1. public interface ShopService {
    2.  
    3.     boolean loginShop(String shop_phone, String password);
    4.  
    5.     boolean registerShop(String shop_phone, String password);
    6.  
    7.     boolean refineShop(String shop_nickname, String shop_address, String shop_owner, String shop_info, int shopId);
    8.  
    9.     boolean updateShopPassword(int shop_id, String password);
    10.  
    11.     boolean saveGood(String goodName, int goodInPrice, int goodOutPrice, int goodReserve, String goodExTime, String goodProduct, int goodShopId);
    12.  
    13.     boolean deleteGood(int good_id);
    14.  
    15.     boolean addGood_number(int good_id, int good_number, String goodName);
    16.  
    17.     boolean inSuPriceByGood_id(int good_id, int price);
    18.  
    19.     List<Older> findOlderByShopId(int shopId);
    20.  
    21.     List<Older> findOlderByUserId(int userId);
    22.  
    23.     Shop findShopById(int shop_id);
    24.  
    25.     List<Good> findGoodByShopId(int goodShopId);
    26.  
    27.     int findShopIdByShopPhone(String shopPhone);
    28.  
    29.     boolean saveGoodByFile(MultipartFile file);
    30.  
    31.     int findShopIdByGoodId(int goodId);
    32.  
    33.     String findShopPhoneByShopId(int shopId);
    34. }
    35.  
    36. @Service("ShopService")
    37. public class ShopServiceImpl implements ShopService {
    38.     @Autowired
    39.     private ShopMapper shopMapper;
    40.  
    41.     @Autowired
    42.     private FileOption fileOption;
    43.  
    44.     @Override
    45.     public boolean loginShop(String shop_phone, String password) {
    46.         return shopMapper.loginShop(shop_phone, password);
    47.     }
    48.  
    49.     @Override
    50.     public boolean registerShop(String shop_phone, String password) {
    51.         return shopMapper.registerShop(shop_phone, password);
    52.     }
    53.  
    54.     @Override
    55.     public boolean refineShop(String shop_nickname, String shop_address, String shop_owner, String shop_info, int shopId) {
    56.         return shopMapper.refineShop(shop_nickname, shop_address, shop_owner, shop_info, shopId);
    57.     }
    58.  
    59.     @Override
    60.     public boolean updateShopPassword(int shop_id, String password) {
    61.         return shopMapper.updateShopPassword(shop_id, password);
    62.     }
    63.  
    64.  
    65.     @Override
    66.     public boolean saveGood(String goodName, int goodInPrice, int goodOutPrice, int goodReserve, String goodExTime, String goodProduct, int goodShopId) {
    67.         return shopMapper.saveGood(goodName, goodInPrice, goodOutPrice, goodReserve, goodExTime, goodProduct, goodShopId);
    68.     }
    69.  
    70.  
    71.     @Override
    72.     public boolean deleteGood(int good_id) {
    73.         return shopMapper.deleteGood(good_id);
    74.     }
    75.  
    76.     @Override
    77.     public boolean addGood_number(int good_id, int good_number, String goodName) {
    78.         return shopMapper.addGood_number(good_id, good_number, goodName);
    79.     }
    80.  
    81.     @Override
    82.     public boolean inSuPriceByGood_id(int good_id, int price) {
    83.         return shopMapper.inSuPriceByGood_id(good_id, price);
    84.     }
    85.  
    86.  
    87.     @Override
    88.     public List<Older> findOlderByShopId(int shopId) {
    89.         return shopMapper.findOlderByShopId(shopId);
    90.     }
    91.  
    92.     @Override
    93.     public List<Older> findOlderByUserId(int userId) {
    94.         return shopMapper.findOlderByUserId(userId);
    95.     }
    96.  
    97.  
    98.     @Override
    99.     public Shop findShopById(int shop_id) {
    100.         return shopMapper.findShopById(shop_id);
    101.     }
    102.  
    103.     @Override
    104.     public List<Good> findGoodByShopId(int goodShopId) {
    105.         return shopMapper.findGoodByShopId(goodShopId);
    106.     }
    107.  
    108.     @Override
    109.     public int findShopIdByShopPhone(String shopPhone) {
    110.         return shopMapper.findShopIdByShopPhone(shopPhone);
    111.     }
    112.  
    113.     @Override
    114.     public boolean saveGoodByFile(MultipartFile file) {
    115.         boolean flag = true;
    116.         List<Good> goodList = fileOption.fileOptions(file);
    117.         for (Good good : goodList) {
    118.             flag = saveGood(good.getGoodName(), good.getGoodInPrice(), good.getGoodOutPrice(),
    119.                     good.getGoodReserve(), good.getGoodExTime(), good.getGoodProduct()
    120.                     , good.getGoodShopId());
    121.         }
    122.         return flag;
    123.     }
    124.  
    125.     @Override
    126.     public int findShopIdByGoodId(int goodId) {
    127.         return shopMapper.findShopIdByGoodId(goodId);
    128.     }
    129.  
    130.     @Override
    131.     public String findShopPhoneByShopId(int shopId) {
    132.         return shopMapper.findShopPhoneByShopId(shopId);
    133.     }
    134. }

    userService与其实现类

    1. public interface UserService {
    2.     /*1.登录*/
    3.     boolean loginUser(String user_phone, String password);
    4.  
    5.     /*2.注册*/
    6.     boolean registerUser(String user_phone, String password);
    7.  
    8.     /*补全信息（最开始注册仅仅按照电话与id以及密码 注册）*/
    9.     boolean refineUser(int user_id, String user_nickname, char user_sex,
    10.                        String user_head, String user_brith, String user_address, String user_register,String password);
    11.  
    12.     /*4.查看热门商品(需要redis数据库查询返回的id排序)*/
    13.     Good findHostGood(int good_id);
    14.  
    15.     /*5.搜素商家(分为两种，按照id查与按照name查)*/
    16.     Shop findShopById(int shop_id);
    17.  
    18.     Shop findShopByName(String shop_nickname);
    19.     /*6.模糊查询，搜索商品(可能不为一个商品)*/
    20.  
    21.     /**
    22.      * @param good_name 注意测试时需要将传入的参数拼接为“%${good_name}%”的形式
    23.      * @return List<Good>
    24.      */
    25.     List<Good> findGoodByName(String good_name);
    26.  
    27.     boolean updateOlderState(int older_id);
    28.  
    29.     String findUserPhoneByUserId(Integer userId);
    30.  
    31.     boolean deleteOlder(int older_id);
    32.  
    33.     boolean addGood(int shop_id, int older_good_number);
    34.  
    35.     User findUserById(int user_id);
    36.     int findUserIdByOlderId(Integer olderId);
    37.  
    38.     int findUserIdByUserPhone(String userPhone);
    39.     List<Good> findAllGood();
    40.  
    41.     boolean saveOlder(int olderUserId,int olderGoodId,int olderGoodNumber,String olderAddress,String olderGoHomeTime,boolean olderState,String olderDate, int olderShopId);
    42. }
    43. @Service("UserService")
    44. public class UserServiceImpl implements UserService {
    45.     @Autowired
    46.     private UserMapper userMapper;
    47.  
    48.     @Override
    49.     public boolean loginUser(String user_phone, String password) {
    50.         return userMapper.loginUser(user_phone,password);
    51.     }
    52.  
    53.     @Override
    54.     public boolean registerUser(String user_phone, String password) {
    55.         return userMapper.registerUser(user_phone,password);
    56.     }
    57.  
    58.     @Override
    59.     public boolean refineUser(int user_id, String user_nickname, char user_sex, String user_head, String user_brith, String user_address, String user_register,String password) {
    60.         return userMapper.refineUser(user_id,user_nickname,user_sex,user_head,user_brith,user_address,user_register,password);
    61.     }
    62.  
    63.     @Override
    64.     public Good findHostGood(int good_id) {
    65.         return userMapper.findHostGood(good_id);
    66.     }
    67.  
    68.     @Override
    69.     public Shop findShopById(int shop_id) {
    70.         return userMapper.findShopById(shop_id);
    71.     }
    72.  
    73.     @Override
    74.     public Shop findShopByName(String shop_nickname) {
    75.         return userMapper.findShopByName(shop_nickname);
    76.     }
    77.  
    78.     @Override
    79.     public List<Good> findGoodByName(String good_name) {
    80.         return userMapper.findGoodByName(good_name);
    81.     }
    82.  
    83.  
    84.     @Override
    85.     public boolean updateOlderState(int older_id) {
    86.         return userMapper.updateOlderState(older_id);
    87.     }
    88.  
    89.     @Override
    90.     public String findUserPhoneByUserId(Integer userId) {
    91.         return userMapper.findUserPhoneByUserId(userId);
    92.     }
    93.  
    94.     @Override
    95.     public boolean deleteOlder(int older_id) {
    96.         return userMapper.deleteOlder(older_id);
    97.     }
    98.  
    99.     @Override
    100.     public boolean addGood(int shop_id, int older_good_number) {
    101.         return userMapper.addGood(shop_id,older_good_number);
    102.     }
    103.  
    104.     @Override
    105.     public User findUserById(int user_id) {
    106.         return userMapper.findUserById(user_id);
    107.     }
    108.  
    109.     @Override
    110.     public int findUserIdByOlderId(Integer olderId) {
    111.         return userMapper.findUserIdByOlderId(olderId);
    112.     }
    113.  
    114.     @Override
    115.     public int findUserIdByUserPhone(String userPhone) {
    116.         return userMapper.findUserIdByUserPhone(userPhone);
    117.     }
    118.  
    119.  
    120.     @Override
    121.     public List<Good> findAllGood() {
    122.         return userMapper.findAllGood();
    123.     }
    124.  
    125.     @Override
    126.     public boolean saveOlder(int olderUserId, int olderGoodId, int olderGoodNumber, String olderAddress, String olderGoHomeTime, boolean olderState, String olderDate, int olderShopId) {
    127.         return userMapper.saveOlder(olderUserId,olderGoodId,olderGoodNumber,olderAddress,olderGoHomeTime,olderState,olderDate,olderShopId);
    128.     }
    129. }
    130.

    controller层（各种Url能记住吗？）

    userController

    1. @RequestMapping("User")
    2. @RestController
    3. public class UserController {
    4.  
    5.     @Autowired
    6.     private UserService userService;
    7.     @Autowired
    8.     private ShopService shopService;
    9.     @Autowired
    10.     private JedisFactory jedisFactory;
    11.  
    12.     /*注册*/
    13.     @RequestMapping("register")
    14.     public ModelAndView registerF() {
    15.         return new ModelAndView("/register/register_user");
    16.     }
    17.  
    18.     @PostMapping("register_user")
    19.     public ModelAndView registerUser(String userPhone, String password) {
    20.         boolean registerUser = userService.registerUser(userPhone, password);
    21.         if (registerUser) {
    22.             loginF();
    23.         }
    24.         return registerF();
    25.     }
    26.  
    27.     /*登录*/
    28.     @RequestMapping("login")
    29.     public ModelAndView loginF() {
    30.         return new ModelAndView("/login/login_user");
    31.     }
    32.  
    33.     @PostMapping("login_user")
    34.     public ModelAndView loginUser(String userPhone, String password) {
    35.         boolean loginKey = jedisFactory.selectLoginKey(userPhone, password);
    36.         if (loginKey) {
    37.             return index_user(userPhone);
    38.         } else {
    39.             boolean loginUser = userService.loginUser(userPhone, password);
    40.             if (loginUser) {
    41.                 return index_user(userPhone);
    42.             }
    43.         }
    44.         return loginF();
    45.     }
    46.  
    47.     /*主页*/
    48.     @RequestMapping("index_user")
    49.     public ModelAndView index_user(String userPhone) {
    50.         List<Good> goodList = userService.findAllGood();
    51.         ModelAndView modelAndView = new ModelAndView();
    52.         modelAndView.addObject("goodList", goodList);
    53.         modelAndView.addObject("userPhone", userPhone);
    54.         modelAndView.setViewName("/index/user/index");
    55.         return modelAndView;
    56.     }
    57.  
    58.     @RequestMapping("index_user_return/{userPhone}")
    59.     public ModelAndView index_user_return(@PathVariable("userPhone") String userPhone) {
    60.         List<Good> goodList = userService.findAllGood();
    61.         ModelAndView modelAndView = new ModelAndView();
    62.         modelAndView.addObject("goodList", goodList);
    63.         modelAndView.addObject("userPhone", userPhone);
    64.         modelAndView.setViewName("/index/user/index");
    65.         return modelAndView;
    66.     }
    67.  
    68.     /*用户查看个人信息*/
    69.     @RequestMapping("find_user/{userPhone}")
    70.     public ModelAndView find_user(@PathVariable("userPhone") String userPhone) {
    71.         int id = userService.findUserIdByUserPhone(userPhone);
    72.         User user = userService.findUserById(id);
    73.         ModelAndView modelAndView = new ModelAndView();
    74.         modelAndView.addObject("User", user);
    75.         modelAndView.addObject("userPhone", userPhone);
    76.         modelAndView.setViewName("/index/user/find_user");
    77.         return modelAndView;
    78.     }
    79.  
    80.     /*用户修改个人信息*/
    81.     @RequestMapping("update_userF/{userPhone}")
    82.     public ModelAndView update_userF(@PathVariable("userPhone") String userPhone) {
    83.         ModelAndView modelAndView = new ModelAndView();
    84.         modelAndView.addObject("userPhone", userPhone);
    85.         modelAndView.setViewName("index/user/update_user");
    86.         return modelAndView;
    87.     }
    88.  
    89.     @RequestMapping("update_user/{userPhone}")
    90.     public ModelAndView update_user(@PathVariable("userPhone") String userPhone, @RequestParam("userNickname") String userNickname, @RequestParam("userSex") char userSex,
    91.                                     @RequestParam("userHead") String userHead, @RequestParam("userBrith") String userBrith,
    92.                                     @RequestParam("userAddress") String userAddress, @RequestParam("userRegister") String userRegister, @RequestParam("password") String password) {
    93.         int id = userService.findUserIdByUserPhone(userPhone);
    94.         boolean flag = userService.refineUser(id, userNickname, userSex, userHead, userBrith, userAddress, userRegister, password);
    95.         if (flag)
    96.             return find_user(userPhone);
    97.         else
    98.             return update_userF(userPhone);
    99.     }
    100.  
    101.     /*查看订单*/
    102.     @RequestMapping("older_user_list/{userPhone}")
    103.     public ModelAndView older_user_list(@PathVariable("userPhone") String userPhone) {
    104.         int id = userService.findUserIdByUserPhone(userPhone);
    105.         List<Older> olderList = shopService.findOlderByUserId(id);
    106.         ModelAndView modelAndView = new ModelAndView();
    107.         modelAndView.addObject("userPhone", userPhone);
    108.         modelAndView.addObject("olderList", olderList);
    109.         modelAndView.setViewName("/List/older_user_list");
    110.         return modelAndView;
    111.     }
    112.  
    113.     /*用户下单弹窗*/
    114.     @RequestMapping("older_user_addF/{userPhone}")
    115.     public ModelAndView older_user_addF(@PathVariable("userPhone") String userPhone) {
    116.         ModelAndView modelAndView = new ModelAndView();
    117.         modelAndView.addObject("userPhone", userPhone);
    118.         modelAndView.setViewName("/index/user/older_user_add");
    119.         return modelAndView;
    120.     }
    121.  
    122.     @RequestMapping("older_user_add/{userPhone}")
    123.     public ModelAndView older_user_add(@PathVariable("userPhone") String userPhone,
    124.                                        @RequestParam("olderGoodId") int olderGoodId, @RequestParam("olderGoodNumber") int olderGoodNumber,
    125.                                        @RequestParam("olderAddress") String olderAddress, @RequestParam("olderGoHomeTime") String olderGoHomeTime, @RequestParam("date") String date) {
    126.         int shopId = shopService.findShopIdByGoodId(olderGoodId);
    127.         int userId = userService.findUserIdByUserPhone(userPhone);
    128.         boolean state = false;
    129.         boolean saveOlder = userService.saveOlder(userId, olderGoodId, olderGoodNumber, olderAddress, olderGoHomeTime, state, date, shopId);
    130.         if (saveOlder)
    131.             return older_user_list(userPhone);
    132.         else
    133.             return older_user_addF(userPhone);
    134.     }
    135.  
    136.     /*用户取消订单*/
    137.     @RequestMapping("del_older_user/{olderId}")
    138.     public ModelAndView del_older_user(@PathVariable("olderId") Integer olderId) {
    139.         int userId = userService.findUserIdByOlderId(olderId);
    140.         String userPhone = userService.findUserPhoneByUserId(userId);
    141.         boolean deleteOlder = userService.deleteOlder(olderId);
    142.         if (deleteOlder)
    143.             return older_user_list(userPhone);
    144.         else
    145.             return older_user_list(userPhone);
    146.     }
    147.     /*用户确认付款（跳转网址定位http://192.168.10.105:8081/order/form）*/
    148.  
    149.     /*用户查询商品按照商品名称，模糊查询*/
    150.     /*用户查询订单按照日期查询*/
    151. }

    shopController

    1. @RestController
    2. @RequestMapping("Shop")
    3. public class ShopController {
    4.  
    5.     @Autowired
    6.     private ShopService shopService;
    7.     @Autowired
    8.     private UserService userService;
    9.     @Autowired
    10.     private JedisFactory jedisFactory;
    11.  
    12.     /*注册*/
    13.     @RequestMapping("register")
    14.     public ModelAndView registerF() {
    15.         return new ModelAndView("register/register_shop");
    16.     }
    17.  
    18.     @PostMapping("register_shop")
    19.     public ModelAndView registerShop(String shopPhone, String password) {
    20.         boolean registerShop = shopService.registerShop(shopPhone, password);
    21.         if (registerShop)
    22.             return loginF();
    23.         return registerF();
    24.     }
    25.  
    26.     /*登录*/
    27.     @RequestMapping("login")
    28.     public ModelAndView loginF() {
    29.         return new ModelAndView("login/login_shop");
    30.     }
    31.  
    32.     @PostMapping("login_shop")
    33.     public ModelAndView loginShop(String shopPhone, String password) {
    34.         boolean loginKey = jedisFactory.selectLoginKey(shopPhone, password);
    35.         if (loginKey) {
    36.             return index_shop(shopPhone);
    37.         } else {
    38.             boolean loginShop = shopService.loginShop(shopPhone, password);
    39.             if (loginShop)
    40.                 return index_shop(shopPhone);
    41.         }
    42.         return loginF();
    43.  
    44.     }
    45.  
    46.     /*商家主页数据加载与渲染*/
    47.     @RequestMapping("index_shop")
    48.     public ModelAndView index_shop(String shopPhone) {
    49.         int id = shopService.findShopIdByShopPhone(shopPhone);
    50.         List<Good> goodList = shopService.findGoodByShopId(id);
    51.         ModelAndView modelAndView = new ModelAndView();
    52.         modelAndView.addObject("shopPhone", shopPhone);
    53.         modelAndView.addObject("goodList", goodList);
    54.         modelAndView.setViewName("index/shop/index");
    55.         return modelAndView;
    56.     }
    57.  
    58.     /*跳转返回主页用，时刻拿着一个令牌*/
    59.     @RequestMapping("index_shop_return/{shopPhone}")
    60.     public ModelAndView index_shop_return(@PathVariable("shopPhone") String shopPhone) {
    61.         List<Good> goodList = shopService.findGoodByShopId(shopService.findShopIdByShopPhone(shopPhone));
    62.         ModelAndView modelAndView = new ModelAndView();
    63.         modelAndView.addObject("shopPhone", shopPhone);
    64.         modelAndView.addObject("goodList", goodList);
    65.         modelAndView.setViewName("index/shop/index");
    66.         return modelAndView;
    67.     }
    68.  
    69.     /*主页面添加商品*/
    70.     @RequestMapping("add_goodF/{shopPhone}")
    71.     public ModelAndView add_goodF(@PathVariable("shopPhone") String shopPhone) {
    72.         ModelAndView modelAndView = new ModelAndView();
    73.         modelAndView.addObject("shopPhone", shopPhone);
    74.         modelAndView.setViewName("index/shop/add_good");
    75.         return modelAndView;
    76.     }
    77.  
    78.     /*单个商品添加*/
    79.     @RequestMapping("add_good/{shopPhone}")
    80.     public ModelAndView add_good(@PathVariable("shopPhone") String shopPhone, @RequestParam("goodName") String goodName, @RequestParam("goodInPrice") Integer goodInPrice, @RequestParam("goodOutPrice") Integer goodOutPrice, @RequestParam("goodReserve") Integer goodReserve, @RequestParam("goodExTime") String goodExTime, @RequestParam("goodProduct") String goodProduct, @RequestParam("goodShopId") Integer goodShopId) {
    81.         boolean saveGood = shopService.saveGood(goodName, goodInPrice, goodOutPrice, goodReserve, goodExTime, goodProduct, goodShopId);
    82.         if (saveGood) {
    83.             return index_shop(shopPhone);
    84.         }
    85.         return good_shop_list(shopPhone);
    86.     }
    87.  
    88.     /*文件导入添加*/
    89.     @RequestMapping("add_good_file/{shopPhone}")
    90.     public ModelAndView add_good_file(@RequestParam("file") MultipartFile file, @PathVariable("shopPhone") String shopPhone) {
    91.         boolean saveGoodByFile = shopService.saveGoodByFile(file);
    92.         if (saveGoodByFile) {
    93.             return index_shop(shopPhone);
    94.         }
    95.         return good_shop_list(shopPhone);
    96.     }
    97.  
    98.     /*商家货架数据加载与渲染*/
    99.     @RequestMapping("good_shop_list/{shopPhone}")
    100.     public ModelAndView good_shop_list(@PathVariable("shopPhone") String shopPhone) {
    101.         ModelAndView modelAndView = new ModelAndView();
    102.         int id = shopService.findShopIdByShopPhone(shopPhone);
    103.         List<Good> goodList = shopService.findGoodByShopId(id);
    104.         modelAndView.addObject("shopPhone", shopPhone);
    105.         modelAndView.addObject("goodList", goodList);
    106.         modelAndView.setViewName("List/good_shop_list");
    107.         return modelAndView;
    108.     }
    109.  
    110.     /*删除商品*/
    111.     @RequestMapping("delete_good/{goodId}")
    112.     public ModelAndView delete_good(@PathVariable("goodId") Integer goodId) {
    113.         int shopId = shopService.findShopIdByGoodId(goodId);
    114.         boolean deleteGood = shopService.deleteGood(goodId);
    115.         String shopPhone = shopService.findShopPhoneByShopId(shopId);
    116.         /*这里需要加上一个删除失败的跳转逻辑*/
    117.         return good_shop_list(shopPhone);
    118.     }
    119.  
    120.     /*商家订单统计页面的查看*/
    121.     @RequestMapping("older_shop_list/{shopPhone}")
    122.     public ModelAndView older_shop_list(@PathVariable("shopPhone") String shopPhone) {
    123.         ModelAndView modelAndView = new ModelAndView();
    124.         int id = shopService.findShopIdByShopPhone(shopPhone);
    125.         List<Older> olderList = shopService.findOlderByShopId(id);
    126.         modelAndView.addObject("shopPhone", shopPhone);
    127.         modelAndView.addObject("olderList", olderList);
    128.         modelAndView.setViewName("List/older_shop_list");
    129.         return modelAndView;
    130.     }
    131.  
    132.     /*商家查询自己的商品按照商品名称查询*/
    133.     @RequestMapping("shop_findGoodByGoodName/{shopPhone}")
    134.     public ModelAndView shop_shop_findGoodByName(@RequestParam("goodName") String goodName, @PathVariable("shopPhone") String shopPhone) {
    135.         /*模糊查询，手动拼接*/
    136.         List<Good> goodList = userService.findGoodByName("%" + goodName + "%");
    137.         if (goodList != null) {
    138.             ModelAndView modelAndView = new ModelAndView();
    139.             modelAndView.addObject("goodList", goodList);
    140.             modelAndView.addObject("shopPhone", shopPhone);
    141.             modelAndView.setViewName("List/good_shop_list");
    142.             return modelAndView;
    143.         }
    144.         return index_shop(shopPhone);
    145.     }
    146.  
    147.     /*商家搜索订单按照用户ID*/
    148.     @RequestMapping("older_shop_list_select/{shopPhone}")
    149.     public ModelAndView shop_findOlderByUserId(@RequestParam("userId") Integer userId, @PathVariable("shopPhone") String shopPhone) {
    150.         List<Older> olderList = shopService.findOlderByUserId(userId);
    151.         if (olderList != null) {
    152.             ModelAndView modelAndView = new ModelAndView();
    153.             modelAndView.addObject("olderList", olderList);
    154.             modelAndView.addObject("shopPhone", shopPhone);
    155.             modelAndView.setViewName("List/older_shop_list");
    156.             return modelAndView;
    157.         }
    158.         return older_shop_list(shopPhone);
    159.     }
    160.  
    161.     /*商家调整价格窗口的弹出*/
    162.     @RequestMapping("update_good_priceF/{shopPhone}")
    163.     public ModelAndView update_good_priceF(@PathVariable("shopPhone") String shopPhone) {
    164.         ModelAndView modelAndView = new ModelAndView();
    165.         modelAndView.addObject("shopPhone", shopPhone);
    166.         modelAndView.setViewName("index/shop/update_good_price");
    167.         return modelAndView;
    168.     }
    169.  
    170.     @RequestMapping("update_good_price/{shopPhone}")
    171.     public ModelAndView update_good_price(@PathVariable("shopPhone") String shopPhone, @RequestParam("goodId") Integer goodId, @RequestParam("goodName") String goodName, @RequestParam("goodPrice") Integer goodPrice) {
    172.         boolean inSuPriceByGoodId = shopService.inSuPriceByGood_id(goodId, goodPrice);
    173.         if (inSuPriceByGoodId)
    174.             return good_shop_list(shopPhone);
    175.         return update_good_priceF(shopPhone);
    176.     }
    177.  
    178.     /*商家进货窗口弹出*/
    179.     @RequestMapping("add_good_numberF/{shopPhone}")
    180.     public ModelAndView add_good_numberF(@PathVariable("shopPhone") String shopPhone) {
    181.         ModelAndView modelAndView = new ModelAndView();
    182.         modelAndView.addObject("shopPhone", shopPhone);
    183.         modelAndView.setViewName("index/shop/add_good_number");
    184.         return modelAndView;
    185.     }
    186.  
    187.     @RequestMapping("add_good_number/{shopPhone}")
    188.     public ModelAndView add_good_number(@PathVariable("shopPhone") String shopPhone, @RequestParam("goodId") Integer goodId, @RequestParam("goodName") String goodName, @RequestParam("goodNumber") Integer goodNumber) {
    189.         boolean addGoodNumber = shopService.addGood_number(goodId, goodNumber, goodName);
    190.         if (addGoodNumber)
    191.             return good_shop_list(shopPhone);
    192.         System.out.println("----------------进货操作失败-------------------");
    193.         return add_good_numberF(shopPhone);
    194.     }
    195.  
    196.     /*商家查看自家店铺信息*/
    197.     @RequestMapping("find_shop/{shopPhone}")
    198.     public ModelAndView find_shop(@PathVariable("shopPhone") String shopPhone) {
    199.         int id = shopService.findShopIdByShopPhone(shopPhone);
    200.         Shop shop = shopService.findShopById(id);
    201.         ModelAndView modelAndView = new ModelAndView();
    202.         modelAndView.addObject("Shop", shop);
    203.         modelAndView.setViewName("index/shop/find_shop");
    204.         return modelAndView;
    205.     }
    206.  
    207.     @RequestMapping("update_shopF/{shopPhone}")
    208.     public ModelAndView update_shopF(@PathVariable("shopPhone") String shopPhone) {
    209.         ModelAndView modelAndView = new ModelAndView();
    210.         modelAndView.setViewName("index/shop/update_shop");
    211.         modelAndView.addObject("shopPhone", shopPhone);
    212.         return modelAndView;
    213.     }
    214.  
    215.     @RequestMapping("update_shop/{shopPhone}")
    216.     public ModelAndView update_shopInfo(@PathVariable("shopPhone") String shopPhone, @RequestParam("shopNickname") String shopNickname
    217.             , @RequestParam("shopAddress") String shopAddress, @RequestParam("shopOwner") String shopOwner
    218.             , @RequestParam("password") String password, @RequestParam("shopInfo") String shopInfo) {
    219.         int id = shopService.findShopIdByShopPhone(shopPhone);
    220.         boolean refineShop = shopService.refineShop(shopNickname, shopAddress, shopOwner, shopInfo, id);
    221.         boolean updateShopPassword = shopService.updateShopPassword(id, password);
    222.         if (refineShop && updateShopPassword) {
    223.             return index_shop(shopPhone);
    224.         }
    225.         return update_shopF(shopPhone);
    226.     }
    227.  
    228.     /*注销商家*/
    229.  
    230. }

    辅助组件

    redis组件

    1、jedisUtils

    1. /*redis生成连接池JedisPool的配置工具*/
    2. public class JedisUntil {
    3.  
    4.     private static JedisPool jedisPool = null;
    5.  
    6.     public static JedisPool getJedisPoolFactory() {
    7.  
    8.         if (jedisPool == null) {
    9.             synchronized (JedisUntil.class) {
    10.                 if (jedisPool == null) {
    11.                     JedisPoolConfig jedisPoolConfig = new JedisPoolConfig();
    12.                     jedisPoolConfig.setMaxIdle(32);
    13.                     jedisPoolConfig.setMaxTotal(200);
    14.                     jedisPoolConfig.setTestOnBorrow(false);
    15.                     jedisPoolConfig.setBlockWhenExhausted(true);
    16.  
    17.                     jedisPool = new JedisPool(jedisPoolConfig, "192.168.20.150", 6379);
    18.                 }
    19.             }
    20.         }
    21.         return jedisPool;
    22.     }
    23.  
    24.     public void release(Jedis jedis, JedisPool jedisPool) {
    25.         if (jedisPool != null) {
    26.             jedis.close();
    27.         }
    28.     }
    29. }

    2、jedisFactory

    1. /*创建jedis生成工厂为我们创建jedis对象并操作redis数据库*/
    2. @Component
    3. public class JedisFactory {
    4.  
    5.     static JedisPool jedisPool = JedisUntil.getJedisPoolFactory();
    6.     static Jedis jedis = jedisPool.getResource();
    7.  
    8.     /*登录走redis，第一次登录即将它加入redis数据库（用 phone-password 键值对存储）*/
    9.     public void addLoginKey(String shopPhone, String password) {
    10.         jedis.auth("hlc");
    11.         jedis.setex(shopPhone, 120, password);
    12.         jedis.close();
    13.     }
    14.  
    15.     public boolean selectLoginKey(String shopPhone, String password) {
    16.         jedis.auth("hlc");
    17.         String V = jedis.get(shopPhone);
    18.         if (V != null) {
    19.             System.out.println("走缓存登录");
    20.             jedis.close();
    21.             return true;
    22.         } else {
    23.             addLoginKey(shopPhone, password);
    24.             selectLoginKey(shopPhone, password);
    25.         }
    26.         jedis.close();
    27.         return false;
    28.     }
    29.  
    30.     public boolean addGoodHostKey(int goodId) {
    31.         Long i = null;
    32.         jedis.auth("hlc");
    33.         i = jedis.zadd("hostGood", Double.parseDouble("1"), String.valueOf(goodId));
    34.         jedis.close();
    35.         return i != null;
    36.     }
    37.  
    38.     /*访问一次就给该商品的热度增加1*/
    39.     public boolean incrGoodHostKeyValue(int goodId) {
    40.         jedis.auth("hlc");
    41.         Long i = null;
    42.         i = jedis.zrank("hostGood", String.valueOf(goodId));
    43.         if (i != null) {
    44.             jedis.zincrby("hostGood", 1, String.valueOf(goodId));
    45.             jedis.close();
    46.             return true;
    47.         }
    48.         return addGoodHostKey(goodId);
    49.     }
    50.  
    51.     /*当商品下架时要删除热度*/
    52.     public boolean delGoodHostKey(int goodId) {
    53.         jedis.auth("hlc");
    54.         Long i = null;
    55.         i = jedis.zrem("host", String.valueOf(goodId));
    56.         jedis.close();
    57.         return i != null;
    58.     }
    59.  
    60.     /*c查询热度在10以上的商品排行*/
    61.     public List<Integer> selectHostGoodKey() {
    62.         jedis.auth("hlc");
    63.         Set<String> set = jedis.zrangeByScore("hostGood", 10, 1000);
    64.         List<Integer> hostList = new ArrayList<>();
    65.         for (String i : set) {
    66.             hostList.add(Integer.valueOf(i));
    67.         }
    68.         jedis.close();
    69.         System.out.println("走缓存查看热度商品");
    70.         return hostList;
    71.     }
    72. }

     文件导入自定义的Excel解析组件

    1. /*文件导入解析数据实现货物的批量导入*/
    2. @Component
    3. public class FileOption {
    4.  
    5.     public List<Good> fileOptions(MultipartFile file) {
    6.  
    7.         List<Good> goodArrayList = new ArrayList<>();
    8.  
    9.         /*获取文件名*/
    10.         String fileName = file.getOriginalFilename();
    11.         /*获取文件后缀*/
    12.         String suffix = fileName.substring(fileName.lastIndexOf(".") + 1);
    13.         /*创建文件输入流对象*/
    14.         InputStream ins = null;
    15.         try {
    16.             ins = file.getInputStream();
    17.         } catch (IOException e) {
    18.             System.out.println("文件导入异常");
    19.             e.printStackTrace();
    20.         }
    21.         /*获取工作薄对象*/
    22.         Workbook wb = null;
    23.         try {
    24.             /*根据文件类型将文件输入流对象给到工作薄对象的内容里去*/
    25.             if (suffix.equals("xlsx")) {
    26.                 wb = new XSSFWorkbook(ins);
    27.             } else {
    28.                 wb = new HSSFWorkbook(ins);
    29.             }
    30.         } catch (IOException e) {
    31.             e.printStackTrace();
    32.             System.out.println("文件版本识别异常");
    33.         }
    34.  
    35.         /*获取excel表单*/
    36.         Sheet sheet = wb.getSheetAt(0);
    37.  
    38.         /* line = 2 :从表的第三行开始获取记录*/
    39.         if (null != sheet) {
    40.             for (int line = 2; line <= sheet.getLastRowNum(); line++) {
    41.                 /*创建对象，封装数据*/
    42.                 Good good = new Good();
    43.                 /*创建行对象，便于逐行操作单元格*/
    44.                 Row row = sheet.getRow(line);
    45.                 if (null == row) {
    46.                     continue;
    47.                 }
    48.                 /* 判断单元格类型是否为文本类型 */
    49.                 if (1 != row.getCell(0).getCellType()) {
    50.                     System.out.println("单元格类型不是文本类型");
    51.                 }
    52.                 /*获取第一个单元格的内容并设置对象的属性*/
    53.                 row.getCell(0).setCellType(Cell.CELL_TYPE_NUMERIC);
    54.                 Integer good_id = (int) row.getCell(0).getNumericCellValue();
    55.                 good.setGoodId(good_id);
    56.                 /* 获取第二个单元格的内容并设置对象的属性*/
    57.                 row.getCell(1).setCellType(Cell.CELL_TYPE_STRING);
    58.                 String good_name = row.getCell(1).getStringCellValue();
    59.                 good.setGoodName(good_name);
    60.                 /*获取第三个单元格内容并设置对象的属性*/
    61.                 row.getCell(2).setCellType(Cell.CELL_TYPE_NUMERIC);
    62.                 Integer good_inPrice = (int) row.getCell(2).getNumericCellValue();
    63.                 good.setGoodInPrice(good_inPrice);
    64.                 /*获取第四行数据并设置对象属性*/
    65.                 row.getCell(3).setCellType(Cell.CELL_TYPE_NUMERIC);
    66.                 Integer good_outPrice = (int) row.getCell(3).getNumericCellValue();
    67.                 good.setGoodOutPrice(good_outPrice);
    68.                 /*获取第五单元格并设置对象属性*/
    69.                 row.getCell(4).setCellType(Cell.CELL_TYPE_NUMERIC);
    70.                 Integer good_reserve = (int) row.getCell(4).getNumericCellValue();
    71.                 good.setGoodReserve(good_reserve);
    72.                 /*获取第六单元格并设置对象属性*/
    73.                 String good_product = String.valueOf(row.getCell(5).getDateCellValue());
    74.                 good.setGoodProduct(good_product);
    75.                 /*获取第七单元格并设置对象属性*/
    76.                 String good_exTime = String.valueOf(row.getCell(6).getDateCellValue());
    77.                 good.setGoodExTime(good_exTime);
    78.                 /*获取第八单元格并设置对象属性*/
    79.                 Integer good_shop_id = (int) row.getCell(7).getNumericCellValue();
    80.                 good.setGoodShopId(good_shop_id);
    81.                 /*将这个对象插入List容器里*/
    82.                 goodArrayList.add(good);
    83.             }
    84.         }
    85.         return goodArrayList;
    86.     }
    87. }

    MD5加密组件

    1. /*加密算法：MD5加密的使用，主要是二次加密加盐的技术*/
    2. @Component
    3. public class MD5 {
    4.  
    5.     public static String slat = "1a2b3c4d";
    6.  
    7.     public String md5_hlc(String src) {
    8.         return DigestUtils.md5Hex(src);
    9.     }
    10.  
    11.     /*前端加密的步骤与这一样，注意盐的位置与盐的值*/
    12.     public String inputPassToFromPass(String inputPass) {
    13.         String slat = "java_secKill";
    14.         String str = slat.charAt(0) +
    15.                 slat.charAt(1) + inputPass +
    16.                 slat.charAt(2);
    17.         return md5_hlc(str);
    18.     }
    19.  
    20.     public String PassToDbPass(String FromPass, String slat) {
    21.         String str = slat.charAt(2) +
    22.                 slat.charAt(1) + FromPass +
    23.                 slat.charAt(0);
    24.         return md5_hlc(str);
    25.  
    26.     }
    27.  
    28.     public String inputPassToDbPass(String inputPass) {
    29.         String fromPass = inputPassToFromPass(inputPass);
    30.         return PassToDbPass(fromPass, slat);
    31.     }
    32.  
    33.     /*测试加密技术*/
    34.     /*444bcbf09f10ee179b8c8d52bf834033（数据库昵称：小年 的实体密码 / 前端加密出现的加密后密码）*/
    35.     /*经过加密之后的密码因该不是这个，原始的密码经过MD5加密之后就发生了加密变化*/
    36. //    public static void main(String[] args) {
    37. //        MD5 m1 = new MD5();
    38. //        System.out.println(m1.inputPassToFromPass("hlc123"));
    39. //        System.out.println(m1.PassToDbPass(m1.inputPassToFromPass("hlc123"), slat));
    40. //
    41. //    }
    42.  
    43. }

    时间矫正组件（解决系统时间与数据库时间格式与时区不一致问题）

    1. /*
    2.  * 日期矫正组件：java提取系统时间可能会减少8小时，由于时区问题，所以需要将时区调整到东八区，
    3.  * 另外数据库日期格式可能与java封装工具包可能存在差异，所以需要转换格式。
    4.  * */
    5. @Component
    6. public class TimeC {
    7.  
    8.     public String getSystemTime() throws ParseException {
    9.         SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm");
    10.         sdf.setTimeZone(TimeZone.getTimeZone("GMT+8"));
    11.         Date date = sdf.parse(sdf.format(new Date()));
    12.         return date.toString();
    13.     }
    14.  
    15. }

     前端页面

    需要的评论区留言我会回复的。

    application.yml文件

    1. spring:
    2.   application:
    3.     #应用名
    4.     name: SecKill
    5.   datasource:
    6.     name: defaultDataSource
    7.     driver-class-name: com.mysql.cj.jdbc.Driver
    8.     url: jdbc:mysql://localhost:3306/ncds?serverTimezone=UTC
    9.     username: root
    10.     password: 123456
    11.     #数据库连接池
    12.     druid:
    13.       name: NCDS
    14.       min-idle: 32
    15.       max-active: 100
    16.       default-auto-commit: true
    17.       max-wait: 3000
    18.   mvc:
    19.     static-path-pattern: /static/**
    20.  
    21.   thymeleaf:
    22.     #是否利用缓存
    23.     cache: false
    24.     mode: HTML5
    25.   redis:
    26.     host: 192.168.20.150
    27.     port: 6379
    28.     password: hlc
    29.     database: 1
    30.     jedis:
    31.       pool:
    32.         max-idle: 32
    33.         max-wait: 3000
    34.         min-idle: 8
    35.         max-active: 20
    36.  
    37. server:
    38.   port: 8080
    39.

    pom文件

    1.  <dependencies>
    2.         <!--跳转模板引擎-->
    3.         <dependency>
    4.             <groupId>org.springframework.boot</groupId>
    5.             <artifactId>spring-boot-starter-thymeleaf</artifactId>
    6.         </dependency>
    7.         <!--springMVC-->
    8.         <dependency>
    9.             <groupId>org.springframework.boot</groupId>
    10.             <artifactId>spring-boot-starter-web</artifactId>
    11.         </dependency>
    12.         <!--mybatis plus 依赖与代码生成器依赖-->
    13.         <dependency>
    14.             <groupId>com.baomidou</groupId>
    15.             <artifactId>mybatis-plus-boot-starter</artifactId>
    16.             <version>3.5.2</version>
    17.         </dependency>
    18.         <!--mysql数据库驱动-->
    19.         <dependency>
    20.             <groupId>mysql</groupId>
    21.             <artifactId>mysql-connector-java</artifactId>
    22.             <scope>runtime</scope>
    23.         </dependency>
    24.         <!--数据库连接池-->
    25.         <dependency>
    26.             <groupId>com.alibaba</groupId>
    27.             <artifactId>druid-spring-boot-starter</artifactId>
    28.             <version>1.2.8</version>
    29.         </dependency>
    30.         <!--lombok开发插件-->
    31.         <dependency>
    32.             <groupId>org.projectlombok</groupId>
    33.             <artifactId>lombok</artifactId>
    34.             <optional>true</optional>
    35.         </dependency>
    36.         <!--测试-->
    37.         <dependency>
    38.             <groupId>org.springframework.boot</groupId>
    39.             <artifactId>spring-boot-starter-test</artifactId>
    40.             <scope>test</scope>
    41.             <exclusions>
    42.                 <exclusion>
    43.                     <groupId>org.junit.vintage</groupId>
    44.                     <artifactId>junit-vintage-engine</artifactId>
    45.                 </exclusion>
    46.             </exclusions>
    47.         </dependency>
    48.         <!--md5依赖-->
    49.         <dependency>
    50.             <groupId>commons-codec</groupId>
    51.             <artifactId>commons-codec</artifactId>
    52.         </dependency>
    53.         <dependency>
    54.             <groupId>org.apache.commons</groupId>
    55.             <artifactId>commons-lang3</artifactId>
    56.             <version>3.12.0</version>
    57.         </dependency>
    58.         <!--redis数据库-->
    59.         <dependency>
    60.             <groupId>org.springframework.boot</groupId>
    61.             <artifactId>spring-boot-starter-data-redis</artifactId>
    62.         </dependency>
    63.         <dependency>
    64.             <groupId>org.apache.commons</groupId>
    65.             <artifactId>commons-pool2</artifactId>
    66.             <version>2.11.1</version>
    67.         </dependency>
    68.         <dependency>
    69.             <groupId>redis.clients</groupId>
    70.             <artifactId>jedis</artifactId>
    71.         </dependency>
    72.         <!--文件导入依赖-->
    73.         <dependency>
    74.             <groupId>org.apache.poi</groupId>
    75.             <artifactId>poi</artifactId>
    76.             <version>3.15</version>
    77.         </dependency>
    78.         <dependency>
    79.             <groupId>org.apache.poi</groupId>
    80.             <artifactId>poi-ooxml</artifactId>
    81.             <version>3.15</version>
    82.         </dependency>
    83.         <dependency>
    84.             <groupId>commons-fileupload</groupId>
    85.             <artifactId>commons-fileupload</artifactId>
    86.             <version>1.3.1</version>
    87.         </dependency>
    88.         <dependency>
    89.             <groupId>commons-io</groupId>
    90.             <artifactId>commons-io</artifactId>
    91.             <version>2.4</version>
    92.         </dependency>
    93.     </dependencies>

    支付端口呢？当然是在我上一篇文章里了！那个就是解决支付实现的模块代码。

  • 相关阅读:
    c++ 动态分配内存
    剑指offer 04. 替换空格
    Unity3D TCP网络通讯核心意涵与基本原理详解
    计算机毕业设计（附源码）python疫情信息管理系统
    你有多了解Shiro认证-SSM？
    【云原生】五年博主教你用阿里云Serverless免费额度搭建个人应用服务, 还不赶快上车。
    springboot毕设项目大学生创新项目运维系统9y232（java+VUE+Mybatis+Maven+Mysql）
    Day10—SQL那些事（特殊场景的查询）
    android开发使用OkHttp自带的WebSocket实现IM功能
    基础算法--区间合并
  • 原文地址：https://blog.csdn.net/m0_59588838/article/details/125453402