<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[xjn的博客]]></title><description><![CDATA[开发中的点点滴滴]]></description><link>https://blog.youkuaiyun.com/bpdwg888</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; bpdwg888]]></copyright><item><title><![CDATA[MySQL中表A的ID插入到表B的多条记录中（基于时间相同，人员相同的条件），可以通过以下SQL语句实现：]]></title><link>https://blog.youkuaiyun.com/bpdwg888/article/details/148587896</link><guid>https://blog.youkuaiyun.com/bpdwg888/article/details/148587896</guid><author>bpdwg888</author><pubDate>Wed, 11 Jun 2025 15:45:51 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[GROUP_CONCAT 查询结果不全]]></title><link>https://blog.youkuaiyun.com/bpdwg888/article/details/144368014</link><guid>https://blog.youkuaiyun.com/bpdwg888/article/details/144368014</guid><author>bpdwg888</author><pubDate>Tue, 10 Dec 2024 10:50:56 +0800</pubDate><description><![CDATA[使用 GROUP_CONCAT 函数在 MySQL 中连接多个值时，如果结果集非常大，可能会导致结果被截断。这是因为 GROUP_CONCAT 有一个默认的最大长度限制，通常是 1024 个字符。如果生成的字符串超过了这个长度，超出部分将被截断。在 MySQL 的配置文件my.ini文件中全局设置。]]></description><category></category></item><item><title><![CDATA[FlywayDB在java中报：none of the following migration scripts locations could be found]]></title><link>https://blog.youkuaiyun.com/bpdwg888/article/details/135498479</link><guid>https://blog.youkuaiyun.com/bpdwg888/article/details/135498479</guid><author>bpdwg888</author><pubDate>Wed, 10 Jan 2024 11:07:15 +0800</pubDate><description><![CDATA[一直测试网上查找资料，好多说的都没能解决这个问题！又说idea创建包的bug等等，而我这里尝试修改也不行，依然报错。最后修改了pom，得以解决，添加扫描报下的.sql文件。]]></description><category></category></item><item><title><![CDATA[java--科星互联ID刷卡器TTS语音版，UDP协议实现语音播报]]></title><link>https://blog.youkuaiyun.com/bpdwg888/article/details/135456605</link><guid>https://blog.youkuaiyun.com/bpdwg888/article/details/135456605</guid><author>bpdwg888</author><pubDate>Mon, 08 Jan 2024 14:34:03 +0800</pubDate><description><![CDATA[/ 刷卡器IP地址。private static final String VOICE_DATA = “已刷卡，欢迎光临”;// 刷卡器UDP端口号。]]></description><category></category></item><item><title><![CDATA[windows下docker开放2375端口供docker-maven插件远程是部署代码]]></title><link>https://blog.youkuaiyun.com/bpdwg888/article/details/131768696</link><guid>https://blog.youkuaiyun.com/bpdwg888/article/details/131768696</guid><author>bpdwg888</author><pubDate>Mon, 17 Jul 2023 16:08:34 +0800</pubDate><description><![CDATA[【代码】windows下docker开放2375端口供docker-maven插件远程是部署代码。]]></description><category></category></item><item><title><![CDATA[java---微服务中子模块相互引用，打包时候报错“找不到”，如何解决]]></title><link>https://blog.youkuaiyun.com/bpdwg888/article/details/131766431</link><guid>https://blog.youkuaiyun.com/bpdwg888/article/details/131766431</guid><author>bpdwg888</author><pubDate>Mon, 17 Jul 2023 14:59:28 +0800</pubDate><description><![CDATA[现在有 common模块和user模块，还有父模块，现在情况是user使用common中的一些方法，但是呢，user在打包发布的时候报错，发现找不到common模块的jar，但是方法中也在引用不报错，这时候怎么解决呢，需要在common模块的pom中加“configuration”然后user在打包之前，需要将common模块 先clean，然后install打到本地仓库，再去打user就ok了。]]></description><category></category></item><item><title><![CDATA[java--自动创建数据库，并执行sql脚本文件]]></title><link>https://blog.youkuaiyun.com/bpdwg888/article/details/129203136</link><guid>https://blog.youkuaiyun.com/bpdwg888/article/details/129203136</guid><author>bpdwg888</author><pubDate>Fri, 24 Feb 2023 16:10:23 +0800</pubDate><description><![CDATA[java--自动创建数据库，并执行sql脚本文件]]></description><category></category></item><item><title><![CDATA[DynamicRoutingDataSource dynamic-datasource 多数据源动态加载、切换]]></title><link>https://blog.youkuaiyun.com/bpdwg888/article/details/129145835</link><guid>https://blog.youkuaiyun.com/bpdwg888/article/details/129145835</guid><author>bpdwg888</author><pubDate>Tue, 21 Feb 2023 17:01:00 +0800</pubDate><description><![CDATA[DynamicRoutingDataSource   dynamic-datasource 多数据源动态加载、切换]]></description><category></category></item><item><title><![CDATA[mysql 根据身份证号更新年龄]]></title><link>https://blog.youkuaiyun.com/bpdwg888/article/details/129056032</link><guid>https://blog.youkuaiyun.com/bpdwg888/article/details/129056032</guid><author>bpdwg888</author><pubDate>Thu, 16 Feb 2023 10:25:52 +0800</pubDate><description><![CDATA[【代码】mysql 根据身份证号更新年龄。]]></description><category></category></item><item><title><![CDATA[mysql “this is incompatible with sql_mode=only_full_group_by“报错]]></title><link>https://blog.youkuaiyun.com/bpdwg888/article/details/125199002</link><guid>https://blog.youkuaiyun.com/bpdwg888/article/details/125199002</guid><author>bpdwg888</author><pubDate>Thu, 09 Jun 2022 10:44:50 +0800</pubDate><description><![CDATA[mysql 报错]]></description><category></category></item><item><title><![CDATA[mybaits---全动态插入List＜Map＜String, Object＞＞]]></title><link>https://blog.youkuaiyun.com/bpdwg888/article/details/122096153</link><guid>https://blog.youkuaiyun.com/bpdwg888/article/details/122096153</guid><author>bpdwg888</author><pubDate>Wed, 22 Dec 2021 22:06:59 +0800</pubDate><description><![CDATA[dao层
public int xxx(@Param("lists")List&lt;Map&lt;String, Object&gt;&gt; listMap);

