毕设-element ui + springboot + mybatis 单条件查询模板
2021-06-03 14:04
标签:hashmap OLE rri text data HERE func idt warning 毕设-element ui + springboot + mybatis 单条件查询模板 标签:hashmap OLE rri text data HERE func idt warning 原文地址:https://www.cnblogs.com/sk-lqbzblogs/p/14671860.html前端
html
div style="margin-top: 15px">
el-select style="width: 150px" v-model="select" placeholder="请选择">
el-option label="歌手列表" value="list">el-option>
el-option label="歌手名" value="singer_name">el-option>
el-select>
el-input
placeholder="请输入内容"
v-model="query_name"
class="input-with-select"
:clearable="true"
@clear="query_clear"
style="width: 550px"
:disabled="select === ‘list‘ ? true : false"
>
el-input>
el-button
type="primary"
icon="el-icon-search"
@click="handleSearch"
:disabled="select === ‘list‘ ? true : false"
>搜索el-button
>
div>
//分页
div class="pagination">
el-pagination
background
layout="prev, pager, next"
:current-page="pagination.pageIndex"
:page-size="pagination.pageSize"
:total="pageTotal"
@current-change="handlePageChange"
>el-pagination>
div>
js
//清除输入框内容
query_clear() {
this.freshList();
this.pageTotal = 1;
this.select = "list";
this.pagination.pageIndex = 1;
},
// 触发搜索按钮
handleSearch() {
this.pagination.pageIndex = 1;
this.query();
},
query() {
let text = this.query_name;
let query_mode = this.select;
let _this = this;
// this.pagination.pageIndex = 1;
if (text != "") {
if (query_mode === "singer_name") {
this.$axios
.get(
"http://localhost:8181/admin/singer/findBySingerName/" +
(_this.pagination.pageIndex - 1) * _this.pagination.pageSize +
"/" +
_this.pagination.pageSize +
"/" +
text
)
.then(function (resp) {
console.log(resp);
switch (resp.data.status) {
case 200: {
_this.pageTotal = resp.data.data.singerCount;
_this.current_list = resp.data.data.singerList;
_this.$message.success("查找成功!");
break;
}
case 400: {
_this.$message.error(resp.data.msg);
_this.$router.push("login");
break;
}
}
});
}
}
else{
this.$message.warning("请输入内容!");
}
},
},
// 分页导航
handlePageChange(val) {
console.log("handlePageChange",val);
this.pagination.pageIndex = val;
this.current_list = [];
if (this.select != "list") {
if(this.query_name != ‘‘){
this.query();
}
else{
this.pageTotal = 1;
}
} else {
this.freshList();
}
},
后端
controller
//查询歌曲:歌手名
@GetMapping({"/admin/music/findBySingerName/{currentPage}/{pageSize}/{singer_name}"})
public Result findBySingerName(@PathVariable Integer currentPage, @PathVariable Integer pageSize,@PathVariable String singer_name){
MyParameter parameter = new MyParameter();
parameter.setSinger_name(singer_name);
return musicService.findBySingerName(currentPage,pageSize,parameter);
}
service
@Override
public Result findBySingerName(Integer cp, Integer ps, MyParameter myParameter){
Map
mapper
select id="getMusicByParameter" resultType="map">
select s.singer_name,m.id, m.music_name, m.music_lyrics
, m.music_createdate as music_createDate,m.music_src
, m.music_photosrc as music_photoSrc , m.music_introduction, m.music_class,
m.music_downloadscore as music_downloadScore, m.musicvideo_id, m.singer_id
from music m,singer s
where>
if test="parameter.singer_name != null">
s.singer_name like "%"#{parameter.singer_name}"%" and
if>
if test="parameter.music_name != null">
m.music_name like "%"#{parameter.music_name}"%" and
if>
m.singer_id = s.id
where>
limit #{currentPage},#{pageSize}
select>
上一篇:Java方法
文章标题:毕设-element ui + springboot + mybatis 单条件查询模板
文章链接:http://soscw.com/index.php/essay/90061.html