难点:
1. 如何做到表的信息和表内容信息按树形结构展示
2. 如何做到选择单表,内部所有表项均被选择,以及点击最上面的多选框所有都被选择
过程1:定义一个可以进行层级的数据结构
@Data
public class Chart {
int id;
String EN;
String CN;
String Des;
int Same;//是否允许重复
String token;
List children;
}
@Data
public class Meta {
int id;
String EN;
String Des;
String CN;//这里其实是type
String token;
String Zhengze;
}
过程2:在查找所有chart信息时,就开始嵌套。
首先获取所有的Chart,根据该表id获取该表的表项,并在该表项的token字端加上表id-字段id,并把该表的meta放入该表的children字段
public ListfindChartsByDBid(int DBId) { // 首先获取相关的表里的内容 List charts=chartMapper.findAllCharts(DBId); //遍历list 并获取里面的id for(Chart chart:charts){ // 通过这个获取相应meta列表并加入 System.out.println(chart.getId()); chart.setToken(chart.getId()+""); if(metaMapper.findAllMetaByCId(chart.getId(),DBId)!=null){ List metaList= metaMapper.findAllMetaByCId(chart.getId(),DBId); for(Meta meta :metaList){ meta.setToken(chart.getId()+"-"+meta.getId()); } chart.setChildren(metaList);} else{ } }
过程三:前端获取信息
表的token是表id
而meta的token是表id-metaid
[{"id":1,"token":"1","children":[
{"id":1,"token":"1-1","zhengze":"F","cn":"FLOAT","en":"t1","des":"DSAD"},
{"id":2,"token":"1-2","zhengze":"F","cn":"DOUBLE","en":"r2","des":"DASD"},
{"id":3,"token":"1-3","zhengze":"F","cn":"INTEGER","en":"r4","des":"ASDDA"},
{"id":4,"token":"1-4","zhengze":"F","cn":"VARCHAR","en":"r5","des":"ASDAD"}],
"cn":"测试","en":"test2237","same":-1,"des":"测试"},
{"id":2,"token":"2","children":[
{"id":1,"token":"2-1","zhengze":"F","cn":"FLOAT","en":"t1","des":"DSAD"},
{"id":2,"token":"2-2","zhengze":"F","cn":"DOUBLE","en":"r2","des":"DASD"},
{"id":3,"token":"2-3","zhengze":"F","cn":"INTEGER","en":"r4","des":"ASDDA"},
{"id":4,"token":"2-4","zhengze":"F","cn":"VARCHAR","en":"r5","des":"ASDAD"}],
"cn":"测试","en":"test223","same":-1,"des":"测试"}]
过程四:前端解析
// 通过数据库id查询数据表的操作---尽量是树形的 但是传入是一个数据库的id
toggleSelection(rows) {
if (rows) {
rows.forEach(row => {
this.$refs.multipleTable.toggleRowSelection(row);
});
} else {
this.$refs.multipleTable.clearSelection();
}
},
created(){
this.dbinfo=this.$route.query.dbinfo
this.choosed=this.$route.query.choosed
this.chartsinfo=this.$route.query.chartsinfo
this.dbid=this.$route.query.dbid
//得把返回的表信息也拿过来
// 遍历数组取出想要的json格式,但因为暂时没有type和数据库名
// {type:insert/get
// 数据库名:
// 涉及表名:a,b,c
// {a:{a1:int ,a2:float}}
// {b:{}}
// {c:{}}}
// 先把每一个的名字拿过来--存 涉及
// 1. 把数据库中文名抓过来
this.json.dbname=this.dbinfo.dben
//console.log(this.json1)
// 2.把涉及表名拿过来
console.log('choosedlength')
console.log(this.choosed.length)
var flagmap={}
// 首先先初始化
for(var i1=0;i1
过程一:初始化
1. 首先获取选择的项的token
2.使用split函数获取chartid和metaid
3.若metaid为空则证明选择了该表所有的列
4. 设置一个flagmap 长度为获取的表的多少 0:选择了该表所有的列 1:根据metaid放 2:已放完
5. 同时将已选择的表的id与chartinfo数组里表的id匹配,将选择的chartname放进数组
过程二:开始放
6.根据切好的chartid对比看是哪个表,创建对象
7.看meta是哪一列,将这一列的名称和类型放进去



