<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[风之&诉]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/luming666</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; luming666]]></copyright><item><title><![CDATA[WebService图片上传]]></title><link>https://blog.youkuaiyun.com/luming666/article/details/116975683</link><guid>https://blog.youkuaiyun.com/luming666/article/details/116975683</guid><author>luming666</author><pubDate>Tue, 18 May 2021 09:37:16 +0800</pubDate><description><![CDATA[&lt;html xmlns="http://www.w3.org/1999/xhtml"&gt;
&lt;head runat="server"&gt;
    &lt;title&gt;文件上传&lt;/title&gt;
    &lt;script src="../Scripts/jquery-1.7.2.min.js" type="text/javascript"&gt;&lt;/script&gt;
    &lt;script type="text/javascript"&gt;
     .]]></description><category></category></item><item><title><![CDATA[sqlserver收缩数据库日志]]></title><link>https://blog.youkuaiyun.com/luming666/article/details/109597699</link><guid>https://blog.youkuaiyun.com/luming666/article/details/109597699</guid><author>luming666</author><pubDate>Tue, 10 Nov 2020 14:07:56 +0800</pubDate><description><![CDATA[说明：收缩日志的原因有很多种，有些是考虑空间不足，有些则是应用程序限制导致的。


--将“恢复模式”设置为“简单”
ALTER DATABASE xszzxt_test SET RECOVERY SIMPLE 
GO
--收缩日志文件大小到10M
DBCC SHRINKFILE (N'xszzxt_test_log' , 10, TRUNCATEONLY)
GO
--将“恢复模式”设置为“完整”
ALTER DATABASE xszzxt_test SET RECOVERY FULL WITH NO_WA]]></description><category></category></item><item><title><![CDATA[sqlserver查询执行过的SQL记录]]></title><link>https://blog.youkuaiyun.com/luming666/article/details/109072384</link><guid>https://blog.youkuaiyun.com/luming666/article/details/109072384</guid><author>luming666</author><pubDate>Wed, 14 Oct 2020 14:23:01 +0800</pubDate><description><![CDATA[declare @startTime datetime,@endTime datetime;
set @startTime='2020-10-14 00:00:00';
set @endTime='2020-10-15 00:00:00';

SELECT TOP 1000 QS.creation_time,SUBSTRING(ST.text,(QS.statement_start_offset/2)+1,((CASE QS.statement_end_offset WHEN -1 THEN DATALE.]]></description><category></category></item><item><title><![CDATA[sqlserver当IDENTITY_INSERT设置为OFF时，不能为表‘XXX‘ 中的标识列插入显式值]]></title><link>https://blog.youkuaiyun.com/luming666/article/details/108974640</link><guid>https://blog.youkuaiyun.com/luming666/article/details/108974640</guid><author>luming666</author><pubDate>Fri, 09 Oct 2020 10:50:39 +0800</pubDate><description><![CDATA[解决方法：

1.先运行“SET IDENTITY_INSERT 表名 ON”

2.再运行你的插入语句

3.最后执行“SET IDENTITY_INSERT 表名 OFF”
]]></description><category></category></item><item><title><![CDATA[sqlserver查询去掉重复数据]]></title><link>https://blog.youkuaiyun.com/luming666/article/details/108119520</link><guid>https://blog.youkuaiyun.com/luming666/article/details/108119520</guid><author>luming666</author><pubDate>Thu, 20 Aug 2020 11:42:43 +0800</pubDate><description><![CDATA[说明：只要数据表“列名”数据相同，则说明是两条重复的数据（ID为数据表的主键自动增长）。推荐使用方法一。


-- 方法一
select * from 表名 A where not exists(select 1 from 表名 where 列名=A.列名 and ID&lt;A.ID)

-- 方法二
select A.* from 表名 A inner join (select min(ID) ID,列名 from 表名 group by 列名) B on A.列名=B.列名 and A.ID=B.ID]]></description><category></category></item><item><title><![CDATA[MySQL查看数据库表容量大小]]></title><link>https://blog.youkuaiyun.com/luming666/article/details/105574506</link><guid>https://blog.youkuaiyun.com/luming666/article/details/105574506</guid><author>luming666</author><pubDate>Fri, 17 Apr 2020 10:26:22 +0800</pubDate><description><![CDATA[1.查看所有数据库容量大小


SELECT
table_schema AS '数据库',
SUM(table_rows) AS '记录数',
SUM(TRUNCATE(data_length/1024/1024, 2)) AS '数据容量(MB)',
SUM(TRUNCATE(index_length/1024/1024, 2)) AS '索引容量(MB)'
FROM information_s...]]></description><category></category></item><item><title><![CDATA[Excel宏正则匹配]]></title><link>https://blog.youkuaiyun.com/luming666/article/details/105540388</link><guid>https://blog.youkuaiyun.com/luming666/article/details/105540388</guid><author>luming666</author><pubDate>Wed, 15 Apr 2020 17:50:32 +0800</pubDate><description><![CDATA[在Excel中使用快捷键Alt+F11启动宏处理


