<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[nangua8552的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/nangua8552</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; nangua8552]]></copyright><item><title><![CDATA[利用Adobe Photoshop 2021生成SVG代码]]></title><link>https://blog.youkuaiyun.com/nangua8552/article/details/129222521</link><guid>https://blog.youkuaiyun.com/nangua8552/article/details/129222521</guid><author>nangua8552</author><pubDate>Sun, 26 Feb 2023 00:41:53 +0800</pubDate><description><![CDATA[利用Adobe Photoshop 2021生成字母C的SVG代码]]></description><category></category></item><item><title><![CDATA[oracle获取字符串中最大值]]></title><link>https://blog.youkuaiyun.com/nangua8552/article/details/124701629</link><guid>https://blog.youkuaiyun.com/nangua8552/article/details/124701629</guid><author>nangua8552</author><pubDate>Wed, 11 May 2022 01:50:29 +0800</pubDate><description><![CDATA[SELECT
	MAX (
		TO_NUMBER (
				REGEXP_SUBSTR ('9,3,6', '(\d+)', 1, LEVEL)
			)
		) AS MAX_VALUE
FROM
	DUAL
CONNECT BY REGEXP_SUBSTR ('9,3,6', '(\d+)', 1, LEVEL) IS NOT NULL


]]></description><category></category></item><item><title><![CDATA[URepost-配置表单，实现按条件查询报表]]></title><link>https://blog.youkuaiyun.com/nangua8552/article/details/124428455</link><guid>https://blog.youkuaiyun.com/nangua8552/article/details/124428455</guid><author>nangua8552</author><pubDate>Tue, 26 Apr 2022 15:29:57 +0800</pubDate><description><![CDATA[一、需求描述：

1.用户可以根据选择【年度】显示对应的报表，如下图：





二、实现方式：

1.此功能用到了URepost的【表单设计】，位置如图：



2. 插入表单，并设置对应属性





3.绑定查询参数，查询参数与数据集添加的参数要一致





4.两个数据源，第一个是报表，第二是报表中的年度去重查询数据【直接使用第一个数据源中的《年度》作为参数也可以，但是它只会列表显示，不会去重】



5.报表的SQL和配置如下：


SELECT ROWNUM, CC.ND, ... FR...]]></description><category></category></item><item><title><![CDATA[URepost-报表链接配置，URL超链接]]></title><link>https://blog.youkuaiyun.com/nangua8552/article/details/124262021</link><guid>https://blog.youkuaiyun.com/nangua8552/article/details/124262021</guid><author>nangua8552</author><pubDate>Mon, 18 Apr 2022 23:00:47 +0800</pubDate><description><![CDATA[实现URepost报表进行超链接



链接配置：

URL填写想跳转的链接

参数在【URL参数】进行配置，其中【#】代表当前数据。
]]></description><category></category></item><item><title><![CDATA[mybatis 先删除后插入]]></title><link>https://blog.youkuaiyun.com/nangua8552/article/details/124261847</link><guid>https://blog.youkuaiyun.com/nangua8552/article/details/124261847</guid><author>nangua8552</author><pubDate>Mon, 18 Apr 2022 22:51:38 +0800</pubDate><description><![CDATA[一、需求描述：

    导入数据前需要把之前的数据先删除后再进行插入

二、遇到的问题

    在一个方法内先执行delete，然后执行insert，插入可以，但是删除不成功；

三、上代码

mapper.java文件


    /**
     *  插入、删除
     * @param map
     * @return
     */
    public int insertOrDelete(@Param(value = "map") Map map);
...]]></description><category></category></item><item><title><![CDATA[springboot + MyBits + oracle 将JSON字段反序列化为java对象]]></title><link>https://blog.youkuaiyun.com/nangua8552/article/details/121783551</link><guid>https://blog.youkuaiyun.com/nangua8552/article/details/121783551</guid><author>nangua8552</author><pubDate>Wed, 08 Dec 2021 09:35:28 +0800</pubDate><description><![CDATA[oracle+mybatis反序列化JSON字段为java对象
{"XM":"张三","JFXMMC":"自费"，"GZAP":"已交接"}]]></description><category></category></item><item><title><![CDATA[Mybatis 使用MERGE INTO批量更新或插入成功但是数据库数据不变]]></title><link>https://blog.youkuaiyun.com/nangua8552/article/details/119900899</link><guid>https://blog.youkuaiyun.com/nangua8552/article/details/119900899</guid><author>nangua8552</author><pubDate>Tue, 24 Aug 2021 23:29:47 +0800</pubDate><description><![CDATA[xml代码


