<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[dailipings的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/dailipings</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; dailipings]]></copyright><item><title><![CDATA[java Excel多sheet导出]]></title><link>https://blog.youkuaiyun.com/dailipings/article/details/109550101</link><guid>https://blog.youkuaiyun.com/dailipings/article/details/109550101</guid><author>dailipings</author><pubDate>Sat, 07 Nov 2020 17:51:59 +0800</pubDate><description><![CDATA[要导出多个sheet，关键就是Excel导出的时间设定，在执行导出文件之前，创建多个工作表




HSSFSheet sheet = workbook.createSheet(sheettitle);  



  这样每创建一个工作表，便会生成一个新的sheet表，在最后导出Excel的时候一次性导出。

try { 
  HSSFWorkbook workbook = new HSSFWorkbook(); 
  OutputStream out = response.getOu...]]></description><category></category></item><item><title><![CDATA[Java BigDecimal类型的 加减乘除运算]]></title><link>https://blog.youkuaiyun.com/dailipings/article/details/109179830</link><guid>https://blog.youkuaiyun.com/dailipings/article/details/109179830</guid><author>dailipings</author><pubDate>Tue, 20 Oct 2020 14:03:18 +0800</pubDate><description><![CDATA[Java BigDecimal类型的 加减乘除运算不能像C#一样简单，需要调用方法：

加法：add

减法：subtract

乘法：multiply

除法：divide





BigDecimal bignum1 =newBigDecimal("10");

BigDecimal bignum2 =newBigDecimal("5");

BigDecimal bignum3 =null;



//加法

bignum3 = bignum1.add(bignum2)...]]></description><category></category></item><item><title><![CDATA[element的el-table-column循环渲染和自定义列]]></title><link>https://blog.youkuaiyun.com/dailipings/article/details/109154374</link><guid>https://blog.youkuaiyun.com/dailipings/article/details/109154374</guid><author>dailipings</author><pubDate>Mon, 19 Oct 2020 09:17:51 +0800</pubDate><description><![CDATA[// 自定义组件
&lt;template&gt;
 &lt;div class="x__table&gt;
  &lt;el-table
   v-loading="tableLoading"
   :data="tableData"
   border
   stripe&gt;
   &lt;el-table-column
    v-if="index"
  ...]]></description><category></category></item><item><title><![CDATA[PHP工具安装]]></title><link>https://blog.youkuaiyun.com/dailipings/article/details/106094114</link><guid>https://blog.youkuaiyun.com/dailipings/article/details/106094114</guid><author>dailipings</author><pubDate>Wed, 13 May 2020 11:19:42 +0800</pubDate><description><![CDATA[wamPServer 64位是一款windows系统下的Apache+PHP+Mysql集成环境整合包，这款工具拥有简单的图形和菜单安装和配置环境。PHP扩展、Apache模块，开启/关闭鼠标点点就搞定，再也不用亲自去修改配置文件了，WAMP它会去做。

软件特色：

1.集成Apache/MySQL/PHP/PhpMyadmin；支持PHP扩展、Apache的mod_rewrit；

2.支持中文语言，一键安装，省时省力；任何人都可以轻松搭建；

3.一键启动、重启、停止所有服务，一键切换到离线状态等等。]]></description><category></category></item><item><title><![CDATA[sql 分析函数语法]]></title><link>https://blog.youkuaiyun.com/dailipings/article/details/103683735</link><guid>https://blog.youkuaiyun.com/dailipings/article/details/103683735</guid><author>dailipings</author><pubDate>Tue, 24 Dec 2019 15:25:39 +0800</pubDate><description><![CDATA[一、分析函数语法


function_name(&lt;argument&gt;,&lt;argument&gt;...) over(&lt;partition_Clause&gt;&lt;order by_Clause&gt;&lt;windowing_Clause&gt;);


function_name()：函数名称

argument：参数

over( )：开窗函数

partit...]]></description><category></category></item><item><title><![CDATA[C# 汉字转拼音]]></title><link>https://blog.youkuaiyun.com/dailipings/article/details/103668611</link><guid>https://blog.youkuaiyun.com/dailipings/article/details/103668611</guid><author>dailipings</author><pubDate>Mon, 23 Dec 2019 16:49:52 +0800</pubDate><description><![CDATA[using Microsoft.International.Converters.PinYinConverter;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Suspects.Dll.Util
{
  publicclassPinYinUt...]]></description><category></category></item><item><title><![CDATA[部署多维数据集项目]]></title><link>https://blog.youkuaiyun.com/dailipings/article/details/103282396</link><guid>https://blog.youkuaiyun.com/dailipings/article/details/103282396</guid><author>dailipings</author><pubDate>Wed, 27 Nov 2019 20:00:54 +0800</pubDate><description><![CDATA[开发环境

本文中示例代码的开发环境如下：

IDE：Visual Studio 2015
SqlServer：Microsoft SQL Server 2014

如果 VS 2015 打不开 BI 项目可以参考这篇文章。

发布多维数据集

在 VS 中右键需要发布的多维数据集项目，选择部署。

如需修改部署设置，右键项目选择属性。在配置下拉框中可以选择部署的配置，点击配置管...]]></description><category></category></item><item><title><![CDATA[小程序内部H5页面跳回小程序页面]]></title><link>https://blog.youkuaiyun.com/dailipings/article/details/103080318</link><guid>https://blog.youkuaiyun.com/dailipings/article/details/103080318</guid><author>dailipings</author><pubDate>Fri, 15 Nov 2019 10:21:03 +0800</pubDate><description><![CDATA[注：首页是在小程序，嵌套网页，该网页才能再次跳转回小程序

