<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[.Kaway.Cheng专栏]]></title><description><![CDATA[太平盛世]]></description><link>https://blog.youkuaiyun.com/zjwtnt</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; zjwtnt]]></copyright><item><title><![CDATA[创建数据库脚本]]></title><link>https://blog.youkuaiyun.com/zjwtnt/article/details/52931699</link><guid>https://blog.youkuaiyun.com/zjwtnt/article/details/52931699</guid><author>zjwtnt</author><pubDate>Wed, 26 Oct 2016 10:09:49 +0800</pubDate><description><![CDATA[CREATE DATABASE IF NOT EXISTS dbname DEFAULT CHARSET utf8 COLLATE utf8_general_ci;]]></description><category></category></item><item><title><![CDATA[添加字段及指定字符集]]></title><link>https://blog.youkuaiyun.com/zjwtnt/article/details/52881326</link><guid>https://blog.youkuaiyun.com/zjwtnt/article/details/52881326</guid><author>zjwtnt</author><pubDate>Fri, 21 Oct 2016 11:08:23 +0800</pubDate><description><![CDATA[alter table weixin_vote_detail add tel varchar(20)  CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' null COMMENT'投票时验证的手机号';]]></description><category></category></item><item><title><![CDATA[常用的MYSQL还原导出命令]]></title><link>https://blog.youkuaiyun.com/zjwtnt/article/details/52451227</link><guid>https://blog.youkuaiyun.com/zjwtnt/article/details/52451227</guid><author>zjwtnt</author><pubDate>Tue, 06 Sep 2016 16:32:41 +0800</pubDate><description><![CDATA[mysql -uroot -p zsda --default-character-set=utf8 


导出
mysqldump -uroot -pchinaway2100 zseri_new_db > zseri_new_db.sql


还原
 gunzip 


备份
mysqldump -h hostname -u username -p databasename]]></description><category></category></item><item><title><![CDATA[图像旋转逆时针]]></title><link>https://blog.youkuaiyun.com/zjwtnt/article/details/48547187</link><guid>https://blog.youkuaiyun.com/zjwtnt/article/details/48547187</guid><author>zjwtnt</author><pubDate>Fri, 18 Sep 2015 15:29:25 +0800</pubDate><description><![CDATA[//用给定角度旋转图像，以jpeg图像格式为例
function rotate($filename,$degrees){
	$img = getimagesize($filename);
	$mime = $img["mime"];//$img->getImageInfo();	
	$source = null;
	switch ($mime)
	{
		case 'image/png':$sou]]></description><category></category></item><item><title><![CDATA[数据备份及恢复]]></title><link>https://blog.youkuaiyun.com/zjwtnt/article/details/48340099</link><guid>https://blog.youkuaiyun.com/zjwtnt/article/details/48340099</guid><author>zjwtnt</author><pubDate>Thu, 10 Sep 2015 10:48:50 +0800</pubDate><description><![CDATA[解压整个数据库
gunzip 


压缩整个数据库
mysqldump -uroot -pabcde --all-deatbases | gzip > all.sql.gz


查看空间
df -hl

