| | |
| | | select * from lf.sys_meta a inner join lf.sys_meta_file b on a.id = b.metaid |
| | | where depid = ANY(fn_rec_array(10, 'dep')); |
| | | |
| | | select * from lf.sys_dir order by id |
| | | |
| | | |
| | | select * from lf.sys_dir order by id; |
| | | select zoning from lf.sys_coord group by zoning; |
| | | |
| | | |
| | | |
| | |
| | | /** |
| | | * 16进制 |
| | | */ |
| | | public static final char[] HEX_DIGITS = { '0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd', 'e', 'f' }; |
| | | public static final char[] HEX_DIGITS = {'0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd', 'e', 'f'}; |
| | | |
| | | /** |
| | | * 字符点 |
| | |
| | | public final static String OBJECT = "java.lang.Object"; |
| | | |
| | | /** |
| | | * MPT文件扩展名 |
| | | */ |
| | | public final static List<String> MPT_EXTENSION = new ArrayList<>(Arrays.asList(".mpt", ".mIdx", ".Strmi")); |
| | | |
| | | /** |
| | | * IMG文件扩展名 |
| | | */ |
| | | public final static List<String> IMG_EXTENSION = new ArrayList<>(Arrays.asList(".img", ".rrd", ".img.aux.xml", ".hdr", ".img.enp", ".img.xml")); |
| | | |
| | | /** |
| | | * TIF文件扩展名 |
| | | */ |
| | | public final static List<String> TIF_EXTENSION = new ArrayList<>(Arrays.asList(".tif", ".prj", ".tfw", ".tfw", ".tif.ovr", ".tif.aux.xml", ".tif.enp", ".tif.xml")); |
| | | |
| | | /** |
| | | * SHP文件扩展名 |
| | | */ |
| | | public final static List<String> SHP_EXTENSION = new ArrayList<>(Arrays.asList(".shp", ".shx", ".dbf", ".prj", ".cpg", ".qix", ".sbn", ".sbx")); |
| | | |
| | | /** |
| | | * 所有文件扩展名 |
| | | */ |
| | | public final static List<String> ALL_EXTENSION = new ArrayList<>(Arrays.asList(".txt", ".xml", ".pdf", ".xls", ".xlsx", ".doc", ".docx", ".ppt", ".pptx", ".shp", ".gdb", ".mdb", ".dwg", ".las", ".laz", ".mpt", ".fly", ".efb", ".g3d", ".fbx", ".obj", ".3dm", ".3dml", ".osgb", ".rvt", ".ifc", ".jpg", ".png", ".img", ".tif", ".bmp", ".gif", ".rmvb", ".rm", ".mp3", ".mp4", ".avi", ".wma", ".7z", ".rar", ".zip")); |
| | | |
| | | /** |
| | | * 插入排除字段 |
| | | */ |
| | | public final static List<String> INSERT_EXCLUDE_FIELDS = new ArrayList<>(Arrays.asList("gid", "objectid", "updateuser", "updatetime", "shape_leng", "shape_area", "serialVersionUID", "dirName", "depName", "verName", "createName", "updateName")); |