<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[asuyunlong的专栏]]></title><description><![CDATA[蜗牛为梦想而生！]]></description><link>https://blog.youkuaiyun.com/asuyunlong</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; asuyunlong]]></copyright><item><title><![CDATA[SpringBoot文件下载]]></title><link>https://blog.youkuaiyun.com/asuyunlong/article/details/115839852</link><guid>https://blog.youkuaiyun.com/asuyunlong/article/details/115839852</guid><author>asuyunlong</author><pubDate>Sun, 18 Apr 2021 21:09:09 +0800</pubDate><description><![CDATA[package com.example.servicehi;

import lombok.extern.slf4j.Slf4j;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;
import javax.servlet.http.HttpServletResponse;
import java.io.Buffe.]]></description><category></category></item><item><title><![CDATA[Spring Boot pom.xml中什么情况下可以不写版本号？]]></title><link>https://blog.youkuaiyun.com/asuyunlong/article/details/108901428</link><guid>https://blog.youkuaiyun.com/asuyunlong/article/details/108901428</guid><author>asuyunlong</author><pubDate>Fri, 02 Oct 2020 13:21:43 +0800</pubDate><description><![CDATA[官方文档的解释如下：



翻译后的意思是：




]]></description><category></category></item><item><title><![CDATA[JDBC PreparedStatement setString IN 传多个参数]]></title><link>https://blog.youkuaiyun.com/asuyunlong/article/details/107288544</link><guid>https://blog.youkuaiyun.com/asuyunlong/article/details/107288544</guid><author>asuyunlong</author><pubDate>Sat, 11 Jul 2020 18:48:19 +0800</pubDate><description><![CDATA[在使用JDBCPreparedStatement 进行SQL预编译时，发现使用IN(String) 传入一个字符串（逗号为分隔符），查询结果不正确。

以下面SQL为例，进行测试。


SELECT * FROM EMP T WHERE T.ENAME IN ('BLAKE', 'ADAMS')

Java中通过 ? 占位符传参。

错误的方式：

直接传入一个拼接字符串。因为会把拼接的字符串当作一个元素去查询。

测试未通过的方式：


PreparedStatement statement = con.]]></description><category></category></item><item><title><![CDATA[Java 压缩ZIP文件]]></title><link>https://blog.youkuaiyun.com/asuyunlong/article/details/106967444</link><guid>https://blog.youkuaiyun.com/asuyunlong/article/details/106967444</guid><author>asuyunlong</author><pubDate>Fri, 26 Jun 2020 11:24:38 +0800</pubDate><description><![CDATA[1.需要导入的两个架包


import org.apache.tools.zip.ZipEntry;
import org.apache.tools.zip.ZipOutputStream;

用apache的相关类代替Java的相关类，可以解决压缩文件中中文文件名乱码的问题。

2.代码如下


/**
	 * 压缩文件
	 * @param zipFile 压缩后的压缩包文件
	 * @param files 要压缩的文件数组
	 */
	public static void zip(File zip]]></description><category></category></item><item><title><![CDATA[Apache POI复制行和复制单元格]]></title><link>https://blog.youkuaiyun.com/asuyunlong/article/details/90576333</link><guid>https://blog.youkuaiyun.com/asuyunlong/article/details/90576333</guid><author>asuyunlong</author><pubDate>Sun, 26 May 2019 15:15:36 +0800</pubDate><description><![CDATA[package test;

import org.apache.poi.hssf.usermodel.HSSFDateUtil;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.X...]]></description><category></category></item><item><title><![CDATA[OpenCV人脸识别三（根据训练的模型进行人脸识别）]]></title><link>https://blog.youkuaiyun.com/asuyunlong/article/details/80584009</link><guid>https://blog.youkuaiyun.com/asuyunlong/article/details/80584009</guid><author>asuyunlong</author><pubDate>Tue, 05 Jun 2018 17:06:47 +0800</pubDate><description><![CDATA[OpenCV版本3.4.1人脸识别算法采用：LBPHFaceRecognizer.pro文件代码QT += core
QT -= gui

CONFIG += c++11

TARGET = opencvTest
CONFIG += console
CONFIG -= app_bundle

TEMPLATE = app

SOURCES += main.cpp \
    fisherdemo....]]></description><category></category></item><item><title><![CDATA[OpenCV人脸识别二（根据ORL人脸库训练模型）]]></title><link>https://blog.youkuaiyun.com/asuyunlong/article/details/80583738</link><guid>https://blog.youkuaiyun.com/asuyunlong/article/details/80583738</guid><author>asuyunlong</author><pubDate>Tue, 05 Jun 2018 16:57:41 +0800</pubDate><description><![CDATA[OpenCV版本3.4.1人脸识别算法采用：LBPHFaceRecognizer.pro文件代码QT += core
QT -= gui

CONFIG += c++11

