当前位置：首页 > news >正文

制作一个网站建设网站得多少钱

news 2025/10/29 0:53:47

制作一个网站,建设网站得多少钱,徐州建站服务,免费海外网络连接器数据库结构用的是若依的数据库基本结构,ruoyi.vip。总体参考了文章#xff1a;https://blog.csdn.net/qq_45847507/article/details/126681110 本文章只包含不同的地方#xff0c;相同的不再赘述。 1、创建spring工程#xff0c;jdk1.8#xff0c;maven。 pom.xml中依赖部…数据库结构用的是若依的数据库基本结构,ruoyi.vip。总体参考了文章https://blog.csdn.net/qq_45847507/article/details/126681110 本文章只包含不同的地方相同的不再赘述。 1、创建spring工程jdk1.8maven。 pom.xml中依赖部分的文件内容 dependenciesdependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter/artifactId/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-test/artifactIdscopetest/scope/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-logging/artifactId/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-web/artifactId/dependencydependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactId/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-security/artifactId/dependency!--redis依赖--dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-data-redis/artifactId/dependency!--fastjson依赖--dependencygroupIdcom.alibaba/groupIdartifactIdfastjson/artifactIdversion1.2.33/version/dependency!--jwt依赖--dependencygroupIdio.jsonwebtoken/groupIdartifactIdjjwt/artifactIdversion0.9.0/version/dependencydependencygroupIdcom.baomidou/groupIdartifactIdmybatis-plus-boot-starter/artifactIdversion3.4.3/version/dependencydependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactId/dependencydependencygroupIdjunit/groupIdartifactIdjunit/artifactIdscopetest/scope/dependency/dependencies2、application.yml的文件内容 spring:datasource:driver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://localhost:3306/mall?serverTimezoneGMT%2B8useUnicodetruecharacterEncodingUTF-8username: rootpassword: rootredis:# Redis服务器地址host: 127.0.0.1# Redis服务器连接端口port: 6379# Redis服务器连接密码password: 123456# Redis数据库索引database: 3# 连接超时时间毫秒timeout: 30000lettuce:pool:max-active: 50max-wait: -1max-idle: 50min-idle: 1logging:level:root: info3、实体类 LoginUser.java package com.rainpet.springsecurity.entity;import com.alibaba.fastjson.annotation.JSONField; import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor; import org.springframework.security.core.GrantedAuthority; import org.springframework.security.core.authority.SimpleGrantedAuthority; import org.springframework.security.core.userdetails.UserDetails;import java.util.Collection; import java.util.List; import java.util.stream.Collectors;Data NoArgsConstructor public class LoginUser implements UserDetails {private SysUser user;//存储权限信息private ListString permissions;public LoginUser(SysUser user,ListString permissions) {this.user user;this.permissions permissions;}//存储SpringSecurity所需要的权限信息的集合JSONField(serialize false)private ListGrantedAuthority authorities;Overridepublic Collection? extends GrantedAuthority getAuthorities() {if(authorities!null){return authorities;}//把permissions中字符串类型的权限信息转换成GrantedAuthority对象存入authorities中authorities permissions.stream().map(SimpleGrantedAuthority::new).collect(Collectors.toList());return authorities;}Overridepublic String getPassword() {return user.getPassword();}Overridepublic String getUsername() {return user.getUserName();}Overridepublic boolean isAccountNonExpired() {return true;}Overridepublic boolean isAccountNonLocked() {return true;}Overridepublic boolean isCredentialsNonExpired() {return true;}Overridepublic boolean isEnabled() {return true;} } SysMenu.java package com.rainpet.springsecurity.entity;import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor;import java.io.Serializable; import java.time.LocalDateTime;/*** 菜单权限表(SysMenu)实体类**/ Data AllArgsConstructor NoArgsConstructor TableName(value sys_menu) public class SysMenu implements Serializable {private static final long serialVersionUID -40356785423868312L;/*** 菜单ID*/TableIdprivate Long menuId;/*** 菜单名称*/private String menuName;/*** 父菜单ID*/private Long parentId;/*** 显示顺序*/private Integer orderNum;/*** 路由地址*/private String path;/*** 组件路径*/private String component;/*** 路由参数*/private String query;/*** 路由名称*/private String routeName;/*** 是否为外链0是 1否*/private Boolean isFrame;/*** 是否缓存0缓存 1不缓存*/private Boolean isCache;/*** 菜单类型M目录 C菜单 F按钮*/private String menuType;/*** 菜单状态0显示 1隐藏*/private String visible;/*** 菜单状态0正常 1停用*/private String status;/*** 权限标识*/private String perms;/*** 菜单图标*/private String icon;/*** 创建者*/private String createBy;/*** 创建时间*/private LocalDateTime createTime;/*** 更新者*/private String updateBy;/*** 更新时间*/private LocalDateTime updateTime;/*** 备注*/private String remark; } SysRole.java package com.rainpet.springsecurity.entity;import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor;import java.io.Serializable; import java.time.LocalDateTime;/*** 角色信息表(SysRole)实体类**/ Data AllArgsConstructor NoArgsConstructor TableName(value sys_role) public class SysRole implements Serializable {private static final long serialVersionUID -40356785423868312L;/*** 角色ID*/TableIdprivate Long roleId;/*** 角色名称*/private String roleName;/*** 角色权限字符串*/private String roleKey;/*** 显示顺序*/private Integer roleSort;/*** 数据范围1全部数据权限 2自定数据权限 3本部门数据权限 4本部门及以下数据权限*/private String dataScope;/*** 菜单树选择项是否关联显示*/private Boolean menuCheckStrictly;/*** 部门树选择项是否关联显示*/private Boolean deptCheckStrictly;/*** 角色状态0正常 1停用*/private String status;/*** 删除标志0代表存在 2代表删除*/private String delFlag;/*** 创建者*/private String createBy;/*** 创建时间*/private LocalDateTime createTime;/*** 更新者*/private String updateBy;/*** 更新时间*/private LocalDateTime updateTime;/*** 备注*/private String remark; } SysUser.java package com.rainpet.springsecurity.entity;import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor;import java.io.Serializable; import java.time.LocalDateTime;/*** 用户信息表(SysUser)实体类**/ Data AllArgsConstructor NoArgsConstructor TableName(value sys_user) public class SysUser implements Serializable {private static final long serialVersionUID -40356785423868312L;/*** 用户ID*/TableIdprivate Long userId;/*** 部门ID*/private Long deptId;/*** 用户账号*/private String userName;/*** 用户昵称*/private String nickName;/*** 用户类型00系统用户*/private String userType;/*** 用户邮箱*/private String email;/*** 手机号码*/private String phonenumber;/*** 用户性别0男 1女 2未知*/private String sex;/*** 头像地址*/private String avatar;/*** 密码*/private String password;/*** 帐号状态0正常 1停用*/private String status;/*** 删除标志0代表存在 2代表删除*/private String delFlag;/*** 最后登录IP*/private String loginIp;/*** 最后登录时间*/private LocalDateTime loginDate;/*** 创建者*/private String createBy;/*** 创建时间*/private LocalDateTime createTime;/*** 更新者*/private String updateBy;/*** 更新时间*/private LocalDateTime updateTime;/*** 备注*/private String remark; } 4、mapper SysMenuMapper.java package com.rainpet.springsecurity.mapper;import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.rainpet.springsecurity.entity.SysMenu; import org.apache.ibatis.annotations.Mapper;import java.util.List;Mapper public interface SysMenuMapper extends BaseMapperSysMenu {ListString selectPermsByUserId(Long id); } SysRoleMapper.java package com.rainpet.springsecurity.mapper;import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.rainpet.springsecurity.entity.SysRole; import org.apache.ibatis.annotations.Mapper;Mapper public interface SysRoleMapper extends BaseMapperSysRole {} SysUserMapper.java package com.rainpet.springsecurity.mapper;import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.rainpet.springsecurity.entity.SysUser; import org.apache.ibatis.annotations.Mapper;Mapper public interface SysUserMapper extends BaseMapperSysUser {} 5、其他问题 SysMenuMapper.xml ?xml version1.0 encodingUTF-8 ? !DOCTYPE mapper PUBLIC -//mybatis.org//DTD Mapper 3.0//EN http://mybatis.org/dtd/mybatis-3-mapper.dtd mapper namespacecom.rainpet.springsecurity.mapper.SysMenuMapperselect idselectPermsByUserId resultTypejava.lang.StringSELECTDISTINCT (case when m.perms then path else m.perms end)FROMsys_user_role urLEFT JOIN sys_role r ON ur.role_id r.role_idLEFT JOIN sys_role_menu rm ON ur.role_id rm.role_idLEFT JOIN sys_menu m ON m.menu_id rm.menu_idWHEREuser_id #{userid}/select /mapper
文章转载自：
http://www.morning.nmwgd.cn.gov.cn.nmwgd.cn
http://www.morning.rfycj.cn.gov.cn.rfycj.cn
http://www.morning.ybgt.cn.gov.cn.ybgt.cn
http://www.morning.ubpsa.cn.gov.cn.ubpsa.cn
http://www.morning.cniedu.com.gov.cn.cniedu.com
http://www.morning.jfcbz.cn.gov.cn.jfcbz.cn
http://www.morning.rkdw.cn.gov.cn.rkdw.cn
http://www.morning.dighk.com.gov.cn.dighk.com
http://www.morning.xsbhg.cn.gov.cn.xsbhg.cn
http://www.morning.zbnkt.cn.gov.cn.zbnkt.cn
http://www.morning.swbhq.cn.gov.cn.swbhq.cn
http://www.morning.fglyb.cn.gov.cn.fglyb.cn
http://www.morning.fthqc.cn.gov.cn.fthqc.cn
http://www.morning.srbmc.cn.gov.cn.srbmc.cn
http://www.morning.pslzp.cn.gov.cn.pslzp.cn
http://www.morning.hwcln.cn.gov.cn.hwcln.cn
http://www.morning.yjtnc.cn.gov.cn.yjtnc.cn
http://www.morning.tgczj.cn.gov.cn.tgczj.cn
http://www.morning.fsrtm.cn.gov.cn.fsrtm.cn
http://www.morning.twdkt.cn.gov.cn.twdkt.cn
http://www.morning.lwlnw.cn.gov.cn.lwlnw.cn
http://www.morning.qrlkt.cn.gov.cn.qrlkt.cn
http://www.morning.knmp.cn.gov.cn.knmp.cn
http://www.morning.rnytd.cn.gov.cn.rnytd.cn
http://www.morning.jpkk.cn.gov.cn.jpkk.cn
http://www.morning.jxcwn.cn.gov.cn.jxcwn.cn
http://www.morning.ffcsr.cn.gov.cn.ffcsr.cn
http://www.morning.dkcpt.cn.gov.cn.dkcpt.cn
http://www.morning.xbyyd.cn.gov.cn.xbyyd.cn
http://www.morning.xjkfb.cn.gov.cn.xjkfb.cn
http://www.morning.qmrsf.cn.gov.cn.qmrsf.cn
http://www.morning.tnwgc.cn.gov.cn.tnwgc.cn
http://www.morning.kxqpm.cn.gov.cn.kxqpm.cn
http://www.morning.kpbgp.cn.gov.cn.kpbgp.cn
http://www.morning.pwggd.cn.gov.cn.pwggd.cn
http://www.morning.nckzt.cn.gov.cn.nckzt.cn
http://www.morning.tsdqr.cn.gov.cn.tsdqr.cn
http://www.morning.plchy.cn.gov.cn.plchy.cn
http://www.morning.bplqh.cn.gov.cn.bplqh.cn
http://www.morning.yrmpr.cn.gov.cn.yrmpr.cn
http://www.morning.gtbjf.cn.gov.cn.gtbjf.cn
http://www.morning.qjtbt.cn.gov.cn.qjtbt.cn
http://www.morning.lchtb.cn.gov.cn.lchtb.cn
http://www.morning.rzbgn.cn.gov.cn.rzbgn.cn
http://www.morning.qzglh.cn.gov.cn.qzglh.cn
http://www.morning.npmx.cn.gov.cn.npmx.cn
http://www.morning.dgfpp.cn.gov.cn.dgfpp.cn
http://www.morning.ygztf.cn.gov.cn.ygztf.cn
http://www.morning.rgpbk.cn.gov.cn.rgpbk.cn
http://www.morning.ktmbp.cn.gov.cn.ktmbp.cn
http://www.morning.hlzpb.cn.gov.cn.hlzpb.cn
http://www.morning.bqwrn.cn.gov.cn.bqwrn.cn
http://www.morning.shuanga.com.cn.gov.cn.shuanga.com.cn
http://www.morning.wglhz.cn.gov.cn.wglhz.cn
http://www.morning.yjfmj.cn.gov.cn.yjfmj.cn
http://www.morning.krzrg.cn.gov.cn.krzrg.cn
http://www.morning.pmjw.cn.gov.cn.pmjw.cn
http://www.morning.hkng.cn.gov.cn.hkng.cn
http://www.morning.gstg.cn.gov.cn.gstg.cn
http://www.morning.zlfxp.cn.gov.cn.zlfxp.cn
http://www.morning.jqhrk.cn.gov.cn.jqhrk.cn
http://www.morning.xbyyd.cn.gov.cn.xbyyd.cn
http://www.morning.gqnll.cn.gov.cn.gqnll.cn
http://www.morning.bcjbm.cn.gov.cn.bcjbm.cn
http://www.morning.demoux.com.gov.cn.demoux.com
http://www.morning.drqrl.cn.gov.cn.drqrl.cn
http://www.morning.hflrz.cn.gov.cn.hflrz.cn
http://www.morning.bpmfg.cn.gov.cn.bpmfg.cn
http://www.morning.ktcfl.cn.gov.cn.ktcfl.cn
http://www.morning.jqbmj.cn.gov.cn.jqbmj.cn
http://www.morning.tqbyw.cn.gov.cn.tqbyw.cn
http://www.morning.qzpkr.cn.gov.cn.qzpkr.cn
http://www.morning.rjnrf.cn.gov.cn.rjnrf.cn
http://www.morning.sxmbk.cn.gov.cn.sxmbk.cn
http://www.morning.rrxmm.cn.gov.cn.rrxmm.cn
http://www.morning.fsjcn.cn.gov.cn.fsjcn.cn
http://www.morning.zsgbt.cn.gov.cn.zsgbt.cn
http://www.morning.qfgxk.cn.gov.cn.qfgxk.cn
http://www.morning.prmbn.cn.gov.cn.prmbn.cn
http://www.morning.zdsqb.cn.gov.cn.zdsqb.cn

查看全文

http://www.tj-hxxt.cn/news/258120.html