<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[for_lover的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/for_lover</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; for_lover]]></copyright><item><title><![CDATA[echarts 中国地图china.js下载]]></title><link>https://blog.youkuaiyun.com/for_lover/article/details/111354304</link><guid>https://blog.youkuaiyun.com/for_lover/article/details/111354304</guid><author>for_lover</author><pubDate>Fri, 18 Dec 2020 10:30:11 +0800</pubDate><description><![CDATA[china. js，世界，各个省份下载地址
Githud地址：
https://github.com/apache/incubator-echarts/tree/master/test/data/map/js

]]></description><category></category></item><item><title><![CDATA[事务管理]]></title><link>https://blog.youkuaiyun.com/for_lover/article/details/109608717</link><guid>https://blog.youkuaiyun.com/for_lover/article/details/109608717</guid><author>for_lover</author><pubDate>Tue, 10 Nov 2020 22:17:26 +0800</pubDate><description><![CDATA[事物管理 ------一般在实现类中实现
@Override@Transactional
public int updateUserLoader(ACEntity acEntity,String userName,String remark,String acId) {
String fullName = acEntity.getFullName();
String shortName = acEntity.getShortName();
Long id = acEntity.getId();
String]]></description><category></category></item><item><title><![CDATA[正则表达式判断]]></title><link>https://blog.youkuaiyun.com/for_lover/article/details/109608703</link><guid>https://blog.youkuaiyun.com/for_lover/article/details/109608703</guid><author>for_lover</author><pubDate>Tue, 10 Nov 2020 22:16:28 +0800</pubDate><description><![CDATA[/*** 根据身份证号获取性别* @param IDCard* @return*/
public static String getSex(String IDCard){
String sex ="";
if (StringUtils.isNotBlank(IDCard)){
// 判断性别
if (Integer.parseInt(IDCard.substring(16).substring(0, 1)) % 2 == 0) {
sex = "2";
} else {
sex = "1";
}
}
ret]]></description><category></category></item><item><title><![CDATA[与SQL有关日期]]></title><link>https://blog.youkuaiyun.com/for_lover/article/details/109608681</link><guid>https://blog.youkuaiyun.com/for_lover/article/details/109608681</guid><author>for_lover</author><pubDate>Tue, 10 Nov 2020 22:15:37 +0800</pubDate><description><![CDATA[//获取当前年月日
private String getDate(String format){
//format格式yyyyMMddHHmmss或yyyyMMdd等...
Date date = new Date();
SimpleDateFormat dateFormat= new SimpleDateFormat(format);
return dateFormat.format(date);
}

