<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[a8101718的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/a8101718</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; a8101718]]></copyright><item><title><![CDATA[sql server post方法]]></title><link>https://blog.youkuaiyun.com/a8101718/article/details/101171586</link><guid>https://blog.youkuaiyun.com/a8101718/article/details/101171586</guid><author>a8101718</author><pubDate>Wed, 17 Oct 2018 17:14:00 +0800</pubDate><description><![CDATA[USE [myehr]GO
/****** Object:  StoredProcedure [dbo].[httpPost]    Script Date: 10/17/2018 17:14:06 ******/SET ANSI_NULLS ONGO
SET QUOTED_IDENTIFIER ONGO
CREATE PROCEDURE [dbo].[httpPost]     ...]]></description><category></category></item><item><title><![CDATA[SQL Server 阻止了对组件 'Ole Automation Procedures' 的 过程'sys.sp_OACreate' 的访问，因为此组件已作为此服务器安全配置的一部分而被关闭。系统管...]]></title><link>https://blog.youkuaiyun.com/a8101718/article/details/101171584</link><guid>https://blog.youkuaiyun.com/a8101718/article/details/101171584</guid><author>a8101718</author><pubDate>Wed, 17 Oct 2018 17:14:00 +0800</pubDate><description><![CDATA[sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO

转载于:https://www.cnblogs.com/xy888/p/9805394.html]]></description><category></category></item><item><title><![CDATA[springboot 内置默认启动tomcat容器遇到The valid characters are defined in RFC 7230 and RFC 3986”...]]></title><link>https://blog.youkuaiyun.com/a8101718/article/details/101171583</link><guid>https://blog.youkuaiyun.com/a8101718/article/details/101171583</guid><author>a8101718</author><pubDate>Thu, 05 Jul 2018 17:56:00 +0800</pubDate><description><![CDATA[URL:
http://127.0.0.1:8081/test?urlcount=2&amp;countcname1=参数名1&amp;countname1=参数1&amp;countcname2=参数名2&amp;countname2=参数2

后台模拟post请求时路径报错:
The valid characters are defined in RFC 7230 and ...]]></description><category></category></item><item><title><![CDATA[Spring boot Oracle数据源配置]]></title><link>https://blog.youkuaiyun.com/a8101718/article/details/101171580</link><guid>https://blog.youkuaiyun.com/a8101718/article/details/101171580</guid><author>a8101718</author><pubDate>Mon, 25 Jun 2018 15:59:00 +0800</pubDate><description><![CDATA[正确:custom.datasource.Oracle.driverClassName = oracle.jdbc.driver.OracleDriver
custom.datasource.Oracle.url=jdbc:oracle:thin:@//127.0.0.1:1521/XE
custom.datasource.Oracle.username=ods
custom....]]></description><category></category></item><item><title><![CDATA[后台开发,JDBC禁忌!]]></title><link>https://blog.youkuaiyun.com/a8101718/article/details/101171581</link><guid>https://blog.youkuaiyun.com/a8101718/article/details/101171581</guid><author>a8101718</author><pubDate>Mon, 25 Jun 2018 10:03:00 +0800</pubDate><description><![CDATA[经常会遇到这种方法:
先查询出本地数据,然后插入到另外一个数据库内,
查询的时候使用的SELECT * FROM ***
然后插入的时候指定列 INSERT INTO ***(*,*,*,)values(*,*,*,)
这种是正常写法,但是有特殊的情况出现的时候就会很尴尬.
比如对方表结构顺序变了或其他变动.那么你查询出来的数据列就跟对方的数据列不匹配.就会插入失败.
当然,...]]></description><category></category></item><item><title><![CDATA[SQL 取得当前时间]]></title><link>https://blog.youkuaiyun.com/a8101718/article/details/101171578</link><guid>https://blog.youkuaiyun.com/a8101718/article/details/101171578</guid><author>a8101718</author><pubDate>Sun, 24 Jun 2018 18:00:00 +0800</pubDate><description><![CDATA[SELECT CONVERT(varchar(100), GETDATE(), 0) 05  9 2011  9:12AM
 SELECT CONVERT(varchar(100), GETDATE(), 1) 05/09/11