&lt;!-- 批量插入或更新 --&gt;
	&lt;insert id="batchInsertOrUpdate" parameterType="java.util.List"&gt;
		MERGE INTO gb_jcqk t
		USING (
			&lt;foreach collection="list" item="item" index="index" separator="union" &gt;
				SELECT
				#{item.id} id,
				#{it]]></description><category></category></item><item><title><![CDATA[mybatis 批量更新，批量插入，批量更新或插入]]></title><link>https://blog.youkuaiyun.com/nangua8552/article/details/119895603</link><guid>https://blog.youkuaiyun.com/nangua8552/article/details/119895603</guid><author>nangua8552</author><pubDate>Tue, 24 Aug 2021 17:58:57 +0800</pubDate><description><![CDATA[&lt;!-- 批量插入 --&gt;
	&lt;insert id ="insertBatch" parameterType="java.util.List" useGeneratedKeys="false"&gt;
		INSERT ALL
		&lt;foreach item="item" index="index" collection="list"&gt;
			INSERT INTO gb_jcqk(
			id,
			gh,
			sj,
			lx,
			jcqk,
			fj,
		.]]></description><category></category></item><item><title><![CDATA[jeesite4.X 多行表单上传附件并获取上传地址]]></title><link>https://blog.youkuaiyun.com/nangua8552/article/details/119305282</link><guid>https://blog.youkuaiyun.com/nangua8552/article/details/119305282</guid><author>nangua8552</author><pubDate>Sun, 01 Aug 2021 23:14:02 +0800</pubDate><description><![CDATA[问题描述：使用在线文档说明的方式，文件信息无法与业务表关联起来。

原方式：


&lt;script id="fileuploadTpl" type="text/template"&gt;//&lt;!--&lt;div&gt;
&lt;#form:fileupload id="{{d.id}}" bizKey="{{d.bizKey}}" bizType="{{d.bizType}}" uploadType="all" 
	class="{{d.cssClass}}" isMini="true" p..]]></description><category></category></item><item><title><![CDATA[jeesite4 使用JUnit]]></title><link>https://blog.youkuaiyun.com/nangua8552/article/details/119256010</link><guid>https://blog.youkuaiyun.com/nangua8552/article/details/119256010</guid><author>nangua8552</author><pubDate>Fri, 30 Jul 2021 21:07:53 +0800</pubDate><description><![CDATA[1、首先安装JUnitGenerator V2.0 JUnitGeneratorV2.0



2、然后在需要测试的类快捷键Alt + insert



3、在生成的类上添加


@RunWith(SpringRunner.class)
@SpringBootTest(classes = Application.class)

两个注解即可。


import com.jeesite.common.dao.CrudDao;
import com.jeesite.modules.Application;
i]]></description><category></category></item><item><title><![CDATA[jeesite多行表单使用字典类型时]]></title><link>https://blog.youkuaiyun.com/nangua8552/article/details/119255934</link><guid>https://blog.youkuaiyun.com/nangua8552/article/details/119255934</guid><author>nangua8552</author><pubDate>Fri, 30 Jul 2021 20:59:47 +0800</pubDate><description><![CDATA[{header:'${text("类型")}', name:'type', sortable:false, width:50,
				editable:true, edittype:'select', editoptions:{'class':'form-control',
					items: $.merge([{dictLabelOrig:'&amp;nbsp;',dictValue:''}], ${toJson(@DictUtils.getDictList('js_gb_type'))}),
	.]]></description><category></category></item><item><title><![CDATA[JeeSite 4.x修改代码生成工具的属性类型]]></title><link>https://blog.youkuaiyun.com/nangua8552/article/details/118863647</link><guid>https://blog.youkuaiyun.com/nangua8552/article/details/118863647</guid><author>nangua8552</author><pubDate>Sat, 17 Jul 2021 22:30:44 +0800</pubDate><description><![CDATA[在src\main\resources\templates\modules\gen\config.xml文件中进行添加修改。






]]></description><category></category></item><item><title><![CDATA[JeeSite 4.x 代码生成工具及erm的使用]]></title><link>https://blog.youkuaiyun.com/nangua8552/article/details/118861481</link><guid>https://blog.youkuaiyun.com/nangua8552/article/details/118861481</guid><author>nangua8552</author><pubDate>Sat, 17 Jul 2021 19:54:18 +0800</pubDate><description><![CDATA[1.使用代码生成工具生成代码需先在数据库建好表。

2.使用erm文件设计数据库；

3.可复制db文件夹下的test.erm文件，或者直接在里面进行设计；

4.erm需使用eclipse打开（需装ERMaster插件）；

5.数据库设计时添加内置了字段组；



6.在空白地方右键导出；



7.根据自己需求勾选需要的项；



8.找到生成的test.sql文件，复制替换掉 src\main\resources\db\create\oracle的test.sql文件；

9.运行Init...]]></description><category></category></item></channel></rss>