1. 后台数据
t_vue_user
t_vue_tree_node
t_vue_articles
2. 动态生成NavMenu导航菜单(只支持2级菜单)
后台重要代码:
TreeNodeDao
public class TreeNodeDao extends BaseDao {
private static final long serialVersionUID = 1297339130752837659L;
public void add(TreeNode treeNode) {
this.getHibernateTemplate().save(treeNode);
}
public List<TreeNode> list(){
return (List<TreeNode>) this.getHibernateTemplate().execute(new HibernateCallback<List<TreeNode>>() {
@Override
public List<TreeNode> doInHibernate(Session session) throws HibernateException {
List<TreeNode> list = (List<TreeNode>) session.createQuery("from TreeNode where treeNodeType=1").list();
// for (TreeNode treeNode : list) {
// Hibernate.initialize(treeNode.getChildren());
// }
return list;
}
});
}
public class TreeNodeAction extends BaseAction{
private static final long serialVersionUID = 1L;
private TreeNodeBiz treeNodeBiz;
public TreeNodeBiz getTreeNodeBiz() {
return treeNodeBiz;
}
public void setTreeNodeBiz(TreeNodeBiz treeNodeBiz) {
this.treeNodeBiz = treeNodeBiz;
}
public String execute() {
ObjectMapper om = new ObjectMapper();
List<TreeNode> list = this.treeNodeBiz.list();
JsonData jsonData = new JsonData(1, "操作成功", list);
try {
ResponseUtil.write(response, om.writeValueAsString(jsonData));
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
}
前端:
LeftNav.vue
<template>
<el-menu router :default-active="$route.path" class="el-menu-vertical-demo" background-color="#334157"
text-color="#fff" active-text-color="#ffd04b" :collapse="collapsed">
<!-- <el-menu default-active="2" :collapse="collapsed" collapse-transition router :default-active="$route.path" unique-opened class="el-menu-vertical-demo" background-color="#334157" text-color="#fff" active-text-color="#ffd04b"> -->
<div class="logobox">
<img class="logoimg" src="../assets/img/logo.png" alt="">
</div>
<!-- 注意 index是必填的属性
1.index可以看成ID,也就是说他是唯一的
2.它代表路由的跳转路径
-->
<el-submenu :index="'id_'+m.treeNodeId" v-for="m in menus">
<template slot="title">
<i :class="m.icon"></i>
<span>{{m.treeNodeName}}</span>
</template>
<el-menu-item :key="'id_'+m2.treeNodeId" :index="m2.url" v-for="m2 in m.children">
<template slot="title">
<i :class="m2.icon"></i>
<span>{{m2.treeNodeName}}</span>
</template>
</el-menu-item>
</el-submenu>
</el-submenu>
</el-menu>
</template>
<script>
export default {
data(){
return{
collapsed:false,
menus:[]
}
},
created(){
this.$root.Bus.$on("collapsed-side",(v)=>{
this.collapsed= v;
});
let url=this.axios.urls.SYSTEM_MENU_TREE;
this.axios.post(url,{}).then((response)=>{
console.log(response);
this.menus=response.data.result;
}).catch((response)=>{
console.log(response);
});
}
}
</script>
<style>
.el-menu-vertical-demo:not(.el-menu--collapse) {
width: 240px;
min-height: 400px;
}
.el-menu-vertical-demo:not(.el-menu--collapse) {
border: none;
text-align: left;
}
.el-menu-item-group__title {
padding: 0px;
}
.el-menu-bg {
background-color: #1f2d3d !important;
}
.el-menu {
border: none;
}
.logobox {
height: 40px;
line-height: 40px;
color: #9d9d9d;
font-size: 20px;
text-align: center;
padding: 20px 0px;
}
.logoimg {
height: 40px;
}
</style>
注1:要实现路由跳转,先要在el-menu标签上添加router属性,然后只要在每个el-menu-item标签内
的index属性设置一下url即可实现点击el-menu-item实现路由跳转。
注2:导航当前项,在el-menu标签中绑定 :default-active="
r
o
u
t
e
.
p
a
t
h
"
,
注
意
是
绑
定
属
性
,
不
要
忘
了
加
“
:
”
,
当
route.path",注意是绑定属性, 不要忘了加“:”,当
route.path",注意是绑定属性,不要忘了加“:”,当route.path等于el-menu-item标签中的index属性值时则该item为当前项。
注3:后台t_tree_node表有几个节点的url为空,则会导致几个节点样式会一致
3 数据表格
后端:
ArticleDao
public List<Article> list(Article article,PageBean pageBean) {
BaseDao obj = this;
return (List<Article>) this.getHibernateTemplate().execute(new HibernateCallback<List<Article>>() {
@Override
public List<Article> doInHibernate(Session session) throws HibernateException {
String hql = "from Article";
Map<String, Object> map = new HashMap<>();
if (StringUtils.isNotBlank(article.getTitle())) {
hql += " where title like :title";
map.put("title", "%"+article.getTitle()+"%");
}
return obj.executeQuery(session, hql, map, pageBean);
}
});
}
public int save(Article article) {
return (int) this.getHibernateTemplate().save(article);
}
public int update(Article article) {
this.getHibernateTemplate().update(article);
return article.getId();
}
public void del(Article article) {
this.getHibernateTemplate().delete(article);
}
}
ArticleAction
public class ArticleAction extends BaseAction implements ModelDriven<Article>{
private ArticleBiz articleBiz;
private Article article = new Article();
public ArticleBiz getArticleBiz() {
return articleBiz;
}
public void setArticleBiz(ArticleBiz articleBiz) {
this.articleBiz = articleBiz;
}
public String list() {
PageBean pageBean = new PageBean();
pageBean.setRequest(request);
ObjectMapper om = new ObjectMapper();
try {
List<Article> list = this.articleBiz.list(article, pageBean);
JsonData jsonData = new JsonData(1, "操作成功", list);
jsonData.put("pageBean", pageBean);
ResponseUtil.write(response, om.writeValueAsString(jsonData));
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
前端:
Articles.vue
<template>
<div>
<!-- 搜索筛选 -->
<el-form :inline="true" :model="formInline" class="user-search">
<el-form-item label="搜索:">
<el-input size="small" v-model="formInline.title" placeholder="输入文章标题"></el-input>
</el-form-item>
<el-form-item>
<el-button size="small" type="primary" icon="el-icon-search" @click="search">搜索</el-button>
</el-form-item>
</el-form>
<!-- 列表 -->
<el-table size="small" :data="listData" border element-loading-text="拼命加载中" style="width: 100%;">
<el-table-column sortable prop="id" label="ID" width="300">
</el-table-column>
<el-table-column sortable prop="title" label="文章标题" width="300">
</el-table-column>
<el-table-column sortable prop="boby" label="文章内容" width="300">
<!-- <template slot-scope="scope">
<div>{{scope.row.editTime|timestampToTime}}</div>
</template> -->
</el-table-column>
<!-- <el-table-column sortable prop="editUser" label="修改人" width="300">
</el-table-column> -->
<!-- <el-table-column align="center" label="操作" min-width="300">
<template slot-scope="scope">
<el-button size="mini" @click="handleEdit(scope.$index, scope.row)">编辑</el-button>
<el-button size="mini" type="danger" @click="deleteUser(scope.$index, scope.row)">删除</el-button>
</template>
</el-table-column> -->
</el-table>
<!-- 分页条 -->
<el-pagination style="margin-top: 20px;" @size-change="handleSizeChange" @current-change="handleCurrentChange"
:current-page="formInline.page" :page-sizes="[10, 20, 30, 50]" :page-size="formInline.rows" layout="total, sizes, prev, pager, next, jumper"
:total="total">
</el-pagination>
</div>
</template>
<script>
export default {
data() {
return {
listData:[],
total:0,
formInline:{
title:'',
page:1,
rows:10,
total:0
}
};
},
methods:{
search(){
this.doSearch(this.formInline);
},
doSearch(params){
let url=this.axios.urls.SYSTEM_ARTICLE_LIST;
this.axios.post(url,params).then((response)=>{
console.log(response);
this.listData=response.data.result;
this.total=response.data.pageBean.total;
}).catch((response)=>{
console.log(response);
});
},
handleSizeChange(rows) {
console.log('页码大小发生改变的时候触发!');
this.formInline.page = 1;
this.formInline.rows = rows;
this.search();
},
handleCurrentChange(page) {
console.log('当前页页码发生改变的时候触发!');
this.formInline.page = page;
this.search();
}
},
created(){
this.doSearch({});
}
}
</script>
<style>
</style>
附录一:vue中如何修改[数组中][对象的值]
data:{
empList:[{eid:1,ename:‘zs’},{eid:2,ename:‘ls’}]
}
this.empList[0].ename=“zss”;//vue 中是无法检测到根据索引值修改的数据变动的
解决方案:通过Vue数组变异方法可以动态控制数据的增减
// 第一个参数是要修改的数据, 第二个值是修改当前数组的哪一个字段,第三个是要修改为什么值
this.$set(this.empList[index], ‘ename’, ‘zss’)
或者
Vue.set(this.empList[index], ‘ename’, ‘zss’)
4.分页条
后端:
PageBean 分页
public class PageBean {
private int page = 1;// 页码
private int rows = 10;// 页大小
private int total = 0;// 总记录数
private boolean pagination = true;// 是否分页
// 获取前台向后台提交的所有参数
private Map<String, String[]> parameterMap;
// 获取上一次访问后台的url
private String url;
/**
* 初始化pagebean
*
* @param req
*/
public void setRequest(HttpServletRequest req) {
this.setPage(req.getParameter("page"));
this.setRows(req.getParameter("rows"));
// 只有jsp页面上填写pagination=false才是不分页
this.setPagination(!"fasle".equals(req.getParameter("pagination")));
this.setParameterMap(req.getParameterMap());
this.setUrl(req.getRequestURL().toString());
}
public int getMaxPage() {
return this.total % this.rows == 0 ? this.total / this.rows : this.total / this.rows + 1;
}
public int nextPage() {
return this.page < this.getMaxPage() ? this.page + 1 : this.getMaxPage();
}
public int previousPage() {
return this.page > 1 ? this.page - 1 : 1;
}
public PageBean() {
super();
}
public int getPage() {
return page;
}
public void setPage(int page) {
this.page = page;
}
public void setPage(String page) {
this.page = StringUtils.isBlank(page) ? this.page : Integer.valueOf(page);
}
public int getRows() {
return rows;
}
public void setRows(int rows) {
this.rows = rows;
}
public void setRows(String rows) {
this.rows = StringUtils.isBlank(rows) ? this.rows : Integer.valueOf(rows);
}
public int getTotal() {
return total;
}
public void setTotal(int total) {
this.total = total;
}
public void setTotal(String total) {
this.total = Integer.parseInt(total);
}
public boolean isPagination() {
return pagination;
}
public void setPagination(boolean pagination) {
this.pagination = pagination;
}
public Map<String, String[]> getParameterMap() {
return parameterMap;
}
public void setParameterMap(Map<String, String[]> parameterMap) {
this.parameterMap = parameterMap;
}
public String getUrl() {
return url;
}
public void setUrl(String url) {
this.url = url;
}
/**
* 获得起始记录的下标
*
* @return
*/
public int getStartIndex() {
return (this.page - 1) * this.rows;
}
@Override
public String toString() {
return "PageBean [page=" + page + ", rows=" + rows + ", total=" + total + ", pagination=" + pagination
+ ", parameterMap=" + parameterMap + ", url=" + url + "]";
}
}
前端:
<!-- 分页条 -->
<el-pagination style="margin-top: 20px;" @size-change="handleSizeChange" @current-change="handleCurrentChange"
:current-page="formInline.page" :page-sizes="[10, 20, 30, 50]" :page-size="formInline.rows" layout="total, sizes, prev, pager, next, jumper"
:total="total">
</el-pagination>
</div>
</template>
<script>
export default {
data() {
return {
listData:[],
total:0,
formInline:{
title:'',
page:1,
rows:10,
total:0
}
};
},
methods:{
search(){
this.doSearch(this.formInline);
},
doSearch(params){
let url=this.axios.urls.SYSTEM_ARTICLE_LIST;
this.axios.post(url,params).then((response)=>{
console.log(response);
this.listData=response.data.result;
this.total=response.data.pageBean.total;
}).catch((response)=>{
console.log(response);
});
},
handleSizeChange(rows) {
console.log('页码大小发生改变的时候触发!');
this.formInline.page = 1;
this.formInline.rows = rows;
this.search();
},
handleCurrentChange(page) {
console.log('当前页页码发生改变的时候触发!');
this.formInline.page = page;
this.search();
}
},
created(){
this.doSearch({});
}
}
</script>
<style>
</style>