Private Sub RegExp_Replace()

    Dim RegExp As Object
    Dim SearchRange As Range, Cell As Range
    
    '此处定义正则表达式
    Set RegExp = CreateObject("vbscript.regexp")
    R...]]></description><category></category></item><item><title><![CDATA[sqlserver存储过程分页查询]]></title><link>https://blog.youkuaiyun.com/luming666/article/details/99633181</link><guid>https://blog.youkuaiyun.com/luming666/article/details/99633181</guid><author>luming666</author><pubDate>Thu, 15 Aug 2019 14:05:53 +0800</pubDate><description><![CDATA[1.单表查询分页存储过程


CREATE PROCEDURE [dbo].[prcPageResult]
(
	@currPage int = 1,                         --当前页页码 (即Top currPage)
	@showColumn varchar(2000) = '*',           --需要得到的字段 (即 column1,column2,......]]></description><category></category></item><item><title><![CDATA[ASP.NET中获取参数POST和GET方式提交的参数]]></title><link>https://blog.youkuaiyun.com/luming666/article/details/86577020</link><guid>https://blog.youkuaiyun.com/luming666/article/details/86577020</guid><author>luming666</author><pubDate>Mon, 21 Jan 2019 16:13:34 +0800</pubDate><description><![CDATA[
//第1种，接收用get方法传输的数据
protected void Page_Load(object sender, EventArgs e) 
{ 
string id = Request.QueryString[&quot;name&quot;]; 
string website = Request.QueryString[&quot;website&quot;]; 
Response.Write(id + &quot;&amp;lt; br&amp;g...]]></description><category></category></item><item><title><![CDATA[MySQL解压版安装]]></title><link>https://blog.youkuaiyun.com/luming666/article/details/82225116</link><guid>https://blog.youkuaiyun.com/luming666/article/details/82225116</guid><author>luming666</author><pubDate>Thu, 30 Aug 2018 17:51:53 +0800</pubDate><description><![CDATA[1.官网下载

https://dev.mysql.com/downloads/mysql/

2.解压到一个合适的目录



3.配置环境变量

Path：bin的目录添加到变量值后面



4.在mysql-8.0.12-winx64目录下新建一个my.ini文件（如果没有my.ini 数据库启动时没有了初始化参数）


[mysql]
; 设置mysql客户端默认字符集
default-ch...]]></description><category></category></item><item><title><![CDATA[jquery分页插件jquery.pagination.js使用方法]]></title><link>https://blog.youkuaiyun.com/luming666/article/details/82112826</link><guid>https://blog.youkuaiyun.com/luming666/article/details/82112826</guid><author>luming666</author><pubDate>Mon, 27 Aug 2018 14:55:13 +0800</pubDate><description><![CDATA[参数说明



前端代码


&amp;lt;script src=&quot;../js/jquery.pagination.js&quot; type=&quot;text/javascript&quot;&amp;gt;&amp;lt;/script&amp;gt;
&amp;lt;link href=&quot;../css/pagination.css&quot; rel=&quot;stylesheet&quot; type=&quot;text/css&quot; /&amp;gt;
&amp]]></description><category></category></item><item><title><![CDATA[正则表达式匹配标签里面的内容]]></title><link>https://blog.youkuaiyun.com/luming666/article/details/81873152</link><guid>https://blog.youkuaiyun.com/luming666/article/details/81873152</guid><author>luming666</author><pubDate>Mon, 20 Aug 2018 16:17:06 +0800</pubDate><description><![CDATA[正则表达式匹配标签里面的内容

