clearss-CSDN博客

原创 HttpClient 发送RequestMethod.Get请求

/** *创建httpClient */public HttpClient createHttpClient() { HttpClientBuilder httpClientBuilder = HttpClientBuilder.create(); PoolingHttpClientConnectionManager poolingHttpClientConnectionM...

2018-07-29 16:11:19 1280

原创正则

private static final String NEWPWD = "newPwd";private static final String pattern0 = "^[0-9]\\d{5}$";private static final String pattern1 = "^([\\d])\\1{2,}([\\d])\\2{2,}$";private static final Str...

2018-05-16 21:38:58 180

原创 mybatis 进行批量更新操作

<update id="updateAgentOpt" parameterType="java.util.List"> UPDATE gt_agent_day_corr_optstatus <trim prefix="set" suffixOverrides=","> <trim prefix="data_source_open =case" suffix

2017-12-14 14:20:06 1761

原创 MongoDB 创建地图索引及根据位置坐标查询地点小例子

MongoDB 创建地图索引及根据位置坐标查询地点小例子1：MongoDB 的安装参照博客：http://www.cnblogs.com/sweetchildomine/p/6397136.html可视化工具：本人用的是robomongo ，下载地址：https://robomongo.org/2：创建地图索引：db.shop.ensureIndex( { loc : "2dsphere" } )

2017-11-01 17:36:53 2331

原创取两个集合中的相同元素

取两个集合中的相同元素，并将结果转换为字符串code public String GetIntersection(String args1, String args2) { String[] arr1 = args1.split(","); String[] arr2 = args2.split(","); List<String> li

2017-10-11 10:39:24 6675

原创 html 使用js动态添加表格

function getTables(list) { for(var i=0;i;i++){ table1=""; table2=""; table3=""; tr1+=""; tr2+=""; tr3+=""; for(var j=0;j3;j++){

2017-10-09 10:58:48 1709

原创 SQL 两数相除保留两位小数

ROUND(CONVERT((SUM(cont)-sum(before_cont)),SIGNED)/CONVERT(sum(before_cont),SIGNED),2);MySql的类型转换CAST(xxx AS 类型), CONVERT(xxx,类型)，整数:SIGNED，无符号整数:UNSIGNED ,浮点数:DECIMAL,ROUND()函数：SELECT ROUND(column_name,decimals) FROM table_name 这两个参数都是必须的， column_name:

2017-10-09 10:06:46 22468

原创对集合中的对象分组，并排序

// 数据源List list = reportReceiveTaskMapper.getResourceAgentReportTypequarter(param);if(null==list || list.size()==0){return result;}// 定义一个map 用于分组Map> mapList = new HashMap>();// 遍历集合以Ag

2017-08-29 16:11:27 1407

原创 java.sql.SQLException: Cannot convert value '2017-07' from column 6 to TIMESTAMP.

java.sql.SQLException: Cannot convert value '2017-07' from column 6 to TIMESTAMP.

2017-08-29 15:34:18 13442 1

clearss的博客