js引用：

&lt;script src="http://res.wx.qq.com/open/js/jweixin-1.4.0.js"&gt;&lt;/script&gt;

//判断当前页面是否在小程序环境中
       wx.miniProgram.getEnv(function (res) {
   ...]]></description><category></category></item><item><title><![CDATA[Java的BigDecimal的保留小数位]]></title><link>https://blog.youkuaiyun.com/dailipings/article/details/102824375</link><guid>https://blog.youkuaiyun.com/dailipings/article/details/102824375</guid><author>dailipings</author><pubDate>Wed, 30 Oct 2019 18:08:05 +0800</pubDate><description><![CDATA[Double d1 = 1233.555;
  /*
   * 这里有个坑，new BigDecimal的时候参数不要传Double类型，要转成String类型
   * 参数Double类型：实际bd=1233.555000000000063664629124104976654052734375
   * 参数String类型：实际b...]]></description><category></category></item><item><title><![CDATA[[RabbitMQ] Exchanges 类型]]></title><link>https://blog.youkuaiyun.com/dailipings/article/details/102678692</link><guid>https://blog.youkuaiyun.com/dailipings/article/details/102678692</guid><author>dailipings</author><pubDate>Tue, 22 Oct 2019 11:02:31 +0800</pubDate><description><![CDATA[RabbitMQ支持 4 种类型的Exchange。

合理使用Exchange可以降低代码和队列之间的耦合度。

1. Default Exchange

默认Exchange名为空字符串（""），且已被预创建。

每个队列创建时会自动的绑定到该默认Exchange，且路由Key和队列名相同。

直接发布消息到队列时，实际上是由默认Exchange根据路由Key来...]]></description><category></category></item><item><title><![CDATA[C# 基于DataTable数据筛选Linq整理]]></title><link>https://blog.youkuaiyun.com/dailipings/article/details/100105710</link><guid>https://blog.youkuaiyun.com/dailipings/article/details/100105710</guid><author>dailipings</author><pubDate>Tue, 27 Aug 2019 18:05:51 +0800</pubDate><description><![CDATA[DataRow[] orderdt = dt.Select(“where条件”);

DataRow[] subOrderdt = orderdt.CopyToDataTable().Select(“where条件”)



List筛选：

过滤重复数据

var list_distinct = list.GroupBy(s =&gt; new {s.OrderType, s.SubOrde...]]></description><category></category></item><item><title><![CDATA[C# 操作word]]></title><link>https://blog.youkuaiyun.com/dailipings/article/details/98586974</link><guid>https://blog.youkuaiyun.com/dailipings/article/details/98586974</guid><author>dailipings</author><pubDate>Tue, 06 Aug 2019 09:27:11 +0800</pubDate><description><![CDATA[public class WordAPI
{
  private object _template;
  private object _newWord;
  private Microsoft.Office.Interop.Word.Application wordApp;
  private Microsoft.Office.Interop.Word.Document _w...]]></description><category></category></item><item><title><![CDATA[java 日期时间转换]]></title><link>https://blog.youkuaiyun.com/dailipings/article/details/97395647</link><guid>https://blog.youkuaiyun.com/dailipings/article/details/97395647</guid><author>dailipings</author><pubDate>Fri, 26 Jul 2019 16:40:55 +0800</pubDate><description><![CDATA[Java时间格式转换大全

import java.text.*;
import java.util.Calendar;
public class VeDate {
/**
 * 获取现在时间
 *
 * @return 返回时间类型 yyyy-MM-dd HH:mm:ss
 */
public static Date getNowDate() {
 Date current...]]></description><category></category></item><item><title><![CDATA[禁止百度收录]]></title><link>https://blog.youkuaiyun.com/dailipings/article/details/96588148</link><guid>https://blog.youkuaiyun.com/dailipings/article/details/96588148</guid><author>dailipings</author><pubDate>Sat, 20 Jul 2019 14:10:37 +0800</pubDate><description><![CDATA[robots.txt基本介绍
