SPA项目开发之动态树+数据表格+分页

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 &quot; , 注 意 是 绑 定 属 性 , 不 要 忘 了 加 “ : ” , 当 route.path&quot;,注意是绑定属性, 不要忘了加“:”,当 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>

5.前后端连接运行

在这里插入图片描述

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值