非织梦做的网站能仿吗,郑州手机网站推广公司,企业 官网,wordpress模板在哪里买目录
1.框架搭建
2.前端搭建
3.后端编写 需求#xff1a;完成简单的连表条件查询以及添加即可 1.框架搭建 1.创建springboot项目 2.相关依赖 !--web依赖--dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boo…目录
1.框架搭建
2.前端搭建
3.后端编写 需求完成简单的连表条件查询以及添加即可 1.框架搭建 1.创建springboot项目 2.相关依赖 !--web依赖--dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-web/artifactId/dependency!--mysql依赖--dependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdscoperuntime/scope/dependency!--lombok依赖--dependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactIdoptionaltrue/optional/dependency!--MyBatis-plus依赖--dependencygroupIdcom.baomidou/groupIdartifactIdmybatis-plus-boot-starter/artifactIdversion3.5.1/version/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-test/artifactIdscopetest/scope/dependency 3.配置文件 #数据源信息
spring.datasource.driver-class-namecom.mysql.cj.jdbc.Driver
spring.datasource.urljdbc:mysql://localhost:3306/db_saas_fbms?serverTimezoneAsia/ShanghaicharacterEncodingUTF8
spring.datasource.usernameroot
spring.datasource.password123456789
#指定映射文件的路径--链表操作
mybatis-plus.mapper-locationsclasspath:/mapper/*.xml
#sql日志
mybatis-plus.configuration.log-implorg.apache.ibatis.logging.stdout.StdOutImpl4.数据库 /*Navicat Premium Data TransferSource Server : wqg1Source Server Type : MySQLSource Server Version : 50731Source Host : localhost:3306Source Schema : db_saas_fbmsTarget Server Type : MySQLTarget Server Version : 50731File Encoding : 65001Date: 25/08/2023 10:20:37
*/SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS 0;-- ----------------------------
-- Table structure for ums_agent
-- ----------------------------
DROP TABLE IF EXISTS ums_agent;
CREATE TABLE ums_agent (id int(11) NOT NULL AUTO_INCREMENT COMMENT 编号,username varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 用户名,levelid int(10) NOT NULL COMMENT 等级编号(外键关联代理商等级表),nickname varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 昵称,phonenum varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 电话,status int(10) NULL DEFAULT NULL COMMENT 账号状态(1正常2禁用),create_time date NULL DEFAULT NULL COMMENT 创建时间,icon varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 头像路径,growth int(10) NULL DEFAULT NULL COMMENT 成长值,integration int(10) NULL DEFAULT NULL COMMENT 积分,PRIMARY KEY (id) USING BTREE
) ENGINE InnoDB AUTO_INCREMENT 3 CHARACTER SET utf8 COLLATE utf8_bin ROW_FORMAT Dynamic;-- ----------------------------
-- Records of ums_agent
-- ----------------------------
INSERT INTO ums_agent VALUES (1, admin01, 1, 代理01, 15346342611, 1, 2023-08-25, www.baidu.com, 100, 10);
INSERT INTO ums_agent VALUES (2, admin02, 2, 代理02, 15346342622, 1, 2023-08-25, www.baidu.com, 100, 10);-- ----------------------------
-- Table structure for ums_agent_level
-- ----------------------------
DROP TABLE IF EXISTS ums_agent_level;
CREATE TABLE ums_agent_level (id int(11) NOT NULL AUTO_INCREMENT COMMENT 编号,name varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 等级名称,note varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 描述说明,growth_point int(10) NULL DEFAULT NULL COMMENT 等级成长值临界点,priviledge_birthday int(10) NULL DEFAULT NULL COMMENT 是否有生日特权,addtime date NULL DEFAULT NULL COMMENT 添加时间,PRIMARY KEY (id) USING BTREE
) ENGINE InnoDB AUTO_INCREMENT 5 CHARACTER SET utf8 COLLATE utf8_bin ROW_FORMAT Dynamic;-- ----------------------------
-- Records of ums_agent_level
-- ----------------------------
INSERT INTO ums_agent_level VALUES (1, 白银, 等级1, 1, NULL, 2023-08-25);
INSERT INTO ums_agent_level VALUES (2, 黄金, 等级2, 1, NULL, 2023-08-25);
INSERT INTO ums_agent_level VALUES (3, 铂金, 等级3, 1, NULL, 2023-08-25);
INSERT INTO ums_agent_level VALUES (4, 王者, 等级4, 1, NULL, 2023-08-25);SET FOREIGN_KEY_CHECKS 1;5.实体类 Data
TableName(value ums_agent)
public class Agent implements Serializable {/*** 编号*/TableId(type IdType.AUTO)private Integer id;/*** 用户名*/private String username;/*** 等级编号(外键关联代理商等级表)*/private Integer levelid;/*** 昵称*/private String nickname;/*** 电话*/private String phonenum;/*** 账号状态(1正常2禁用)*/private Integer status;/*** 创建时间*/private Date createTime ;/*** 头像路径*/private String icon ;/*** 成长值*/private Integer growth;/*** 积分*/private Integer integration;TableField(exist false)private AgentLevel agentLevel;}Data
TableName(value ums_agent_level)
public class AgentLevel implements Serializable {/*** 编号*/TableId(type IdType.AUTO)private Integer id;/*** 等级名称*/private String name;/*** 描述说明*/private String note;/*** 等级成长值临界点*/private Integer growthPoint;/*** 是否有生日特权*/private Integer priviledgeBirthday;/*** 添加时间*/private Date addtime;}2.前端搭建 !DOCTYPE html
html langen
headmeta charsetUTF-8titleTitle/titlescript src/js/jquery.min.js/scriptscript src/js/vue.js/scriptscript src/js/axios.min.js/scriptlink relstylesheet href/css/index.cssscript src/js/index.js/script
/head
bodydiv idappdiv stylewidth: 800px;margin: 0px autoel-input v-modelinput placeholder用户名或者电话 prefix-iconel-icon-searchstylemargin: 0px auto ; width: 400px/el-inputel-button clickfindAll()查询/el-buttonel-button clickopenDialog添加/el-button/div!--布局--divel-table:datatableDatastripeborderstylewidth: 100%:header-cell-style{text-align:center}:cell-style{text-align:center}el-table-columnpropusernamelabel用户名width180/el-table-columnel-table-columnpropnicknamelabel昵称width180/el-table-columnel-table-columnpropagentLevel.namelabel等级width180/el-table-columnel-table-columnpropphonenumlabel电话width180/el-table-columnel-table-column label状态template slot-scopescopespan v-ifscope.row.status1正常/spanspan v-ifscope.row.status2禁用/span/template/el-table-columnel-table-columnpropgrowthlabel成长值width150px/el-table-columnel-table-columnpropintegrationlabel积分/el-table-column/el-table!--添加表单--el-dialog title代理商添加 :visible.syncdialogFormVisibleel-form :modelformInfoel-form-item label用户名el-input v-modelformInfo.username/el-input/el-form-item!--动态下拉选框--el-form-item label等级el-select v-modelformInfo.levelid placeholder请选择el-optionv-foritem in options:keyitem.id:labelitem.name:valueitem.id/el-option/el-select/el-form-itemel-form-item label昵称el-input v-modelformInfo.nickname/el-input/el-form-itemel-form-item label电话el-input v-modelformInfo.phonenum/el-input/el-form-itemel-form-item label积分el-input v-modelformInfo.integration/el-input/el-form-itemel-form-item label成长值el-input v-modelformInfo.growth/el-input/el-form-itemel-form-item label状态el-radio v-modelformInfo.status label1正常/el-radioel-radio v-modelformInfo.status label2禁用/el-radio/el-form-item/el-formdiv slotfooter classdialog-footerel-button clickdialogFormVisible false取 消/el-buttonel-button typeprimary clickinsert确 定/el-button/div/el-dialog/div
/div
/body
scriptlet app new Vue({el: #app,data: {input: ,tableData: [],options: [],dialogFormVisible: false,formInfo: {},},created() {this.findAll();this.findPosition();;},methods: {// 根据状态回显binConter(status) {switch (status) {case 1:return 正常break;case 2:return 禁用break;}},// 打开会话弹框openDialog() {this.dialogFormVisible true;},// 添加insert() {console.log(this.formInfo)axios.post(agent/insert, this.formInfo).then(Result {if (Result.data.code 200) {this.$message.success(添加成功);this.findAll();}})//清空this.formInfo;//关闭this.dialogFormVisible false;},// 查询所有findAll() {console.log(this.input)axios.post(/agent/query?input this.input).then(Result {this.tableData Result.data.data;console.log(this.tableData)})},//查询等级findPosition() {axios.get(/agentLevel/query).then(Result {this.options Result.data.data;})}}})
/script/html3.后端编写 1.设置统一返回类型
NoArgsConstructor
AllArgsConstructor
Data
public class ResultT {//表示状态码private Integer code;//消息提示private String msg;//响应的数据内容private Object data;
} 2.controller层 RestController
RequestMapping(/agent)
public class AgentController {Autowiredprivate AgentService agentService;/*** 查询所有* param input* return*/PostMapping(/query)public ResultListAgent agentList(RequestParam String input) {ListAgent agentList agentService.agentList(input);return new Result(200,成功,agentList);}/*** 添加* param agent* return*/PostMapping(/insert)public Result insert(RequestBody Agent agent){agent.setIcon(www.baidu.com);Date date new Date();agent.setCreateTime(date);boolean save agentService.save(agent);return new Result(200,成功,null);}} RestController
RequestMapping(/agentLevel)
public class AgentLevelController {Autowiredprivate AgentLevelService agentLevelService;/*** 查询等级* return*/GetMapping(/query)public Result select(){return agentLevelService.select();}
}3.service层 public interface AgentService extends IServiceAgent {/*** 查询所有* param input* return*/ListAgent agentList(String input);
}public interface AgentLevelService {/*** 查询等级* return*/Result select();
}5.serviceImpl层 Service
public class AgentServiceImpl extends ServiceImplAgentDao,Agent implements AgentService {Autowiredprivate AgentDao agentDao;/*** 查询所有* param input* return*/Overridepublic ListAgent agentList(String input) {return agentDao.agentList(input);}
}Service
public class AgentLevelServiceImpl implements AgentLevelService {Autowiredprivate AgentLevelDao agentLevelDao;/*** 查询等级* return*/Overridepublic Result select() {ListAgentLevel agentLevels agentLevelDao.selectList(null);return new Result(200,查询成功,agentLevels);}
} 6.dao层 Mapper
public interface AgentDao extends BaseMapperAgent {/*** 查询所有* param input* return*/ListAgent agentList(String input);
}Mapper
public interface AgentLevelDao extends BaseMapper AgentLevel {
}7. ?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.wangqiguang.fbms.dao.AgentDao!--查询所有条件查询--resultMap idagentList01 typecom.wangqiguang.fbms.pojo.Agent autoMappingtrueid propertyid columnid/association propertyagentLevel javaTypecom.wangqiguang.fbms.pojo.AgentLevel autoMappingtrueid propertyid columnid//association/resultMapselect idagentList resultMapagentList01SELECTa.id,a.username,a.levelid,a.nickname,a.phonenum,a.status,a.create_time,a.icon,a.growth,a.integration,e.id,e.name,e.note,e.priviledge_birthday,e.growth_point,e.addtimeFROMums_agent AS aINNER JOINums_agent_level AS eONa.levelid e.idwhereif test input!null and input!a.username like concat(%,#{input},%)ora.phonenum like concat(%,#{input},%)/if/where/select/mapper完成
