<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[zkvistor的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/zkvistor</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; zkvistor]]></copyright><item><title><![CDATA[MVC发布到IIS 配置细节]]></title><link>https://blog.youkuaiyun.com/zkvistor/article/details/51362715</link><guid>https://blog.youkuaiyun.com/zkvistor/article/details/51362715</guid><author>zkvistor</author><pubDate>Tue, 10 May 2016 14:05:51 +0800</pubDate><description><![CDATA[自己记录一下，方便以后查阅]]></description><category></category></item><item><title><![CDATA[软件工程的几个步骤]]></title><link>https://blog.youkuaiyun.com/zkvistor/article/details/5650423</link><guid>https://blog.youkuaiyun.com/zkvistor/article/details/5650423</guid><author>zkvistor</author><pubDate>Sun, 06 Jun 2010 09:05:00 +0800</pubDate><description><![CDATA[1  问题定义2 可行性研究3 需求分析4 总体设计5 详细设计6 编码和单元测试7综合测试8 软件维护详情请见    http://dev.firnow.com/course/3_program/gcs/20071010/77318.html自己也是在一个面试题中遇到这样的问题 ，就搜索了一下 记录下来]]></description><category></category></item><item><title><![CDATA[武汉明源软件面试题]]></title><link>https://blog.youkuaiyun.com/zkvistor/article/details/5648578</link><guid>https://blog.youkuaiyun.com/zkvistor/article/details/5648578</guid><author>zkvistor</author><pubDate>Fri, 04 Jun 2010 22:55:00 +0800</pubDate><description><![CDATA[今天去明源面试，面试题目如下1 有两张表 A 学生表ID          Name          age1           李1             122           李2             333           李3             324           李4             345           李5             366           李6             377           李7             ]]></description><category></category></item><item><title><![CDATA[如何利用SQLSERVER2000的DTS 导入数据到Oracle？]]></title><link>https://blog.youkuaiyun.com/zkvistor/article/details/5485108</link><guid>https://blog.youkuaiyun.com/zkvistor/article/details/5485108</guid><author>zkvistor</author><pubDate>Wed, 14 Apr 2010 14:42:00 +0800</pubDate><description><![CDATA[具体步骤就不多说了 ，要导出的SQLSERVER表叫 LDJCUS，主键 Uid (int   自动增长列)，导入到Oracle总报错：对象名无效 ，去掉主键列就可以，不知道为什么？难道自动增长的主键列就不能导入到Oracle中？？？疑惑。。。。]]></description><category></category></item><item><title><![CDATA[导入Oracle实例]]></title><link>https://blog.youkuaiyun.com/zkvistor/article/details/5485084</link><guid>https://blog.youkuaiyun.com/zkvistor/article/details/5485084</guid><author>zkvistor</author><pubDate>Wed, 14 Apr 2010 14:36:00 +0800</pubDate><description><![CDATA[ --创建用户create user iagent identified by ia--profile default  default  tablespace userstemporary tablespace temp;--account unlock; --删除用户drop user iagent cascade;  --修改用户密码  alter]]></description><category></category></item><item><title><![CDATA[如何导入ORACLE 备份文件]]></title><link>https://blog.youkuaiyun.com/zkvistor/article/details/5386084</link><guid>https://blog.youkuaiyun.com/zkvistor/article/details/5386084</guid><author>zkvistor</author><pubDate>Tue, 16 Mar 2010 16:53:00 +0800</pubDate><description><![CDATA[ --创建用户create user iagent identified by ia--profile default  default  tablespace userstemporary tablespace temp;--account unlock; --删除用户drop user iagent cascade;  --修改用户密码  alter]]></description><category></category></item><item><title><![CDATA[SQL SERVER 常用字符串函数 ]]></title><link>https://blog.youkuaiyun.com/zkvistor/article/details/5334880</link><guid>https://blog.youkuaiyun.com/zkvistor/article/details/5334880</guid><author>zkvistor</author><pubDate>Mon, 01 Mar 2010 10:03:00 +0800</pubDate><description><![CDATA[stuff  如：select stuff(zhangkang,1,1,Mrz) 结果：Mrzhangkang  这个和replace比较相似   ， 可以实现在指定位置替换字符串，等同于在该位置重新插入字符串    ]]></description><category></category></item><item><title><![CDATA[SQL2005实现数据库自动备份]]></title><link>https://blog.youkuaiyun.com/zkvistor/article/details/5080746</link><guid>https://blog.youkuaiyun.com/zkvistor/article/details/5080746</guid><author>zkvistor</author><pubDate>Sat, 26 Dec 2009 12:32:00 +0800</pubDate><description><![CDATA[具体的步骤就不写了 把关键的写一下1 必须安装的是SQL2005非简易版(SQLSERVER  Express)   启动SQLSERVER 代理服务，新建作业2 步骤-->常规 选择所要备份的数据库       在命令里输入 USE MasterGOdeclare @str varchar(100)set @str=D:/DataBase/DB_B2CShop/DB_BackU]]></description><category></category></item><item><title><![CDATA[改进的Oracle分页存储过程]]></title><link>https://blog.youkuaiyun.com/zkvistor/article/details/4954914</link><guid>https://blog.youkuaiyun.com/zkvistor/article/details/4954914</guid><author>zkvistor</author><pubDate>Mon, 07 Dec 2009 10:26:00 +0800</pubDate><description><![CDATA[--Oracle分页存储过程(1)----定义包头部create or replace package ZK_Pack istype refCursorType is ref cursor;             --定义游标变量用于返回记录集procedure PageSort_proc                     (p_field in varchar2,      --要查询的]]></description><category></category></item><item><title><![CDATA[SQLSERVER数据库日志文件过大，如何压缩并定期清理 ?]]></title><link>https://blog.youkuaiyun.com/zkvistor/article/details/4954695</link><guid>https://blog.youkuaiyun.com/zkvistor/article/details/4954695</guid><author>zkvistor</author><pubDate>Mon, 07 Dec 2009 10:00:00 +0800</pubDate><description><![CDATA[日志文件64.7G，硬盘都快满了, 解决方案如下:先压缩数据库日志文件 (以我SQL2000 的iRecorder数据库为例):右键iRecorder   属性 --> 选项-->故障还原模式 默认情况下是 “完全”，改为“简单”，点确定，所有任务-->收缩数据库-->文件--> 数据库文件iRecorder_Data(选你要压缩的日志文件)，确定，改完之后 把故障还原模式 改成“完全”，这只]]></description><category></category></item><item><title><![CDATA[如何优化ASP.NET应用程序？]]></title><link>https://blog.youkuaiyun.com/zkvistor/article/details/4859418</link><guid>https://blog.youkuaiyun.com/zkvistor/article/details/4859418</guid><author>zkvistor</author><pubDate>Mon, 23 Nov 2009 21:59:00 +0800</pubDate><description><![CDATA[ 刚看到了一片文章  http://dotnet.youkuaiyun.com/page/a92a1213-9896-49c7-9c89-14ae5f0d87ae    提到如下几点:1. 数据库连接超时2. 创建的对象只管用，不管释放3. 调试(Debug)模式下编译后，就用于应用环境中了4. 实际作业模式分享 1,2,3比较好理解，我在做的时候犯了他说的 第三种错误，至于4 不是太懂? 另外我]]></description><category></category></item><item><title><![CDATA[SQLSERVER 分页存储过程(2 在SQL2005下使用)  ]]></title><link>https://blog.youkuaiyun.com/zkvistor/article/details/4712022</link><guid>https://blog.youkuaiyun.com/zkvistor/article/details/4712022</guid><author>zkvistor</author><pubDate>Thu, 22 Oct 2009 10:20:00 +0800</pubDate><description><![CDATA[ 调用 带参数存储过程declare @totalRec intexec fenye venshop_hw,20,1,hw_id desc,hw_id,hw_name,hw_sn,hw_price1,hw_price2,hw_kucun,sort_id=1,@totalRec outputprint 总计+convert(varchar(6),@totalRec)+条]]></description><category></category></item><item><title><![CDATA[利用Jquery实现鼠标滑动显示大图 ]]></title><link>https://blog.youkuaiyun.com/zkvistor/article/details/4509736</link><guid>https://blog.youkuaiyun.com/zkvistor/article/details/4509736</guid><author>zkvistor</author><pubDate>Wed, 02 Sep 2009 08:56:00 +0800</pubDate><description><![CDATA[效果如下：http://www.vancl.com/Product_4221614/QuanMianShuangCengVLingZhenZhiShan+TianLanSe.html 可以在http://www.magictoolbox.com/magiczoom_examples/ 下载    views.aspx 引用如下：     img {  border: 0px; } ]]></description><category></category></item><item><title><![CDATA[SQLServer 分页存储过程（1） ]]></title><link>https://blog.youkuaiyun.com/zkvistor/article/details/4497359</link><guid>https://blog.youkuaiyun.com/zkvistor/article/details/4497359</guid><author>zkvistor</author><pubDate>Sat, 29 Aug 2009 18:08:00 +0800</pubDate><description><![CDATA[/**if exists (select * from sysobjects where name=page_sort)drop proc page_sort**/create proc page_sort( @Name  nvarchar(100)=,     --表名,如 pinyin @PageSize int,           --每页的记录数,默认为 10 @CurPage ]]></description><category></category></item><item><title><![CDATA[Oracle分页存储过程]]></title><link>https://blog.youkuaiyun.com/zkvistor/article/details/4497356</link><guid>https://blog.youkuaiyun.com/zkvistor/article/details/4497356</guid><author>zkvistor</author><pubDate>Sat, 29 Aug 2009 18:08:00 +0800</pubDate><description><![CDATA[create or replace package JT_P_page istype type_cur is ref cursor;                    --定义游标变量用于返回记录集procedure Pagination  (Pindex in number,        --要显示的页数索引，从0开始                       Psql in varch]]></description><category></category></item><item><title><![CDATA[ASP.NET调用Oracle分页存储过程并结合ASPnetpager分页控件  实现分页功能]]></title><link>https://blog.youkuaiyun.com/zkvistor/article/details/4497305</link><guid>https://blog.youkuaiyun.com/zkvistor/article/details/4497305</guid><author>zkvistor</author><pubDate>Sat, 29 Aug 2009 17:44:00 +0800</pubDate><description><![CDATA[之前用的是GridView自带的分页功能，那速度啊慢的真实不行  ，决定自定义分页  Oracle库里有5W多条数据AspnetPager做的还是不错，拿过来用Oracle 分页存储过程： create or replace package JT_P_page istype type_cur is ref cursor;                    --定义游标变量用于返]]></description><category></category></item><item><title><![CDATA[C#验证国内电话和手机的正则表达式 ]]></title><link>https://blog.youkuaiyun.com/zkvistor/article/details/4470603</link><guid>https://blog.youkuaiyun.com/zkvistor/article/details/4470603</guid><author>zkvistor</author><pubDate>Fri, 21 Aug 2009 16:37:00 +0800</pubDate><description><![CDATA[using System .Text;using System.Text.RegularExpressions;  Regex rx = new Regex("(//d{3}-//d{8}|//d{4}-//d{7})|^(13[0-9]|15[0|3|6|7|8|9]|18[8|9])//d{8}$"); if (rx.IsMatch((OrderPhone.Value.Trim()))]]></description><category></category></item><item><title><![CDATA[根据导入Excel文件批量修改Oracle数据库中订单信息]]></title><link>https://blog.youkuaiyun.com/zkvistor/article/details/4470507</link><guid>https://blog.youkuaiyun.com/zkvistor/article/details/4470507</guid><author>zkvistor</author><pubDate>Fri, 21 Aug 2009 16:20:00 +0800</pubDate><description><![CDATA[Excel文件里是返回的订单相关信息，如:运单号，状态，发货时间......... 页面布局如下：页面有个html  input上传控件  还有个修改按钮  点击浏览，选择要导入的文件然后点修改就可以 批量修改 思路就是把Excel表当做数据源进行读取,Excel中的数据保存到DataSet中  using System.Data.OleDb;。。。。。 ///  ]]></description><category></category></item><item><title><![CDATA[ASP.NET页面上数据导出到Excel]]></title><link>https://blog.youkuaiyun.com/zkvistor/article/details/4403343</link><guid>https://blog.youkuaiyun.com/zkvistor/article/details/4403343</guid><author>zkvistor</author><pubDate>Mon, 03 Aug 2009 10:37:00 +0800</pubDate><description><![CDATA[页面上用GridView显示数据导出按钮Click事件 protected void Btn_DC_Click(object sender, EventArgs e)    {        string fileName = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.]]></description><category></category></item><item><title><![CDATA[部署ASP.NET程序问题总汇]]></title><link>https://blog.youkuaiyun.com/zkvistor/article/details/3663979</link><guid>https://blog.youkuaiyun.com/zkvistor/article/details/3663979</guid><author>zkvistor</author><pubDate>Wed, 31 Dec 2008 10:14:00 +0800</pubDate><description><![CDATA[本机开发环境：VS2005(2.0框架)+Oracle8i客户端+IIS5.1 +WINDOWS XP服务器：Oracle92 +WINDOWS2003+IIS6.0公司要在原有程序基础上加个批量修改功能,相当于是二次开发，以前很少连接ORACLE数据库，一开始就遇到连数据的问题， 开始用using system.Data.Oledb,死活连不上，后来改为using system.Data]]></description><category></category></item></channel></rss>