查看磁盘
fdisk -l
挂载U盘
fat mount -t vfat /dev/sdb1 /var/usb2 默认支持FAT32
fat mount -t ntf]]></description><category></category></item><item><title><![CDATA[同页面多记录JS倒计时器]]></title><link>https://blog.youkuaiyun.com/zjwtnt/article/details/47951615</link><guid>https://blog.youkuaiyun.com/zjwtnt/article/details/47951615</guid><author>zjwtnt</author><pubDate>Mon, 24 Aug 2015 15:22:12 +0800</pubDate><description><![CDATA[/*
功能：同页面多个倒计时器
作者：zjwtnt
时间：2015-8-24
strttime:日期，如：2015-10-01 10:01:01 需要前导零
obj:显示倒计时的按钮，如果是链接的话就需要自行修改下边源码
*/
function timer(strtime,obj)  
{  
	var reg = /^(\d+)\-(\d{1,2})\-(\d{1,2})\s+(\d{1,2})]]></description><category></category></item><item><title><![CDATA[c#发邮件，我在win2003验证过，可以用．不用装任何组件]]></title><link>https://blog.youkuaiyun.com/zjwtnt/article/details/1864810</link><guid>https://blog.youkuaiyun.com/zjwtnt/article/details/1864810</guid><author>zjwtnt</author><pubDate>Sat, 03 Nov 2007 13:33:00 +0800</pubDate><description><![CDATA[using System.Web.Mail两个重载，一个是数组邮件地址列表，另一个是字符串数组邮件地        #region SendMailSmtp调 用 范 例        //SendMail a = new SendMail();        //string content;        //content = "aaaabbbbbb";        //A]]></description><category></category></item><item><title><![CDATA[ 项目升级到.NET 3.5,遭遇compilerOptions问题]]></title><link>https://blog.youkuaiyun.com/zjwtnt/article/details/1861838</link><guid>https://blog.youkuaiyun.com/zjwtnt/article/details/1861838</guid><author>zjwtnt</author><pubDate>Thu, 01 Nov 2007 20:00:00 +0800</pubDate><description><![CDATA[由于近日想将一些2.0的项目迁移到3.5下进行开发,主要是想运用LINQ进行改写.按照升级向导一路下来,在修改web.config后,编译时抛出" 当前的信任级别不允许使用 compilerOptions 属性"的错误,到MSDN上搜索了一下,原来是trust level引起的问题,找到解决的方法如下:解决办法一:在web.config中把trust level设置成Full这样做]]></description><category></category></item><item><title><![CDATA[数据控件嵌套写法]]></title><link>https://blog.youkuaiyun.com/zjwtnt/article/details/1679127</link><guid>https://blog.youkuaiyun.com/zjwtnt/article/details/1679127</guid><author>zjwtnt</author><pubDate>Thu, 05 Jul 2007 00:43:00 +0800</pubDate><description><![CDATA[DataBinder.Eval(FormView1.DataItem,"fk_productClass").ToString() ]]></description><category></category></item><item><title><![CDATA[函数:递归分类]]></title><link>https://blog.youkuaiyun.com/zjwtnt/article/details/1669604</link><guid>https://blog.youkuaiyun.com/zjwtnt/article/details/1669604</guid><author>zjwtnt</author><pubDate>Thu, 28 Jun 2007 00:23:00 +0800</pubDate><description><![CDATA[CREATE Function GetChild(@regid int)Returns @Child Table(id int ,productClass varchar(50),pid int )AsBeginInsert @Child Select  id,productClass,pid  From productClass Where id=@regidif exists(select  ]]></description><category></category></item><item><title><![CDATA[存储过程,无限级分类]]></title><link>https://blog.youkuaiyun.com/zjwtnt/article/details/1640719</link><guid>https://blog.youkuaiyun.com/zjwtnt/article/details/1640719</guid><author>zjwtnt</author><pubDate>Wed, 06 Jun 2007 14:54:00 +0800</pubDate><description><![CDATA[ 创建表if exists (select * from dbo.sysobjects where id = object_id(N[dbo].[Tb_Column]) and OBJECTPROPERTY(id, NIsUserTable) = 1)drop table [dbo].[Tb_Column]GOCreate TABLE [dbo].[Tb_Column] (    ]]></description><category></category></item><item><title><![CDATA[显示隐藏层]]></title><link>https://blog.youkuaiyun.com/zjwtnt/article/details/1632359</link><guid>https://blog.youkuaiyun.com/zjwtnt/article/details/1632359</guid><author>zjwtnt</author><pubDate>Thu, 31 May 2007 10:07:00 +0800</pubDate><description><![CDATA[function showdiv(div_id,div_showORhidden,div_width,div_height,div_top,div_left){ /**  div_id:           层ID  div_showORhidden: 显示/隐藏  true/false  div_width:        层宽度     0:默认  div_height:       层高度 ]]></description><category></category></item><item><title><![CDATA[显示年月日星期]]></title><link>https://blog.youkuaiyun.com/zjwtnt/article/details/1630593</link><guid>https://blog.youkuaiyun.com/zjwtnt/article/details/1630593</guid><author>zjwtnt</author><pubDate>Wed, 30 May 2007 10:09:00 +0800</pubDate><description><![CDATA[todayDate = new Date();date = todayDate.getDate();month= todayDate.getMonth() +1;year= todayDate.getYear();document.write("")document.write("")if(navigator.appName == "Netscape"){ document.write(1900+]]></description><category></category></item><item><title><![CDATA[ADO.NET中的多数据表操作浅析—修改]]></title><link>https://blog.youkuaiyun.com/zjwtnt/article/details/1625633</link><guid>https://blog.youkuaiyun.com/zjwtnt/article/details/1625633</guid><author>zjwtnt</author><pubDate>Fri, 25 May 2007 14:59:00 +0800</pubDate><description><![CDATA[ADO.NET中的多数据表操作浅析—修改作者：郑佐        2004-8-5三、更新数据集首先需要说明的是我这里去掉了Order Details表，对两个表的操作只是其中的几个字段。下面是窗体界面：图单选框用来选择不同的更新方法。在DataAccess类中增加两个类成员变量：     private SqlDataAdapter _customerDa]]></description><category></category></item><item><title><![CDATA[关于 gif 和 jpg]]></title><link>https://blog.youkuaiyun.com/zjwtnt/article/details/1625233</link><guid>https://blog.youkuaiyun.com/zjwtnt/article/details/1625233</guid><author>zjwtnt</author><pubDate>Fri, 25 May 2007 11:48:00 +0800</pubDate><description><![CDATA[         最近上网看到很多大型网站都是用gif作为平面设计的首选,虽然自己不是做设计的,也明白他们为什么用gif,其实做IT的大家都明白为什么要这样做.         今天,我上百度把百度的logo.gif摘下来.在属性里看到其大小才1.53k,占用空间4k,我把它用PHOTOSHOP改了一下,改成jpg,质量存为最低(0),也要20多K,而且质量还很难看,后来又用 microsoft ]]></description><category></category></item><item><title><![CDATA[把Excel文件中的数据读入到DataGrid中]]></title><link>https://blog.youkuaiyun.com/zjwtnt/article/details/1622537</link><guid>https://blog.youkuaiyun.com/zjwtnt/article/details/1622537</guid><author>zjwtnt</author><pubDate>Wed, 23 May 2007 14:41:00 +0800</pubDate><description><![CDATA[private DataSet CreateDataSource(){string strConn;strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source=C://Inetpub//wwwroot//contacts.xls;"+"Extended Properties=Excel 8.0;";]]></description><category></category></item><item><title><![CDATA[注册IIS组件]]></title><link>https://blog.youkuaiyun.com/zjwtnt/article/details/1622144</link><guid>https://blog.youkuaiyun.com/zjwtnt/article/details/1622144</guid><author>zjwtnt</author><pubDate>Wed, 23 May 2007 11:22:00 +0800</pubDate><description><![CDATA[regsvr32 C:/WINNT/Microsoft.NET/Framework/v1.1.4322/aspnet_isapi.dll默认的ASP。NET服务是禁止的,需要IIS管理器－－本地计算机－－WEB服务扩展－－ASP。NET服务－－允许。 ]]></description><category></category></item><item><title><![CDATA[图像信息读取类]]></title><link>https://blog.youkuaiyun.com/zjwtnt/article/details/1613749</link><guid>https://blog.youkuaiyun.com/zjwtnt/article/details/1613749</guid><author>zjwtnt</author><pubDate>Thu, 17 May 2007 17:41:00 +0800</pubDate><description><![CDATA[using System;using System.Drawing;using System.Drawing.Imaging;using System.Collections;using System.ComponentModel;namespace Test.Com{/// /// 功能：获得图片EXIF信息/// 作者：Rexsp/// 创建日期：2004-03-20/// public cl]]></description><category></category></item><item><title><![CDATA[Nhibernate 映射文件部分参数解释]]></title><link>https://blog.youkuaiyun.com/zjwtnt/article/details/1611196</link><guid>https://blog.youkuaiyun.com/zjwtnt/article/details/1611196</guid><author>zjwtnt</author><pubDate>Wed, 16 May 2007 11:02:00 +0800</pubDate><description><![CDATA[                                                                                                                                        ]]></description><category></category></item><item><title><![CDATA[执行存储过程的方法]]></title><link>https://blog.youkuaiyun.com/zjwtnt/article/details/1605370</link><guid>https://blog.youkuaiyun.com/zjwtnt/article/details/1605370</guid><author>zjwtnt</author><pubDate>Sat, 12 May 2007 01:24:00 +0800</pubDate><description><![CDATA[public IList ExecuteStoredProc( string spName, ICollection paramInfos ) { IList result = new ArrayList(); ISessionFactoryImplementor s = (ISessionFactoryImplementor)cfg.BuildSessionFactory(); IDbComma]]></description><category></category></item></channel></rss>