TARGET = opencvTest
CONFIG += console
CONFIG -= app_bundle

TEMPLATE = app

SOURCES += main.cpp \
    fisherdemo....]]></description><category></category></item><item><title><![CDATA[OpenCV create_csv.py使用方法]]></title><link>https://blog.youkuaiyun.com/asuyunlong/article/details/80579754</link><guid>https://blog.youkuaiyun.com/asuyunlong/article/details/80579754</guid><author>asuyunlong</author><pubDate>Tue, 05 Jun 2018 12:55:54 +0800</pubDate><description><![CDATA[OpenCV中create_csv.py脚本是用Python2写的，如果你要在Python3下面使用，你需要把脚本里面的Python2语法修改为Python3。代码如下：Python2#!/usr/bin/env python

import sys
import os.path

# This is a tiny script to help you creating a CSV file fr...]]></description><category></category></item><item><title><![CDATA[apache pdfbox PDF文件转换为图片]]></title><link>https://blog.youkuaiyun.com/asuyunlong/article/details/79863064</link><guid>https://blog.youkuaiyun.com/asuyunlong/article/details/79863064</guid><author>asuyunlong</author><pubDate>Mon, 09 Apr 2018 11:12:25 +0800</pubDate><description><![CDATA[单页PDF文件转换图片方法，需要导入pdfbox-2.0.9.jar、fontbox-2.0.9.jar、pdfbox-tools-2.0.9.jar架包：/**
	 * 将单页PDF文件转换为图片
	 * apache pdfbox工具实现
	 * @param srcPath PDF文件绝对路径
	 * @param destPath 图片文件绝对路径
	 */
	public static ...]]></description><category></category></item><item><title><![CDATA[ICEpdf转换pdf文件为图片]]></title><link>https://blog.youkuaiyun.com/asuyunlong/article/details/79652843</link><guid>https://blog.youkuaiyun.com/asuyunlong/article/details/79652843</guid><author>asuyunlong</author><pubDate>Thu, 22 Mar 2018 13:53:23 +0800</pubDate><description><![CDATA[ICEpdf版本为：6.3.01.转换代码如下：package com.icepdf;

import java.awt.image.BufferedImage;
import java.awt.image.RenderedImage;
import java.io.File;
import javax.imageio.ImageIO;
import org.icepdf.core.pobject...]]></description><category></category></item><item><title><![CDATA[oracle 删除级联树形结构数据]]></title><link>https://blog.youkuaiyun.com/asuyunlong/article/details/78842998</link><guid>https://blog.youkuaiyun.com/asuyunlong/article/details/78842998</guid><author>asuyunlong</author><pubDate>Tue, 19 Dec 2017 15:20:06 +0800</pubDate><description><![CDATA[DELETE FROM AMC_DEPT WHERE ID IN (SELECT ID FROM AMC_DEPT start with ID=4 connect by prior ID=PID)注意：id为菜单主键，pid为子菜单中父菜单主键。]]></description><category></category></item><item><title><![CDATA[Flex3 AdvancedDataGrid 树形结构展示数据]]></title><link>https://blog.youkuaiyun.com/asuyunlong/article/details/78811120</link><guid>https://blog.youkuaiyun.com/asuyunlong/article/details/78811120</guid><author>asuyunlong</author><pubDate>Fri, 15 Dec 2017 11:32:47 +0800</pubDate><description><![CDATA[代码如下：

<mx:VBox xmlns:mx="http://www.adobe.com/2006/mxml" 
	xmlns:flexlib="http://code.google.com/p/flexlib/"
	width="100%"
	height="100%"
	creationComplete="handleCreationComplete()">
	
        <![C]]></description><category></category></item><item><title><![CDATA[MyBatis提示getFundBonus attempted to return null from a method with a primitive return type (double)]]></title><link>https://blog.youkuaiyun.com/asuyunlong/article/details/78223923</link><guid>https://blog.youkuaiyun.com/asuyunlong/article/details/78223923</guid><author>asuyunlong</author><pubDate>Fri, 13 Oct 2017 11:19:13 +0800</pubDate><description><![CDATA[错误提示：
Caused by: org.apache.ibatis.binding.BindingException: Mapper method 'com.amc.nonstandardinsinfo.dao.mapper.NonstandardInsInfoManageMapper.getFundBonus attempted to return null from a method wi]]></description><category></category></item><item><title><![CDATA[Oracle两表之间数据更新]]></title><link>https://blog.youkuaiyun.com/asuyunlong/article/details/77775951</link><guid>https://blog.youkuaiyun.com/asuyunlong/article/details/77775951</guid><author>asuyunlong</author><pubDate>Fri, 01 Sep 2017 18:03:58 +0800</pubDate><description><![CDATA[UPDATE AMC_FAX_ADDRESS_LIST AFAL
   SET (FAX1, FAX2, TEL1, TEL2) =
       (SELECT BFI.LXR_FAX, BFI.JBR_FAX, BFI.LXR_TEL, BFI.JBR_TEL
          FROM BASE_FAXLIST_INFO BFI
         WHERE BFI.FAXID = AFA]]></description><category></category></item><item><title><![CDATA[CXF JaxWsProxyFactoryBean调用SOAP服务出现异常信息]]></title><link>https://blog.youkuaiyun.com/asuyunlong/article/details/73740037</link><guid>https://blog.youkuaiyun.com/asuyunlong/article/details/73740037</guid><author>asuyunlong</author><pubDate>Mon, 26 Jun 2017 15:03:00 +0800</pubDate><description><![CDATA[异常信息如下：
