<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[zmdds的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/zmdds</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; zmdds]]></copyright><item><title><![CDATA[c#无法删除文件的解决思路]]></title><link>https://blog.youkuaiyun.com/zmdds/article/details/4998205</link><guid>https://blog.youkuaiyun.com/zmdds/article/details/4998205</guid><author>zmdds</author><pubDate>Sun, 13 Dec 2009 16:15:00 +0800</pubDate><description><![CDATA[很久以前做项目的时候碰到过,建一个临时文件,最后调用File.Delete(filepath)删除文件报错,当时没有深究这个问题.今天又碰到了,最后发现是前面使用System.Drawing.Image image = System.Drawing.Image.FromFile(path);没有释放,使用image.Dispose();后马上解决问题.今后如果碰到类似的问题,多看看是不是有文件打开]]></description><category></category></item><item><title><![CDATA[尽量不要拼凑Sql语句,用参数来防注入]]></title><link>https://blog.youkuaiyun.com/zmdds/article/details/4881787</link><guid>https://blog.youkuaiyun.com/zmdds/article/details/4881787</guid><author>zmdds</author><pubDate>Thu, 26 Nov 2009 23:12:00 +0800</pubDate><description><![CDATA[    如果是类似"select   *   from   user   where   uid="+uid +"  and   pwd="+pwd 很容易出问题    使用   SQLParamenter          把你的SQL语句写成   类似存储过程             select   *   from   user   where   uid=@uid   and   p]]></description><category></category></item><item><title><![CDATA[JavaScript中函数的传递]]></title><link>https://blog.youkuaiyun.com/zmdds/article/details/4866679</link><guid>https://blog.youkuaiyun.com/zmdds/article/details/4866679</guid><author>zmdds</author><pubDate>Tue, 24 Nov 2009 21:43:00 +0800</pubDate><description><![CDATA[每次用Google的 GEvent.addListener(marker, "click", function() {                    marker.openInfoWindowHtml(num);                 });就觉得很爽,传个函数过去,onclick事件就能触发,以前自己也想写类似的功能,几次都没搞出来,今天随手写两行代码反而搞定了.]]></description><category></category></item><item><title><![CDATA[Sql 2005 递归查询]]></title><link>https://blog.youkuaiyun.com/zmdds/article/details/4822210</link><guid>https://blog.youkuaiyun.com/zmdds/article/details/4822210</guid><author>zmdds</author><pubDate>Tue, 17 Nov 2009 15:29:00 +0800</pubDate><description><![CDATA[ Oracle中的递归查询可以依靠增强的sql语句START WITH ...CONNECT BY PRIOR来搞定.sql 2005中不支持该语句,以下示例可以实现递归查询.WITH TREE(xzdm,Prexzdm,lvl,topxzdm) AS (     SELECT xzdm,prexzdm,1,prexzdm as topxzdm FROM xzdm WHERE Prexzdm ]]></description><category></category></item><item><title><![CDATA[删除重复数据]]></title><link>https://blog.youkuaiyun.com/zmdds/article/details/4514238</link><guid>https://blog.youkuaiyun.com/zmdds/article/details/4514238</guid><author>zmdds</author><pubDate>Thu, 03 Sep 2009 10:39:00 +0800</pubDate><description><![CDATA[delete from kjt_xzdw a where rowid>(select min(rowid) from kjt_xzdw b where a.xzdm=b.xzdm);]]></description><category></category></item><item><title><![CDATA[Mapgis与ArcGIS的装换,Oracle Spatial的相关selsct]]></title><link>https://blog.youkuaiyun.com/zmdds/article/details/4365000</link><guid>https://blog.youkuaiyun.com/zmdds/article/details/4365000</guid><author>zmdds</author><pubDate>Mon, 20 Jul 2009 21:58:00 +0800</pubDate><description><![CDATA[今天没时间,贴两个链接 比较相同图元的sql语句.select Objectid 结果集数目多于一个时,运算速度巨慢SELECT A.*FROM temp_tudi_1 A, temp_tudi_1 BWHERE B.Objectid in (select objectid from temp_tudi_1 where objectid =1 or objectid =2) a]]></description><category></category></item><item><title><![CDATA[ArcEngine中对Feature的编辑]]></title><link>https://blog.youkuaiyun.com/zmdds/article/details/4361806</link><guid>https://blog.youkuaiyun.com/zmdds/article/details/4361806</guid><author>zmdds</author><pubDate>Sun, 19 Jul 2009 18:53:00 +0800</pubDate><description><![CDATA[今天做一下午图元导入都不成功,还好在网上找到这个帖子,我导入失败的原因就是设置了OID. 来源:http://blog.sina.com.cn/s/blog_53fc3ca10100c9v1.html  对Feature的编辑分为以下几个部分1.新建2.修改3.删除涉及到的接口有以下几个IWorkspaceEditIFeatureClassIFeatureCursorIFeat]]></description><category></category></item><item><title><![CDATA[Flex动态添加Web service的result事件函数]]></title><link>https://blog.youkuaiyun.com/zmdds/article/details/4273738</link><guid>https://blog.youkuaiyun.com/zmdds/article/details/4273738</guid><author>zmdds</author><pubDate>Tue, 16 Jun 2009 16:27:00 +0800</pubDate><description><![CDATA[往上介绍的使用Web service的方法大多是写死的,有时我们要根据需要更改响应result事件的函数.以下代码可以完成这个工作 import mx.rpc.events.*; webService1.getOperation("operation_name").removeEventListener();webService1.getOperation("operation]]></description><category></category></item><item><title><![CDATA[kjt项目回顾(1)]]></title><link>https://blog.youkuaiyun.com/zmdds/article/details/4257816</link><guid>https://blog.youkuaiyun.com/zmdds/article/details/4257816</guid><author>zmdds</author><pubDate>Wed, 10 Jun 2009 15:36:00 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[flex下使用google api获取对应经纬度的地名]]></title><link>https://blog.youkuaiyun.com/zmdds/article/details/4256624</link><guid>https://blog.youkuaiyun.com/zmdds/article/details/4256624</guid><author>zmdds</author><pubDate>Wed, 10 Jun 2009 10:16:00 +0800</pubDate><description><![CDATA[用到的api为reverseGeocode(latlng);但是使用这个api返回的地名只到县这个级别的单位.如果要获得乡,村一级的单位需要自己做处理,我目前的处理方法是获得县,然后从自己的数据库中取出县所辖所有乡村的坐标,计算后确定地名.代码片段如下:public function onmyclick(event:MapMouseEvent):void  {      var geocode]]></description><category></category></item><item><title><![CDATA[.net 下webservice 的WebMethod的属性]]></title><link>https://blog.youkuaiyun.com/zmdds/article/details/4256555</link><guid>https://blog.youkuaiyun.com/zmdds/article/details/4256555</guid><author>zmdds</author><pubDate>Wed, 10 Jun 2009 09:56:00 +0800</pubDate><description><![CDATA[WebMethod有6个属性：.Description.EnableSession.MessageName.TransactionOption.CacheDuration.BufferResponse1) Description:是对webservice方法描述的信息。就像webservice方法的功能注释，可以让调用者看见的注释。C#:[WebMethod(Description]]></description><category></category></item><item><title><![CDATA[flex调用web服务的安全设置]]></title><link>https://blog.youkuaiyun.com/zmdds/article/details/4129992</link><guid>https://blog.youkuaiyun.com/zmdds/article/details/4129992</guid><author>zmdds</author><pubDate>Mon, 27 Apr 2009 17:00:00 +0800</pubDate><description><![CDATA[在本机上发布了一个服务,然后通过flex调用服务,调试通过,然后将服务部署到服务器上后,问题就来了:报security error access url.上网查了查资料,大意说其中一种解决方法就是将一个crossdomain.xml安全策略文件放到部署web服务的服务器上.当时不知道这个怎么写,灵机一动去中国气象局的网站抄了一个http://www.webxml.com.cn/crossdomai]]></description><category></category></item><item><title><![CDATA[Oracl数据导出]]></title><link>https://blog.youkuaiyun.com/zmdds/article/details/4054371</link><guid>https://blog.youkuaiyun.com/zmdds/article/details/4054371</guid><author>zmdds</author><pubDate>Tue, 07 Apr 2009 15:20:00 +0800</pubDate><description><![CDATA[部分表导出  exp gisdb/gis@orcl file=d:/webgut20080805.dmp tables=(rooms_sp) 全库导出 exp gisdb/gis@orcl file=d:/webgut20080805.dmp]]></description><category></category></item><item><title><![CDATA[ArcGIS mobile 开发笔记(一)]]></title><link>https://blog.youkuaiyun.com/zmdds/article/details/4025953</link><guid>https://blog.youkuaiyun.com/zmdds/article/details/4025953</guid><author>zmdds</author><pubDate>Thu, 26 Mar 2009 10:46:00 +0800</pubDate><description><![CDATA[经过两天的摸索,大致有了些头绪.在模拟器上已经可以获得GPS文件数据,然后叠加到图层上.可以访问局域网中的地图服务.摸索的测试都是在改写ArcGIS的示例程序Walkthrough_PPC05CSharp下进行.入门的好帖子http://wu-yongfeng.blogspot.com/2008/08/arcgis-mobile-sdk-93.html更加详细的网络配置参看http:/]]></description><category></category></item><item><title><![CDATA[将A表数据更新到B表相关列的SQL语句]]></title><link>https://blog.youkuaiyun.com/zmdds/article/details/3773245</link><guid>https://blog.youkuaiyun.com/zmdds/article/details/3773245</guid><author>zmdds</author><pubDate>Wed, 14 Jan 2009 10:26:00 +0800</pubDate><description><![CDATA[update ktz_xy set ktz_xy.dmlvl = (select tdfldm1.dmlvl from tdfldm1 where ktz_xy.dldm=tdfldm1.dldm )选择ktz_xy表中凡是dldm 与tdfldm1表的dldm 相同的记录,将其值ktz_xy.dmlvl 修改为tdfldm1.dmlvl 的值]]></description><category></category></item><item><title><![CDATA[oracle两表间导数据语句]]></title><link>https://blog.youkuaiyun.com/zmdds/article/details/3772942</link><guid>https://blog.youkuaiyun.com/zmdds/article/details/3772942</guid><author>zmdds</author><pubDate>Wed, 14 Jan 2009 10:07:00 +0800</pubDate><description><![CDATA[insert into ktz_xy(dldm) select tdfldm1.dldm from tdfldm1 order by tdfldm1.id将tdfldm1表中的dldm 列导入ktz_xy表的dldm列.如果是这样加了括号会报错,去掉order by则不会,奇怪insert into ktz_xy(dldm) (select tdfldm1.dldm from tdfl]]></description><category></category></item><item><title><![CDATA[查看oracle被锁对象]]></title><link>https://blog.youkuaiyun.com/zmdds/article/details/3761635</link><guid>https://blog.youkuaiyun.com/zmdds/article/details/3761635</guid><author>zmdds</author><pubDate>Mon, 12 Jan 2009 17:42:00 +0800</pubDate><description><![CDATA[一个字不用改,直接执行就可以得到被锁的对象SELECT A.OWNER,                  A.xzdm,                     B.XIDUSN,                          B.XIDSLOT,                         B.XIDSQN,                          B.SESSION_I]]></description><category></category></item><item><title><![CDATA[SQL语句中的;带来的问题]]></title><link>https://blog.youkuaiyun.com/zmdds/article/details/3729595</link><guid>https://blog.youkuaiyun.com/zmdds/article/details/3729595</guid><author>zmdds</author><pubDate>Wed, 07 Jan 2009 22:11:00 +0800</pubDate><description><![CDATA[今天在写代码的时候碰到"ORA-00911: 无效字符",但是语句在PLSQL DEVELOPER上可以运行,后来终于发现语句中多带了个;号,在PLSQL DEVELOPER没有问题,但是代码中有问题]]></description><category></category></item><item><title><![CDATA[.net中的CrystalReport(水晶报表)控件使用笔记]]></title><link>https://blog.youkuaiyun.com/zmdds/article/details/3604726</link><guid>https://blog.youkuaiyun.com/zmdds/article/details/3604726</guid><author>zmdds</author><pubDate>Thu, 25 Dec 2008 15:46:00 +0800</pubDate><description><![CDATA[        今天试了试vs2008中带有的CrystalReport控件,感觉非常强大,专业的果然不一样.以前项目中拼死拼活写的报表界面,现在可以轻松的一路next搞定.当然今天试的时候也出了些问题.下面就简要记录下.        页面载入时报"您请求的报表需要更多信息".        出现这个问题是我在用oracle的表时发生的,会出现一个界面,让你输入服务器,用户,密码.然后登]]></description><category></category></item><item><title><![CDATA[最近.net项目的一点心得]]></title><link>https://blog.youkuaiyun.com/zmdds/article/details/3426911</link><guid>https://blog.youkuaiyun.com/zmdds/article/details/3426911</guid><author>zmdds</author><pubDate>Tue, 02 Dec 2008 10:21:00 +0800</pubDate><description><![CDATA[1.GridView使用制定的SQL语句查询.如下面的语句,可以很容易的实现通过下拉菜单查询所有记录SELECT CID, CNAME, CPROPERTY, CZHUJIANG, TOTALTIME, EXPTIME, PRACTICETIME, TEACHERID, TEACHERNAME, TEACHECLASS, CTYPE FROM TEACHPLAN WHERE (PLANYEAR]]></description><category></category></item></channel></rss>