SPA项目开发之CRUD与表单验证

SPA项目开发之CRUD+表单验证

ArticleAction:

package com.xhh.vue.web;

import java.util.List;

import com.fasterxml.jackson.databind.ObjectMapper;
import com.opensymphony.xwork2.ModelDriven;
import com.xhh.base.util.PageBean;
import com.xhh.base.web.BaseAction;
import com.xhh.vue.biz.ArticleBiz;
import com.xhh.vue.entity.Article;
import com.xhh.vue.util.JsonData;
import com.xhh.vue.util.ResponseUtil;

public class ArticleAction extends BaseAction implements ModelDriven<Article>{
	private static final long serialVersionUID = 1L;
	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;
	}
	
	
	public String add() {
		ObjectMapper om = new ObjectMapper();
		try {
			code = this.articleBiz.save(article);
		} catch (Exception e) {
			e.printStackTrace();
			code = 0;
		}finally {
			JsonData jsonData = new JsonData(code, code == 0 ? "新增失败" : "新增成功", code);
			try {
				ResponseUtil.write(response, om.writeValueAsString(jsonData));
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return null;
	}
	
	public String edit() {
		ObjectMapper om = new ObjectMapper();
		try {
			code = this.articleBiz.edit(article);
		} catch (Exception e) {
			e.printStackTrace();
			code = 0;
		}finally {
			JsonData jsonData = new JsonData(code, code == 0 ? "修改失败" : "修改成功", code);
			try {
				ResponseUtil.write(response, om.writeValueAsString(jsonData));
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return null;
	}
	
	public String del() {
		ObjectMapper om = new ObjectMapper();
		try {
			this.articleBiz.del(article);
			code = 1;
		} catch (Exception e) {
			e.printStackTrace();
			code = 0;
		}finally {
			JsonData jsonData = new JsonData(code, code == 0 ? "删除失败" : "删除成功", code);
			try {
				ResponseUtil.write(response, om.writeValueAsString(jsonData));
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return null;
	}

	@Override
	public Article getModel() {
		return article;
	}

}

ArticleDao:

package com.xhh.vue.dao;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.springframework.orm.hibernate5.HibernateCallback;

import com.xhh.base.dao.BaseDao;
import com.xhh.base.util.PageBean;
import com.xhh.vue.entity.Article;
import com.xhh.vue.util.StringUtils;

public class ArticleDao extends BaseDao {

	private static final long serialVersionUID = -2644908988755094673L;

	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);
	}
}

前端：

<template>
	<div>
		<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-button size="small" type="primary" icon="el-icon-plus" @click="add">添加</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="body" label="文章内容" width="300">
				</el-table-column>

				<el-table-column align="center" label="操作" min-width="300">
					<template slot-scope="scope">
						<el-button size="mini" @click="edit(scope.$index, scope.row)">编辑</el-button>
						<el-button size="mini" type="danger" @click="delete(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="pageBean.total">
			</el-pagination>

			<!-- 编辑界面 -->
			<el-dialog :title="title" :visible.sync="editFormVisible" width="30%" @click="closeDialog">
				<el-form label-width="120px" :model="editForm" :rules="rules" ref="editForm">
					<el-form-item label="文章标题" prop="title">
						<el-input size="small" v-model="editForm.title" auto-complete="off" placeholder="请输入文章标题"></el-input>
					</el-form-item>
					<el-form-item label="文章内容" prop="body">
						<el-input size="small" v-model="editForm.body" auto-complete="off" placeholder="请输入文章内容"></el-input>
					</el-form-item>
				</el-form>
				<div slot="footer" class="dialog-footer">
					<el-button size="small" @click="closeDialog">取消</el-button>
					<el-button size="small" type="primary" class="title" @click="submitForm">保存</el-button>
				</div>
			</el-dialog>

		</div>

		<!--列表 -->
		<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="body" label="文章内容" width="300">
			</el-table-column>
		</el-table>
	</div>
</template>

<script>
	export default {
		data() {
			return {
				listData: [],
				pageBean: {
					total: 0
				},
				formInline: {
					title: '',
					page: 1,
					rows: 10
				},
				editFormVisible: false,
				title: '',
				editForm: {
					body: '',
					title: '',
					id : 0
				},
				rules: {
					title: [{
						required: true,
						message: '请输入文章标题',
						trigger: 'blur'
					}],
					body: [{
							required: true,
							message: '请输入文章内容',
							trigger: 'blur'
						},
						{
							min: 3,
							max: 5,
							message: '长度在 3 到 5 个字符',
							trigger: 'blur'
						}
					],
				}

			};
		},
		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 = re0sponse.data.result;
					this.pageBean = response.data.pageBean;
				}).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();
			},
			closeDialog() {
				this.editFormVisible = false;
				this.clearForm();
			},
			submitForm() {
				//用来提交新增、修改的表单数据的，提交之前需要通过vue实例中定义的表单填写规则
				this.$refs['editForm'].validate((valid) => {
					if (valid) {
						let url;
						if(this.editForm.id == 0){
							url = this.axios.urls.SYSTEM_ARTICLE_ADD;
						}else{
							url = this.axios.urls.SYSTEM_ARTICLE_EDIT;
						}
						this.axios.post(url, this.editForm).then((response) => {
							console.log(response);
							this.clearForm();
							this.dosearch(this.formInline);
						}).catch((response) => {
							console.log(response);
						});
					} else {
						console.log('error submit!!');
						return false;
					}
				});
			},
			clearForm(){
				this.editForm.id = 0;
				this.editForm.title = '';
				this.editForm.body = '';
				this.formInline.page = 1;
				this.formInline.rows = 10;
				this.editFormVisible = false;
			},
			add() {
				this.title = '新增文章';
				this.editFormVisible = true;
				
			},
			edit(index,row){//修改
				//index代表的是操作数据在当前界面的行号
				//row代表操作的当前数据，那也就意味着可以从row中获取所有数据库列段名
				//var row = $("#dd").datagrid("getSelected");
				//$("#ff").form("load",row);完成了数据回显
				this.title = '编辑文章';
				this.editForm.id = row.id;
				this.editForm.title = row.title;
				this.editForm.body = row.body;
				this.editFormVisible = true;
			},
			delete(){//删除
				let url = this.axios.urls.SYSTEM_ARTICLE_DEL;
				this.axios.post(url, {id:row.id}).then((response) => {
					console.log(response);
					this.clearForm();
					this.dosearch({});
				}).catch((response) => {
					console.log(response);
				});
			}
				
		},
		created() {
			this.dosearch({});
		}
	}
</script>

<style>

</style>