SELECT CONVERT(varchar(100), GETDATE(), 2) 11.05.09
SELECT CONVERT(varcha...]]></description><category></category></item><item><title><![CDATA[Oracle插入数据报错 (ORA-00913: 值过多)]]></title><link>https://blog.youkuaiyun.com/a8101718/article/details/101171577</link><guid>https://blog.youkuaiyun.com/a8101718/article/details/101171577</guid><author>a8101718</author><pubDate>Fri, 22 Jun 2018 16:50:00 +0800</pubDate><description><![CDATA[原语句,表面没有双引号:INSERT INTO xm_ftp_lvl_mgr_hr VALUES('191','457','张A810','080072','1','null','null','null','1','null','系统管理员','2018-06-21 11:47:59','null','null','null','null','null','null','null',...]]></description><category></category></item><item><title><![CDATA[Oracle插入数据报错 (ORA-00904: "ID": 标识符无效)]]></title><link>https://blog.youkuaiyun.com/a8101718/article/details/101171575</link><guid>https://blog.youkuaiyun.com/a8101718/article/details/101171575</guid><author>a8101718</author><pubDate>Wed, 13 Jun 2018 17:19:00 +0800</pubDate><description><![CDATA[语句：

insert into SC_TASK (id) values(2);


　插入语句完全没问题，就是一直报错(ORA-00904: "ID": 标识符无效).
　根据以往经验，检查建表语句是否正确,结果发现建表语句内莫名其妙自己写了双引号：

create SC_TASK("id",.........


　这样的话，在插入数据时字段上也加上双引号，并且...]]></description><category></category></item><item><title><![CDATA[SqlServer死锁处理]]></title><link>https://blog.youkuaiyun.com/a8101718/article/details/101171533</link><guid>https://blog.youkuaiyun.com/a8101718/article/details/101171533</guid><author>a8101718</author><pubDate>Thu, 31 May 2018 15:39:00 +0800</pubDate><description><![CDATA[--查询死锁
SELECT request_session_id spid,OBJECT_NAME(resource_associated_entity_id)tableName
FROM sys.dm_tran_locks
WHERE resource_type='OBJECT '

--杀死死锁
KILL 155

--显示死锁相关信息
exec sp_who2...]]></description><category></category></item><item><title><![CDATA[jdbcTemplate 方法]]></title><link>https://blog.youkuaiyun.com/a8101718/article/details/101171535</link><guid>https://blog.youkuaiyun.com/a8101718/article/details/101171535</guid><author>a8101718</author><pubDate>Tue, 22 May 2018 15:41:00 +0800</pubDate><description><![CDATA[//1.查询一行数据并返回int型结果  
jdbcTemplate.queryForInt("select count(*) from test");  
//2. 查询一行数据并将该行数据转换为Map返回  
jdbcTemplate.queryForMap("select * from test where name='name5'");  
//3.查询一行任何类型的...]]></description><category></category></item><item><title><![CDATA[thymeleaf javascript取后台传入的数值]]></title><link>https://blog.youkuaiyun.com/a8101718/article/details/101171573</link><guid>https://blog.youkuaiyun.com/a8101718/article/details/101171573</guid><author>a8101718</author><pubDate>Tue, 22 May 2018 11:42:00 +0800</pubDate><description><![CDATA[&lt;script th:inline="javascript"&gt;  
/*&lt;![CDATA[*/  
  
    var message = [[${message}]];  
    console.log(message);  
  
/*]]&gt;*/  
&lt;/script&gt; 