方法： &amp;lt;[^&amp;gt;]+&amp;gt;]]></description><category></category></item><item><title><![CDATA[C#使用NewtonSoft操作Json]]></title><link>https://blog.youkuaiyun.com/luming666/article/details/81532402</link><guid>https://blog.youkuaiyun.com/luming666/article/details/81532402</guid><author>luming666</author><pubDate>Thu, 09 Aug 2018 11:24:31 +0800</pubDate><description><![CDATA[
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System.Collections.Generic;
using System.Data;
using Newtonsoft.Json.Converters;

namespace Dd.Utility
{
    public static class JsonHelper
  ...]]></description><category></category></item><item><title><![CDATA[微信商城中购物车和订单表结构设计]]></title><link>https://blog.youkuaiyun.com/luming666/article/details/80760109</link><guid>https://blog.youkuaiyun.com/luming666/article/details/80760109</guid><author>luming666</author><pubDate>Thu, 21 Jun 2018 14:43:19 +0800</pubDate><description><![CDATA[购物车的实现可以使用多种方式，主流的有以下3种：存储在用户游览器中：如使用cookie记录，也可以使用HTML5的本地存储等存储在服务器中：存储在用户会话（session）中，用户在关闭游览器后存储信息会被销毁存储在数据库中：可以存储在Mysql、Redis等数据库中下面以Mysql存储用户的购物车信息，这样用户无论何时都可以看到自己的购物车历史记录。购物车表（goods_shopcar）设计见图...]]></description><category></category></item><item><title><![CDATA[DIV里面的图片水平垂直居中]]></title><link>https://blog.youkuaiyun.com/luming666/article/details/80475725</link><guid>https://blog.youkuaiyun.com/luming666/article/details/80475725</guid><author>luming666</author><pubDate>Mon, 28 May 2018 09:47:07 +0800</pubDate><description><![CDATA[方法一：    div{
        width:150px;
        height: 100px;
        display: table-cell;
        vertical-align: middle;
        text-align: center;
        border:1px solid #000;
    }
    img {
       ...]]></description><category></category></item><item><title><![CDATA[jQuery自定义插件]]></title><link>https://blog.youkuaiyun.com/luming666/article/details/79700545</link><guid>https://blog.youkuaiyun.com/luming666/article/details/79700545</guid><author>luming666</author><pubDate>Mon, 26 Mar 2018 17:02:34 +0800</pubDate><description><![CDATA[1.添加jQuery对象级的插件，是给jQuery类添加方法。;(function($){
	$.fn.extend({
		&quot;函数名&quot;:function(自定义参数){
			//这里写插件代码
		}
	});
})(jQuery);
或者
;(function($){
	$.fn.函数名=function(自定义参数){
		//这里写插件代码
	}
})(jQuery);调用方法：$(&quot;#...]]></description><category></category></item><item><title><![CDATA[CSS三角形提示框]]></title><link>https://blog.youkuaiyun.com/luming666/article/details/79363080</link><guid>https://blog.youkuaiyun.com/luming666/article/details/79363080</guid><author>luming666</author><pubDate>Sat, 24 Feb 2018 16:53:04 +0800</pubDate><description><![CDATA[/*CSS三角形提示框-向上*/
.tag_a{ width:406px; height:325px; border:1px solid #cccccc; position:absolute;z-index:3;background-color:#FFF;top:30px;left:25px;}
.tag_a em{border:0px;display:block; position:absolu...]]></description><category></category></item><item><title><![CDATA[js中仿C#中的string.format]]></title><link>https://blog.youkuaiyun.com/luming666/article/details/79290127</link><guid>https://blog.youkuaiyun.com/luming666/article/details/79290127</guid><author>luming666</author><pubDate>Thu, 08 Feb 2018 15:32:09 +0800</pubDate><description><![CDATA[仿C#中的string.Format()String.prototype.format = function(args) {
    var result = this;
    if (arguments.length &amp;gt; 0) {    
        if (arguments.length == 1 &amp;amp;&amp;amp; typeof (args) == &quot;object&quot;) {
 ...]]></description><category></category></item><item><title><![CDATA[C#使用Socket实现心跳]]></title><link>https://blog.youkuaiyun.com/luming666/article/details/79140990</link><guid>https://blog.youkuaiyun.com/luming666/article/details/79140990</guid><author>luming666</author><pubDate>Tue, 23 Jan 2018 16:07:40 +0800</pubDate><description><![CDATA[Server端代码：
class Program
{
    static SocketListener listener;

    public static void Main(string[] args)
    {
        //实例化Timer类，设置间隔时间为5000毫秒；
        System.Timers.Timer t = new System.Timers.T]]></description><category></category></item><item><title><![CDATA[C#使用Socket实现服务器与多个客户端通信(简单的聊天系统)]]></title><link>https://blog.youkuaiyun.com/luming666/article/details/79125453</link><guid>https://blog.youkuaiyun.com/luming666/article/details/79125453</guid><author>luming666</author><pubDate>Mon, 22 Jan 2018 10:34:58 +0800</pubDate><description><![CDATA[扩展：
由于server端是存储了所有server与client的连接对象，因此我们是可以基于此demo的基础上实现聊天系统：
* 每当一个与用户发言时，是由server接收到的某个用户的发言信息的，此时服务器端可以通过循环发送该用户发送的信息给每个已经连接连接的用户（排除发送者）。
Server端代码：
class Program
{
    //创建一个和客户端通信的套接字
    s]]></description><category></category></item></channel></rss>