mapper
&lt;insert id="xxx"  parameterType="java.util.List"&gt;
      
          &lt;foreach collection="lists" item="maps" index="maps" separator=";"&gt;
                in]]></description><category></category></item><item><title><![CDATA[jquery--根据input的value值选定]]></title><link>https://blog.youkuaiyun.com/bpdwg888/article/details/121558114</link><guid>https://blog.youkuaiyun.com/bpdwg888/article/details/121558114</guid><author>bpdwg888</author><pubDate>Fri, 26 Nov 2021 13:39:56 +0800</pubDate><description><![CDATA[&lt;input type="checkbox" name="checkbox" id="check1" value="篮球"/&gt;
	&lt;label for="check1"&gt;
		篮球
	&lt;/label&gt;

后台返回的格式是json字符串，解析为数组
var strs= new Array(); //定义一数组
	strs=JSON.parse(item[par]); //解析
						
	for(i=0;i&lt;strs.length ;i++ ){
			$("i.]]></description><category></category></item><item><title><![CDATA[前端上传多文件，携带多参数，java接收（省去频繁写一一对应的参数）]]></title><link>https://blog.youkuaiyun.com/bpdwg888/article/details/121554450</link><guid>https://blog.youkuaiyun.com/bpdwg888/article/details/121554450</guid><author>bpdwg888</author><pubDate>Fri, 26 Nov 2021 10:40:05 +0800</pubDate><description><![CDATA[前端上传多文件，并携带多参数，为了方便后台接收，个人理解为：
	var data = new FormData();
	var dataMap = {};
	dataMap.name = name;
	dataMap.age = age;
	dataMap.sex = sex;
	dataMap.phone = phone;
	data.append("param",JSON.stringify(dataMap));

将前端的众多参数装进map中，然后将map转为json字符串。
后台接收–：
//上传基]]></description><category></category></item><item><title><![CDATA[tomcat解决跨域配置＜Context docBase=“xx“ path=““ reloadable=“true“ crossContext=“true“/＞导致项目加载两次]]></title><link>https://blog.youkuaiyun.com/bpdwg888/article/details/120487479</link><guid>https://blog.youkuaiyun.com/bpdwg888/article/details/120487479</guid><author>bpdwg888</author><pubDate>Sun, 26 Sep 2021 13:58:30 +0800</pubDate><description><![CDATA[springboot打成得war放在tomcat中，每次定时任务都回执行两次，发现原来是启动得时候，项目加载了两次导致，为了解决前后断跨域得问题，在server.xml中配置如下，方可解决问题。
1：Host 中的appBase=""
2:Context  中的docBase=“webapps/xxx”
&lt;Host appBase="" autoDeploy="true" name="localhost" unpackWARs="true"&gt;
        

        &lt;!-- ]]></description><category></category></item><item><title><![CDATA[java--springboot aop记录访问者的信息]]></title><link>https://blog.youkuaiyun.com/bpdwg888/article/details/115208385</link><guid>https://blog.youkuaiyun.com/bpdwg888/article/details/115208385</guid><author>bpdwg888</author><pubDate>Thu, 25 Mar 2021 14:43:42 +0800</pubDate><description><![CDATA[@Around("@annotation(requestMapping)")
    public Object recordCallLog(ProceedingJoinPoint pjp, RequestMapping requestMapping) throws Throwable {
    	long start = System.currentTimeMillis();

        String params = "";

        Object[] args = pjp.getAr.]]></description><category></category></item><item><title><![CDATA[java--json字符串转List＜Map＞]]></title><link>https://blog.youkuaiyun.com/bpdwg888/article/details/113736027</link><guid>https://blog.youkuaiyun.com/bpdwg888/article/details/113736027</guid><author>bpdwg888</author><pubDate>Sun, 07 Feb 2021 10:00:08 +0800</pubDate><description><![CDATA[List&lt;Map&gt; list =new ArrayList&lt;Map&gt;();
