<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Lracm的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Lracm</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Lracm]]></copyright><item><title><![CDATA[WinForms中通过下拉框ComboBox获取年份]]></title><link>https://blog.youkuaiyun.com/Lracm/article/details/141101978</link><guid>https://blog.youkuaiyun.com/Lracm/article/details/141101978</guid><author>Lracm</author><pubDate>Sun, 11 Aug 2024 10:12:23 +0800</pubDate><description><![CDATA[【代码】WinForms中通过下拉框ComboBox获取年份。]]></description><category></category></item><item><title><![CDATA[C#获取GDB下图层名称及字段信息]]></title><link>https://blog.youkuaiyun.com/Lracm/article/details/140797771</link><guid>https://blog.youkuaiyun.com/Lracm/article/details/140797771</guid><author>Lracm</author><pubDate>Tue, 30 Jul 2024 15:20:21 +0800</pubDate><description><![CDATA[获取图层名及字段信息，可以用来图层或字段查询]]></description><category></category></item><item><title><![CDATA[C#中正则表达式的应用]]></title><link>https://blog.youkuaiyun.com/Lracm/article/details/140583712</link><guid>https://blog.youkuaiyun.com/Lracm/article/details/140583712</guid><author>Lracm</author><pubDate>Sun, 21 Jul 2024 10:02:02 +0800</pubDate><description><![CDATA[【代码】C#中正则表达式的应用。]]></description><category></category></item><item><title><![CDATA[postgresql获取字段属性]]></title><link>https://blog.youkuaiyun.com/Lracm/article/details/140360320</link><guid>https://blog.youkuaiyun.com/Lracm/article/details/140360320</guid><author>Lracm</author><pubDate>Thu, 11 Jul 2024 20:27:09 +0800</pubDate><description><![CDATA[【代码】postgresql获取字段属性。]]></description><category></category></item><item><title><![CDATA[Druid连接池]]></title><link>https://blog.youkuaiyun.com/Lracm/article/details/140253181</link><guid>https://blog.youkuaiyun.com/Lracm/article/details/140253181</guid><author>Lracm</author><pubDate>Sun, 07 Jul 2024 21:56:48 +0800</pubDate><description><![CDATA[【代码】Druid连接池。]]></description><category></category></item><item><title><![CDATA[数据库连接池C3P0连接(附jar包)]]></title><link>https://blog.youkuaiyun.com/Lracm/article/details/140252821</link><guid>https://blog.youkuaiyun.com/Lracm/article/details/140252821</guid><author>Lracm</author><pubDate>Sun, 07 Jul 2024 21:38:57 +0800</pubDate><description><![CDATA[【代码】数据库连接池C3P0连接(附jar包)]]></description><category></category></item><item><title><![CDATA[C#选择文件、文件夹]]></title><link>https://blog.youkuaiyun.com/Lracm/article/details/123164498</link><guid>https://blog.youkuaiyun.com/Lracm/article/details/123164498</guid><author>Lracm</author><pubDate>Sun, 27 Feb 2022 15:08:13 +0800</pubDate><description><![CDATA[选择文件
			OpenFileDialog dialog = new OpenFileDialog();
            dialog.Multiselect = true;//该值确定是否可以选择多个文件
            dialog.Title = "请选择文件夹";
            dialog.Filter = "所有文件(*.*)|*.*";
            if (dialog.ShowDialog() == System.Windows.Forms.Dialo]]></description><category></category></item><item><title><![CDATA[Postgis备份还原数据库所有数据（包括模式）]]></title><link>https://blog.youkuaiyun.com/Lracm/article/details/121165495</link><guid>https://blog.youkuaiyun.com/Lracm/article/details/121165495</guid><author>Lracm</author><pubDate>Fri, 05 Nov 2021 16:16:39 +0800</pubDate><description><![CDATA[pg_dump -U postgres -f /postgres.sql  evaluatedata
psql -U postgres -f /postgres.sql evaluatedata


]]></description><category></category></item><item><title><![CDATA[批量给文件夹下shp文件增加字段并赋值文件名]]></title><link>https://blog.youkuaiyun.com/Lracm/article/details/117018493</link><guid>https://blog.youkuaiyun.com/Lracm/article/details/117018493</guid><author>Lracm</author><pubDate>Wed, 19 May 2021 10:23:07 +0800</pubDate><description><![CDATA[批量给文件夹下shp文件增加字段并赋值文件名
# -*- coding: utf-8 -*-
import arcpy
#文件夹路径
arcpy.env.workspace = r'D:\test'
shpfiles = arcpy.ListFeatureClasses()

for shp in shpfiles:
    try:
        inFeatures = shp
        #print shp
        #新增字段
        fieldName = "Name"
  ]]></description><category></category></item><item><title><![CDATA[获取文件夹下所有shp矢量数据的边界值]]></title><link>https://blog.youkuaiyun.com/Lracm/article/details/111951788</link><guid>https://blog.youkuaiyun.com/Lracm/article/details/111951788</guid><author>Lracm</author><pubDate>Wed, 30 Dec 2020 11:03:18 +0800</pubDate><description><![CDATA[遍历文件夹，读取边界，代码如下
import os
from osgeo import ogr

base = r"E:\shp"     #文件夹路径
def findAllFile(base):
    for root, ds, fs in os.walk(base):
        for f in fs:
            if f.endswith('.shp'):
                fullname = os.path.join(root, f)
            ]]></description><category></category></item><item><title><![CDATA[access/sql分类查询]]></title><link>https://blog.youkuaiyun.com/Lracm/article/details/111746443</link><guid>https://blog.youkuaiyun.com/Lracm/article/details/111746443</guid><author>Lracm</author><pubDate>Sat, 26 Dec 2020 15:07:08 +0800</pubDate><description><![CDATA[access/sql分类查询
access/sql分类查询
统计数据，按name分组统计num的和，对name分组后按ph分组统计求和

sql 语句
SELECT name,
sum(num) as sum,
SUM(case class WHEN 1 THEN num ELSE 0 END) as ph1,
SUM(case class WHEN 3 THEN num ELSE 0 END) as ph3
from testmj 
GROUP BY name

结果如下

access中不支持case ]]></description><category></category></item></channel></rss>