杂记

1、按照像素截取字符串

<div style="width:150px; overflow:hidden; text-overflow:ellipsis; white-space:nowrap; display: block;">
   {{item[item2]}}
</div>

2、命令创建maven 项目
mvn archetype:create
-DgroupId=[your project’s group id]
-DartifactId=[your project’s artifact id]
-DarchetypeArtifactId=maven-archetype-webapp

3.获取手机屏幕宽高

  var w=windows.innerWidth
|| document.documentElement.clientWidth || document.body.clientWidth; var h=windows.innerHeight || document.documentElement.clientHeight || document.body.clientHeight;

一个有意思的sql

select o.id,z.level1,o.level2 from
(select x.*,y.groupId from excelimport as x
join
(select a.id,(select max(b.id) from excelimport as b where b.id<=a.id and b.level1<>'') as groupId from excelimport as a) as y
on x.id=y.id) as o
LEFT JOIN
(select * from excelimport where level1<>'') as z
on o.groupId=z.id