//取当前年度
Calendar cal = Calendar.getInstance();/*** ]]></description><category></category></item><item><title><![CDATA[金额小写转化为大写]]></title><link>https://blog.youkuaiyun.com/for_lover/article/details/109608655</link><guid>https://blog.youkuaiyun.com/for_lover/article/details/109608655</guid><author>for_lover</author><pubDate>Tue, 10 Nov 2020 22:14:22 +0800</pubDate><description><![CDATA[private static final String UNIT = "万仟佰拾亿仟佰拾万仟佰拾元角分";
private static final String DIGIT = "零壹贰叁肆伍陆柒捌玖";
private static final double MAX_VALUE = 9999999999999.99D;

public String change(double v) {
if (v &lt; 0 || v &gt; MAX_VALUE) {
return "参数非法!";
}
long ]]></description><category></category></item><item><title><![CDATA[常用地址]]></title><link>https://blog.youkuaiyun.com/for_lover/article/details/109608270</link><guid>https://blog.youkuaiyun.com/for_lover/article/details/109608270</guid><author>for_lover</author><pubDate>Tue, 10 Nov 2020 21:53:06 +0800</pubDate><description><![CDATA[1、MiniUI中的Tree
https://blog.youkuaiyun.com/u012934325/article/details/82121355
2、Json在线解析及格式化验证
https://www.json.cn
3、JasperReports+Ireport+Java运用
https://blog.youkuaiyun.com/yangydq/article/details/79023416#commentsedit
4、Oracle递归查询
https://www.cnblogs.com/Soprano...]]></description><category></category></item><item><title><![CDATA[XML中数据库的操作]]></title><link>https://blog.youkuaiyun.com/for_lover/article/details/109608190</link><guid>https://blog.youkuaiyun.com/for_lover/article/details/109608190</guid><author>for_lover</author><pubDate>Tue, 10 Nov 2020 21:47:15 +0800</pubDate><description><![CDATA[每一个派生出来的表都必须有一个自己的别名1、修改
&lt;update id="insertNationalTaxHandChargeById" useGeneratedKeys="true"&gt;
update t_bsm_tax_batdeclare set gskkbj = #{gdskkbj},gsMemo=#{gdsMemo} where id=#{id}
&lt;/update&gt;

2、查询
&lt;select id ="getACByName" resultType="ACEntit]]></description><category></category></item><item><title><![CDATA[转换为JSONObject对象]]></title><link>https://blog.youkuaiyun.com/for_lover/article/details/109608173</link><guid>https://blog.youkuaiyun.com/for_lover/article/details/109608173</guid><author>for_lover</author><pubDate>Tue, 10 Nov 2020 21:46:06 +0800</pubDate><description><![CDATA[//接口参数
JSONObject data = new JSONObject();
data.put("baz423", -1);//变更事件ID
data.put("aac058", cxjmxxDto.getAac058());//证件类型
data.put("aac147", cxjmxxDto.getAac147());//证件号码

data.put("aac003", cxjmxxDto.getAac003());//姓名
data.put("aac004", cxjmxxDto.getAac]]></description><category></category></item><item><title><![CDATA[视图和递归查询]]></title><link>https://blog.youkuaiyun.com/for_lover/article/details/109608087</link><guid>https://blog.youkuaiyun.com/for_lover/article/details/109608087</guid><author>for_lover</author><pubDate>Tue, 10 Nov 2020 21:41:04 +0800</pubDate><description><![CDATA[1、递归查询
SELECT * FROMtableName
START WITH BAE024 = '410222040505'
CONNECT BY PRIOR AAB301 = BAE024
union all
select '410422'
from dual


select aab301, aae044
fromtableName
start with aab301 = '410222'
connect by prior aab301 = bae024

2、视图

create or rep..]]></description><category></category></item><item><title><![CDATA[Oracle数据库配置]]></title><link>https://blog.youkuaiyun.com/for_lover/article/details/109588723</link><guid>https://blog.youkuaiyun.com/for_lover/article/details/109588723</guid><author>for_lover</author><pubDate>Tue, 10 Nov 2020 21:38:33 +0800</pubDate><description><![CDATA[1、Mysql开启远程连接
update user set host='%' where user='root' and host='localhost';
在my中把修改为character-set-server = utf8
show VARIABLES like '%char%' 查数据字符集

2、不用安装oracle配置文件
用plSQL安装之后打开，在工具里面的preferences中







在上面的配置路径
下面的配置子文件加上 /oci.dll

3、解决plsql中文显示问号（..]]></description><category></category></item><item><title><![CDATA[CURD]]></title><link>https://blog.youkuaiyun.com/for_lover/article/details/109607993</link><guid>https://blog.youkuaiyun.com/for_lover/article/details/109607993</guid><author>for_lover</author><pubDate>Tue, 10 Nov 2020 21:37:03 +0800</pubDate><description><![CDATA[1、参数插入
insert into table
(BAZ001,
BAZ002,
BAZ007,
AAA001,
AAA005,
AAA002,
AAE030,
AAE031,
AAE013,
AAB034,
AAE140,
AAE036,
BZE011,
BZE036,
BZE034,
AAE035)
select aaa027 || '3900000003',
aaa027 || '3900000003',
'0',
'SZYY',
'1',
'20190101',
'30000101',
'',
a]]></description><category></category></item><item><title><![CDATA[枚举dto]]></title><link>https://blog.youkuaiyun.com/for_lover/article/details/109588692</link><guid>https://blog.youkuaiyun.com/for_lover/article/details/109588692</guid><author>for_lover</author><pubDate>Mon, 09 Nov 2020 23:00:48 +0800</pubDate><description><![CDATA[在正常的开发过程中可能需要对某个变量进行定义，把该变量放在枚举中以便后期的开发和维护。
一般情况下枚举中只使用get()，不使用set(),避免枚举值发生变化。
package com.wondersgroup.hnmi.jmggyw.common.enums;

import java.util.HashMap;
import java.util.Map;

/**
* @author sunchao
* @description 市县乡村组的级别
* @date 2019/10/6 17:52
...]]></description><category></category></item><item><title><![CDATA[DBlink连接]]></title><link>https://blog.youkuaiyun.com/for_lover/article/details/109588666</link><guid>https://blog.youkuaiyun.com/for_lover/article/details/109588666</guid><author>for_lover</author><pubDate>Mon, 09 Nov 2020 22:58:33 +0800</pubDate><description><![CDATA[一、DBLink
当用户要跨本地数据库，访问另外一个数据库表中的数据时，本地数据库中必须创建了远程数据库的dblink,通过dblink本地数据库可以像访问本地数据库一样访问远程数据库表中的数据。
创建：
create database link DYCL_KF--DBlink名称
connect toHNSIB_DYSIidentified by"DBW0B!FzgeEHf"--目标数据库的用户名和密码
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRES...]]></description><category></category></item><item><title><![CDATA[表结构]]></title><link>https://blog.youkuaiyun.com/for_lover/article/details/109588627</link><guid>https://blog.youkuaiyun.com/for_lover/article/details/109588627</guid><author>for_lover</author><pubDate>Mon, 09 Nov 2020 22:57:35 +0800</pubDate><description><![CDATA[1、创建表

drop tabletableName cascade constraints;

/*==============================================================*/
/* Table: tableName*/
/*==============================================================*/
create tabletableName
(
BKC168 VARCHAR2(20) not n..]]></description><category></category></item><item><title><![CDATA[java中常用的一些方法]]></title><link>https://blog.youkuaiyun.com/for_lover/article/details/109588588</link><guid>https://blog.youkuaiyun.com/for_lover/article/details/109588588</guid><author>for_lover</author><pubDate>Mon, 09 Nov 2020 22:55:29 +0800</pubDate><description><![CDATA[/**  1、去除特殊字符，一来防止报错，而来防止sql注入
 * 转义字符
 * @param str 原始字符串
 * @return 举例 escape("张三%%李四","%","\\%") --- 张三\%\%李四
 */
