框架
环境搭建
(1)pom.xml
(注意，mysql版本请与自己的相匹配)
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>org.example</groupId>
<artifactId>brand-case</artifactId>
<version>1.0-SNAPSHOT</version>
<packaging>war</packaging>
<properties>
<maven.compiler.source>8</maven.compiler.source>
<maven.compiler.target>8</maven.compiler.target>
</properties>
<dependencies>
<!--Servlet-->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
<scope>provided</scope>
</dependency>
<!--MyBatis-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.5</version>
</dependency>
<!--MySQL-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.28</version>
</dependency>
<!--fastjson-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.62</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.apache.tomcat.maven</groupId>
<artifactId>tomcat7-maven-plugin</artifactId>
<version>2.2</version>
</plugin>
</plugins>
</build>
</project>(2)实体类下的Brand类
package com.itheima.pojo;
public class Brand {
// id 主键
private Integer id;
// 品牌名称
private String brandName;
// 企业名称
private String companyName;
// 排序字段
private Integer ordered;
// 描述信息
private String description;
// 状态：0：禁用 1：启用
private Integer status;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getBrandName() {
return brandName;
}
public void setBrandName(String brandName) {
this.brandName = brandName;
}
public String getCompanyName() {
return companyName;
}
public void setCompanyName(String companyName) {
this.companyName = companyName;
}
public Integer getOrdered() {
return ordered;
}
public void setOrdered(Integer ordered) {
this.ordered = ordered;
}
public String getDescription() {
return description;
}
public void setDescription(String description) {
this.description = description;
}
public Integer getStatus() {
return status;
}
//逻辑视图
public String getStatusStr(){
if (status == null){
return "未知";
}
return status == 0 ? "禁用":"启用";
}
public void setStatus(Integer status) {
this.status = status;
}
@Override
public String toString() {
return "Brand{" +
"id=" + id +
", brandName='" + brandName + '\'' +
", companyName='" + companyName + '\'' +
", ordered=" + ordered +
", description='" + description + '\'' +
", status=" + status +
'}';
}
}
(3) BrandMapper.java 与 BrandMapper.xml
(4)SqlSessionFactoryUtils.java(mybatis-config.xml处是你自己的文件路径)
(5)由于我们在用一种很新的方法写servlet
package com.itheima.web.servlet;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.lang.reflect.InvocationTargetException;
import java.lang.reflect.Method;
/*替换HttpServlet，根据请求路径的最后一段，进行方法分发(get or post)*/
public class BaseServlet extends HttpServlet {
//根据请求路径的最后一行进行分发
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//1.获取请求路径
String uri = req.getRequestURI();/* /brand-case/brand/selectAll */
//2.获取最后一段路径，方法名
int index = uri.lastIndexOf('/');/*从后开始获取某个字符第一次出现的位置索引*/
String methodName = uri.substring(index+1);//从该索引位置进行剪切，至字符串的最有一位(包含'/')
//执行方法
//1.获取brandservlet的字节码对象class
Class<? extends BaseServlet> cls = this.getClass();
//2.获取method对象
try {
Method cm = cls.getMethod(methodName,HttpServletRequest.class,HttpServletResponse.class);
//3.执行方法
try {
cm.invoke(this,req,resp);
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (InvocationTargetException e) {
e.printStackTrace();
}
} catch (NoSuchMethodException e) {
e.printStackTrace();
}
}
}
（6）BrandServletImpl.java 定义接口
package com.itheima.service.impl;
import com.itheima.mapper.BrandMapper;
import com.itheima.pojo.Brand;
import com.itheima.pojo.PageBean;
import com.itheima.service.BrandService;
import com.itheima.util.SqlSessionFactoryUtils;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import java.util.List;
public class BrandServiceImpl implements BrandService {
//1.创建 SqlSessionFactory 工厂
SqlSessionFactory factory = SqlSessionFactoryUtils.getSqlSessionFactory();
}（7）PageBean实体类
package com.itheima.pojo;
import java.util.List;
//分页查询
public class PageBean<T> {
//总记录数
private int totalCount;
//当前页数据
private List<T> rows;
public int getTotalCount() {
return totalCount;
}
public void setTotalCount(int totalCount) {
this.totalCount = totalCount;
}
public List<T> getRows() {
return rows;
}
public void setRows(List<T> rows) {
this.rows = rows;
}
}
(8)查询所有
public interface BrandMapper {
// 查询所有
@Select("select * from tb_brand")
@ResultMap("brandResultMap")
List<Brand> selectAll();
}public class BrandServiceImpl implements BrandService {
//1.创建 SqlSessionFactory 工厂
SqlSessionFactory factory = SqlSessionFactoryUtils.getSqlSessionFactory();
//查询操作
@Override
public List<Brand> selectAll() {
//2.获取SqllSession对象
SqlSession session = factory.openSession();
//3.获取brandmapper
BrandMapper mapper = session.getMapper(BrandMapper.class);
//4.调用方法
List<Brand> brands = mapper.selectAll();
//5.释放资源
session.close();
return brands;
}
}@WebServlet("/brand/*")
public class BrandServlet extends BaseServlet{
private BrandService brandService = new BrandServiceImpl();
public void selectAll(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//1.调用service查询
List<Brand> brands = brandService.selectAll();
//2.转为JSON
String s = JSON.toJSONString(brands);
//3.写数据
//中文
resp.setContentType("text/json;charset=UTF-8");
resp.getWriter().write(s);
}
}//分页条件查询
public void selectByPageAndCondition(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//1. 接收 当前页码 和 每页展示条数 url?currentPage=1&pageSize=5
String _currentPage = request.getParameter("currentPage");
String _pageSize = request.getParameter("pageSize");
int currentPage = Integer.parseInt(_currentPage);
int pageSize = Integer.parseInt(_pageSize);
// 获取查询条件对象
BufferedReader br = request.getReader();
String params = br.readLine();//json字符串
//转为 Brand
Brand brand = JSON.parseObject(params, Brand.class);
//2. 调用service查询
PageBean<Brand> pageBean = brandService.selectByPageAndCondition(currentPage,pageSize,brand);
//2. 转为JSON
String jsonString = JSON.toJSONString(pageBean);
//3. 写数据
response.setContentType("text/json;charset=utf-8");
response.getWriter().write(jsonString);
}//查询分页数据
selectAll(){
//查询所有数据
axios({
method:"post",
url:"http://localhost:8080/brand-case/brand/selectByPageAndCondition?currentPage="+this.currentPage+"&pageSize="+this.pageSize,
data:this.brand
}).then(resp =>{
this.tableData = resp.data.rows;//{rows:[],totalCount:[]}
this.tableCount = resp.data.totalCount;
})
},(9)data(){}
data() {
return {
//默认每页5条数据
pageSize:5,
//总记录数
tableCount:100,
// 当前页码
currentPage: 1,
// 添加数据对话框是否展示的标记
dialogVisible: false,
dialogVisible2: false,
tableData:{},
// 品牌模型数据
brand: {
status: '',
brandName: '',
companyName: '',
id:"",
ordered:"",
description:""
},
// 复选框选中数据集合
multipleSelection: [],
selectByIds:[]
}(10)添加数据
//添加
@Insert("insert into tb_brand values(null,#{brandName},#{companyName},#{ordered},#{description},#{status})")
void add(Brand brand);//添加操作
@Override
public void add(Brand brand) {
//2.获取SqlSession对象
SqlSession session = factory.openSession();
//3.获取brandmapper
BrandMapper mapper = session.getMapper(BrandMapper.class);
//4.调用方法
mapper.add(brand);
session.commit();
session.close();
}public void add(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//接受品牌数据（JSON格式）
BufferedReader br = req.getReader();
String params = br.readLine();//读取一行,JSON全部数据就是一行
//转为Brand对象
Brand brand = JSON.parseObject(params, Brand.class);
//调用service添加
brandService.add(brand);
//响应数据成功的标识
resp.getWriter().write("success");
}
// 添加数据
addBrand(){
// console.log(this.brand);
//添加axios请求，添加数据
var _this = this;
axios({
method:"post",
url:"http://localhost:8080/brand-case/brand/add",
data:_this.brand
}).then(function (resp){
if(resp.data == "success"){
//添加成功
//关闭窗口
_this.dialogVisible = false;
//查询所有
_this.selectAll();
_this.$message({
message:'添加成功了少年郎',
type:'success'
});
}
})
},(11)修改方法
//修改
@Update("update tb_brand set brand_name = #{brandName},company_name = #{companyName},ordered = #{ordered},description = #{description},status = #{status} where id = #{id}")
void update(Brand brand);//修改操作
@Override
public void update(Brand brand){
//获取SQLSession对象
SqlSession session = factory.openSession();
//获取brandmapper
BrandMapper mapper = session.getMapper(BrandMapper.class);
//调用方法
mapper.update(brand);
session.commit();
session.close();
}// 修改
public void update(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//接受品牌数据（JSON格式）
BufferedReader br = req.getReader();
String params = br.readLine();//读取一行,JSON全部数据就是一行
//转为Brand对象
Brand brand = JSON.parseObject(params, Brand.class);
//调用service修改
brandService.update(brand);
resp.getWriter().write("success");
}updateBrand(){
//修改数据
//添加axios请求，添加数据
var _this = this;
axios({
method:"post",
url:"http://localhost:8080/brand-case/brand/update",
data:_this.brand
}).then(function (resp){
if(resp.data == "success"){
//修改成功
//关闭窗口
_this.dialogVisible2 = false;
//查询所有
_this.selectAll();
_this.$message({
message:'修改成功了少年郎',
type:'success'
});
}
})
},(12) 删除方法
//删除
@Delete("delete from tb_brand where id = #{id}")
void deleteById(int id);//删除操作
@Override
public void deleteById(int id){
//获取SQLSession对象
SqlSession session = factory.openSession();
//获取brandmapper
BrandMapper mapper = session.getMapper(BrandMapper.class);
//调用方法
mapper.deleteById(id);
session.commit();
session.close();
}//删除
public void deleteById(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//接受品牌数据（JSON格式）
BufferedReader br = req.getReader();
String params = br.readLine();//读取一行,JSON全部数据就是一行
//转为 int
int id = JSON.parseObject(params,int.class);
//调用service修改
brandService.deleteById(id);
resp.getWriter().write("success");
}//删除数据
deleteById(index,row) {
// 弹出确认提示框
this.$confirm('此操作将删除该数据, 是否继续?', '提示', {
confirmButtonText: '确定',
cancelButtonText: '取消',
type: 'warning'
}).then(() => {
//用户点击确认按钮
//2. 发送AJAX请求
var _this = this;
// 发送ajax请求，添加数据
axios({
method:"post",
url:"http://localhost:8080/brand-case/brand/deleteById",
data:row.id
}).then(function (resp) {
if(resp.data == "success"){
//删除成功
// 重新查询数据
_this.selectAll();
// 弹出消息提示
_this.$message({
message: '删除成功了少年郎',
type: 'success'
});
}
})
}).catch(() => {
//用户点击取消按钮
this.$message({
type: 'info',
message: '已取消删除'
});
});
},(13) 批量删除方法
//批量删除
void deleteByIds(@Param("ids") int[] ids);BrandMapper.xml下添加
<delete id="deleteByIds">
delete from tb_brand where id in
<foreach collection="ids" item="id" separator="," open="(" close=")">
#{id}
</foreach>
</delete>//批量删除操作
@Override
public void deleteByIds(int[] ids){
//获取SQLSession对象
SqlSession session = factory.openSession();
//获取brandmapper
BrandMapper mapper = session.getMapper(BrandMapper.class);
//调用方法
mapper.deleteByIds(ids);
session.commit();
session.close();
}//批量删除
public void deleteByIds(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//接受品牌数据（JSON格式）
BufferedReader br = req.getReader();
String params = br.readLine();//读取一行,JSON全部数据就是一行
//转为Brand对象
int[] ids = JSON.parseObject(params, int[].class);
//调用service修改
brandService.deleteByIds(ids);
resp.getWriter().write("success");
}deleteByIds() {
//console.log(this.multipleSelection);
//1.创建id数组[1,2,3],从multipleSelection模型里面来的数据
this.$confirm('此操作将永久删除该文件, 是否继续?', '提示', {
confirmButtonText: '确定',
cancelButtonText: '取消',
type: 'warning'
}).then(() => {
for (let i = 0; i < this.multipleSelection.length; i++) {
let element = this.multipleSelection[i];
//获取遍历后得到id值
this.selectByIds[i] = element.id;
}
var _this = this;
axios({
method: "post",
url: "http://localhost:8080/brand-case/brand/deleteByIds",
data: _this.selectByIds
}).then(resp => {
if (resp.data == "success") {
//录入成功，关闭窗口,并且重新查询数据
_this.selectAll();
_this.$message({
message: '成功删除数据',
type: 'success'
});
}else{
_this.$message({
message: '没有数据可以删除',
type: 'info'
});
}
})
}).catch(() => {
this.$message({
type: 'info',
message: '已取消删除'
});
});
},
(14)分页查询(和普通查询方法一样会被 “条件分页查询替代” )
//分页查询-查询当前页
@Select("select * from tb_brand limit #{begin} , #{size}")
@ResultMap("brandResultMap")
List<Brand> selectByPage(@Param("begin") int begin,@Param("size") int size);
//分页查询-总记录数
@Select("select count(*) from tb_brand")
int selectTotalCount();@Override
public PageBean<Brand> selectByPage(int currentPage, int pageSize) {
//获取SQLSession对象
SqlSession session = factory.openSession();
//获取brandmapper
BrandMapper mapper = session.getMapper(BrandMapper.class);
//计算开始索引
int begin = (currentPage-1)*pageSize;
//计算总体数据数量
int size = pageSize;
//查询总数
int totalCount = mapper.selectTotalCount();
//调用方法
List<Brand> rows = mapper.selectByPage(begin, size);
//封装函数
PageBean<Brand> pageBean = new PageBean<>();
pageBean.setTotalCount(totalCount);
pageBean.setRows(rows);
session.close();
return pageBean;
}//分页查询
public void selectByPage(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
/*接收参数
* currentPage:当前页码
* PageSize:每页条数
* http://localhost:8080/brand-case/brand/selectByPage?currentPage=1&pageSize=5
* */
String _currentPage = req.getParameter("currentPage");
String _pageSize = req.getParameter("pageSize");
int currentPage = Integer.parseInt(_currentPage);
int pageSize = Integer.parseInt(_pageSize);
//2. 调用service查询
PageBean<Brand> pageBean = brandService.selectByPage(currentPage, pageSize);
//2.转为JSON
String s = JSON.toJSONString(pageBean);
//3.写数据
//中文
resp.setContentType("text/json;charset=UTF-8");
resp.getWriter().write(s);
}
(15)条件分页查询
//条件查询-分页查询
List<Brand> selectByPageAndCondition(@Param("begin") int begin,@Param("size") int size,@Param("brand") Brand brand);
//总记录数-满足查询条件的
int selectTotalCountByCondition(Brand brand);<select id="selectByPageAndCondition" resultMap="brandResultMap">
select *
from tb_brand
<where>
<if test="brand.brandName != null and brand.brandName != '' ">
and brand_name like #{brand.brandName}
</if>
<if test="brand.companyName != null and brand.companyName != '' ">
and company_name like #{brand.companyName}
</if>
<if test="brand.status != null">
and status = #{brand.status}
</if>
</where>
limit #{begin},#{size}
</select>
<select id="selectTotalCountByCondition" resultType="java.lang.Integer">
select count(*)
from tb_brand
<where>
<if test=" brandName != null and brandName != '' ">
and brand_name like #{ brandName}
</if>
<if test=" companyName != null and companyName != '' ">
and company_name like #{ companyName}
</if>
<if test=" status != null">
and status = #{ status}
</if>
</where>
</select>@Override
public PageBean<Brand> selectByPageAndCondition(int currentPage, int pageSize, Brand brand) {
//获取SQLSession对象
SqlSession session = factory.openSession();
//获取brandmapper
BrandMapper mapper = session.getMapper(BrandMapper.class);
//计算开始索引
int begin = (currentPage-1)*pageSize;
//计算总体数据数量
int size = pageSize;
//处理模糊算法
String brandName = brand.getBrandName();
if (brandName != null && brandName.length() > 0){
brand.setBrandName("%"+brandName+"%");
}
String companyName = brand.getCompanyName();
if (companyName != null && companyName.length() > 0){
brand.setCompanyName("%"+companyName+"%");
}
//调用方法
List<Brand> rows = mapper.selectByPageAndCondition(begin, size,brand);
//查询总数
int totalCount = mapper.selectTotalCountByCondition(brand);
//封装函数
PageBean<Brand> pageBean = new PageBean<>();
pageBean.setTotalCount(totalCount);
pageBean.setRows(rows);
session.close();
return pageBean;
}//分页条件查询
public void selectByPageAndCondition(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//1. 接收 当前页码 和 每页展示条数 url?currentPage=1&pageSize=5
String _currentPage = request.getParameter("currentPage");
String _pageSize = request.getParameter("pageSize");
int currentPage = Integer.parseInt(_currentPage);
int pageSize = Integer.parseInt(_pageSize);
// 获取查询条件对象
BufferedReader br = request.getReader();
String params = br.readLine();//json字符串
//转为 Brand
Brand brand = JSON.parseObject(params, Brand.class);
//2. 调用service查询
PageBean<Brand> pageBean = brandService.selectByPageAndCondition(currentPage,pageSize,brand);
//2. 转为JSON
String jsonString = JSON.toJSONString(pageBean);
//3. 写数据
response.setContentType("text/json;charset=utf-8");
response.getWriter().write(jsonString);
}//分页
//每页条数发生变化
handleSizeChange(val) {
// console.log(`每页 ${val} 条`);
//重新设置每页条数
this.pageSize = val;
this.selectAll();
},
//页数发生变化
handleCurrentChange(val) {
// console.log(`当前页: ${val}`);
//重新设置当前页码
this.currentPage = val;
this.selectAll();
}
},（15）总的brand.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
<style>
.el-table .warning-row {
background: oldlace;
}
.el-table .success-row {
background: #f0f9eb;
}
</style>
</head>
<body>
<div id="app">
<!--搜索表单-->
<el-form :inline="true" :model="brand" class="demo-form-inline">
<el-form-item label="当前状态">
<el-select v-model="brand.status" placeholder="当前状态">
<el-option label="启用" value="1"></el-option>
<el-option label="禁用" value="0"></el-option>
</el-select>
</el-form-item>
<el-form-item label="企业名称">
<el-input v-model="brand.companyName" placeholder="企业名称"></el-input>
</el-form-item>
<el-form-item label="品牌名称">
<el-input v-model="brand.brandName" placeholder="品牌名称"></el-input>
</el-form-item>
<el-form-item>
<el-button type="primary" @click="onSubmit">查询</el-button>
</el-form-item>
</el-form>
<!--按钮-->
<el-row>
<el-button type="danger" plain @click="deleteByIds">批量删除</el-button>
<el-button type="primary" plain @click="dialogVisible = true">新增</el-button>
</el-row>
<!--添加数据对话框表单-->
<el-dialog
title="编辑品牌"
:visible.sync="dialogVisible"
width="30%"
>
<el-form ref="form" :model="brand" label-width="80px">
<el-form-item label="品牌名称">
<el-input v-model="brand.brandName"></el-input>
</el-form-item>
<el-form-item label="企业名称">
<el-input v-model="brand.companyName"></el-input>
</el-form-item>
<el-form-item label="排序">
<el-input v-model="brand.ordered"></el-input>
</el-form-item>
<el-form-item label="备注">
<el-input type="textarea" v-model="brand.description"></el-input>
</el-form-item>
<el-form-item label="状态">
<el-switch v-model="brand.status"
active-value="1"
inactive-value="0"
></el-switch>
</el-form-item>
<el-form-item>
<el-button type="primary" @click="addBrand">提交</el-button>
<el-button @click="dialogVisible = false">取消</el-button>
</el-form-item>
</el-form>
</el-dialog>
<!--表格-->
<el-table
:data="tableData"
style="width: 100%"
:row-class-name="tableRowClassName"
@selection-change="handleSelectionChange"
>
<el-table-column
type="selection"
width="55">
</el-table-column>
<el-table-column
type="index"
width="50">
</el-table-column>
<el-table-column
prop="brandName"
label="品牌名称"
align="center"
>
</el-table-column>
<el-table-column
prop="companyName"
label="企业名称"
align="center"
>
</el-table-column>
<el-table-column
prop="ordered"
align="center"
label="排序">
</el-table-column>
<el-table-column
prop="statusStr"
align="center"
label="当前状态">
</el-table-column>
<el-table-column
align="center"
label="操作">
<template slot-scope="scope">
<el-row>
<el-button type="primary" plain @click="updateById(scope.$index, scope.row)">修改</el-button>
<el-button type="danger" plain @click="deleteById(scope.$index, scope.row)">删除</el-button>
</el-row>
<!--修改数据对话框表单-->
<el-dialog
title="编辑品牌"
:visible.sync="dialogVisible2"
width="30%"
>
<el-form ref="form" :model="brand" label-width="80px">
<el-form-item label="品牌名称">
<el-input v-model="brand.brandName"></el-input>
</el-form-item>
<el-form-item label="企业名称">
<el-input v-model="brand.companyName"></el-input>
</el-form-item>
<el-form-item label="排序">
<el-input v-model="brand.ordered"></el-input>
</el-form-item>
<el-form-item label="备注">
<el-input type="textarea" v-model="brand.description"></el-input>
</el-form-item>
<el-form-item label="状态">
<el-switch v-model="brand.status"
active-value="1"
inactive-value="0"
></el-switch>
</el-form-item>
<el-form-item >
<template slot-scope="scope">
<el-button type="primary" @click="updateBrand">提交</el-button>
<el-button @click="dialogVisible2 = false">取消</el-button>
</template>
</el-form-item>
</el-form>
</el-dialog>
</template>
</el-table-column>
</el-table>
<!--分页工具条-->
<el-pagination
@size-change="handleSizeChange"
@current-change="handleCurrentChange"
:current-page="currentPage"
:page-sizes="[5, 10, 15, 20]"
:page-size="5"
layout="total, sizes, prev, pager, next, jumper"
:total="tableCount">
</el-pagination>
</div>
<script src="js/vue.js"></script>
<script src="element-ui/lib/index.js"></script>
<link rel="stylesheet" href="element-ui/lib/theme-chalk/index.css">
<script src="js/axios-0.18.0.js"></script>
<script>
new Vue({
el: "#app",
mounted(){
//页面加载完成之后,发送异步请求，获取数据
this.selectAll();
},
methods: {
//查询分页数据
selectAll(){
//查询所有数据
axios({
method:"post",
url:"http://localhost:8080/brand-case/brand/selectByPageAndCondition?currentPage="+this.currentPage+"&pageSize="+this.pageSize,
data:this.brand
}).then(resp =>{
this.tableData = resp.data.rows;//{rows:[],totalCount:[]}
this.tableCount = resp.data.totalCount;
})
},
tableRowClassName({row, rowIndex}) {
if (rowIndex === 1) {
return 'warning-row';
} else if (rowIndex === 3) {
return 'success-row';
}
return '';
},
// 复选框选中后执行的方法
handleSelectionChange(val) {
this.multipleSelection = val;
// console.log(this.multipleSelection)
},
// 查询方法
onSubmit() {
this.selectAll();
},
// 添加数据
addBrand(){
// console.log(this.brand);
//添加axios请求，添加数据
var _this = this;
axios({
method:"post",
url:"http://localhost:8080/brand-case/brand/add",
data:_this.brand
}).then(function (resp){
if(resp.data == "success"){
//添加成功
//关闭窗口
_this.dialogVisible = false;
//查询所有
_this.selectAll();
_this.$message({
message:'添加成功了少年郎',
type:'success'
});
}
})
},
updateById(index,row) {
this.brand.id = row.id;
this.dialogVisible2 = true;
},
updateBrand(){
//修改数据
//添加axios请求，添加数据
var _this = this;
axios({
method:"post",
url:"http://localhost:8080/brand-case/brand/update",
data:_this.brand
}).then(function (resp){
if(resp.data == "success"){
//修改成功
//关闭窗口
_this.dialogVisible2 = false;
//查询所有
_this.selectAll();
_this.$message({
message:'修改成功了少年郎',
type:'success'
});
}
})
},
//删除数据
deleteById(index,row) {
// 弹出确认提示框
this.$confirm('此操作将删除该数据, 是否继续?', '提示', {
confirmButtonText: '确定',
cancelButtonText: '取消',
type: 'warning'
}).then(() => {
//用户点击确认按钮
//2. 发送AJAX请求
var _this = this;
// 发送ajax请求，添加数据
axios({
method:"post",
url:"http://localhost:8080/brand-case/brand/deleteById",
data:row.id
}).then(function (resp) {
if(resp.data == "success"){
//删除成功
// 重新查询数据
_this.selectAll();
// 弹出消息提示
_this.$message({
message: '删除成功了少年郎',
type: 'success'
});
}
})
}).catch(() => {
//用户点击取消按钮
this.$message({
type: 'info',
message: '已取消删除'
});
});
},
deleteByIds() {
//console.log(this.multipleSelection);
//1.创建id数组[1,2,3],从multipleSelection模型里面来的数据
this.$confirm('此操作将永久删除该文件, 是否继续?', '提示', {
confirmButtonText: '确定',
cancelButtonText: '取消',
type: 'warning'
}).then(() => {
for (let i = 0; i < this.multipleSelection.length; i++) {
let element = this.multipleSelection[i];
//获取遍历后得到id值
this.selectByIds[i] = element.id;
}
var _this = this;
axios({
method: "post",
url: "http://localhost:8080/brand-case/brand/deleteByIds",
data: _this.selectByIds
}).then(resp => {
if (resp.data == "success") {
//录入成功，关闭窗口,并且重新查询数据
_this.selectAll();
_this.$message({
message: '成功删除数据',
type: 'success'
});
}else{
_this.$message({
message: '没有数据可以删除',
type: 'info'
});
}
})
}).catch(() => {
this.$message({
type: 'info',
message: '已取消删除'
});
});
},
//分页
//每页条数发生变化
handleSizeChange(val) {
// console.log(`每页 ${val} 条`);
//重新设置每页条数
this.pageSize = val;
this.selectAll();
},
//页数发生变化
handleCurrentChange(val) {
// console.log(`当前页: ${val}`);
//重新设置当前页码
this.currentPage = val;
this.selectAll();
}
},
data() {
return {
//默认每页5条数据
pageSize:5,
//总记录数
tableCount:100,
// 当前页码
currentPage: 1,
// 添加数据对话框是否展示的标记
dialogVisible: false,
dialogVisible2: false,
tableData:{},
// 品牌模型数据
brand: {
status: '',
brandName: '',
companyName: '',
id:"",
ordered:"",
description:""
},
// 复选框选中数据集合
multipleSelection: [],
selectByIds:[]
}
}
})
</script>
</body>
</html>
版权声明：本文为Yuan_ice原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。