实用操作

excel拼接

=CONCATENATE("<result property=""",A1,""" column=""",A1,""" />")

=CONCATENATE(A1,",")

=CONCATENATE("private String ",A1,";")  //类字段

 

 

 

数据库系统表

 select * from sysobjects  

 select * from  syscolumns

SELECT * FROM INFORMATION_SCHEMA.columns

 

 

端口占用

netstat -ano 查询所有端口

netstat -aon|findstr "49157" 查询指定端口 获取PID

tasklist|findstr "2720" 根据PID查询进程