robots.txt是一个纯文本文件，在这个文件中网站管理者可以声明该网站中不想被robots访问的部分，或者指定搜索引擎只收录指定的内容。
当一个搜索机器人（有的叫搜索蜘蛛）访问一个站点时，它会首先检查该站点根目录下是否存在robots.txt，如果存在，搜索机器人就会按照该文件中的内容来确定访问的范围；如果该文件不存在，那么搜索机器人就沿着链接抓取。
另外，rob...]]></description><category></category></item><item><title><![CDATA[DATASET不支持System.Nullable错误问题解决]]></title><link>https://blog.youkuaiyun.com/dailipings/article/details/94003485</link><guid>https://blog.youkuaiyun.com/dailipings/article/details/94003485</guid><author>dailipings</author><pubDate>Fri, 28 Jun 2019 14:56:47 +0800</pubDate><description><![CDATA[using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Reflection;
using YTO.WeiXin.Model;
using System.Collections;


namespace YTO.Wei...]]></description><category></category></item><item><title><![CDATA[sql server 两表模糊匹配查询更新其中一张表字段值]]></title><link>https://blog.youkuaiyun.com/dailipings/article/details/90286606</link><guid>https://blog.youkuaiyun.com/dailipings/article/details/90286606</guid><author>dailipings</author><pubDate>Fri, 17 May 2019 09:10:16 +0800</pubDate><description><![CDATA[update T_SYS_BankCode set CityCode = tab2.CityCode from T_SYS_BankCode as tab1 join T_SYS_CityCode as tab2 on tab2.City like CONCAT('%',tab1.City,'%')



]]></description><category></category></item><item><title><![CDATA[微信商户支付——Native扫码]]></title><link>https://blog.youkuaiyun.com/dailipings/article/details/90261525</link><guid>https://blog.youkuaiyun.com/dailipings/article/details/90261525</guid><author>dailipings</author><pubDate>Thu, 16 May 2019 13:14:47 +0800</pubDate><description><![CDATA[最近在做微信支付，调用微信的统一下单支付接口URL地址：https://api.mch.weixin.qq.com/pay/unifiedorder时，老是返回“签名错误”，不知道是怎么回事。我在日志中打印出生成的字符串和签名，然后用相同的数据在微信支付提供的在线支付调试工具生成签名，发现生成的签名结果一样！生成的最终xml也一样，但接口就是返回

&lt;xml&gt;&lt;return_co...]]></description><category></category></item><item><title><![CDATA[[.NET Core] 使用 WebApiClient 获取小程序码]]></title><link>https://blog.youkuaiyun.com/dailipings/article/details/90064108</link><guid>https://blog.youkuaiyun.com/dailipings/article/details/90064108</guid><author>dailipings</author><pubDate>Fri, 10 May 2019 15:07:04 +0800</pubDate><description><![CDATA[wxacode.getUnlimited



安装WebApiClient.JIT和Microsoft.AspNetCore.Http

	
Install-Package WebApiClient.JIT -Version 1.0.8
Install-Package Microsoft.AspNetCore.Http -Version 2.1.1

	
	IAuthApi.cs
	
/...]]></description><category></category></item><item><title><![CDATA[IIS调优--增加并发处理能力]]></title><link>https://blog.youkuaiyun.com/dailipings/article/details/88992948</link><guid>https://blog.youkuaiyun.com/dailipings/article/details/88992948</guid><author>dailipings</author><pubDate>Wed, 03 Apr 2019 13:16:36 +0800</pubDate><description><![CDATA[一个ASP.NET项目在部署到生产环境时，当用户并发量达到200左右时，IIS出现了明显的请求排队现象，发送的请求都进入等待，无法及时响应，系统基本处于不可用状态。因经验不足，花了很多时间精力解决这个问题，本文记录了我查找问题的过程和最后解决方案，供大家参考。



软硬件环境：

IBM刀片服务器，Intel至强处理器，4物理核，16个逻辑核心，内存32G

Windows Server200...]]></description><category></category></item><item><title><![CDATA[SQL SERVER随意整理]]></title><link>https://blog.youkuaiyun.com/dailipings/article/details/88812903</link><guid>https://blog.youkuaiyun.com/dailipings/article/details/88812903</guid><author>dailipings</author><pubDate>Tue, 26 Mar 2019 10:05:13 +0800</pubDate><description><![CDATA[快速插入大数量数据:

declare @i int ,@m varchar(50) --变量声明
set @i=150000  --变量赋值
set @m='66632423432423'
while @i&gt;0
begin
insert into T_SYS_Test1(Id,Title) select @i,@m
set @i=@i-1
end

------...]]></description><category></category></item></channel></rss>