转载于:https://www.cnblo...]]></description><category></category></item><item><title><![CDATA[Thymeleaf模板表达式]]></title><link>https://blog.youkuaiyun.com/a8101718/article/details/101171572</link><guid>https://blog.youkuaiyun.com/a8101718/article/details/101171572</guid><author>a8101718</author><pubDate>Mon, 21 May 2018 15:58:00 +0800</pubDate><description><![CDATA[日期格式、组件提取等.${#dates.format(date)}
${#dates.arrayFormat(datesArray)}
${#dates.listFormat(datesList)}
${#dates.setFormat(datesSet)}
${#dates.format(date, 'dd/MMM/yyyy HH:mm')}
${#dates.array...]]></description><category></category></item><item><title><![CDATA[thymeleaf循环遍历]]></title><link>https://blog.youkuaiyun.com/a8101718/article/details/101171570</link><guid>https://blog.youkuaiyun.com/a8101718/article/details/101171570</guid><author>a8101718</author><pubDate>Mon, 21 May 2018 15:09:00 +0800</pubDate><description><![CDATA[th:each属性用于迭代循环，语法：th:each="obj,iterStat:${objList}"
迭代对象可以是Java.util.List,java.util.Map,数组等;
iterStat称作状态变量，属性有：
    index:当前迭代对象的index（从0开始计算）
    count: 当前迭代对象的index(从1开始计算)
    size:被迭...]]></description><category></category></item><item><title><![CDATA[spring boot 实体命名规范]]></title><link>https://blog.youkuaiyun.com/a8101718/article/details/101171569</link><guid>https://blog.youkuaiyun.com/a8101718/article/details/101171569</guid><author>a8101718</author><pubDate>Thu, 17 May 2018 10:25:00 +0800</pubDate><description><![CDATA[实体类命名最好全部小写

转载于:https://www.cnblogs.com/xy888/p/9049688.html]]></description><category></category></item><item><title><![CDATA[Spring Boot 接口 返回json格式数据]]></title><link>https://blog.youkuaiyun.com/a8101718/article/details/101171571</link><guid>https://blog.youkuaiyun.com/a8101718/article/details/101171571</guid><author>a8101718</author><pubDate>Wed, 16 May 2018 12:10:00 +0800</pubDate><description><![CDATA[@ResponseBody //必须添加此注解
@RequestMapping("/emPower")
public String emPowers(@RequestBody Object user) {
System.out.println(user);

return "{'msg':'OK','success':200'}";
}



转载于:https:/...]]></description><category></category></item><item><title><![CDATA[解析Json格式]]></title><link>https://blog.youkuaiyun.com/a8101718/article/details/101171542</link><guid>https://blog.youkuaiyun.com/a8101718/article/details/101171542</guid><author>a8101718</author><pubDate>Tue, 15 May 2018 22:50:00 +0800</pubDate><description><![CDATA[String temp = "{'data':{'a':[{'b1':'bb1','c1':'cc1'},{'b2':'bb2','c2':'cc2'}]}}";		JSONObject jodata = JSONObject.fromObject(temp);		JSONObject joa = JSONObject.fromObject(jodata.get("data").toSt...]]></description><category></category></item><item><title><![CDATA[Maven相关]]></title><link>https://blog.youkuaiyun.com/a8101718/article/details/101171538</link><guid>https://blog.youkuaiyun.com/a8101718/article/details/101171538</guid><author>a8101718</author><pubDate>Thu, 10 May 2018 18:00:00 +0800</pubDate><description><![CDATA[mvnpackageassembly:single 

打包后会在target目录下生成一个xxx-jar-with-dependencies.jar文件，这个文件不但包含了自己项目中的代码和资源，还包含了所有依赖包的内容。所以可以直接通过java -jar来运行。
此外还可以直接通过mvn package来打包，无需assembly:single，不过需要加上一些配置：...]]></description><category></category></item><item><title><![CDATA[Docker打包jar为镜像包]]></title><link>https://blog.youkuaiyun.com/a8101718/article/details/101171541</link><guid>https://blog.youkuaiyun.com/a8101718/article/details/101171541</guid><author>a8101718</author><pubDate>Thu, 10 May 2018 17:09:00 +0800</pubDate><description><![CDATA[将Dockerfile和jar放在同一目录下，命令行进入这个目录，使用命令：
docker build -t jamtur01/nginx .

转载于:https://www.cnblogs.com/xy888/p/9020602.html]]></description><category></category></item><item><title><![CDATA[解决项目打jar包后无法获取配置文件的路径问题]]></title><link>https://blog.youkuaiyun.com/a8101718/article/details/101171540</link><guid>https://blog.youkuaiyun.com/a8101718/article/details/101171540</guid><author>a8101718</author><pubDate>Sun, 10 Dec 2017 12:45:00 +0800</pubDate><description><![CDATA[今天在开发中做一个java项目，要求读取配置文件中的信息，开始一直写成绝对路径，当项目打jar包以后就找不到配置文件了，后面在网上当了一个方法，问题最后解决了，拿出来跟大家分享一下。


public class SMBConfig {//SMB消息参数public static String SMB_SENDER = ""; //Smb消息发送方public static S...]]></description><category></category></item><item><title><![CDATA[天堂2 GIT源码 提取地址]]></title><link>https://blog.youkuaiyun.com/a8101718/article/details/101171567</link><guid>https://blog.youkuaiyun.com/a8101718/article/details/101171567</guid><author>a8101718</author><pubDate>Mon, 06 Mar 2017 19:01:00 +0800</pubDate><description><![CDATA[Add the following Git https://bitbucket.org/l2jserver/l2j_server.git URL.
Later on! Add the Datapack with https://bitbucket.org/l2jserver/l2j_datapack.git URL.

转载于:https://www.cnblogs.com/xy888...]]></description><category></category></item></channel></rss>