public static String escape(String str){
    if(StringUtils.hasText(str)){
        //暂时就只有这些特殊字符，如果后面在实际开发和测试中还发现特殊字符，直接在这里添加就行
        st.]]></description><category></category></item><item><title><![CDATA[MiniUI属性]]></title><link>https://blog.youkuaiyun.com/for_lover/article/details/109588549</link><guid>https://blog.youkuaiyun.com/for_lover/article/details/109588549</guid><author>for_lover</author><pubDate>Mon, 09 Nov 2020 22:53:14 +0800</pubDate><description><![CDATA[&lt;div id="yjsYhzGrid"----设置ID

class="mini-datagrid"

multiSelect="false"----若属性值为false，则只能选中一行；反之可以选择多行。（默认属性值为false）

showSummaryRow="true"--------显示汇总行

style="width:100%;height: 350px;"

frozenStartColumn="0"--------固定列的开始

frozenEndColumn="3"--...]]></description><category></category></item><item><title><![CDATA[常用的SQL函数]]></title><link>https://blog.youkuaiyun.com/for_lover/article/details/109588512</link><guid>https://blog.youkuaiyun.com/for_lover/article/details/109588512</guid><author>for_lover</author><pubDate>Mon, 09 Nov 2020 22:51:31 +0800</pubDate><description><![CDATA[一、通过固定的字符截取字符串

update temp_20200420_48
set aac147 = SUBSTR(bz,
INSTR(bz, '|', 1, 4) + 1,
INSTR(bz, '|', 1, 5) - INSTR(bz, '|', 1, 4) - 1),
aac003 = SUBSTR(bz,
INSTR(bz, '|', 1, 1) + 1,
INSTR(bz, '|', 1, 2) - INSTR(bz, '|', 1, 1) - 1);
select bz, INSTR(bz,]]></description><category></category></item><item><title><![CDATA[参数传递]]></title><link>https://blog.youkuaiyun.com/for_lover/article/details/109588456</link><guid>https://blog.youkuaiyun.com/for_lover/article/details/109588456</guid><author>for_lover</author><pubDate>Mon, 09 Nov 2020 22:49:16 +0800</pubDate><description><![CDATA[1、JS中上传（前台）
var bke057s = [];
for (var i = 0; rows.length &gt; i; i++) {
    bke057s.push(rows[i].bke057);
}
bke057s = bke057s.join(',');

controller层接收（后台）
String[] bke057Array = request.getParameter("bke057s").split(",");//数组
for (String bke057 : bke057.]]></description><category></category></item><item><title><![CDATA[市县乡村四级级联（MINIUI实现）]]></title><link>https://blog.youkuaiyun.com/for_lover/article/details/109588330</link><guid>https://blog.youkuaiyun.com/for_lover/article/details/109588330</guid><author>for_lover</author><pubDate>Mon, 09 Nov 2020 22:45:14 +0800</pubDate><description><![CDATA[一、前端页面实现
&lt;fieldset class="layui-elem-field"&gt;
    &lt;legend&gt;行政区划信息&lt;/legend&gt;
    &lt;div class="layui-field-box" id="xzqhxx"&gt;
        &lt;table style="width:99.5%;"&gt;
            &lt;tr class="table_tr"&gt;
                &lt;td class=.]]></description><category></category></item><item><title><![CDATA[diaLog、dataTable模板的使用]]></title><link>https://blog.youkuaiyun.com/for_lover/article/details/109588265</link><guid>https://blog.youkuaiyun.com/for_lover/article/details/109588265</guid><author>for_lover</author><pubDate>Mon, 09 Nov 2020 22:39:53 +0800</pubDate><description><![CDATA[一．dialog的使用模板
$('#formAddEditClient').dialog({
    title : $('#formAddEditClient').find('#id') .val() == '0' ? '添加客户信息' : '修改客户信息',
    resizable : false,
    width : 810,
    modal : true,
    buttons : {
        "取消" : function() {  $("#setAccounts").pr.]]></description><category></category></item></channel></rss>