javax.xml.bind.JAXBException: class com.ulic.webservice.vo.SealFile以及其任何超类对此上下文都是未知的。
	at com.sun.xml.bind.v2.runtime.XMLSerializer.reportError(XMLSerializer.java:247)
	at com.sun.xml.bind.v2]]></description><category></category></item><item><title><![CDATA[java StringTokenizer]]></title><link>https://blog.youkuaiyun.com/asuyunlong/article/details/73550106</link><guid>https://blog.youkuaiyun.com/asuyunlong/article/details/73550106</guid><author>asuyunlong</author><pubDate>Wed, 21 Jun 2017 16:19:19 +0800</pubDate><description><![CDATA[StringTokenizer：官方API解释如下：stringtokenizer 类允许应用程序将字符串分解为标记。
StringTokenizer 是出于兼容性的原因而被保留的遗留类（虽然在新代码中并不鼓励使用它）。建议所有寻求此功能的人使用 String 的 split 方法或
 java.util.regex 包。

在看spring源码时发现的这个方法，发现这个工具类在某些时候使]]></description><category></category></item><item><title><![CDATA[java 解析SOAP字符串指定标签转换为实体类]]></title><link>https://blog.youkuaiyun.com/asuyunlong/article/details/73294798</link><guid>https://blog.youkuaiyun.com/asuyunlong/article/details/73294798</guid><author>asuyunlong</author><pubDate>Thu, 15 Jun 2017 18:01:56 +0800</pubDate><description><![CDATA[1.测试实体类
package test;

@SuppressWarnings("serial")
public class Policy implements java.io.Serializable{
	private String LicenseNo;
	private String LicenseType;
	private String ComCode;
	private Strin]]></description><category></category></item><item><title><![CDATA[mybatis中insert into ...select ...from dual union all select ... from dual 提示sql命令未结束的问题]]></title><link>https://blog.youkuaiyun.com/asuyunlong/article/details/71275641</link><guid>https://blog.youkuaiyun.com/asuyunlong/article/details/71275641</guid><author>asuyunlong</author><pubDate>Sat, 06 May 2017 18:25:03 +0800</pubDate><description><![CDATA[需要在插入时加上useGeneratedKeys="false"
原Mapper：
	 
	 	INSERT INTO AMC_PRODUCT_ROLE_USER
	   		(user_id, role_id)
		
			SELECT 
				#{productRole.user_id,jdbcType=VARCHAR},
				#{productRole.role_id,jdbcTy]]></description><category></category></item><item><title><![CDATA[oracle imp和exp]]></title><link>https://blog.youkuaiyun.com/asuyunlong/article/details/71268625</link><guid>https://blog.youkuaiyun.com/asuyunlong/article/details/71268625</guid><author>asuyunlong</author><pubDate>Sat, 06 May 2017 15:49:08 +0800</pubDate><description><![CDATA[oracle 中使用 imp和exp可以进行数据的导入和导出
1.导出指定用户表空间
EXP ul3/ul3@hz BUFFER=64000 FILE=E:\hz.dmp OWNER=ul32.导入指定用户表空间
IMP ul3/ul3@orcl BUFFER=64000 FILE=C:\hz.DMP FROMUSER=ul3 TOUSER=ul3
在使用oracle dmp文件导入时，导]]></description><category></category></item><item><title><![CDATA[apache cxf-2.4.3 +spring-3.0.5发布SOAP协议WebService服务]]></title><link>https://blog.youkuaiyun.com/asuyunlong/article/details/70494852</link><guid>https://blog.youkuaiyun.com/asuyunlong/article/details/70494852</guid><author>asuyunlong</author><pubDate>Sun, 23 Apr 2017 12:12:12 +0800</pubDate><description><![CDATA[1.apache cxf-2.4.3导入相关架包：
commons-net-3.3.jar

cxf-2.4.3.jar

geronimo-jaxws_2.2_spec-1.1.jar

geronimo-servlet_3.0_spec-1.0.jar

jaxb-api-2.2.6.jar

jaxb-impl-2.2.6.jar

neethi-3.0.1.jar]]></description><category></category></item></channel></rss>