<template><div><h1 align="center">SSM阶段机试，ts={{ ts }}</h1><!-- 查询条件 --><el-form style="margin-top: 15px" :inline="true" class="demo-form-inline"><el-form-item label="客户名称"><el-input v-model="custName" placeholder="客户名称"></el-input></el-form-item><el-form-item><el-button type="primary" @click="qry()">查询</el-button><el-button type="primary" @click="addOrder()">新增</el-button></el-form-item></el-form><!--表格--><el-table style="width: 100%;" :data="orders" :border="true" max-height="550"><el-table-column prop="id" label="订单编号" min-width="40" align="center"></el-table-column><el-table-column prop="custName" label="客户名称" min-width="100" align="center"></el-table-column><el-table-column prop="amount" label="订单金额" min-width="70" align="center"></el-table-column><el-table-column prop="custPhone" label="电话" min-width="70" align="center"></el-table-column><el-table-column prop="orderDesc" label="订单描述" min-width="70" align="center"></el-table-column><el-table-column prop="custAddr" label="客户地址" min-width="70" align="center"></el-table-column><el-table-column label="操作"><template slot-scope="scope"><el-buttonsize="mini"@click="Doupdate(scope.row)">编辑</el-button><el-buttonsize="mini"type="danger"@click="Dodelete(scope.row)">删除</el-button></template></el-table-column></el-table><!-- 弹出窗口 --><el-dialog title="增加订单" :visible.sync="dialogFormVisible" @close="closeBookForm" width="500px"><el-form :model="orderForm" :rules="rules" ref="orderForm"  ><el-form-item label="订单描述" :label-width="formLabelWidth" prop="orderDesc"><el-input v-model="orderForm.orderDesc" autocomplete="off" :style="{width: formEleWidth}"  ></el-input></el-form-item><el-form-item label="金额" :label-width="formLabelWidth" prop="amount" ><el-input v-model="orderForm.amount" autocomplete="off" :style="{width: formEleWidth}" ></el-input></el-form-item><el-form-item label="客户" :label-width="formLabelWidth" prop="custName"><el-input v-model="orderForm.custName" autocomplete="off" :style="{width: formEleWidth}" ></el-input></el-form-item><el-form-item label="电话" :label-width="formLabelWidth" prop="custPhone"><el-input v-model="orderForm.custPhone" autocomplete="off" :style="{width: formEleWidth}" ></el-input></el-form-item><el-form-item label="地址" :label-width="formLabelWidth" prop="custAddr"><el-input v-model="orderForm.custAddr" autocomplete="off" :style="{width: formEleWidth}" ></el-input></el-form-item></el-form><div slot="footer" class="dialog-footer"><el-button @click="dialogFormVisible = false">取 消</el-button><el-button type="primary" @click="save()">确 定</el-button></div></el-dialog></div>
</template>

<script>export default {data:function(){return {ts:new Date().getTime(),custName:'',orders:[],orderForm:{id:'',orderDesc:'',amount:'',custName:'',custPhone:'',custAddr:'',},//控制对话框是否显示，默认是隐藏状态dialogFormVisible: false,//统一控制标签的宽度formLabelWidth: '40px',//统一控制表单元素的宽度formEleWidth: '400px',rules:{orderDesc:[{required:true,message:'请输入订单描述',trigger:'blur'}],amount:[{required:true,message:'请输入订单描述',trigger:'blur'}],custName:[{required:true,message:'请输入订单描述',trigger:'blur'}],custPhone:[{required:true,message:'请输入订单描述',trigger:'blur'}],custAddr:[{required:true,message:'请输入订单描述',trigger:'blur'}]}};},methods:{qry:function(){let url=this.axios.urls.ORDER_REQ;this.axios.get(url,{params:{custName:this.custName}}).then(resp =>{this.orders=resp.data.data;}).catch(error =>{console.log(error);});},closeBookForm: function() {this.dialogFormVisible = false;},addOrder: function() {this.dialogFormVisible = true;this.orderForm.id='';this.orderForm.orderDesc='';this.orderForm.amount='';this.orderForm.custName='';this.orderForm.custPhone='';this.orderForm.custAddr='';},Doupdate:function(row){this.dialogFormVisible = true;this.orderForm.id=row.id;this.orderForm.orderDesc=row.orderDesc;this.orderForm.amount=row.amount;this.orderForm.custName=row.custName;this.orderForm.custPhone=row.custPhone;this.orderForm.custAddr=row.custAddr;},//保存修改save:function(){this.$refs['orderForm'].validate(valid =>{if(valid){let url=this.axios.urls.ORDER_ADD;if(this.orderForm.id!=null && this.orderForm.id!=''){url=this.axios.urls.ORDER_UPDATE;}this.axios.post(url,this.orderForm).then(resp =>{if(resp.data.code==1){this.$message({message:resp.data.msg,type:'success'});this.dialogFormVisible=false;this.qry();}else{this.$message({message:resp.data.msg,type:'error'});this.dialogFormVisible=false;}}).catch(error =>{});}});},//删除Dodelete:function(row){let url=this.axios.urls.ORDER_DELETE+"?id="+row.id;this.axios.delete(url).then(resp =>{if(resp.data.code==1){this.$message({message:resp.data.msg,type:'success'});this.dialogFormVisible=false;this.qry();}else{this.$message({message:resp.data.msg,type:'error'});this.dialogFormVisible=false;}}).catch(error =>{console.log(error)})}}}
</script>

 <!--MybatisPlus--><dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-boot-starter</artifactId><version>3.0.5</version></dependency>
<!--代码生成依赖--><dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-generator</artifactId><version>3.5.0</version></dependency><dependency><groupId>org.freemarker</groupId><artifactId>freemarker</artifactId><version>2.3.31</version></dependency>

 public static void main(String[] args) {//我们需要构建一个代码生成器对象AutoGenerator mpg = new AutoGenerator();//怎么样去执行，配置策略//1、全局配置GlobalConfig gc = new GlobalConfig();String projectPath = System.getProperty("user.dir");//获取当前目录gc.setOutputDir(projectPath+"/src/main/java");//输出到哪个目录gc.setAuthor("海天");gc.setOpen(false);gc.setFileOverride(false);//是否覆盖gc.setServiceName("%sService");//去Service的I前缀gc.setIdType(IdType.ID_WORKER);gc.setDateType(DateType.ONLY_DATE);gc.setSwagger2(true);mpg.setGlobalConfig(gc);//2、设置数据源DataSourceConfig dsc = new DataSourceConfig();dsc.setUsername("root");dsc.setPassword("123");dsc.setUrl("jdbc:mysql://localhost:3306/mybatisplus?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf-8");dsc.setDriverName("com.mysql.cj.jdbc.Driver");dsc.setDbType(DbType.MYSQL);mpg.setDataSource(dsc);//3、包的配置PackageConfig pc = new PackageConfig();pc.setModuleName("study");pc.setParent("com.wsk");pc.setEntity("entity");pc.setMapper("mapper");pc.setService("service");pc.setController("controller");mpg.setPackageInfo(pc);//4、策略配置StrategyConfig strategy = new StrategyConfig();strategy.setInclude("user");//设置要映射的表名,只需改这里即可strategy.setNaming(NamingStrategy.underline_to_camel);strategy.setColumnNaming(NamingStrategy.underline_to_camel);strategy.setEntityLombokModel(true);//是否使用lombok开启注解strategy.setLogicDeleteFieldName("deleted");
}