//需要json-jar
list = JSONObject.parseArray(string, Map.class);


]]></description><category></category></item><item><title><![CDATA[java----获取当前月份的第一天、当前天、最后一天]]></title><link>https://blog.youkuaiyun.com/bpdwg888/article/details/112987064</link><guid>https://blog.youkuaiyun.com/bpdwg888/article/details/112987064</guid><author>bpdwg888</author><pubDate>Fri, 22 Jan 2021 15:59:46 +0800</pubDate><description><![CDATA[SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
		//获取当前日期
		Calendar ca=Calendar.getInstance();
		ca.add(Calendar.MONTH, 0);
		ca.set(Calendar.DAY_OF_MONTH,1);
        ca.set(Calendar.DAY_OF_MONTH, ca.getActualMaximum(Calendar.DAY_OF_MONTH..]]></description><category></category></item><item><title><![CDATA[java --map转String]]></title><link>https://blog.youkuaiyun.com/bpdwg888/article/details/112672486</link><guid>https://blog.youkuaiyun.com/bpdwg888/article/details/112672486</guid><author>bpdwg888</author><pubDate>Fri, 15 Jan 2021 15:48:48 +0800</pubDate><description><![CDATA[需要json-jar
 Map&lt;String, String&gt; map = new HashMap&lt;String, String&gt;();
 map.put("time", "2021-01");
 String jsonObject = JSONObject.toJSONString(map);


]]></description><category></category></item><item><title><![CDATA[mybatis---一个方法执行多个sql的前提是：]]></title><link>https://blog.youkuaiyun.com/bpdwg888/article/details/108529927</link><guid>https://blog.youkuaiyun.com/bpdwg888/article/details/108529927</guid><author>bpdwg888</author><pubDate>Fri, 11 Sep 2020 10:53:55 +0800</pubDate><description><![CDATA[1.需要在数据库连接参数加上allowMultiQueries=true
spring.datasource.url = jdbc:mysql://localhost:3306/xxx?useUnicode=true&amp;characterEncoding=utf-8&amp;serverTimezone=UTC&amp;allowMultiQueries=true



]]></description><category></category></item><item><title><![CDATA[mysql---重复的年月日时分秒转换为年月日并分组排序]]></title><link>https://blog.youkuaiyun.com/bpdwg888/article/details/108488346</link><guid>https://blog.youkuaiyun.com/bpdwg888/article/details/108488346</guid><author>bpdwg888</author><pubDate>Wed, 09 Sep 2020 14:00:02 +0800</pubDate><description><![CDATA[SELECT * from (SELECT DATE_FORMAT(time,'%Y-%m-%d') as times from measure where DATE_SUB(CURDATE(), INTERVAL 8 DAY) &lt;= date(time))a GROUP BY a.times ORDER BY a.times desc




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